SAP Table MDLV
Customizing MRP Area
MDLV (Customizing MRP Area) 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 MDLV to other SAP tables.
MDLV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| BERID | MRP Area | BERID | CHAR | 10 | 0 | |||||||||
| BERTY | Type of MRP area | BERTY | NUMC | 2 | 0 |
Possible values
|
||||||||
| BERTX | MRP area text | BERTX | CHAR | 40 | 0 | |||||||||
| WERZG | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||
| ORTZG | Receiving storage location | ORTZG | T001L | CHAR | 4 | 0 | ||||||||
| SPE_BNTYP | Business Types of MRP Area | /SPE/BNTYP | CHAR | 1 | 0 |
Possible values
|
||||||||
MDLV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MDLV | MANDT | MDLV | MANDT | T000 | Clients | MANDT |
| MDLV | ORTZG | MDLV | MANDT | T001L | Storage Locations | MANDT |
| MDLV | ORTZG | MDLV | WERZG | T001L | Storage Locations | WERKS |
| MDLV | ORTZG | MDLV | ORTZG | T001L | Storage Locations | LGORT |
| MDLV | WERZG | MDLV | MANDT | T001W | Plants/Branches | MANDT |
| MDLV | WERZG | MDLV | WERZG | T001W | Plants/Branches | WERKS |
