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

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-MRP-BD (Application Component) Master Data
     ⤷ MD02 (Package) Appl. development R/3 control tables requirements planning

Basic Data

Table Category	INTTAB	Structure
Structure	MDPM	Table Relationship Diagram
Short Description	View of Material Components in the Planned Order

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	AUFST	☐	AUFST	AUFST	NUMC	2	0	Order level
2	AUFWG	☐	AUFWG	AUFWG	NUMC	2	0	Order path
3	PMSOR	☐	PMSOR	RSPOS	NUMC	4	0	Internal sort key
4	XPOSN	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
5	PMSO1	☐	PMSO1	CHAR2	CHAR	2	0	Sort fiels 1 for discontinued and substitute parts
6	EPOSN	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
7	STSOR	☐	SORTP	CHAR10	CHAR	10	0	Sort String
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
11	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
12	POSNR	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
13	UPSKZ	☐	UPSKZ	XFELD	CHAR	1	0	Indicator: Subitems Exist
14	DUMPS	☐	DUMPS	XFELD	CHAR	1	0	Phantom item indicator
15	TXTPS	☐	TXTPS	XFELD	CHAR	1	0	Item text indicator
16	INPOS	☐	INPOS	XFELD	CHAR	1	0	Indicator: intra material
17	SGTPS	☐	SGTPS	XFELD	CHAR	1	0	Bulk material indicator
18	KFPOS	☐	KFPOS	XFLAG	CHAR	1	0	Indicator: "configurable item"
19	KZKUP	☐	KZKUP	XFELD	CHAR	1	0	Indicator: Co-Product
20	KLPOS	☐	KLPOS	XFELD	CHAR	1	0	Indicator: class item
21	CLAKZ	☐	CLAKZ	XFELD	CHAR	1	0	Indicator: classification exists
22	DBSKZ	☐	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
23	MTKFM	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
24	KMPKA	☐	CK_SELKZ	CK_SELKZ	CHAR	1	0	Indicator for Relevancy to Costing	TCK08
25	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
26	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
27	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
28	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
29	BEIKZ	☐	BEIKZ	BEIKZ	CHAR	1	0	Material Provision Indicators	*
30	ERSKZ	☐	ERSKZ	ERSKZ	CHAR	1	0	Indicator: Spare Part	T413
31	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
32	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
33	LAGME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
34	ESMNG	☐	ESMNG	ESMNG	FLTP	16	16	Usage quantity per order unit of measure
35	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
36	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T158B
37	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
38	ERFMG	☐	CO_MENGE	MENGV13	QUAN	13	3	Requirement quantity of the component
39	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	*
40	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
41	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
42	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
43	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
44	ALTPS	☐	ALTPS	XFELD	CHAR	1	0	Alternative item indicator
45	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
46	ALPGR	☐	CS_ALPGR	CHAR2	CHAR	2	0	Alternative Item: Group
47	ALPRF	☐	CS_ALPRF	NUM2	NUMC	2	0	Alternative Item: Ranking Order
48	ALPST	☐	CS_ALPST	CS_ALPST	CHAR	1	0	Alternative Item: Strategy
49	KMPAS	☐	KAUSF	DEC3_2	DEC	5	2	Component scrap in percent
50	AVOAS	☐	AVOAU	DEC3_2	DEC	5	2	Operation Scrap
51	AVONT	☐	NETAU	XFELD	CHAR	1	0	Indicator: Net Scrap
52	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
53	SBTER	☐	SBTER	DATUM	DATS	8	0	Latest requirements date
54	NLFZT	☐	NLFZT	NLFZT	DEC	3	0	Lead-Time Offset
55	ASTTR	☐	ASTTR	DATUM	DATS	8	0	Order start date
56	VERTI	☐	SA_VERTI	SA_VERTL	CHAR	4	0	Distribution key for component consumption	*
57	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
58	ROHPS	☐	ROHPS	XFELD	CHAR	1	0	Variable-sized item indicator
59	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
60	ROAME	☐	ROAME	MEINS	UNIT	3	0	Unit of measure for variable-size items	*
61	ROMNG	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
62	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	*
63	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
64	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
65	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
66	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	*
67	LGPRO	☐	LGPRO	LGORT	CHAR	4	0	Issue storage location	T001L
68	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	PVBE
69	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
70	AUSME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	*
71	STLTX	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	*
72	SGTX1	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
73	SGTX2	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
74	NFPKZ	☐	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
75	KZAUS	☐	AUSLF	AUSLF	CHAR	1	0	Discontinuation type
76	NFEAG	☐	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
77	NFGRP	☐	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
78	NAFKZ	☐	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
79	NFMAT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
80	NOMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
81	NFUML	☐	NFUML	NFUML	DEC	5	4	NOT USED: Quantity transfer factor for follow-up material
82	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
83	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	*
84	BAUST	☐	BAUST	AUFST	NUMC	2	0	Assembly order level
85	BAUWG	☐	BAUWG	AUFWG	NUMC	2	0	Assembly order path
86	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
87	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
88	STKNR	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
89	STKZA	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
90	STVKN	☐	STVKN	KNTNR	NUMC	8	0	Inherited Node Number of BOM Item
91	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
92	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
93	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
94	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
95	LIFZT	☐	LIFZT	DEC3	DEC	3	0	Delivery Time in Days
96	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
97	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
98	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
99	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
100	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
101	SAKTO	☐	SAKTO	SAKNR	CHAR	10	0	Cost Element	*
102	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
103	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	*
104	DISVF	☐	DISVF	DISVF	CHAR	1	0	MRP procedure
105	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
106	MISKZ	☐	MISKZ	MISKZ	CHAR	1	0	Mixed MRP indicator
107	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
108	SBDKZ	☐	SBDKZ	SBDKZ	CHAR	1	0	Dependent requirements ind. for individual and coll. reqmts
109	KZBED	☐	KZBED	KZBED	CHAR	1	0	Indicator for Requirements Grouping
110	EPRIO	☐	EPRIO	EPRIO	CHAR	4	0	Withdrawal sequence group for stocks	*
111	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
112	MTAKZ	☐	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
113	MTADT	☐	AUSDT	DATUM	DATS	8	0	Effective-out date
114	MTNMT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
115	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
116	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
117	RSART	☐	RSART	RSART	CHAR	1	0	Record type
118	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
119	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
120	SMBLN	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
121	SMBLP	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
122	VSTAT	☐	VSTAT_D	VSTAT	CHAR	1	0	Processing Status
123	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
124	IMDCI	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
125	ACENQ	☐	ACENQ	XFELD	CHAR	1	0	Material block in availability check with transfer of qties
126	IFIXX	☐	IFIXX	CHAR1	CHAR	1	0	Internal fixing indicator when fixing phantom assemblies
127	STALT	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
128	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	*
129	PUMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
130	VRPLA	☐	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
131	PBDNR	☐	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
132	NOSRQ	☐	EINBD	CHAR1	CHAR	1	0	No individual requirements in table RESB
133	DBKZG	☐	DBKZG	CHAR1	CHAR	1	0	Requirement as total record in table RQIT
134	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
135	OBNUM	☐	OBNUM	OBNUM	CHAR	20	0	Object reference: Document log - repetitive manufacturing
136	EDGNO	☐	EDGNO	EDGNO	NUMC	17	0	Internal number for edge of object dependencies tree	*
137	NLFZV	☐	CS_NLFZV	NLFZT	DEC	3	0	Lead-time offset for operation
138	NLFMV	☐	CS_NLFMV	MEINS	UNIT	3	0	Unit for lead-time offset for operation	*
139	APOKZ	☐	APOKZ	APOKZ	CHAR	1	0	Indicator: Is material relevant for APO
140	.INCLUDE	☐				0	0	Structure for Goods Movement - Reason Code
141	MB_GRUND	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	T157D
142	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
143	NODSP	☐	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
144	MLSCR	☐	MLSC_RELEVANT	XFELD	CHAR	1	0	Multilevel Subcontracting Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDPM	BWART	T158B	BWART		1	N
2	MDPM	CHARG	MCHA	CHARG
3	MDPM	ERSKZ	T413	ERSKZ
4	MDPM	KMPKA	TCK08	SELKZ
5	MDPM	KNTTP	T163K	KNTTP
6	MDPM	LGPRO	T001L	LGORT
7	MDPM	MATNR	MARA	MATNR
8	MDPM	MB_GRUND	T157D	GRUND
9	MDPM	POSTP	T418	POSTP
10	MDPM	PRVBE	PVBE	PRVBE
11	MDPM	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in