SAP Table
MDLV Customizing MRP Area
SAP table MDLV has 2 primary key fields being MANDT,BERID.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
MDLV columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| KeyBERID | MRP Area | CHAR | 10 | 0 | BERID | ||||||||
| BERTY | Type of MRP Area | NUMC | 2 | 0 | BERTY | ||||||||
|
|||||||||||||
| BERTX | MRP Area Text | CHAR | 40 | 0 | BERTX | ||||||||
| WERZG | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||||
| ORTZG | Receiving Storage Location | CHAR | 4 | 0 | T001L | ORTZG | |||||||
| SPE_BNTYP | Business Types of MRP Area | CHAR | 1 | 0 | /SPE/BNTYP | ||||||||
|
|||||||||||||
| MDMA_CREATE_ASSIGNMENTS | MRP Area: Create Material Assignments Automatically | CHAR | 1 | 0 | MDMA_CREATE_ASSIGNMENTS | ||||||||
| MDMA_PROFILE | MRP Area Profile | CHAR | 12 | 0 | MDMA_PRF | MDMA_PROFILE | |||||||
/ Relationships
MDLV foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| MDLV | MANDT | T000 | Clients | MANDT |
| MDLV | MDMA_PROFILE | MDMA_PRF | MRP Area Profile | MANDT |
| MDLV | MDMA_PROFILE | MDMA_PRF | MRP Area Profile | MDMA_PROFILE |
| MDLV | ORTZG | T001L | Storage Locations | MANDT |
| MDLV | ORTZG | T001L | Storage Locations | WERKS |
| MDLV | WERZG | T001W | Plants/Branches | MANDT |
| MDLV | WERZG | T001W | Plants/Branches | WERKS |