SAP ABAP Table PPH_MDPS_ABAP_EXT_COMPARE (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_SUPPORT (Package) PP on HANA: Test Entities

Basic Data

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