SAP table MDLV (Customizing MRP Area)
SAP table MDLV has 2 primary key fields being MANDT,BERID.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
MRP Area
CHAR
10
0
BERID
BERTY
Type of MRP Area
NUMC
2
0
BERTY
Possible values
01
Plant
02
Storage Location
03
Supplier
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
Possible values
Standard MRP Area
1
Contract Packager
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 foreign key relationships
Table
Field
Check Table
Check Field
0 MDLV
MANDT
T000 Clients
MANDT
1 MDLV
MDMA_PROFILE
MDMA_PRF MRP Area Profile
MANDT
1 MDLV
MDMA_PROFILE
MDMA_PRF MRP Area Profile
MDMA_PROFILE
0 MDLV
ORTZG
T001L Storage Locations
MANDT
0 MDLV
ORTZG
T001L Storage Locations
WERKS
1 MDLV
WERZG
T001W Plants/Branches
MANDT
1 MDLV
WERZG
T001W Plants/Branches
WERKS