MDPS_DB - Chache Table Supply Demand Item (enable Field Extensability)

Chache Table Supply Demand Item (enable Field Extensability) information is stored in SAP table MDPS_DB.
It is part of development package ODATA_PP_MRP in software component PP-FIO. This development package consists of objects that can be grouped under "OData Services for Material Requirements Planning".

Fields for table MDPS_DB

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	S_MANDT	CLNT	6
MATNR	Material Number	X	MATNR	CHAR	80
PLANT	Plant	X	WERKS_D	CHAR	8
MATERIALSHORTAGEPROFILE	Material Shortage Profile	X	MATERIALSHORTAGEPROFILE	CHAR	24
MATERIALSHORTAGEPROF_CNT	Counter for SDM Customizing Settings	X	SDM_COUNTER	NUMC	6
LINE	Numeric field length 8	X	NUM08	NUMC	16
PLAAB	Material requirements planning segment		PLAAB	NUMC	4
PLANR	Planning segment number		PLANR	CHAR	40
DAT00	Receipt/Requirements date		DAT00	DATS	16
TAG00	Daily shift (sort indicator 0)		TAG00	NUMC	4
SORT1	Sort indicator 01		SORT1	CHAR	2
SORT2	Sort indicator 02		SORT2	CHAR	4
EXTRA	MRP element data		EXTRA	CHAR	80
DELKZ	Abbreviation for MRP element		DELB0	CHAR	12
VSTAT	Processing Status		VSTAT_D	CHAR	2
VRFKZ	Availability indicator		VRFKZ	CHAR	2
PLUMI	Receipt/issue indicator		PLUMI	CHAR	2
MNG01	Quantity received or quantity required		MNG01	QUAN	7
MNG02	Variable scrap quantity		MNG02	QUAN	7
MNG03	Shortage Quantity		MNG03	QUAN	7
MNG04	ATP quantity		MNG04	QUAN	7
DAT01	Delivery/order finish date		DAT01	DATS	16
DAT02	Start/release date		DAT02	DATS	16
DAT03	Opening date		DAT03	DATS	16
PERKZ	Period indicator		MD_PERKZ	CHAR	2
PRPER	Forecast period		PRPER	NUMC	12
WEBAZ	Goods receipt processing time in days		WEBAZ	DEC	2
UKZ01	Indicator: MRP element can be brought forward		UKZ01	CHAR	2
UMDAT	Rescheduling date		UMDAT	DATS	16
UMDA2	Rescheduling date		UMDAT	DATS	16
RDMNG	Excess stock quantity		RDMNG	QUAN	7
FIX01	Indicator: Fixing of Lot Size in Planned Order		FIX01	CHAR	2
FIX02	Indicator: fixing explosion in planned order		FIX02	CHAR	2
BAART	P.O./Order type		BAART	CHAR	8
PLART	Planning type		PLART	CHAR	2
BESKZ	Procurement Type		BESKZ	CHAR	2
SOBES	Special procurement type		SOBES	CHAR	2
ESOBS	Special procurement - external display		ESOBS	CHAR	2
UMSKZ	Planned Order Conversion Indicator		PLUMS	CHAR	2
AUSSL	Exception message key		AUSSL	CHAR	4
OLDSL	Key of the second exception message		OLDSL	CHAR	4
ABEKZ	Exception indicator		ABEKZ	CHAR	2
WRK01	Planning Plant		PLWRK	CHAR	8
WRK02	Production Plant		PWWRK	CHAR	8
LGORT	Storage location		LGORT_D	CHAR	8
CHARG	Batch Number		CHARG_D	CHAR	20
LSOBS	Special procurement type at storage location level		LSOBS	CHAR	4
DELNR	MRP element number		DELNR	CHAR	20
DEL12	MRP element number		DEL12	CHAR	24
DELPS	Item number of purchase requisition		BNFPO	NUMC	10
DELET	Schedule Line Number MRP Element		DELET	NUMC	8
VPZUO	Allocation Indicator		VPZUO	CHAR	2
VERVP	Consumption indicator for planning requirements		VERVP	CHAR	2
VERSB	Version Number for Independent Requirements		VERSB	CHAR	4
AKTAL	Current explosion available		AKTAL	CHAR	2
RSNUM	Number of reservation/dependent requirements		RSNUM	NUMC	20
SERNR	BOM explosion number		SERNR	CHAR	16
PALTR	Explosion date		PALTR	DATS	16
TECHS	Parameter Variant/Standard Variant		TECHS	CHAR	24
REVLV	Revision Level		REVLV	CHAR	4
VERID	Production Version		VERID	CHAR	8
STLAN	BOM Usage		STLAN	CHAR	2
STALT	Alternative BOM		STALT	CHAR	4
STSTA	Bill of Material Status		STLST	NUMC	4
NFPKZ	Indicator: Follow-Up Item		CS_KZNFP	CHAR	2
KZAUS	Discontinuation indicator		KZAUS	CHAR	2
NFEAG	Discontinuation group		CS_NFEAG	CHAR	4
NFGRP	Follow-up group		CS_NFGRP	CHAR	4
NAFKZ	Indicator: follow-up material active/not active		NAFKZ	CHAR	2
NFMNG	Follow-up quantity		NFMNG	QUAN	7
NFMAT	Follow-Up Material		NFMAT	CHAR	80
AENNR	Change Number		AENNR	CHAR	24
DELVR	MRP element		DELKZ	CHAR	4
AUFVR	Source number for order		AUFVR	CHAR	20
POSVR	Source item number		POSVR	NUMC	12
EINVR	Source schedule line number		EINVR	NUMC	8
BAUGR	Higher-Level Assembly Material		BAUGR	CHAR	80
KNTTP	Account Assignment Category		KNTTP	CHAR	2
KZVBR	Consumption posting		KZVBR	CHAR	2
SOBKZ	Special Stock Indicator		SOBKZ	CHAR	2
KDAUF	Sales Order Number		KDAUF	CHAR	20
KDPOS	Item number in Sales Order		KDPOS	NUMC	12
PSPEL	WBS Element		PS_POSNR	NUMC	16
CUOBJ	Configuration (internal object number)		CUOBJ	NUMC	36
AUFNR	Run schedule header number		SA_AUFNR	CHAR	24
VERTO	Distribution key for quantity produced		SA_VERTO	CHAR	8
QUNUM	Number of quota arrangement		QUNUM	CHAR	20
QUPOS	Quota arrangement item		QUPOS	NUMC	6
LIFNR	Account Number of Supplier		LIFNR	CHAR	20
EKORG	Purchasing organization		EKORG	CHAR	8
EBELN	Purchasing Document Number		EBELN	CHAR	20
EBELP	Item Number of Purchasing Document		EBELP	NUMC	10
VRTYP	Purchasing Document Category		BSTYP	CHAR	2
AUTET	Source List Usage in Materials Planning		AUTET	CHAR	2
BEDAT	Purchase Order Date		BEDAT	DATS	16
ETMEN	Scheduled Quantity		ETMEN	QUAN	7
GLMNG	Quantity Delivered (Stock Transfer)		GLMNG	QUAN	7
FRTHW	Production note in the planned order		FRTHW	CHAR	2
AKTFT	Indicator "Detailed scheduling available"		AKTFT	CHAR	2
BEDID	ID of the Capacity Requirements Record		BEDID	NUMC	24
TRMER	Scheduling error		TRMER	CHAR	4
AKTRT	Indicator "Detailed scheduling available"		AKTFT	CHAR	2
RATID	-INVALID FOR S/4- Index for the rslts of schedg prod. rates		RATID	NUMC	24
RATER	-INVALID FOR S/4- Schedg error in schedg production rates		RATER	CHAR	4
AKTGT	-INVALID FOR S/4- Indicator: "rough-cut schedg available"		AKTGT	CHAR	2
GROID	-INVALID FOR S/4- Index for rough scheduling results		GROID	NUMC	24
GROER	-INVALID FOR S/4- Scheduling error in rough scheduling		GROER	CHAR	4
AUFTM	MRP element: order quantity		AUFTM	QUAN	7
ARSNR	Settlement reservation number		ARSNR	NUMC	20
ARSPS	Item number of the settlement reservation		ARSPS	NUMC	8
PRNKZ	Ind.: Leading order in collective order is planned ordre		PRNKZ	CHAR	2
KAPFX	Indicator: Capacity for Planned Order is Dispatched		KAPFX	CHAR	2
PSTTI	Planned Order Start Time		PSTTI	TIMS	12
PEDTI	Planned Order End Time		PEDTI	TIMS	12
RSART	Record type		RSART	CHAR	2
XFEHL	Missing Part		XFEHL	CHAR	2
MONKZ	Indicator: For Assembly Order Procedures		MONKZ	CHAR	2
MDFST	Production order status: internal ind. for MRP		MDFST	CHAR	2
VRPLA	Indicator: planning without final assembly		VRPLA	CHAR	2
PBDNR	Requirements Plan		PBDNR	CHAR	20
KUNNR	Customer Number		KUNNR	CHAR	20
KZBWS	Valuation of Special Stock		KZBWS	CHAR	2
MDMNG	MRP: quantity field (stock in transit, receipt qty, ...)		MDMNG	QUAN	7
WAMNG	Issued Quantity		WAMNG	QUAN	7
EDGNO	Internal number for edge of object dependencies tree		EDGNO	NUMC	34
TPMNG	Overall quantity MRP element (for static pegging)		TPQTY	QUAN	7
EMATN	Material number corresponding to manufacturer part number		EMATN	CHAR	80
UMREZ	Numerator for Conversion to Base Units of Measure		UMREZ	DEC	3
UMREN	Denominator for conversion to base units of measure		UMREN	DEC	3
ERFME	Unit of entry		ERFME	UNIT	6
ERFMG	Quantity in unit of entry		ERFMG	QUAN	7
PRSCH	Planned order: scheduling using production dates		MD_PRSCHED	CHAR	2
LVSCH	Planned order: leading scheduling level (determines dates)		MD_LVSCHED	CHAR	2
DBSKZ	Direct procurement indicator		DBSKZ	CHAR	2
STLTY	BOM category		STLTY	CHAR	2
STLNR	Bill of Material		STNUM	CHAR	16
STLKN	BOM item node number		STLKN	NUMC	16
STPOZ	Internal counter		CIM_COUNT	NUMC	16
EKGRP	Purchasing Group		EKGRP	CHAR	6
MATKL	Material Group		MATKL	CHAR	18
PLIFZ	Planned Delivery Time in Days		PLIFZ	DEC	2
PSTMP	Last Change to Planned Order: Time Stamp		PSTMP	DEC	8
EXTNL	Indicator for External Procurement		EXTNL	CHAR	2
ADINF	Field for Additional Information		MD_ADINF	CHAR	8
STAEX	Status information on BOM explosion in planned order		MD_STAEX	CHAR	4
RESLO	Issuing Storage Location for Stock Transport Order		RESLO	CHAR	8
PRIO_URG	Requirement Urgency		PRIO_URG	NUMC	4	PURG
PRIO_REQ	Requirement Priority		PRIO_REQ	NUMC	6	PREQ
MDMAT	Material Number		MATNR	CHAR	80
MDLOC	Location of MRP Element		MDLOC	CHAR	40
MDWRK	Plant		WERKS_D	CHAR	8
MDBER	MRP Area		BERID	CHAR	20
SRM_CONTRACT_ID	Central Contract		SRM_CONTRACT_ID	CHAR	20
SRM_CONTRACT_ITM	Central Contract Item Number		SRM_CONTRACT_ITEM	NUMC	20
SGT_CATV	Segmentation Value		SGT_CATV	CHAR	80
SGT_RCAT	Requirement Segment		SGT_RCAT	CHAR	80
SGT_SCAT	Stock Segment		SGT_SCAT	CHAR	80
DISUB_SOBKZ	Special Stock Indicator		SOBKZ	CHAR	2
IMWERK	Delivery has Status 'In Plant'		IMWRK	CHAR	2
VBELN	Sales and Distribution Document Number		VBELN	CHAR	20
ATRKZ	Request ID		ATRKZ	CHAR	2
M_MRP	Indicator: Matrix Is Activated		MMRP_ACTIVE	CHAR	2
MPNMT	Material Number		MATNR	CHAR	80
PCMNG	Excess stock quantity		RDMNG	QUAN	7
PVGUID	Internal Number of the PVS Variant		PVS_PVGUID	RAW	16
MD4KD	Customer name		MD4KD	CHAR	70
MD4LI	Vendor Name		MD4LI	CHAR	70
DECISIONSUPPORT	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
DEMANDCATEGORYGROUP	Demand Groups for Supply and Demand Matching		DEMANDCATEGORYGROUP	CHAR	2
RECEIPTCATEGORYGROUP	Supply Groups for Supply and Demand Matching		RECEIPTCATEGORYGROUP	CHAR	2
SUPPLYINTHEPAST	Single-Character Flag		CHAR1	CHAR	2