MRP_SUP_DEM_ITEM - Supply Demand Item

Supply Demand Item information is stored in SAP table MRP_SUP_DEM_ITEM.
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 MRP_SUP_DEM_ITEM

Field Name	Description	Is Key	Data Element	Data Type	Length
LINE	ABAP System Field: Loop Index	X	SYST_INDEX	INT4	4
MRPPLANT	Plant	X	WERKS_D	CHAR	8
MATERIALID	Material Number	X	MATNR	CHAR	80
MRPAREA	MRP Area	X	BERID	CHAR	20
MATERIALSHORTAGEDEFINITIONID	Shortage Definition ID	X	PPMRP_SHORT_DEF_ID	CHAR	30
MRPPLANNINGSEGMENTTYPE	Material requirements planning segment	X	PLAAB	NUMC	4
MRPPLANNINGSEGMENTNUMBER	Planning segment number	X	PLANR	CHAR	40
USERID	User ID	X	VDM_USERID	CHAR	24
MRPELEMENT	MRP element number		DEL12	CHAR	24
MRPELEMENTITEM	MRP Element Item (External)		PPMRP_ELEMITEM_EXT	CHAR	12
MRPELEMENTSCHEDULELINE	MRP Element Schedule Line (External)		PPMRP_ELEMLINE_EXT	CHAR	8
MRPELEMENTCATEGORY	MRP element		DELKZ	CHAR	4
MRPELEMENTCATEGORYSHORTNAME	Abbreviation for MRP element		DELB0	CHAR	12
MRPELEMENTAVAILYORRQMTDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
MRPAVAILABLEQUANTITY	Available quantity		VRFMG	QUAN	7
MRPELEMENTOPENQUANTITY	Quantity received or quantity required		MNG01	QUAN	7
MRPELEMENTQUANTITYISFIRM	Indicator: Fixing of Lot Size in Planned Order		FIX01	CHAR	2
MRPELEMENTDOCUMENTTYPE	P.O./Order type		BAART	CHAR	8
MFGORDERSTATUSINTERNALCODE	Production order status: internal ind. for MRP		MDFST	CHAR	2
STORAGELOCATION	Storage location		LGORT_D	CHAR	8
ASSEMBLY	Higher-Level Assembly Material		BAUGR	CHAR	80
PRODUCTIONVERSION	Production Version		VERID	CHAR	8
REQUIREMENTPLAN	Requirements Plan		PBDNR	CHAR	20
SOURCEMRPELEMENT	MRP element number		DEL12	CHAR	24
SOURCEMRPELEMENTITEM	Source MRP Element Item (External)		PPMRP_SOURCELEMITEM_EXT	CHAR	12
SOURCEMRPELEMENTSCHEDULELINE	Source MRP Element Schedule Line (External)		PPMRP_SOURCELEMLINE_EXT	CHAR	8
SOURCEMRPELEMENTCATEGORY	MRP element		DELKZ	CHAR	4
MRPELEMENTBUSINESSPARTNERID	Business Partner		PPMRP_BUSINESSPARTNER	CHAR	20
MRPELEMENTBUSINESSPARTNERNAME	Business Partner Name		PPMRP_BUSINESSPARTNERNAME	CHAR	70
MRPELEMENTBUSINESSPARTNERTYPE	Type of Business Partner		PPMRP_BP_TYPE	CHAR	2
MATERIALBASEUNIT	Do not use MEINS to avoid Gateway conversion			CHAR	6
MATERIALBASEUNITTEXT	External Unit of Measurement in Technical Format (6-Char.)		MSEH6	CHAR	12
UNITOFMEASURECOMMERCIALNAME	External Unit of Measurement in Commercial Format (3-Char.)		MSEH3	CHAR	6
QUANTITYPRECISION	No. of decimal places for rounding		ANDEC	INT2	2
MATERIALSHORTAGESTATUS	Character Field of Length 1		CHAR01	CHAR	2
RELEASED	Character Field of Length 1		CHAR01	CHAR	2
PARTIALLYDELIVERED	Character Field of Length 1		CHAR01	CHAR	2
REQUESTSTATUS	Component of the Version Number		CHAR2	CHAR	4
VENDORSTATUS	Component of the Version Number		CHAR2	CHAR	4
MRPAVAILABILITY	Availability indicator		VRFKZ	CHAR	2
MATERIALSHORTAGECRITICALQTY	Quantity received or quantity required		MNG01	QUAN	7
MATERIALSHORTAGETHRESHOLDQTY	Quantity received or quantity required		MNG01	QUAN	7
MRPEVALUATIONHORIZONINDAYS	4 Byte Signed Integer		INT4	INT4	4
DECISIONSUPPORT	Character Field of Length 1		CHAR01	CHAR	2
SHORTAGECOUNT	2 Byte Signed Integer		INT2	INT2	2
MATERIALSAFETYSTOCKQTY	Safety Stock		EISBE	QUAN	7
MRPELEMENTDOCUMENTTYPENAME				CHAR	120
SUPPLYAGGREGATION	1 Byte Unsigned Integer		INT1	INT1	1
DEMANDAGGREGATION	1 Byte Unsigned Integer		INT1	INT1	1
MRPELEMENTCATEGORYGROUP	Demand Groups for Supply and Demand Matching		DEMANDCATEGORYGROUP	CHAR	2
MRPELEMENTCATEGORYGROUPNAME	Short Text for Fixed Values		VAL_TEXT	CHAR	120
SUPPLYINTHEPAST	Character Field of Length 1		CHAR01	CHAR	2
AGGREGATEDMRPELEMENTS	4 Byte Signed Integer		INT4	INT4	4
TARGETQUANTITYUNITDISPLAYDCMLS	Number of decimal places for number display		DECAN	INT2	2
CREATIONDATETIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
MATERIALEXTERNALID	Material Number		MATNR	CHAR	80