SAP table MDCP (Structure used to create planning file entries)

Field Description Data Type Length Decimals Checktable Data Element
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
DISST Low-Level Code CHAR 3 0 DISST
DISMM MRP Type CHAR 2 0 T438A DISMM
MISKZ Mixed MRP indicator CHAR 1 0 MISKZ
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
MTART Material type CHAR 4 0 MTART
OBJKT Object CHAR 10 0 OBJKT
FUNKT Activity category in SAP transaction CHAR 1 0 AKTYP
MATKZ Checkbox CHAR 1 0 XFELD
No
X Yes
PSTAT Maintenance status CHAR 15 0 PSTAT_D
MINBE Reorder Point QUAN 13 3 MINBE
EISBE Safety Stock QUAN 13 3 EISBE
KZBEW Movement Indicator CHAR 1 0 KZBEW
Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
K Goods movement for kanban requirement (WM - internal only)
L Goods movement for delivery note
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
KZEAR Final Issue for Reservation CHAR 1 0 KZEAR
RSNUM Number of reservation/dependent requirements NUMC 10 0 RSNUM
URMNG Initial ordered/reserved quantity QUAN 13 3 URMNG
BEMNG Quantity moved in GR/GI QUAN 13 3 BEMNG
GEMNG Quantities already received or withdrawn QUAN 13 3 GEMNG
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
GSAEN Net Change Planning Indicator CHAR 1 0 GSAEN
AKKEN Net change planning indicator in the planning horizon CHAR 1 0 AKKEN
RESDT Indicator: Reset Procurement Proposals CHAR 1 0 RESDT
RESAL Re-explode BOM CHAR 1 0 RESAL
RHYTD Date for planning (e.g. as per time-phased mat. planning) DATS 8 0 RHYTD
PLTRM Planning date for planned order/purchase requisition DATS 8 0 PLTRM
MMSTA Plant-Specific Material Status CHAR 2 0 MMSTA
DISKZ Storage location MRP indicator CHAR 1 0 DISKZ
Storage location stock also planned at plant level
1 Storage location stock excluded from MRP
2 Storage location stock planned separately
BDART Requirement type CHAR 2 0 BDART
BDTER Requirements date for the component DATS 8 0 BDTER
DUMPS Phantom item indicator CHAR 1 0 DUMPS
RSHKZ Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
XSTBW Reversal movement type CHAR 1 0 XSTBW
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
SOBSL Special procurement type CHAR 2 0 SOBSL
LGORT Storage location CHAR 4 0 LGORT_D
OPUFF SAPLDISP: work without float CHAR 1 0 OPUFF
ALTSB Special procurement type CHAR 2 0 SOBSL
KNTKZ Flag: item assg. to account, usually not relevant to MRP CHAR 1 0 KNTKZ
MRPPP PPC Planning Calendar CHAR 3 0 MRPPP
ALTPP PPC Planning Calendar CHAR 3 0 MRPPP
KNNUM Internal number of knowledge element NUMC 10 0 KNNUM
KLART Class Type CHAR 3 0 KLASSENART
CLASS Class number CHAR 18 0 KLASSE_D
MTKFM Configurable Material CHAR 1 0 KZKFG
NEWDS Low-Level Code CHAR 3 0 DISST
ALTDI MRP Type CHAR 2 0 DISMM
PLSCN Planning Scenario in Long-Term Planning NUMC 3 0 PLSCN
KZAUS Discontinuation indicator CHAR 1 0 KZAUS
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
ALTAL Discontinuation indicator CHAR 1 0 KZAUS
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
NOUPD SAPLDISP: no immediate update to MDVM/MDVL CHAR 1 0 NOUPD
NOINS SAPLDISP: no immediate insert to MDVM/MDVL CHAR 1 0 NOINS
BERID MRP Area CHAR 10 0 BERID
BERTY Type of MRP Area NUMC 2 0 BERTY
01 Plant
02 Storage Location
03 Supplier
LBEAR MRP Area Subcontractor CHAR 10 0 LBEAR
VMDBE Planning file entry for plant MRP area CHAR 1 0 VMDBE
Planning file entry only for plant MRP area
1 Planning file entry for all MRP areas in plant
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
LOEKZ Asset class marked for deletion CHAR 1 0 LOEKZ
DIBER Indicator: MRP area exists CHAR 1 0 DIBER
DBSKZ Direct procurement indicator CHAR 1 0 DBSKZ
No direct procurement or direct production
E Direct production
F Direct procurement
VRPLA Indicator: planning without final assembly CHAR 1 0 VRPLA
NOBUF Indicator: Without Buffering BOM in Shared Buffer CHAR 1 0 MD_NOBUF
LFRHY PPC Planning Calendar CHAR 3 0 MRPPP
DISGR MRP Group CHAR 4 0 DISGR
PPSKZ Indicator for Advanced Planning CHAR 1 0 PPSKZ
STLNR Bill of Material CHAR 8 0 STNUM
STLTY BOM category CHAR 1 0 STLTY
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
P Work Breakdown Structure BOM
S Standard BOM
T Functional Location BOM
STLAL Alternative BOM CHAR 2 0 STLAL
STLKN BOM item node number NUMC 8 0 STLKN

MDCP foreign key relationships

Table Field Check Table Check Field
0 MDCP DISMM T438A MRP Type MANDT
0 MDCP DISMM T438A MRP Type DISMM
1 MDCP MATNR MARA General Material Data MANDT
1 MDCP MATNR MARA General Material Data MATNR
0 MDCP WERKS T001W Plants/Branches MANDT
0 MDCP WERKS T001W Plants/Branches WERKS