MRP_SOL_VIEW - MRP Solution View Cache Table

MRP Solution View Cache Table information is stored in SAP table MRP_SOL_VIEW.
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_SOL_VIEW

Field Name	Description	Is Key	Data Element	Data Type	Length
ITEMINDEX	ABAP System Field: Loop Index	X	SYST_INDEX	INT4	4
ORDERID	MRP element number	X	DEL12	CHAR	24
ORDERITEMID	MRP Element Item (External)	X	PPMRP_ELEMITEM_EXT	CHAR	12
ORDERSCHEDULELINEID	Schedule Line Number MRP Element	X	DELET	NUMC	8
USERID	User ID	X	VDM_USERID	CHAR	24
ACCTASSIGNMENTCATEGORY	Account Assignment Category		KNTTP	CHAR	2
ASSEMBLY	Higher-Level Assembly Material		BAUGR	CHAR	80
CHANGESTATEID	Character field of length 40		CHAR40	CHAR	80
ITEMCOMMENT	Text field length 200		CHAR200	CHAR	400
COMPANYCODE	Company Code		BUKRS	CHAR	8
CONTACTMAIL	E-Mail Address		AD_SMTPADR	CHAR	482
CONTACTNAME	Full Name of Person		AD_NAMTEXT	CHAR	160
CONTACTPHONE	First Cell Phone Number: Dialing Code + Number		AD_MBNMBR1	CHAR	60
CURRENTDLVQUANT	Currently Delivered Quantity of the Change Request		MRPREQQUANTDLV	DEC	7
DENOMINATOR	Denominator for conversion to base units of measure		UMREN	DEC	3
MATERIALID	Material Number		MATNR	CHAR	80
MATERIALBASEUNIT	Base Unit of Measure		MEINS	UNIT	6
MATERIALBASEUNITSHORT	External Unit of Measurement in Technical Format (6-Char.)		MSEH6	CHAR	12
MATERIALEXTERNALID	Material Number		MATNR	CHAR	80
MATERIALGOODSRECEIPTDURATION	Goods receipt processing time in days		WEBAZ	DEC	2
MATERIALGROUPNAME	Material Group Description		WGBEZ	CHAR	40
MATERIALPROCUREMENTTYPE	Special procurement type		SOBES	CHAR	2
MATERIALSAFETYSTOCKQTY	Safety Stock		EISBE	QUAN	7
MATERIALSHORTAGECRITICALQTY	Quantity received or quantity required		MNG01	QUAN	7
MATERIALSHORTAGEDEFINITIONID	Shortage Definition ID		PPMRP_SHORT_DEF_ID	CHAR	30
MATERIALSHORTAGEENDDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
MATERIALSHORTAGEPROFILE	Material Shortage Profile		MATERIALSHORTAGEPROFILE	CHAR	24
MATERIALSHORTAGEPROFILECOUNT	Counter for SDM Customizing Settings		SDM_COUNTER	NUMC	6
MATERIALSHORTAGEQUANTITY	Shortage Quantity at First Shortage Date		MATERIALSHORTAGEQUANTITY	QUAN	7
MATERIALSHORTAGESTARTDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
MATERIALSHORTAGETHRESHOLDQTY	Quantity received or quantity required		MNG01	QUAN	7
MRPAREA	MRP Area		BERID	CHAR	20
MRPAVAILABILITYDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
MRPAVAILABLEQUANTITY	Available quantity		VRFMG	QUAN	7
MRPAVAILABILITY	MRP Material Availability on a Specific Date		PPMRP_AVAILABILITY	CHAR	2
MRPELEMENTAVORRQMTDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
MRPELEMENTCATEGORY	MRP element		DELKZ	CHAR	4
MRPELEMENTCATEGORYSHORTNAME	Abbreviation for MRP element		DELB0	CHAR	12
MRPELEMENTCHANGEDAVORRQMTDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
MRPELEMENTCHANGEDDELIVERYDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
MRPELEMENTCHANGEDOPENQUANTITY	Quantity received or quantity required		MNG01	QUAN	7
MRPELEMENTDELIVERYDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
MRPELEMENTDOCUMENTTYPE	P.O./Order type		BAART	CHAR	8
MRPELEMENTDOCUMENTTYPENAME	Character field, length 64		CHAR64	CHAR	128
ORDERID_EXT	MRP element number		DEL12	CHAR	24
ORDERITEMID_EXT	MRP Element Item (External)		PPMRP_ELEMITEM_EXT	CHAR	12
MRPELEMENTOPENQUANTITY	Quantity received or quantity required		MNG01	QUAN	7
MRPELEMENTORDERTYPE	MRP element		DELKZ	CHAR	4
MRPELEMENTQUANTITYISFIRM	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
ORDERQUANTITYUNITDISPLAYDCMLS	Number of decimal places for number display		DECAN	INT2	2
ORDERSCHEDULELINEID_EXT	MRP Element Schedule Line (External)		PPMRP_ELEMLINE_EXT	CHAR	8
ORDERUNIT	External Unit of Measurement in Commercial Format (3-Char.)		MSEH3	CHAR	6
ORDUNITOFMEASURECOMMERCIALNAME	External Unit of Measurement in Commercial Format (3-Char.)		MSEH3	CHAR	6
ORDERUNIT_PRECISION	External Unit of Measurement in Technical Format (6-Char.)		MSEH6	CHAR	12
ORDERUNITSHORT	External Unit of Measurement in Technical Format (6-Char.)		MSEH6	CHAR	12
MRPPLANNINGSEGMENTNUMBER	Planning segment number		PLANR	CHAR	40
MRPPLANNINGSEGMENTTYPE	Material requirements planning segment		PLAAB	NUMC	4
MRPPLANT	Plant		WERKS_D	CHAR	8
NUMERATOR	Numerator for Conversion to Base Units of Measure		UMREZ	DEC	3
ORDEREDCHANGEDQUANTITY	Quantity		MRPQUANTITY	QUAN	7
ORDEREDQUANTITY	Quantity		MRPQUANTITY	QUAN	7
ORIGINALTOTALQUANT	Total Original Quantity of the Change Request		MRPREQQUANTORIGTOTAL	DEC	7
ORIGINALTOTALQUANTBASEUNIT	Base Unit of Measure		MEINS	UNIT	6
PARTIALLYDELIVERED	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
ITEMPRECISION	Number of Decimals		PPMRP_PRECISION	INT1	1
PROPOSALRANKING	Single-Character Flag		CHAR1	CHAR	2
PURCHASECONTRACT	Purchasing Document Number		EBELN	CHAR	20
PURCHASECONTRACTITEM	Item Number of Purchasing Document		EBELP	NUMC	10
PURCHASEORDERTYPE	Purchasing Document Type		ESART	CHAR	8
PURCHASINGDOCUMENTCATEGORY	Purchasing Document Category		BSTYP	CHAR	2
PURCHASINGINFORECORD	Number of purchasing info record		INFNR	CHAR	20
PURCHASINGGROUP	Purchasing Group		MRPPURCHASINGGROUP	CHAR	6
PURCHASINGORGANIZATION	Purchasing organization		EKORG	CHAR	8
QUANTITYPRECISION	Number of decimal places for number display		DECAN	INT2	2
RECEIVINGPLANT	Plant		WERKS_D	CHAR	8
RECEIVINGSTORAGELOCATION	Storage location		LGORT_D	CHAR	8
RELEASED	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
REQUESTSTATUS	Status of the Change Request		MRPREQUESTSTATUS	CHAR	4
SALESORDER	Sales and Distribution Document Number		VBELN	CHAR	20
SALESORDERITEM	Sales document item		VBELP	NUMC	12
SOLUTION_OPTION	Status of the Change Request		MRPREQUESTSTATUS	CHAR	4
SOLUTION_TYPE	Solution Card: Solution Type		PPMRP_SOLUTION_TYPE	CHAR	4
SOURCEMRPELEMENT	MRP element number		DEL12	CHAR	24
SOURCEMRPELEMENTCATEGORY	MRP element		DELKZ	CHAR	4
SOURCEMRPELEMENTITEM	MRP Element Item (External)		PPMRP_ELEMITEM_EXT	CHAR	12
SOURCEMRPELEMENTSCHEDULELINE	MRP Element Schedule Line (External)		PPMRP_ELEMLINE_EXT	CHAR	8
STORAGELOCATION	Storage location		LGORT_D	CHAR	8
SUPPLYINGSTORAGELOCATION	Storage location		LGORT_D	CHAR	8
SUPPLYINTHEPAST	Character Field of Length 1		CHAR01	CHAR	2
TARGETDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
TARGETQUANTITY	Quantity		MRPQUANTITY	QUAN	7
TARGETQUANTITYINORDERUNIT	Base Unit of Measure		MEINS	UNIT	6
TARGETQUANTITYUNITDISPLAYDCMLS	Number of decimal places for number display		DECAN	INT2	2
TARGETTOTALQUANT	Total Target Quantity of the Change Request		MRPREQQUANTTARGTOTAL	DEC	7
UNITOFMEASURECOMMERCIALNAME	External Unit of Measurement in Commercial Format (3-Char.)		MSEH3	CHAR	6
VENDOR	Account Number of Supplier		LIFNR	CHAR	20
VENDORNAME	Name 1		NAME1_GP	CHAR	70
VENDORPLANT	Plant		WERKS_D	CHAR	8
VENDORSTATUS	Vendor's Response to the Change Request		MRPREQUESTVENDORSTATUS	CHAR	4
WBSELEMENT	WBS Element		PS_POSNR	NUMC	16
BP_TYPE	Type of Business Partner		PPMRP_BP_TYPE	CHAR	2
REQUIREMENTCOUNTER	Requirement Counter		PPMRP_REQ_COUNT	INT4	4
MRPELEMENT_INT	MRP element number		DEL12	CHAR	24
MRPELEMENTITEM_INT	MRP element item		DELPS	NUMC	12
MRPELEMENTSCHEDULELINE_INT	Schedule Line Number MRP Element		DELET	NUMC	8
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
ISPROPOSAL	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
ISSIMULATIONACTIVE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
SIMULATE	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
SOLUTIONINDEX	ABAP System Field: Loop Index		SYST_INDEX	INT4	4
SIMULATIONQUANTIY	Quantity		MRPQUANTITY	QUAN	7
SIMULATIONDATE	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
SOLUTIONRESCHEDULE	Number of Days to Reschulde		MRPRESCHUDLEDAYS	INT2	2
AGGREGATEDMRPELEMENTS	4 Byte Signed Integer		INT4	INT4	4
CREATIONDATETIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
.INCLUDE				PPMRP_SUPPLY_DEMAND_ITEM_INCL	0
DUMMY_MRP_SUPPLY_DEMAND_ITEM	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				PPMRP_SOL_CARD_INCL	0
DUMMY_MRP_SOL_CARD	Dummy function in length 1		DUMMY	CHAR	2