1. Home
  2. Resources
  3. SAP Tables
  4. MDCP - Structure used to create planning file entries

SAP Table MDCP

Structure used to create planning file entries

MDCP (Structure used to create planning file entries) 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 MDCP to other SAP tables.

Source: MDCP (Structure used to create planning file entries)

MDCP table fields

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

MDCP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MDCP DISMM SYST MANDT T438A MRP Type MANDT
MDCP DISMM MDCP DISMM T438A MRP Type DISMM
MDCP MATNR SYST MANDT MARA General Material Data MANDT
MDCP MATNR MDCP MATNR MARA General Material Data MATNR
MDCP WERKS SYST MANDT T001W Plants/Branches MANDT
MDCP WERKS MDCP WERKS T001W Plants/Branches WERKS