SAP ABAP Table MDPS (Item in MRP document)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM (Application Component) Customer Relationship Management
⤷

CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷

MD (Package) Application development R/3 requirements planning

Basic Data

Table Category	INTTAB	Structure
Structure	MDPS	Table Relationship Diagram
Short Description	Item in MRP document

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	PLAAB	PLAAB	PLAAB	NUMC	2	0	Material requirements planning segment
2	PLANR	PLANR	PLANR	CHAR	20	0	Planning segment number
3	DAT00	DAT00	DATUM	DATS	8	0	Receipt/Requirements date
4	TAG00	TAG00	TAG00	NUMC	2	0	Daily shift (sort indicator 0)
5	SORT1	SORT1	SORT1	CHAR	1	0	Sort indicator 01
6	SORT2	SORT2	SORT2	CHAR	2	0	Sort indicator 02
7	DELKZ	DELKZ	DELKZ	CHAR	2	0	MRP element
8	VSTAT	VSTAT_D	VSTAT	CHAR	1	0	Processing Status
9	VRFKZ	VRFKZ	VRFKZ	CHAR	1	0	Availability indicator
10	PLUMI	PLUMI	CHAR1	CHAR	1	0	Receipt/issue indicator
11	MNG01	MNG01	MENGV13	QUAN	13	3	Quantity received or quantity required
12	MNG02	MNG02	MENG13	QUAN	13	3	Variable scrap quantity
13	MNG03	MNG03	MENG13	QUAN	13	3	Shortage Quantity
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	PRPER	PRPER	PRPER	NUMC	6	0	Forecast period
20	WEBAZ	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
21	UKZ01	UKZ01	XFELD	CHAR	1	0	Indicator: MRP element can be brought forward
22	UMDAT	UMDAT	DATUM	DATS	8	0	Rescheduling date
23	UMDA2	UMDAT	DATUM	DATS	8	0	Rescheduling date
24	RDMNG	RDMNG	MENG13	QUAN	13	3	Excess stock quantity
25	FIX01	FIX01	XFELD	CHAR	1	0	Indicator: Fixing of Lot Size in Planned Order
26	FIX02	FIX02	XFELD	CHAR	1	0	Indicator: fixing explosion in planned order
27	BAART	BAART	BAART	CHAR	4	0	P.O./Order type
28	PLART	PLART	PLART	CHAR	1	0	Planning type	*
29	BESKZ	BESKZ	BESKZ	CHAR	1	0	Procurement Type
30	SOBES	SOBES	SOBES	CHAR	1	0	Special procurement type
31	ESOBS	ESOBS	ESOBS	CHAR	1	0	Special procurement - external display	*
32	UMSKZ	PLUMS	XFELD	CHAR	1	0	Conversion indicator for planned order
33	AUSSL	AUSSL	AUSSL	CHAR	2	0	Exception message key	*
34	OLDSL	OLDSL	AUSSL	CHAR	2	0	Key of the second exception message	*
35	ABEKZ	ABEKZ	CHAR1	CHAR	1	0	Exception indicator
36	WRK01	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
37	WRK02	PWWRK	WERKS	CHAR	4	0	Production plant in planned order	*
38	LGORT	LGORT_D	LGORT	CHAR	4	0	Storage location	*
39	CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
40	LSOBS	LSOBS	SOBSL	CHAR	2	0	Special procurement type at storage location level	*
41	DELNR	DELNR	DELNR	CHAR	10	0	MRP element number
42	DEL12	DEL12	DEL12	CHAR	12	0	MRP element number
43	DELPS	DELPS	DELPS	NUMC	6	0	MRP element item
44	DELET	DELET	DELET	NUMC	4	0	Scheduling number planning element
45	VPZUO	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
46	ZUVKZ	DZUVKZ	ZUVKZ	CHAR	1	0	Consumption indicator
47	VERVP	VERVP	VERVP	CHAR	1	0	Consumption indicator for planning requirements
48	VERSB	VERSB	VERSB	CHAR	2	0	Version number for independent requirements	*
49	AKTAL	AKTAL	XFLAG	CHAR	1	0	Current explosion available
50	RSNUM	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
51	SERNR	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
52	PALTR	PALTR	DATUM	DATS	8	0	Explosion date
53	TECHS	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
54	REVLV	REVLV	REVLV	CHAR	2	0	Revision level
55	VERID	VERID	VERID	CHAR	4	0	Production Version	*
56	STLAN	STLAN	STLAN	CHAR	1	0	BOM Usage	*
57	STALT	STALT	ALTNR	CHAR	2	0	Alternative BOM
58	STSTA	STLST	STLST	NUMC	2	0	BOM Statuses	*
59	NFPKZ	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
60	KZAUS	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
61	NFEAG	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
62	NFGRP	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
63	NAFKZ	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
64	NFMNG	NFMNG	MENGE	QUAN	13	3	Follow-up quantity
65	NFMAT	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
66	AENNR	AENNR	AENNR	CHAR	12	0	Change Number	*
67	DELVR	DELKZ	DELKZ	CHAR	2	0	MRP element
68	AUFVR	AUFVR	CHAR10	CHAR	10	0	Source number for order
69	POSVR	POSVR	NUM06	NUMC	6	0	Source item number
70	EINVR	EINVR	NUM04	NUMC	4	0	Source schedule line number
71	BAUGR	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	*
72	KNTTP	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
73	KZVBR	KZVBR	KZVBR	CHAR	1	0	Consumption posting
74	SOBKZ	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
75	KDAUF	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
76	KDPOS	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
77	PSPEL	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
78	CUOBJ	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
79	AUFNR	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	*
80	VERTO	SA_VERTO	SA_VERTL	CHAR	4	0	Distribution key for quantity produced	*
81	QUNUM	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
82	QUPOS	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
83	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
84	EKORG	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
85	EBELN	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
86	EBELP	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
87	VRTYP	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
88	AUTET	AUTET	AUTET	CHAR	1	0	Source List Usage in Materials Planning
89	BEDAT	BEDAT	DATUM	DATS	8	0	Purchase Order Date
90	ETMEN	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
91	GLMNG	GLMNG	MENG13	QUAN	13	3	Quantity Delivered (Stock Transfer)
92	FRTHW	FRTHW	FRTHW	CHAR	1	0	Production note in the planned order
93	AKTFT	AKTFT	XFELD	CHAR	1	0	Indicator "Detailed scheduling available"
94	BEDID	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
95	TRMER	TRMER	TRMER	CHAR	2	0	Scheduling error
96	AKTRT	AKTFT	XFELD	CHAR	1	0	Indicator "Detailed scheduling available"
97	RATID	RATID	BEDID	NUMC	12	0	Index for the results of scheduling production rates	*
98	RATER	RATER	TRMER	CHAR	2	0	Scheduling error in scheduling production rates
99	AKTGT	AKTGT	XFELD	CHAR	1	0	Indicator: "rough-cut scheduling available"
100	GROID	GROID	BEDID	NUMC	12	0	Index for rough scheduling results	*
101	GROER	GROER	TRMER	CHAR	2	0	Scheduling error in rough scheduling
102	AUFTM	AUFTM	MENGV13	QUAN	13	3	MRP element: order quantity
103	ARSNR	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
104	ARSPS	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
105	PRNKZ	PRNKZ	KREUZ	CHAR	1	0	Ind.: Leading order in collective order is planned ordre
106	KAPFX	KAPFX	XFELD	CHAR	1	0	Indicator: capacity for planned order dispatched
107	PSTTI	PSTTI	UZEIT	TIMS	6	0	Start Time of Planned Order
108	PEDTI	PEDTI	UZEIT	TIMS	6	0	End Time of Planned Order
109	RSART	RSART	RSART	CHAR	1	0	Record type
110	XFEHL	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
111	MONKZ	MONKZ	XFELD	CHAR	1	0	Indicator: for assembly order procedures
112	MDFST	MDFST	CHAR1	CHAR	1	0	Production order status: internal ind. for MRP
113	VRPLA	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
114	PBDNR	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
115	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
116	KZBWS	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
117	MDMNG	MDMNG	MENGV13	QUAN	13	3	MRP: quantity field (stock in transit, receipt qty, ...)
118	WAMNG	WAMNG	MENG13	QUAN	13	3	Issued quantity
119	EDGNO	EDGNO	EDGNO	NUMC	17	0	Internal number for edge of object dependencies tree	*
120	TPMNG	TPQTY	MENGV13	QUAN	13	3	Overall quantity MRP element (for static pegging)
121	EMATN	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
122	.INCLUDE				0	0	Include alternative quantity, MRP document
123	UMREZ	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
124	UMREN	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
125	ERFME	ERFME	MEINS	UNIT	3	0	Unit of entry	*
126	ERFMG	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
127	PRSCH	MD_PRSCHED	XFELD	CHAR	1	0	Planned order: scheduling using production dates
128	LVSCH	MD_LVSCHED	SCHED_TYPE	CHAR	1	0	Planned order: leading scheduling level (determines dates)
129	DBSKZ	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
130	STLTY	STLTY	STLTY	CHAR	1	0	BOM Category
131	STLNR	STNUM	STNUM	CHAR	8	0	Bill of Material
132	STLKN	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
133	STPOZ	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
134	EKGRP	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
135	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
136	PLIFZ	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
137	PSTMP	PSTMP	TZNTSTMPS	DEC	15	0	Last Change to Planned Order: Time Stamp
138	EXTNL	EXTNL	XFELD	CHAR	1	0	Indicator for External Procurement
139	ADINF	MD_ADINF	MD_ADINF	CHAR	4	0	Field for Additional Information
140	STAEX	MD_STAEX	MD_STAEX	CHAR	2	0	Status information on BOM explosion in planned order
141	RESLO	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
142	PRIO_URG	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
143	PRIO_REQ	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
144	MDMAT	MATNR	MATNR	CHAR	18	0	Material Number	*
145	MDLOC	MDLOC		CHAR	20	0	Location of MRP Element
146	MDWRK	WERKS_D	WERKS	CHAR	4	0	Plant	*
147	MDBER	BERID	BERID	CHAR	10	0	MRP Area	*
148	SRM_CONTRACT_ID	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
149	SRM_CONTRACT_ITM	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
150	.INCLUDE				0	0