Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||
WERKS | Plant | WERKS_D | MARC | CHAR | 4 | 0 | ||||||
LGORT | Storage Location | LGORT_D | MARD | CHAR | 4 | 0 | ||||||
CHARG | Batch Number | CHARG_D | MCHA | CHAR | 10 | 0 | ||||||
LVORM | Deletion Flag for All Data on a Batch Stock | LVOCB | CHAR | 1 | 0 | Possible values | ||||||
ERSDA | Created On | ERSDA | DATS | 8 | 0 | |||||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||
LAEDA | Date of Last Change | LAEDA | DATS | 8 | 0 | |||||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||
LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4 | 0 | |||||||
LFMON | Current period (posting period) | LFMON | NUMC | 2 | 0 | |||||||
SPERC | Physical Inventory Blocking Indicator | SPERR | CHAR | 1 | 0 | Possible values
| ||||||
CLABS | Valuated Unrestricted-Use Stock | LABST | QUAN | 13 | 3 | |||||||
CUMLM | Stock in transfer (from one storage location to another) | UMLMD | QUAN | 13 | 3 | |||||||
CINSM | Stock in Quality Inspection | INSME | QUAN | 13 | 3 | |||||||
CEINM | Total Stock of All Restricted Batches | EINME | QUAN | 13 | 3 | |||||||
CSPEM | Blocked Stock | SPEME | QUAN | 13 | 3 | |||||||
CRETM | Blocked Stock Returns | RETME | QUAN | 13 | 3 | |||||||
CVMLA | Valuated unrestricted-use stock in previous period | VMLAB | QUAN | 13 | 3 | |||||||
CVMUM | Stock in Transfer in Previous Period | VMUML | QUAN | 13 | 3 | |||||||
CVMIN | Stock in Quality Inspection in Previous Period | VMINS | QUAN | 13 | 3 | |||||||
CVMEI | Restricted-Use Stock in Previous Period | VMEIN | QUAN | 13 | 3 | |||||||
CVMSP | Blocked stock of previous period | VMSPE | QUAN | 13 | 3 | |||||||
CVMRE | Blocked Stock Returns in Previous Period | VMRET | QUAN | 13 | 3 | |||||||
KZICL | Physical inventory indicator for whse stock in current year | KZILL | CHAR | 3 | 0 | |||||||
KZICQ | Phys. inventory ind. f. stock in qual. insp. in current year | KZILQ | CHAR | 3 | 0 | |||||||
KZICE | Physical inventory indicator for restricted-use stock | KZILE | CHAR | 3 | 0 | |||||||
KZICS | Physical inventory indicator for blocked stock | KZILS | CHAR | 3 | 0 | |||||||
KZVCL | Physical inventory indicator for stock in previous year | KZVLL | CHAR | 3 | 0 | |||||||
KZVCQ | Phys. inventory ind. f. stock in qual. insp. in prev. period | KZVLQ | CHAR | 3 | 0 | |||||||
KZVCE | Physical inventory ind. for restricted-use stock, prev.pd | KZVLE | CHAR | 3 | 0 | |||||||
KZVCS | Phys. inventory indicator for blocked stock in prev. period | KZVLS | CHAR | 3 | 0 | |||||||
HERKL | Country of origin of the material | HERKL | T005 | CHAR | 3 | 0 | ||||||
CHDLL | Date of Last Posted Count for Unrestricted-Use Stock | DLINL | DATS | 8 | 0 | |||||||
CHJIN | Fiscal year of current physical inventory indicator | GJINV | NUMC | 4 | 0 | |||||||
CHRUE | MCHBH rec. already exists for per. before last of MCHB per. | CHRUE | CHAR | 1 | 0 | Possible values |
Dear All,
There is a complete listof SAP MM basic tables
Material Master Data:
MARA – General Data, material type
MAKT– Short Texts, descriptions
MARM– Conversion Factors
MVKE – Sales Org, distribution channel
MLAN – Sales data, tax indicator, tax
MARC – classification
MBEW – Plant Planning Data
MLGN – Valuation Data
MLGT – Warehouse Management Inventory Data
MVER – Warehouse Management Storage Type
MAPR – Data
MARD – Consumption Data
MCHA – Pointer for Forecast Data
MCHB – Storage location data
Purchasing:
EKPO– Purchasing Document Item
EKKO– Purchasing Document Header
EBAN– Purchase Requisition
EKBE– History per Purchasing Document
EKET– Scheduling Agreement Schedule Lines
EINE– Purchasing Info Record: Purchasing Organization Data
EKKN– Account Assignment in Purchasing Document
EINA– Purchasing Info Record: General Data
EKES– Vendor Confirmations
EBKN– Purchase Requisition Account Assignment
EORD– Purchasing Source List
T024– Purchasing Groups
EKBZ– History per Purchasing Document: Delivery Costs
AMPL– Table of Approved Manufacturer Parts
EKAN– Vendor Address: Purchasing Document
Inventory Management:
MSEG– Document Segment: Material
MKPF– Header: Material Document
RESB– Reservation/dependent requirements
MARI– Short document: material movement
ISEG– Physical Inventory Document Items
RKPF– Document Header: Reservation
T156– Movement Type
IKPF– Header: Physical Inventory Document
T156T– Movement Type Text
CHVW– Table CHVW for Batch Where-Used List
T156SY– Mvt Type: Qty/Value Update: System Table; Rel. 4.6A
MMIM_REP_PRINT– Print Settings, Reporting MM-IM
T156S– Movement Type: Quantities/Value Posting (Until Rel. 4.5B)
T156W– Posting string values
T156M– Posting String: Quantity
Invoice Control:
RSEG– Document Item: Incoming Invoice
RBKP– Document Header: Invoice Receipt
BSIM– Secondary Index, Documents for Material
RKWA– Consignment Withdrawals
RBCO– Document Item, Incoming Invoice, Account Assignment
RBKP_BLOCKED– Logistics Invoice Verification: Blocked Invoices Baixar internet download manager crackeado 2019.
RBKP_V– Generierte Tabelle zu einem View
T149D– Global Valuation Types
RBDRSEG– Batch IV: Invoice Document Items
RBTX– Taxes: Incoming Invoice
RBWS– Withholding Tax Data, Incoming Invoice
RBKPB– Invoice Document Header (Batch Invoice Verification)
RBDIFFKO– Invoice Verification – Conditions
RBEX– Persistent Key Figures Header and Item
Symptom
- After Materials are migrated from an external system (example 'legacy'), checking table MARD, the field DLINL (Date of Last Count) is initial : 00.00.0000.
- For a batch managed material within table MCHB, the field CHDLL (Date of Last Count) is initial : 00.00.0000.
Read more..
Environment
- Materials Management (MM)
- SAP ERP Central Component
- SAP ERP
- SAP enhancement package for SAP ERP
- SAP enhancement package for SAP ERP, version for SAP HANA
- SAP S/4HANA
- SAP S/4HANA Cloud
Product
SAP ERP Central Component all versions ; SAP ERP all versions ; SAP S/4HANA Cloud all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions
Keywords
ECC, Cycle Count, T159C, OMCN, FIRST, Count, 00.00.0000, DLINL, CHDLL, MARD-ERSDA / MCHB-ERSDA, Inventory Difference, MI07, MI08, MI10 , KBA , MM-IM-PI , Physical Inventory , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
MCH1 is a standard SAP Table which is used to store Batches (if Batch Management Cross-Plant) data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP MCH1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
SAP MCH1 Table fields within data Dictionary
Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
MANDT | MANDT | CLNT | 3 | T000 | Client | |
MATNR | MATNR | CHAR | 18 | MARA | Material Number | MATN1 |
CHARG | CHARG_D | CHAR | 10 | Batch Number | ||
LVORM | LVOC1 | CHAR | 1 | Deletion Flag for All Data in a Batch | ||
.INCLUDE | MCHI1 | Data Fields for MCHA, MCH1 and MCH2: Division 1 | ||||
ERSDA | ERSDA | DATS | 8 | Created On | ||
ERNAM | ERNAM | CHAR | 12 | Name of Person who Created the Object | ||
AENAM | AENAM | CHAR | 12 | Name of Person Who Changed Object | ||
LAEDA | LAEDA | DATS | 8 | Date of Last Change | ||
VERAB | VERAB | DATS | 8 | Availability date | ||
VFDAT | VFDAT | DATS | 8 | Shelf Life Expiration or Best-Before Date | ||
ZUSCH | DZUSCH | CHAR | 1 | Batch status key | ||
ZUSTD | DZUSTD | CHAR | 1 | Batch in Restricted-Use Stock | ||
ZAEDT | DZAEDT | DATS | 8 | Date of last status change | ||
LIFNR | ELIFN | CHAR | 10 | LFA1 | Vendor Account Number | ALPHA |
LICHA | LICHN | CHAR | 15 | Vendor Batch Number | ||
VLCHA | VLCHN | CHAR | 10 | * | Original batch number (deactivated) | |
VLWRK | VLWRK | CHAR | 4 | MARC | Original plant (deactivated) | |
VLMAT | VLMAT | CHAR | 18 | MARA | Original material (deactivated) | MATN1 |
.APPEND | MILL_MCHI1 | MILL Enhancement | ||||
XPCBT | MILL_XPCBT | CHAR | 1 | Single-Unit Batch Indicator | ||
.INCLUDE | MCHI2 | Data Fields for MCHA, MCH1 and MCH2: Division 2 | ||||
CHAME | CHAME | UNIT | 3 | Unit of issue for batch (deactivated) | CUNIT | |
LWEDT | LWEDT | DATS | 8 | Date of last goods receipt | ||
FVDT1 | FVDAT | DATS | 8 | Date for unrestricted use | ||
FVDT2 | FVDAT | DATS | 8 | Date for unrestricted use | ||
FVDT3 | FVDAT | DATS | 8 | Date for unrestricted use | ||
FVDT4 | FVDAT | DATS | 8 | Date for unrestricted use | ||
FVDT5 | FVDAT | DATS | 8 | Date for unrestricted use | ||
FVDT6 | FVDAT | DATS | 8 | Date for unrestricted use | ||
HERKL | HERKL | CHAR | 3 | T005 | Country of origin of the material | |
HERKR | HERKR | CHAR | 3 | T005S | Region of origin of material (non-preferential origin) | |
MTVER | MTVER | CHAR | 4 | TVFM | Export/import material group | |
QNDAT | QNPDAT | DATS | 8 | Next Inspection Date | ||
HSDAT | HSDAT | DATS | 8 | Date of Manufacture | ||
CUOBJ_BM | CUOBJ_BM | NUMC | 18 | Internal object no.: Batch classification | ||
DEACT_BM | DEACT_BM | CHAR | 1 | Batch is no longer active | ||
BATCH_TYPE | BATCH_TYPE | CHAR | 1 | Type of Batch |
Key field |
Non-key field |
MCH1 - Batches (if Batch Management Cross-Plant)
MCEX_DELTA_BACK - Backup Table for Logistics Extraction Queues (MCEX*)
MCEXSETUP - ID Assign. Structure for Set-Up Tables in Reconstruction
MCEXLOG_11V_SSL - Logfile-structure for MC11V_0SSL
MCEXLOG_04_MAT - Logfile Structure for MC04P_0MAT
MCEXLOG - File for saving logs
MCEX_DELTA_BACK - Backup Table for Logistics Extraction Queues (MCEX*)
MCEXSETUP - ID Assign. Structure for Set-Up Tables in Reconstruction
MCEXLOG_11V_SSL - Logfile-structure for MC11V_0SSL
MCEXLOG_04_MAT - Logfile Structure for MC04P_0MAT
MCEXLOG - File for saving logs
Symptom
Unable to 'Post Goods Issue' for an Outbound Delivery in VL02N, due to the error message 'M7001 Check table XMCHA: entry does not exist'.
Mchb Table In Sap Office
Read more..Environment
- Materials Management (MM)
- SAP ERP
- SAP ERP Central Component
- SAP enhancement package for SAP ERP
- SAP enhancement package for SAP ERP, version for SAP HANA
- SAP S/4HANA
- SAP S/4HANA Cloud
Product
SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions
Keywords
ECC, non-batch managed, STO, PGI, Outbound Delivery, M7001, Check table XMCHA: entry does not exist, Post Goods Issue, LIPS-UMCHA, MCHB, MARA-XCHPF, MM03, ME21N, ME22, VL02N, OBD, , KBA , MM-IM-ST , Stock Transfer / Transfer Posting , MM-IM-GI , Goods Issue and Return Delivery , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Sap Tables And Fields
Visit SAP Support Portal's SAP Notes and KBA Search.