SAP table MDPM (View of Material Components in the Planned Order)

Field Description Data Type Length Decimals Checktable Data Element
AUFST Order level NUMC 2 0 AUFST
AUFWG Order path NUMC 2 0 AUFWG
PMSOR Internal sort key NUMC 4 0 PMSOR
XPOSN BOM Item Number CHAR 4 0 SPOSN
PMSO1 Sort fiels 1 for discontinued and substitute parts CHAR 2 0 PMSO1
EPOSN BOM Item Number CHAR 4 0 SPOSN
STSOR Sort String CHAR 10 0 SORTP
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
BDART Requirement type CHAR 2 0 BDART
POSTP Item category (bill of material) CHAR 1 0 T418 POSTP
POSNR BOM Item Number CHAR 4 0 SPOSN
UPSKZ Indicator: sub-items exist CHAR 1 0 UPSKZ
DUMPS Phantom item indicator CHAR 1 0 DUMPS
TXTPS Item is Text indicator CHAR 1 0 TXTPS
INPOS Indicator: Intra Material CHAR 1 0 INPOS
SGTPS Bulk material indicator CHAR 1 0 SGTPS
KFPOS Indicator: Configurable Item CHAR 1 0 KFPOS
KZKUP Indicator: co-product CHAR 1 0 KZKUP
KLPOS Indicator: class item CHAR 1 0 KLPOS
CLAKZ Indicator: Classification Exists CHAR 1 0 CLAKZ
DBSKZ Direct procurement indicator CHAR 1 0 DBSKZ
No direct procurement or direct production
E Direct production
F Direct procurement
MTKFM Configurable Material CHAR 1 0 KZKFG
KMPKA Indicator for Relevancy to Costing CHAR 1 0 TCK08 CK_SELKZ
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
BEIKZ Material Provision Indicator CHAR 1 0 BEIKZ
ERSKZ Indicator: Spare Part CHAR 1 0 T413 ERSKZ
BDMNG Requirement Quantity of Component QUAN 13 3 CO_MENGE
VMENG Confirmed quantity for availability check in SKU QUAN 15 3 VMENG
LAGME Base Unit of Measure UNIT 3 0 MEINS
ESMNG Usage quantity per order unit of measure FLTP 16 16 ESMNG
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
BWART Movement type (inventory management) CHAR 3 0 T158B BWART
KZEAR Final Issue for Reservation CHAR 1 0 KZEAR
ERFMG Requirement Quantity of Component QUAN 13 3 CO_MENGE
ERFME Unit of entry UNIT 3 0 ERFME
UMREZ Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
UMREN Denominator for conversion to base units of measure DEC 5 0 UMREN
ENMNG Quantity withdrawn QUAN 13 3 ENMNG
FMENG Quantity is fixed CHAR 1 0 FMENG
ALTPS Alternative Item Indicator CHAR 1 0 ALTPS
EWAHR Usage Probability in % (Alternative Item) DEC 3 0 EWAHR
ALPGR Alternative item: group CHAR 2 0 CS_ALPGR
ALPRF Alternative item: ranking order NUMC 2 0 CS_ALPRF
ALPST Alternative item: strategy CHAR 1 0 CS_ALPST
1 Manual maintenance/by usage probability
2 100% check
KMPAS Component Scrap in Percent DEC 5 2 KAUSF
AVOAS Operation Scrap DEC 5 2 AVOAU
AVONT Net Scrap Indicator CHAR 1 0 NETAU
BDTER Requirements date for the component DATS 8 0 BDTER
SBTER Latest requirements date DATS 8 0 SBTER
NLFZT Lead-time offset DEC 3 0 NLFZT
ASTTR Order start date DATS 8 0 ASTTR
VERTI Distribution key for component consumption CHAR 4 0 SA_VERTI
REVLV Revision Level CHAR 2 0 REVLV
ROHPS Variable-Sized Item Indicator CHAR 1 0 ROHPS
ROANZ Required Number of Variable-Size Items QUAN 13 3 ROANZ
ROAME Unit of measure for variable-size items UNIT 3 0 ROAME
ROMNG Variable-Size Item Quantity per Piece (PC) QUAN 13 3 ROMEN
ROMEI Unit of measure for sizes 1 to 3 UNIT 3 0 ROMEI
ROMS1 Size 1 QUAN 13 3 ROMS1
ROMS2 Size 2 QUAN 13 3 ROMS2
ROMS3 Size 3 QUAN 13 3 ROMS3
RFORM Formula Key for Variable-Size Items CHAR 2 0 RFORM
LGPRO Issue Storage Location CHAR 4 0 T001L LGPRO
PRVBE Production Supply Area CHAR 10 0 PVBE PRVBE
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
AUSME Unit of issue UNIT 3 0 AUSME
STLTX Language: The long text was stored in this language LANG 1 0 LTXSP
SGTX1 Text, Length 40 CHAR 40 0 TXT40
SGTX2 Text, Length 40 CHAR 40 0 TXT40
NFPKZ Indicator: Follow-Up Item CHAR 1 0 CS_KZNFP
KZAUS Discontinuation Type CHAR 1 0 AUSLF
1 Simple discontinuation (-> maintain in master record)
2 Parallel discontin. (group) (-> maintain in BOM)
3 Dependent parallel discontin. (-> maintain in BOM)
5 Follow-up mat. within group (-> maintain BOM)
NFEAG Discontinuation group CHAR 2 0 CS_NFEAG
NFGRP Follow-up group CHAR 2 0 CS_NFGRP
NAFKZ Indicator: follow-up material active/not active CHAR 1 0 NAFKZ
NFMAT Follow-Up Material CHAR 40 0 NFMAT
NOMNG Input Quantity QUAN 13 3 NOMNG
NFUML NOT USED: Quantity transfer factor for follow-up material DEC 5 4 NFUML
AENNR Change Number CHAR 12 0 AENNR
BAUGR Higher-Level Assembly Material CHAR 40 0 BAUGR
BAUST Assembly Order Level NUMC 2 0 BAUST
BAUWG Assembly Order Path NUMC 2 0 BAUWG
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
STLNR Bill of Material CHAR 8 0 STNUM
STKNR BOM item node number NUMC 8 0 STLKN
STKZA Internal counter NUMC 8 0 CIM_COUNT
STVKN Inherited node number of BOM item NUMC 8 0 STVKN
SERNR BOM explosion number CHAR 8 0 SERNR
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
EKORG Purchasing organization CHAR 4 0 EKORG
EKGRP Purchasing Group CHAR 3 0 EKGRP
LIFZT Delivery time in days DEC 3 0 LIFZT
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
PREIS Price CURR 11 2 PREIS
PEINH Price unit DEC 5 0 PEINH
WAERS Currency Key CUKY 5 0 WAERS
SAKTO Cost element CHAR 10 0 SAKTO
MATKL Material Group CHAR 9 0 MATKL
DISMM MRP Type CHAR 2 0 DISMM
DISVF MRP Procedure CHAR 1 0 DISVF
B Reorder Point Planning
C Demand-Driven Replenishment
D Material Requirements Planning
M Master Production Scheduling
N No MRP
R Time-Phased Materials Planning
S Forecast-Based Planning
W Replenishment (IS Retail)
X Without MRP, with BOM Explosion
DISST Low-Level Code CHAR 3 0 DISST
MISKZ Mixed MRP indicator CHAR 1 0 MISKZ
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
MAKTX Material Description CHAR 40 0 MAKTX
SBDKZ Dependent requirements ind. for individual and coll. reqmts CHAR 1 0 SBDKZ
Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
KZBED Indicator for Requirements Grouping CHAR 1 0 KZBED
0 In rep. mfg, individual record in addn to total requirements
T Display of dependent requirements as a daily total
EPRIO Withdrawal Sequence Group for Stocks CHAR 4 0 EPRIO
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
MTAKZ Discontinuation indicator CHAR 1 0 KZAUS
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
MTADT Effective-Out Date DATS 8 0 AUSDT
MTNMT Follow-Up Material CHAR 40 0 NFMAT
RSNUM Number of reservation/dependent requirements NUMC 10 0 RSNUM
RSPOS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
RSART Record type CHAR 1 0 RSART
AUFNR Order Number CHAR 12 0 AUFNR
APLZL General counter for order NUMC 8 0 CO_APLZL
SMBLN Number of Material Document CHAR 10 0 MBLNR
SMBLP Item in Material Document NUMC 4 0 MBLPO
VSTAT Processing Status CHAR 1 0 VSTAT_D
SELKZ Selection flag CHAR 1 0 SELKZ
Not selected
* Selected and processed
X Selected but not yet processed
IMDCI Row Index of Internal Tables INT4 10 0 SYTABIX
ACENQ Material block in availability check with transfer of qties CHAR 1 0 ACENQ
IFIXX Internal fixing indicator when fixing phantom assemblies CHAR 1 0 IFIXX
STALT Alternative BOM CHAR 2 0 STALT
MTVFP Checking Group for Availability Check CHAR 2 0 MTVFP
PUMNG Input Quantity QUAN 13 3 NOMNG
VRPLA Indicator: planning without final assembly CHAR 1 0 VRPLA
PBDNR Requirements Plan CHAR 10 0 PBDNR
NOSRQ No individual requirements in table RESB CHAR 1 0 EINBD
DBKZG Requirement as total record in table RQIT CHAR 1 0 DBKZG
TECHS Parameter Variant/Standard Variant CHAR 12 0 TECHS
OBNUM Object reference: Document log - repetitive manufacturing CHAR 20 0 OBNUM
EDGNO Internal number for edge of object dependencies tree NUMC 17 0 EDGNO
NLFZV Lead-time offset for operation DEC 3 0 CS_NLFZV
NLFMV Unit for lead-time offset for operation UNIT 3 0 CS_NLFMV
APOKZ Indicator: Is material relevant for APO CHAR 1 0 APOKZ
Material is not relevant to APO
1 ATP check will be carried out in APO for material
2 ATP check and planning will be carried out in APO
3 Is active in APO integration model (set automatically)
MB_GRUND Reason for Movement NUMC 4 0 T157D MB_GRBEW
XFEHL Missing Part CHAR 1 0 XFEHL
NODSP Effective for Materials Planning CHAR 1 0 NO_DISP_PLUS
Relevant to materials planning
1 Not relevant to materials planning
B Immediately with blocking indicator
X Relevant to materials planning at a defined time
MLSCR Multilevel Subcontracting Indicator CHAR 1 0 MLSC_RELEVANT
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
BOM_VERSN BOM Version CHAR 4 0 CS_VERSN
/CWM/ERFMG Requirement Quantity of the Component in PUoM QUAN 13 3 /CWM/CO_MENGE
/CWM/ERFME PUoM Entry Unit of Measure UNIT 3 0 * /CWM/ERFME
/CWM/BDMNG Requirement Quantity QUAN 13 3 BDMNG
/CWM/MEINS Parallel Unit of Measure UNIT 3 0 * /CWM/MEINS
NO_DISP Effective for Materials Planning CHAR 1 0 NO_DISP_PLUS
Relevant to materials planning
1 Not relevant to materials planning
B Immediately with blocking indicator
X Relevant to materials planning at a defined time
DISUB_PSPNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
DISUB_KUNNR Customer Number CHAR 10 0 KUNNR
DISUB_VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
DISUB_POSNR Item number of the SD document NUMC 6 0 POSNR
DISUB_OWNER Owner of stock CHAR 10 0 * OWNER_D
ALLOCATED Single-Character Flag CHAR 1 0 CHAR1
FSH_CRITICAL_COMP Critical Component Indicator CHAR 1 0 FSH_CRITICAL_COMP
Not Critical
A Critical and automatic selection of stock
M Critical and manual selection of stock
FSH_CRITICAL_LEVEL Crtical Level of a Component in BoM DEC 2 0 FSH_CRITICAL_LEVEL
WRF_CHARSTC1 Characteristic Value 1 CHAR 18 0 WRF_CHARSTC1
WRF_CHARSTC1_TXT Characteristic Description 1 CHAR 70 0 WRF_CHARSTC1_TEXT
WRF_CHARSTC2 Characteristic Value 2 CHAR 18 0 WRF_CHARSTC2
WRF_CHARSTC2_TXT Characteristic Description 2 CHAR 70 0 WRF_CHARSTC2_TEXT
WRF_CHARSTC3 Characteristic Value 3 CHAR 18 0 WRF_CHARSTC3
WRF_CHARSTC3_TXT Characteristic Description 3 CHAR 70 0 WRF_CHARSTC3_TEXT

