SAP ABAP Table PPH_MDPS_EXT_TWO (enhanced MDPS structure)

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_TWO	Table Relationship Diagram
Short Description	enhanced MDPS structure

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	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	DAT00	☐	DAT00	DATUM	DATS	8	0	Receipt/Requirements date
6	SORT1	☐	SORT1	SORT1	CHAR	1	0	Sort indicator 01
7	SORT2	☐	SORT2	SORT2	CHAR	2	0	Sort indicator 02
8	DELKZ	☐	DELKZ	DELKZ	CHAR	2	0	MRP element
9	VRFKZ	☐	VRFKZ	VRFKZ	CHAR	1	0	Availability indicator
10	PLUMI	☐	PLUMI	CHAR1	CHAR	1	0	Receipt/issue indicator
11	MNG01	☐			DEC	20	3
12	MNG02	☐	MNG02	MENG13	QUAN	13	3	Variable scrap quantity
13	MNG03	☐			DEC	20	3
14	MNG04	☐	MNG04	MENGV13	QUAN	13	3	ATP quantity
15	DAT01	☐	DAT01	DATUM	DATS	8	0	Delivery/order finish date
16	DAT02	☐	DAT02	DATUM	DATS	8	0	Start/release date
17	DAT03	☐	DAT03	DATUM	DATS	8	0	Opening date
18	PERKZ	☐	MD_PERKZ	MDPER	CHAR	1	0	Period indicator
19	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
20	FIX01	☐	FIX01	XFELD	CHAR	1	0	Indicator: Fixing of Lot Size in Planned Order
21	FIX02	☐	FIX02	XFELD	CHAR	1	0	Indicator: fixing explosion in planned order
22	BAART	☐	BAART	BAART	CHAR	4	0	P.O./Order type
23	PLART	☐	PLART	PLART	CHAR	1	0	Planning type	*
24	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
25	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
26	UMSKZ	☐	PLUMS	XFELD	CHAR	1	0	Conversion indicator for planned order
27	WRK01	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
28	WRK02	☐	PWWRK	WERKS	CHAR	4	0	Production plant in planned order	*
29	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
30	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
31	LSOBS	☐	LSOBS	SOBSL	CHAR	2	0	Special procurement type at storage location level	*
32	DELNR	☐	DELNR	DELNR	CHAR	10	0	MRP element number
33	DEL12	☐	DEL12	DEL12	CHAR	12	0	MRP element number
34	DELPS	☐	DELPS	DELPS	NUMC	6	0	MRP element item
35	DELET	☐	DELET	DELET	NUMC	4	0	Scheduling number planning element
36	VPZUO	☐	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
37	ZUVKZ	☐			CHAR	1	0
38	VERVP	☐	VERVP	VERVP	CHAR	1	0	Consumption indicator for planning requirements
39	VERSB	☐	VERSB	VERSB	CHAR	2	0	Version number for independent requirements	*
40	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
41	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
42	PALTR	☐	PALTR	DATUM	DATS	8	0	Explosion date
43	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
44	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
45	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
46	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	*
47	STALT	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
48	STSTA	☐	STLST	STLST	NUMC	2	0	BOM Statuses	*
49	NFPKZ	☐	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
50	KZAUS	☐	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
51	NFEAG	☐	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
52	NFGRP	☐	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
53	NAFKZ	☐	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
54	NFMNG	☐	NFMNG	MENGE	QUAN	13	3	Follow-up quantity
55	NFMAT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
56	DELVR	☐	DELKZ	DELKZ	CHAR	2	0	MRP element
57	AUFVR	☐	AUFVR	CHAR10	CHAR	10	0	Source number for order
58	POSVR	☐	POSVR	NUM06	NUMC	6	0	Source item number
59	EINVR	☐	EINVR	NUM04	NUMC	4	0	Source schedule line number
60	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	*
61	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
62	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
63	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
64	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
65	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
66	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
67	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
68	AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	*
69	VERTO	☐	SA_VERTO	SA_VERTL	CHAR	4	0	Distribution key for quantity produced	*
70	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
71	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
72	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
73	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
74	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
75	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
76	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
77	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
78	ETMEN	☐	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
79	GLMNG	☐	GLMNG	MENG13	QUAN	13	3	Quantity Delivered (Stock Transfer)
80	FRTHW	☐	FRTHW	FRTHW	CHAR	1	0	Production note in the planned order
81	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
82	TRMER	☐	TRMER	TRMER	CHAR	2	0	Scheduling error
83	RATID	☐	RATID	BEDID	NUMC	12	0	Index for the results of scheduling production rates	*
84	RATER	☐	RATER	TRMER	CHAR	2	0	Scheduling error in scheduling production rates
85	GROID	☐	GROID	BEDID	NUMC	12	0	Index for rough scheduling results	*
86	GROER	☐	GROER	TRMER	CHAR	2	0	Scheduling error in rough scheduling
87	AUFTM	☐	AUFTM	MENGV13	QUAN	13	3	MRP element: order quantity
88	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
89	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
90	PRNKZ	☐	PRNKZ	KREUZ	CHAR	1	0	Ind.: Leading order in collective order is planned ordre
91	KAPFX	☐	KAPFX	XFELD	CHAR	1	0	Indicator: capacity for planned order dispatched
92	PSTTI	☐	PSTTI	UZEIT	TIMS	6	0	Start Time of Planned Order
93	PEDTI	☐	PEDTI	UZEIT	TIMS	6	0	End Time of Planned Order
94	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
95	MONKZ	☐	MONKZ	XFELD	CHAR	1	0	Indicator: for assembly order procedures
96	MDFST	☐	MDFST	CHAR1	CHAR	1	0	Production order status: internal ind. for MRP
97	VRPLA	☐	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
98	PBDNR	☐	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
99	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
100	MDMNG	☐	MDMNG	MENGV13	QUAN	13	3	MRP: quantity field (stock in transit, receipt qty, ...)
101	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
102	EDGNO	☐	EDGNO	EDGNO	NUMC	17	0	Internal number for edge of object dependencies tree	*
103	TPMNG	☐			DEC	20	3
104	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
105	PRSCH	☐	MD_PRSCHED	XFELD	CHAR	1	0	Planned order: scheduling using production dates
106	LVSCH	☐	MD_LVSCHED	SCHED_TYPE	CHAR	1	0	Planned order: leading scheduling level (determines dates)
107	DBSKZ	☐	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
108	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
109	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
110	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
111	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
112	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
113	PSTMP	☐	PSTMP	TZNTSTMPS	DEC	15	0	Last Change to Planned Order: Time Stamp
114	EXTNL	☐	EXTNL	XFELD	CHAR	1	0	Indicator for External Procurement
115	STAEX	☐	MD_STAEX	MD_STAEX	CHAR	2	0	Status information on BOM explosion in planned order
116	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
117	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
118	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
119	XT_RSSTA	☐	RSSTA	STATR	CHAR	1	0	Status of reservation
120	XT_UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
121	XT_STATU	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
122	MDBS_BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
123	EBAN_ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
124	EBAN_FRGKZ	☐	FRGKZ	FRGKZ	CHAR	1	0	Release Indicator	*
125	EBAN_REVNO	☐	REVNO	REVNO	CHAR	8	0	Version number in Purchasing
126	MARD_DISKZ	☐	DISKZ	DISKZ	CHAR	1	0	Storage location MRP indicator
127	MARD_BSKFL	☐	BSKFL	XFLAG	CHAR	1	0	Flag whether stock correction factors exist
128	XT_MENGE_DB	☐			DEC	13	3
129	XT_WEMNG_DB	☐			DEC	13	3
130	MDBS_DABMG_DB	☐			DEC	13	3
131	AFPO_KRSNR	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
132	AFPO_KRSPS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
133	XT_KZFIX	☐	KZFIX	KZFIX	CHAR	1	0	Indicator: Fixing control
134	XT_ETFZ1	☐	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
135	XT_ETFZ2	☐	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PPH_MDPS_EXT_TWO	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
2	PPH_MDPS_EXT_TWO	PRIO_URG	PURG	PRIO_URG	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in	616