SAP Table MCBC
Help Table for Standard Settings in Customizing
MCBC (Help Table for Standard Settings in Customizing) 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 MCBC to other SAP tables.
MCBC table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | 0 | |||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | 0 | |||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | 0 | |||
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | 0 | |||
| HWAER | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||
| DISPO | MRP Controller (Materials Planner) | DISPO | T024D | CHAR | 3 | 0 | ||
| MTART | Material Type | MTART | T134 | CHAR | 4 | 0 | ||
| MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||
| DISMM | MRP Type | DISMM | T438A | CHAR | 2 | 0 | ||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||
| MBWBEST | Quantity of valuated stock | MBWBEST | QUAN | 15 | 3 | |||
| WBWBEST | Value of valuated stock | WBWBEST | CURR | 15 | 2 | |||
| MKOBEST | Quantity of consignment stock | MKOBEST | QUAN | 15 | 3 | |||
| LETZTZUG | Date: Last Receipt | LETZTZUG | DATS | 8 | 0 | |||
| LETZTABG | Date: last (i.e. most recent) goods issue | LETZTABG | DATS | 8 | 0 | |||
| LETZTVER | Date: last (i.e. most recent) consumption | LETZTVER | DATS | 8 | 0 | |||
| LETZTBEW | Date: last (i.e. most recent) goods movement | LETZTBEW | DATS | 8 | 0 | |||
| EISBE | Safety stock | MC_EISBE | QUAN | 15 | 3 | |||
| BKLAS | Valuation Class | BKLAS | T025 | CHAR | 4 | 0 | ||
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | 0 | |||
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | 0 | |||
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | 0 | |||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | 0 | |||
MCBC foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MCBC | BKLAS | MCBC | MANDT | T025 | Valuation Classes | MANDT |
| MCBC | BKLAS | MCBC | BKLAS | T025 | Valuation Classes | BKLAS |
| MCBC | DISMM | MCBC | MANDT | T438A | MRP Type | MANDT |
| MCBC | DISMM | MCBC | DISMM | T438A | MRP Type | DISMM |
| MCBC | DISPO | MCBC | WERKS | T024D | MRP controllers | WERKS |
| MCBC | DISPO | MCBC | DISPO | T024D | MRP controllers | DISPO |
| MCBC | DISPO | MCBC | MANDT | T024D | MRP controllers | MANDT |
| MCBC | GSBER | MCBC | GSBER | TGSB | Business Areas | GSBER |
| MCBC | GSBER | MCBC | MANDT | TGSB | Business Areas | MANDT |
| MCBC | HWAER | MCBC | MANDT | TCURC | Currency Codes | MANDT |
| MCBC | HWAER | MCBC | HWAER | TCURC | Currency Codes | WAERS |
| MCBC | LGORT | MCBC | MANDT | T001L | Storage Locations | MANDT |
| MCBC | LGORT | MCBC | WERKS | T001L | Storage Locations | WERKS |
| MCBC | LGORT | MCBC | LGORT | T001L | Storage Locations | LGORT |
| MCBC | MANDT | MCBC | MANDT | T000 | Clients | MANDT |
| MCBC | MATKL | MCBC | MANDT | T023 | Material Groups | MANDT |
| MCBC | MATKL | MCBC | MATKL | T023 | Material Groups | MATKL |
| MCBC | MATNR | MCBC | MANDT | MARA | General Material Data | MANDT |
| MCBC | MATNR | MCBC | MATNR | MARA | General Material Data | MATNR |
| MCBC | MTART | MCBC | MTART | T134 | Material Types | MTART |
| MCBC | MTART | MCBC | MANDT | T134 | Material Types | MANDT |
| MCBC | SPART | MCBC | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| MCBC | SPART | MCBC | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| MCBC | WERKS | MCBC | MANDT | T001W | Plants/Branches | MANDT |
| MCBC | WERKS | MCBC | WERKS | T001W | Plants/Branches | WERKS |
