MDLV
Customizing MRP AreaExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table MDLV.
SAP table MDLV has 2 primary key fields: MANDT,BERID.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
MDLV fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| Key BERID | 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 | |||||||
MDLV relationships.
| 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 |