SAP ABAP Table PPH_MDPS_EXT_ONE (enhanced MDPS structure SP1)

Hierarchy

☛

SAP_APPL (Software Component) Logistics and Accounting
⤷

PP-MRP (Application Component) Material Requirements Planning
⤷

PPH_ACCESS_HANA (Package) PP on HANA: Access to HANA objects

Basic Data

Table Category	INTTAB	Structure
Structure	PPH_MDPS_EXT_ONE	Table Relationship Diagram
Short Description	enhanced MDPS structure SP1

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
2	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
3	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
4	BERID	BERID	BERID	CHAR	10	0	MRP Area	*
5	BERTY	BERTY	BERTY	NUMC	2	0	Type of MRP area
6	PLAAB	PLAAB	PLAAB	NUMC	2	0	Material requirements planning segment
7	PLANR	PLANR	PLANR	CHAR	20	0	Planning segment number
8	DAT00	DAT00	DATUM	DATS	8	0	Receipt/Requirements date
9	SORT1	SORT1	SORT1	CHAR	1	0	Sort indicator 01
10	SORT2	SORT2	SORT2	CHAR	2	0	Sort indicator 02
11	DELKZ	DELKZ	DELKZ	CHAR	2	0	MRP element
12	VRFKZ	VRFKZ	VRFKZ	CHAR	1	0	Availability indicator
13	PLUMI	PLUMI	CHAR1	CHAR	1	0	Receipt/issue indicator
14	MNG01			DEC	20	3
15	MNG02	MNG02	MENG13	QUAN	13	3	Variable scrap quantity
16	MNG03			DEC	20	3
17	MNG04	MNG04	MENGV13	QUAN	13	3	ATP quantity
18	DAT01	DAT01	DATUM	DATS	8	0	Delivery/order finish date
19	DAT02	DAT02	DATUM	DATS	8	0	Start/release date
20	DAT03	DAT03	DATUM	DATS	8	0	Opening date
21	PERKZ	MD_PERKZ	MDPER	CHAR	1	0	Period indicator
22	WEBAZ	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
23	FIX01	FIX01	XFELD	CHAR	1	0	Indicator: Fixing of Lot Size in Planned Order
24	FIX02	FIX02	XFELD	CHAR	1	0	Indicator: fixing explosion in planned order
25	BAART	BAART	BAART	CHAR	4	0	P.O./Order type
26	PLART	PLART	PLART	CHAR	1	0	Planning type	*
27	BESKZ	BESKZ	BESKZ	CHAR	1	0	Procurement Type
28	SOBES	SOBES	SOBES	CHAR	1	0	Special procurement type
29	UMSKZ	PLUMS	XFELD	CHAR	1	0	Conversion indicator for planned order
30	WRK01	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
31	WRK02	PWWRK	WERKS	CHAR	4	0	Production plant in planned order	*
32	LGORT	LGORT_D	LGORT	CHAR	4	0	Storage location	*
33	CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
34	LSOBS	LSOBS	SOBSL	CHAR	2	0	Special procurement type at storage location level	*
35	DELNR	DELNR	DELNR	CHAR	10	0	MRP element number
36	DEL12	DEL12	DEL12	CHAR	12	0	MRP element number
37	DELPS	DELPS	DELPS	NUMC	6	0	MRP element item
38	DELET	DELET	DELET	NUMC	4	0	Scheduling number planning element
39	VPZUO	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
40	ZUVKZ			CHAR	1	0
41	VERVP	VERVP	VERVP	CHAR	1	0	Consumption indicator for planning requirements
42	VERSB	VERSB	VERSB	CHAR	2	0	Version number for independent requirements	*
43	RSNUM	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
44	SERNR	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
45	PALTR	PALTR	DATUM	DATS	8	0	Explosion date
46	TECHS	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
47	REVLV	REVLV	REVLV	CHAR	2	0	Revision level
48	VERID	VERID	VERID	CHAR	4	0	Production Version	*
49	STLAN	STLAN	STLAN	CHAR	1	0	BOM Usage	*
50	STALT	STALT	ALTNR	CHAR	2	0	Alternative BOM
51	STSTA	STLST	STLST	NUMC	2	0	BOM Statuses	*
52	NFPKZ	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
53	KZAUS	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
54	NFEAG	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
55	NFGRP	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
56	NAFKZ	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
57	NFMNG	NFMNG	MENGE	QUAN	13	3	Follow-up quantity
58	NFMAT	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
59	DELVR	DELKZ	DELKZ	CHAR	2	0	MRP element
60	AUFVR	AUFVR	CHAR10	CHAR	10	0	Source number for order
61	POSVR	POSVR	NUM06	NUMC	6	0	Source item number
62	EINVR	EINVR	NUM04	NUMC	4	0	Source schedule line number
63	BAUGR	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	*
64	KNTTP	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
65	KZVBR	KZVBR	KZVBR	CHAR	1	0	Consumption posting
66	SOBKZ	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
67	KDAUF	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
68	KDPOS	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
69	PSPEL	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
70	CUOBJ	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
71	AUFNR	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	*
72	VERTO	SA_VERTO	SA_VERTL	CHAR	4	0	Distribution key for quantity produced	*
73	QUNUM	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
74	QUPOS	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
75	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
76	EKORG	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
77	EBELN	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
78	EBELP	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
79	VRTYP	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
80	BEDAT	BEDAT	DATUM	DATS	8	0	Purchase Order Date
81	ETMEN	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
82	GLMNG	GLMNG	MENG13	QUAN	13	3	Quantity Delivered (Stock Transfer)
83	FRTHW	FRTHW	FRTHW	CHAR	1	0	Production note in the planned order
84	BEDID	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
85	TRMER	TRMER	TRMER	CHAR	2	0	Scheduling error
86	RATID	RATID	BEDID	NUMC	12	0	Index for the results of scheduling production rates	*
87	RATER	RATER	TRMER	CHAR	2	0	Scheduling error in scheduling production rates
88	GROID	GROID	BEDID	NUMC	12	0	Index for rough scheduling results	*
89	GROER	GROER	TRMER	CHAR	2	0	Scheduling error in rough scheduling
90	AUFTM	AUFTM	MENGV13	QUAN	13	3	MRP element: order quantity
91	ARSNR	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
92	ARSPS	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
93	PRNKZ	PRNKZ	KREUZ	CHAR	1	0	Ind.: Leading order in collective order is planned ordre
94	KAPFX	KAPFX	XFELD	CHAR	1	0	Indicator: capacity for planned order dispatched
95	PSTTI	PSTTI	UZEIT	TIMS	6	0	Start Time of Planned Order
96	PEDTI	PEDTI	UZEIT	TIMS	6	0	End Time of Planned Order
97	XFEHL	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
98	MONKZ	MONKZ	XFELD	CHAR	1	0	Indicator: for assembly order procedures
99	MDFST	MDFST	CHAR1	CHAR	1	0	Production order status: internal ind. for MRP
100	VRPLA	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
101	PBDNR	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
102	KZBWS	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
103	MDMNG	MDMNG	MENGV13	QUAN	13	3	MRP: quantity field (stock in transit, receipt qty, ...)
104	WAMNG	WAMNG	MENG13	QUAN	13	3	Issued quantity
105	EDGNO	EDGNO	EDGNO	NUMC	17	0	Internal number for edge of object dependencies tree	*
106	TPMNG			DEC	20	3
107	EMATN	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
108	PRSCH	MD_PRSCHED	XFELD	CHAR	1	0	Planned order: scheduling using production dates
109	LVSCH	MD_LVSCHED	SCHED_TYPE	CHAR	1	0	Planned order: leading scheduling level (determines dates)
110	DBSKZ	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
111	STLTY	STLTY	STLTY	CHAR	1	0	BOM Category
112	STLNR	STNUM	STNUM	CHAR	8	0	Bill of Material
113	STLKN	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
114	STPOZ	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
115	PLIFZ	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
116	PSTMP	PSTMP	TZNTSTMPS	DEC	15	0	Last Change to Planned Order: Time Stamp
117	EXTNL	EXTNL	XFELD	CHAR	1	0	Indicator for External Procurement
118	STAEX	MD_STAEX	MD_STAEX	CHAR	2	0	Status information on BOM explosion in planned order
119	RESLO	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
120	RESB_UMWRK	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	*
121	RESB_SHKZG	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
122	RESB_DUMPS	DUMPS	XFELD	CHAR	1	0	Phantom item indicator
123	RESB_BWART	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
124	XT_RSSTA	RSSTA	STATR	CHAR	1	0	Status of reservation
125	RESB_SCHGT	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
126	XT_UMSOK	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
127	MDUB_BSTYP	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
128	XT_RETPO	RETPO	XFELD	CHAR	1	0	Returns Item
129	XT_LBLKZ	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
130	XT_LOEKZ	LOEKZ	XFELD	CHAR	1	0	Asset class marked for deletion
131	XT_AKTNR	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
132	MDUA_FRGDT	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
133	XT_EMLIF	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	*
134	XT_INSMK	INSMK	INSMK	CHAR	1	0	Stock Type
135	XT_ITCONS	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
136	XT_STATU	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
137	EBAN_PSTYP	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
138	MDBS_BSTME	BSTME	MEINS	UNIT	3	0	Order unit	*
139	EBAN_ESTKZ	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
140	EBAN_FRGKZ	FRGKZ	FRGKZ	CHAR	1	0	Release Indicator	*
141	EBAN_REVNO	REVNO	REVNO	CHAR	8	0	Version number in Purchasing
142	XT_NO_DISP	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
143	MDPB_PLNKZ	PLNKZ	PLNKZ	CHAR	1	0	Planning Indicator
144	MDPB_OPLKZ	OPLKZ	CHAR1	CHAR	1	0	With no MRP
145	XT_WEPOS	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
146	MARD_DISKZ	DISKZ	DISKZ	CHAR	1	0	Storage location MRP indicator
147	MARD_IS_CONSI			CHAR	1	0
148	MARD_BSKFL	BSKFL	XFLAG	CHAR	1	0	Flag whether stock correction factors exist
149	XT_STOCK_CAT			CHAR	1	0
150	XT_MENGE_DB			DEC	13	3
151	XT_WEMNG_DB			DEC	13	3
152	MDBS_WAMNG_DB			DEC	13	3
153	MDBS_DABMG_DB			DEC	13	3
154	MDBS_AMENG			DEC	13	3
155	MDBS_FIXMG	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
156	MDBS_EGLKZ	EGLKZ	XFELD	CHAR	1	0	"Outward Delivery Completed" Indicator
157	AFPO_KRSNR	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
158	AFPO_KRSPS	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
159	XT_FLS_RSTO	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
160	XT_KONNR	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
161	XT_KTPNR	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
162	XT_INFNR	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
163	XT_KZFIX	KZFIX	KZFIX	CHAR	1	0	Indicator: Fixing control
164	XT_ETFZ1	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
165	XT_ETFZ2	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)