SAP ABAP Table PPH_MDPS_ABAP_EXT (Enhanced MDPS structure for HANA Selection used in ABAP)

Hierarchy

☛

SAP_APPL (Software Component) Logistics and Accounting
⤷

PP-MRP (Application Component) Material Requirements Planning
⤷

PPH_POSTPROCESSING (Package) PPH in HANA: Post Processing

Basic Data

Table Category	INTTAB	Structure
Structure	PPH_MDPS_ABAP_EXT	Table Relationship Diagram
Short Description	Enhanced MDPS structure for HANA Selection used in ABAP

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	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
2	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
3	BERID	BERID	BERID	CHAR	10	0	MRP Area	*
4	.INCLUDE				0	0	Item in MRP document
5	PLAAB	PLAAB	PLAAB	NUMC	2	0	Material requirements planning segment
6	PLANR	PLANR	PLANR	CHAR	20	0	Planning segment number
7	DAT00	DAT00	DATUM	DATS	8	0	Receipt/Requirements date
8	TAG00	TAG00	TAG00	NUMC	2	0	Daily shift (sort indicator 0)
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	VSTAT	VSTAT_D	VSTAT	CHAR	1	0	Processing Status
13	VRFKZ	VRFKZ	VRFKZ	CHAR	1	0	Availability indicator
14	PLUMI	PLUMI	CHAR1	CHAR	1	0	Receipt/issue indicator
15	MNG01	MNG01	MENGV13	QUAN	13	3	Quantity received or quantity required
16	MNG02	MNG02	MENG13	QUAN	13	3	Variable scrap quantity
17	MNG03	MNG03	MENG13	QUAN	13	3	Shortage Quantity
18	MNG04	MNG04	MENGV13	QUAN	13	3	ATP quantity
19	DAT01	DAT01	DATUM	DATS	8	0	Delivery/order finish date
20	DAT02	DAT02	DATUM	DATS	8	0	Start/release date
21	DAT03	DAT03	DATUM	DATS	8	0	Opening date
22	PERKZ	MD_PERKZ	MDPER	CHAR	1	0	Period indicator
23	PRPER	PRPER	PRPER	NUMC	6	0	Forecast period
24	WEBAZ	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
25	UKZ01	UKZ01	XFELD	CHAR	1	0	Indicator: MRP element can be brought forward
26	UMDAT	UMDAT	DATUM	DATS	8	0	Rescheduling date
27	UMDA2	UMDAT	DATUM	DATS	8	0	Rescheduling date
28	RDMNG	RDMNG	MENG13	QUAN	13	3	Excess stock quantity
29	FIX01	FIX01	XFELD	CHAR	1	0	Indicator: Fixing of Lot Size in Planned Order
30	FIX02	FIX02	XFELD	CHAR	1	0	Indicator: fixing explosion in planned order
31	BAART	BAART	BAART	CHAR	4	0	P.O./Order type
32	PLART	PLART	PLART	CHAR	1	0	Planning type	*
33	BESKZ	BESKZ	BESKZ	CHAR	1	0	Procurement Type
34	SOBES	SOBES	SOBES	CHAR	1	0	Special procurement type
35	ESOBS	ESOBS	ESOBS	CHAR	1	0	Special procurement - external display	*
36	UMSKZ	PLUMS	XFELD	CHAR	1	0	Conversion indicator for planned order
37	AUSSL	AUSSL	AUSSL	CHAR	2	0	Exception message key	*
38	OLDSL	OLDSL	AUSSL	CHAR	2	0	Key of the second exception message	*
39	ABEKZ	ABEKZ	CHAR1	CHAR	1	0	Exception indicator
40	WRK01	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
41	WRK02	PWWRK	WERKS	CHAR	4	0	Production plant in planned order	*
42	LGORT	LGORT_D	LGORT	CHAR	4	0	Storage location	*
43	CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
44	LSOBS	LSOBS	SOBSL	CHAR	2	0	Special procurement type at storage location level	*
45	DELNR	DELNR	DELNR	CHAR	10	0	MRP element number
46	DEL12	DEL12	DEL12	CHAR	12	0	MRP element number
47	DELPS	DELPS	DELPS	NUMC	6	0	MRP element item
48	DELET	DELET	DELET	NUMC	4	0	Scheduling number planning element
49	VPZUO	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
50	ZUVKZ	DZUVKZ	ZUVKZ	CHAR	1	0	Consumption indicator
51	VERVP	VERVP	VERVP	CHAR	1	0	Consumption indicator for planning requirements
52	VERSB	VERSB	VERSB	CHAR	2	0	Version number for independent requirements	*
53	AKTAL	AKTAL	XFLAG	CHAR	1	0	Current explosion available
54	RSNUM	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
55	SERNR	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
56	PALTR	PALTR	DATUM	DATS	8	0	Explosion date
57	TECHS	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
58	REVLV	REVLV	REVLV	CHAR	2	0	Revision level
59	VERID	VERID	VERID	CHAR	4	0	Production Version	*
60	STLAN	STLAN	STLAN	CHAR	1	0	BOM Usage	*
61	STALT	STALT	ALTNR	CHAR	2	0	Alternative BOM
62	STSTA	STLST	STLST	NUMC	2	0	BOM Statuses	*
63	NFPKZ	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
64	KZAUS	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
65	NFEAG	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
66	NFGRP	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
67	NAFKZ	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
68	NFMNG	NFMNG	MENGE	QUAN	13	3	Follow-up quantity
69	NFMAT	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
70	AENNR	AENNR	AENNR	CHAR	12	0	Change Number	*
71	DELVR	DELKZ	DELKZ	CHAR	2	0	MRP element
72	AUFVR	AUFVR	CHAR10	CHAR	10	0	Source number for order
73	POSVR	POSVR	NUM06	NUMC	6	0	Source item number
74	EINVR	EINVR	NUM04	NUMC	4	0	Source schedule line number
75	BAUGR	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	*
76	KNTTP	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
77	KZVBR	KZVBR	KZVBR	CHAR	1	0	Consumption posting
78	SOBKZ	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
79	KDAUF	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
80	KDPOS	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
81	PSPEL	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
82	CUOBJ	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
83	AUFNR	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	*
84	VERTO	SA_VERTO	SA_VERTL	CHAR	4	0	Distribution key for quantity produced	*
85	QUNUM	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
86	QUPOS	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
87	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
88	EKORG	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
89	EBELN	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
90	EBELP	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
91	VRTYP	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
92	AUTET	AUTET	AUTET	CHAR	1	0	Source List Usage in Materials Planning
93	BEDAT	BEDAT	DATUM	DATS	8	0	Purchase Order Date
94	ETMEN	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
95	GLMNG	GLMNG	MENG13	QUAN	13	3	Quantity Delivered (Stock Transfer)
96	FRTHW	FRTHW	FRTHW	CHAR	1	0	Production note in the planned order
97	AKTFT	AKTFT	XFELD	CHAR	1	0	Indicator "Detailed scheduling available"
98	BEDID	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
99	TRMER	TRMER	TRMER	CHAR	2	0	Scheduling error
100	AKTRT	AKTFT	XFELD	CHAR	1	0	Indicator "Detailed scheduling available"
101	RATID	RATID	BEDID	NUMC	12	0	Index for the results of scheduling production rates	*
102	RATER	RATER	TRMER	CHAR	2	0	Scheduling error in scheduling production rates
103	AKTGT	AKTGT	XFELD	CHAR	1	0	Indicator: "rough-cut scheduling available"
104	GROID	GROID	BEDID	NUMC	12	0	Index for rough scheduling results	*
105	GROER	GROER	TRMER	CHAR	2	0	Scheduling error in rough scheduling
106	AUFTM	AUFTM	MENGV13	QUAN	13	3	MRP element: order quantity
107	ARSNR	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
108	ARSPS	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
109	PRNKZ	PRNKZ	KREUZ	CHAR	1	0	Ind.: Leading order in collective order is planned ordre
110	KAPFX	KAPFX	XFELD	CHAR	1	0	Indicator: capacity for planned order dispatched
111	PSTTI	PSTTI	UZEIT	TIMS	6	0	Start Time of Planned Order
112	PEDTI	PEDTI	UZEIT	TIMS	6	0	End Time of Planned Order
113	RSART	RSART	RSART	CHAR	1	0	Record type
114	XFEHL	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
115	MONKZ	MONKZ	XFELD	CHAR	1	0	Indicator: for assembly order procedures
116	MDFST	MDFST	CHAR1	CHAR	1	0	Production order status: internal ind. for MRP
117	VRPLA	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
118	PBDNR	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
119	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
120	KZBWS	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
121	MDMNG	MDMNG	MENGV13	QUAN	13	3	MRP: quantity field (stock in transit, receipt qty, ...)
122	WAMNG	WAMNG	MENG13	QUAN	13	3	Issued quantity
123	EDGNO	EDGNO	EDGNO	NUMC	17	0	Internal number for edge of object dependencies tree	*
124	TPMNG	TPQTY	MENGV13	QUAN	13	3	Overall quantity MRP element (for static pegging)
125	EMATN	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
126	.INCLUDE				0	0	Include alternative quantity, MRP document
127	UMREZ	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
128	UMREN	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
129	ERFME	ERFME	MEINS	UNIT	3	0	Unit of entry	*
130	ERFMG	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
131	PRSCH	MD_PRSCHED	XFELD	CHAR	1	0	Planned order: scheduling using production dates
132	LVSCH	MD_LVSCHED	SCHED_TYPE	CHAR	1	0	Planned order: leading scheduling level (determines dates)
133	DBSKZ	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
134	STLTY	STLTY	STLTY	CHAR	1	0	BOM Category
135	STLNR	STNUM	STNUM	CHAR	8	0	Bill of Material
136	STLKN	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
137	STPOZ	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
138	EKGRP	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
139	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
140	PLIFZ	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
141	PSTMP	PSTMP	TZNTSTMPS	DEC	15	0	Last Change to Planned Order: Time Stamp
142	EXTNL	EXTNL	XFELD	CHAR	1	0	Indicator for External Procurement
143	ADINF	MD_ADINF	MD_ADINF	CHAR	4	0	Field for Additional Information
144	STAEX	MD_STAEX	MD_STAEX	CHAR	2	0	Status information on BOM explosion in planned order
145	RESLO	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
146	PRIO_URG	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
147	PRIO_REQ	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
148	MDMAT	MATNR	MATNR	CHAR	18	0	Material Number	*
149	MDLOC	MDLOC		CHAR	20	0	Location of MRP Element
150	MDWRK	WERKS_D	WERKS	CHAR	4	0	Plant	*
151	MDBER	BERID	BERID	CHAR	10	0	MRP Area	*
152	SRM_CONTRACT_ID	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
153	SRM_CONTRACT_ITM	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
154	.INCLUDE				0	0
155	RESB_UMWRK			CHAR	4	0
156	RESB_SHKZG			CHAR	1	0
157	RESB_DUMPS			CHAR	1	0
158	RESB_BWART	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
159	XT_RSSTA			CHAR	1	0
160	RESB_SCHGT			CHAR	1	0
161	XT_UMSOK			CHAR	1	0
162	MDUB_BSTYP			CHAR	1	0
163	XT_RETPO			CHAR	1	0
164	XT_LBLKZ			CHAR	1	0
165	XT_LOEKZ			CHAR	1	0
166	XT_AKTNR			CHAR	10	0
167	MDUA_FRGDT			CHAR	8	0
168	MDUA_LBLKZ			CHAR	1	0
169	XT_EMLIF			CHAR	10	0
170	XT_INSMK			CHAR	1	0
171	XT_ITCONS			CHAR	1	0
172	XT_STATU			CHAR	1	0
173	EBAN_PSTYP			CHAR	1	0
174	MDBS_BSTME	BSTME	MEINS	UNIT	3	0	Order unit	*
175	EBAN_ESTKZ			CHAR	1	0
176	EBAN_FRGKZ	FRGKZ	FRGKZ	CHAR	1	0	Release Indicator	*
177	EBAN_REVNO	REVNO	REVNO	CHAR	8	0	Version number in Purchasing
178	XT_NO_DISP			CHAR	1	0
179	MDPB_PLNKZ			CHAR	1	0
180	MDPB_OPLKZ			CHAR	1	0
181	XT_WEPOS			CHAR	1	0
182	MARD_DISKZ			CHAR	1	0
183	MARD_IS_CONSI			CHAR	1	0
184	MARD_BSKFL	BSKFL	XFLAG	CHAR	1	0	Flag whether stock correction factors exist
185	XT_STOCK_CAT			CHAR	1	0
186	XT_MENGE_DB			DEC	13	3
187	XT_WEMNG_DB			DEC	13	3
188	MDBS_WAMNG_DB			DEC	13	3
189	MDBS_DABMG_DB			DEC	13	3
190	MDBS_AMENG			DEC	13	3
191	MDBS_FIXMG	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
192	MDBS_EGLKZ	EGLKZ	XFELD	CHAR	1	0	"Outward Delivery Completed" Indicator
193	AFPO_KRSNR	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
194	AFPO_KRSPS	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
195	XT_FLS_RSTO	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
196	XT_KONNR	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
197	XT_KTPNR	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
198	XT_INFNR	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
199	XT_KZFIX	KZFIX	KZFIX	CHAR	1	0	Indicator: Fixing control
200	XT_ETFZ1	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
201	XT_ETFZ2	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)
202	DISTR_DONE	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)