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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
BERID
MRP Area
|
BERID |
CHAR
|
10 | 0 | ||||||||||
|
BERTY
Type of MRP area
|
BERTY |
NUMC
|
2 | 0 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
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 |