SAP Table MCHBH
Batch Stocks: History
MCHBH (Batch Stocks: History) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MCHBH to other SAP tables.
MCHBH table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | CLNT | 3 | 0 | |||
MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||
WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||
CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 | 0 | ||
LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4 | 0 | |||
LFMON | Current period (posting period) | LFMON | NUMC | 2 | 0 | |||
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 |
MCHBH foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
MCHBH | CHARG | MCHBH | CHARG | MCH1 | Batches (if Batch Management Cross-Plant) | CHARG |
MCHBH | CHARG | MCHBH | MANDT | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
MCHBH | CHARG | MCHBH | MATNR | MCH1 | Batches (if Batch Management Cross-Plant) | MATNR |
MCHBH | LGORT | MCHBH | MANDT | T001L | Storage Locations | MANDT |
MCHBH | LGORT | MCHBH | WERKS | T001L | Storage Locations | WERKS |
MCHBH | LGORT | MCHBH | LGORT | T001L | Storage Locations | LGORT |
MCHBH | WERKS | MCHBH | WERKS | T001W | Plants/Branches | WERKS |
MCHBH | WERKS | MCHBH | MANDT | T001W | Plants/Branches | MANDT |