MDPM foreign key relationships

Table Field Check Table Check Field
0 MDPM BWART T158B Check Table: Movement Type for Transaction Code MANDT
0 MDPM BWART T158B Check Table: Movement Type for Transaction Code TCODE
1 MDPM CHARG MCHA Batches MANDT
1 MDPM CHARG MCHA Batches WERKS
1 MDPM CHARG MCHA Batches CHARG
0 MDPM ERSKZ T413 Spare Part Indicators MANDT
1 MDPM KMPKA TCK08 Indicator for Relevancy to Costing MANDT
1 MDPM KMPKA TCK08 Indicator for Relevancy to Costing SELKZ
0 MDPM KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
0 MDPM KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
1 MDPM LGPRO T001L Storage Locations MANDT
1 MDPM LGPRO T001L Storage Locations WERKS
0 MDPM MATNR MARA General Material Data MANDT
0 MDPM MATNR MARA General Material Data MATNR
1 MDPM MB_GRUND T157D Reason for Movement MANDT
0 MDPM POSTP T418 Item Categories MANDT
0 MDPM POSTP T418 Item Categories POSTP
1 MDPM PRVBE PVBE Production Supply Area MANDT
1 MDPM PRVBE PVBE Production Supply Area WERKS
1 MDPM PRVBE PVBE Production Supply Area PRVBE
0 MDPM WERKS T001W Plants/Branches WERKS