MRP_SOL_VIEW

Transparent Table Temporary Data
117 Fields 1 CDS Views

MRP Solution View Cache Table

MRP_SOL_VIEW is an SAP database table in S/4HANA. MRP Solution View Cache Table. It contains 117 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MRPSolutionItem view from BASIC MRP Solution View Items

Fields (117)

KeyField Data ElementDescription DomainTypeLength
KEY itemindex syst_index Loop Index
KEY orderid del12 MRP element number
KEY orderitemid ppmrp_elemitem_ext MRP Element Item
KEY orderschedulelineid delet Scheduling
KEY userid vdm_userid User ID
acctassignmentcategory knttp Acct Assgmt Cat
assembly baugr Pegged Reqmt
changestateid char40 Char
itemcomment char200 Text (200 char)
companycode bukrs Company Code
contactmail ad_smtpadr E-Mail Address
contactname ad_namtext Full Name
contactphone ad_mbnmbr1 Mobile Phone
currentdlvquant mrpreqquantdlv Delivered Quantity
denominator umren Denominator
materialid matnr Material
materialbaseunit meins Base Unit
materialbaseunitshort mseh6 Technical
materialexternalid matnr Material
materialgoodsreceiptduration webaz GR proc. time
materialgroupname wgbez Matl Grp Desc.
materialprocurementtype sobes Spec. procuremt
materialsafetystockqty eisbe Safety Stock
materialshortagecriticalqty mng01 Rec./reqd qty
materialshortagedefinitionid ppmrp_short_def_id Shortage Def. ID
materialshortageenddate timestamp Time Stamp
materialshortageprofile materialshortageprofile Shortage Prf.
materialshortageprofilecount sdm_counter Counter
materialshortagequantity materialshortagequantity Shortage Qty
materialshortagestartdate timestamp Time Stamp
materialshortagethresholdqty mng01 Rec./reqd qty
mrparea berid MRP Area
mrpavailabilitydate timestamp Time Stamp
mrpavailablequantity vrfmg Avail. Quantity
mrpavailability ppmrp_availability MRP Availability
mrpelementavorrqmtdate timestamp Time Stamp
mrpelementcategory delkz MRP Elmnt Ind.
mrpelementcategoryshortname delb0 MRP element
mrpelementchangedavorrqmtdate timestamp Time Stamp
mrpelementchangeddeliverydate timestamp Time Stamp
mrpelementchangedopenquantity mng01 Rec./reqd qty
mrpelementdeliverydate timestamp Time Stamp
mrpelementdocumenttype baart P.O./Order type
mrpelementdocumenttypename char64 Character field, length 64
orderid_ext del12 MRP element number
orderitemid_ext ppmrp_elemitem_ext MRP Element Item
mrpelementopenquantity mng01 Rec./reqd qty
mrpelementordertype delkz MRP Elmnt Ind.
mrpelementquantityisfirm boole_d TRUE
orderquantityunitdisplaydcmls decan Decimal Places
orderschedulelineid_ext ppmrp_elemline_ext Schedule Line
orderunit mseh3 Commercial
ordunitofmeasurecommercialname mseh3 Commercial
orderunit_precision mseh6 Technical
orderunitshort mseh6 Technical
mrpplanningsegmentnumber planr Plng Segmnt No.
mrpplanningsegmenttype plaab MRP segment
mrpplant werks_d Plant
numerator umrez Numerator
orderedchangedquantity mrpquantity Quantity
orderedquantity mrpquantity Quantity
originaltotalquant mrpreqquantorigtotal Total Orig. Quantity
originaltotalquantbaseunit meins Base Unit
partiallydelivered boole_d TRUE
itemprecision ppmrp_precision No. of Decimals
proposalranking char1 Single-Character Flag
purchasecontract ebeln Purchasing Doc.
purchasecontractitem ebelp Item
purchaseordertype esart Document Type
purchasingdocumentcategory bstyp Doc. Category
purchasinginforecord infnr Info Record
purchasinggroup mrppurchasinggroup Purchasing Group
purchasingorganization ekorg Purchasing Org.
quantityprecision decan Decimal Places
receivingplant werks_d Plant
receivingstoragelocation lgort_d Location
released boole_d TRUE
requeststatus mrprequeststatus Change Req. Status
salesorder vbeln SD Document
salesorderitem vbelp Sales doc. item
solution_option mrprequeststatus Change Req. Status
solution_type ppmrp_solution_type Sol. Type
sourcemrpelement del12 MRP element number
sourcemrpelementcategory delkz MRP Elmnt Ind.
sourcemrpelementitem ppmrp_elemitem_ext MRP Element Item
sourcemrpelementscheduleline ppmrp_elemline_ext Schedule Line
storagelocation lgort_d Location
supplyingstoragelocation lgort_d Location
supplyinthepast char01 Char01
targetdate timestamp Time Stamp
targetquantity mrpquantity Quantity
targetquantityinorderunit meins Base Unit
targetquantityunitdisplaydcmls decan Decimal Places
targettotalquant mrpreqquanttargtotal Total Target Qty
unitofmeasurecommercialname mseh3 Commercial
vendor lifnr Supplier
vendorname name1_gp Name
vendorplant werks_d Plant
vendorstatus mrprequestvendorstatus Vendor's Response
wbselement ps_posnr WBS Element
bp_type ppmrp_bp_type Business Part. Type
requirementcounter ppmrp_req_count Requirement Counter
mrpelement_int del12 MRP element number
mrpelementitem_int delps MRP elemnt item
mrpelementscheduleline_int delet Scheduling
mrpelementbusinesspartnerid ppmrp_businesspartner BusinessPartner
mrpelementbusinesspartnername ppmrp_businesspartnername Bus.Partner Name
mrpelementbusinesspartnertype ppmrp_bp_type Business Part. Type
isproposal boole_d TRUE
issimulationactive boole_d TRUE
simulate boole_d TRUE
solutionindex syst_index Loop Index
simulationquantiy mrpquantity Quantity
simulationdate timestamp Time Stamp
solutionreschedule mrpreschudledays Number of Days to Reschulde
aggregatedmrpelements int4 INT4
creationdatetime timestampl Time Stamp

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- MRP Solution View Cache Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MRP_SOL_VIEW (
    ITEMINDEX,                       -- Loop Index [syst_index]
    ORDERID,                         -- MRP element number [del12]
    ORDERITEMID,                     -- MRP Element Item [ppmrp_elemitem_ext]
    ORDERSCHEDULELINEID,             -- Scheduling [delet]
    USERID,                          -- User ID [vdm_userid]
    ACCTASSIGNMENTCATEGORY,          -- Acct Assgmt Cat [knttp]
    ASSEMBLY,                        -- Pegged Reqmt [baugr]
    CHANGESTATEID,                   -- Char [char40]
    ITEMCOMMENT,                     -- Text (200 char) [char200]
    COMPANYCODE,                     -- Company Code [bukrs]
    CONTACTMAIL,                     -- E-Mail Address [ad_smtpadr]
    CONTACTNAME,                     -- Full Name [ad_namtext]
    CONTACTPHONE,                    -- Mobile Phone [ad_mbnmbr1]
    CURRENTDLVQUANT,                 -- Delivered Quantity [mrpreqquantdlv]
    DENOMINATOR,                     -- Denominator [umren]
    MATERIALID,                      -- Material [matnr]
    MATERIALBASEUNIT,                -- Base Unit [meins]
    MATERIALBASEUNITSHORT,           -- Technical [mseh6]
    MATERIALEXTERNALID,              -- Material [matnr]
    MATERIALGOODSRECEIPTDURATION,    -- GR proc. time [webaz]
    MATERIALGROUPNAME,               -- Matl Grp Desc. [wgbez]
    MATERIALPROCUREMENTTYPE,         -- Spec. procuremt [sobes]
    MATERIALSAFETYSTOCKQTY,          -- Safety Stock [eisbe]
    MATERIALSHORTAGECRITICALQTY,     -- Rec./reqd qty [mng01]
    MATERIALSHORTAGEDEFINITIONID,    -- Shortage Def. ID [ppmrp_short_def_id]
    MATERIALSHORTAGEENDDATE,         -- Time Stamp [timestamp]
    MATERIALSHORTAGEPROFILE,         -- Shortage Prf. [materialshortageprofile]
    MATERIALSHORTAGEPROFILECOUNT,    -- Counter [sdm_counter]
    MATERIALSHORTAGEQUANTITY,        -- Shortage Qty [materialshortagequantity]
    MATERIALSHORTAGESTARTDATE,       -- Time Stamp [timestamp]
    MATERIALSHORTAGETHRESHOLDQTY,    -- Rec./reqd qty [mng01]
    MRPAREA,                         -- MRP Area [berid]
    MRPAVAILABILITYDATE,             -- Time Stamp [timestamp]
    MRPAVAILABLEQUANTITY,            -- Avail. Quantity [vrfmg]
    MRPAVAILABILITY,                 -- MRP Availability [ppmrp_availability]
    MRPELEMENTAVORRQMTDATE,          -- Time Stamp [timestamp]
    MRPELEMENTCATEGORY,              -- MRP Elmnt Ind. [delkz]
    MRPELEMENTCATEGORYSHORTNAME,     -- MRP element [delb0]
    MRPELEMENTCHANGEDAVORRQMTDATE,   -- Time Stamp [timestamp]
    MRPELEMENTCHANGEDDELIVERYDATE,   -- Time Stamp [timestamp]
    MRPELEMENTCHANGEDOPENQUANTITY,   -- Rec./reqd qty [mng01]
    MRPELEMENTDELIVERYDATE,          -- Time Stamp [timestamp]
    MRPELEMENTDOCUMENTTYPE,          -- P.O./Order type [baart]
    MRPELEMENTDOCUMENTTYPENAME,      -- Character field, length 64 [char64]
    ORDERID_EXT,                     -- MRP element number [del12]
    ORDERITEMID_EXT,                 -- MRP Element Item [ppmrp_elemitem_ext]
    MRPELEMENTOPENQUANTITY,          -- Rec./reqd qty [mng01]
    MRPELEMENTORDERTYPE,             -- MRP Elmnt Ind. [delkz]
    MRPELEMENTQUANTITYISFIRM,        -- TRUE [boole_d]
    ORDERQUANTITYUNITDISPLAYDCMLS,   -- Decimal Places [decan]
    ORDERSCHEDULELINEID_EXT,         -- Schedule Line [ppmrp_elemline_ext]
    ORDERUNIT,                       -- Commercial [mseh3]
    ORDUNITOFMEASURECOMMERCIALNAME,  -- Commercial [mseh3]
    ORDERUNIT_PRECISION,             -- Technical [mseh6]
    ORDERUNITSHORT,                  -- Technical [mseh6]
    MRPPLANNINGSEGMENTNUMBER,        -- Plng Segmnt No. [planr]
    MRPPLANNINGSEGMENTTYPE,          -- MRP segment [plaab]
    MRPPLANT,                        -- Plant [werks_d]
    NUMERATOR,                       -- Numerator [umrez]
    ORDEREDCHANGEDQUANTITY,          -- Quantity [mrpquantity]
    ORDEREDQUANTITY,                 -- Quantity [mrpquantity]
    ORIGINALTOTALQUANT,              -- Total Orig. Quantity [mrpreqquantorigtotal]
    ORIGINALTOTALQUANTBASEUNIT,      -- Base Unit [meins]
    PARTIALLYDELIVERED,              -- TRUE [boole_d]
    ITEMPRECISION,                   -- No. of Decimals [ppmrp_precision]
    PROPOSALRANKING,                 -- Single-Character Flag [char1]
    PURCHASECONTRACT,                -- Purchasing Doc. [ebeln]
    PURCHASECONTRACTITEM,            -- Item [ebelp]
    PURCHASEORDERTYPE,               -- Document Type [esart]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [bstyp]
    PURCHASINGINFORECORD,            -- Info Record [infnr]
    PURCHASINGGROUP,                 -- Purchasing Group [mrppurchasinggroup]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    QUANTITYPRECISION,               -- Decimal Places [decan]
    RECEIVINGPLANT,                  -- Plant [werks_d]
    RECEIVINGSTORAGELOCATION,        -- Location [lgort_d]
    RELEASED,                        -- TRUE [boole_d]
    REQUESTSTATUS,                   -- Change Req. Status [mrprequeststatus]
    SALESORDER,                      -- SD Document [vbeln]
    SALESORDERITEM,                  -- Sales doc. item [vbelp]
    SOLUTION_OPTION,                 -- Change Req. Status [mrprequeststatus]
    SOLUTION_TYPE,                   -- Sol. Type [ppmrp_solution_type]
    SOURCEMRPELEMENT,                -- MRP element number [del12]
    SOURCEMRPELEMENTCATEGORY,        -- MRP Elmnt Ind. [delkz]
    SOURCEMRPELEMENTITEM,            -- MRP Element Item [ppmrp_elemitem_ext]
    SOURCEMRPELEMENTSCHEDULELINE,    -- Schedule Line [ppmrp_elemline_ext]
    STORAGELOCATION,                 -- Location [lgort_d]
    SUPPLYINGSTORAGELOCATION,        -- Location [lgort_d]
    SUPPLYINTHEPAST,                 -- Char01 [char01]
    TARGETDATE,                      -- Time Stamp [timestamp]
    TARGETQUANTITY,                  -- Quantity [mrpquantity]
    TARGETQUANTITYINORDERUNIT,       -- Base Unit [meins]
    TARGETQUANTITYUNITDISPLAYDCMLS,  -- Decimal Places [decan]
    TARGETTOTALQUANT,                -- Total Target Qty [mrpreqquanttargtotal]
    UNITOFMEASURECOMMERCIALNAME,     -- Commercial [mseh3]
    VENDOR,                          -- Supplier [lifnr]
    VENDORNAME,                      -- Name [name1_gp]
    VENDORPLANT,                     -- Plant [werks_d]
    VENDORSTATUS,                    -- Vendor's Response [mrprequestvendorstatus]
    WBSELEMENT,                      -- WBS Element [ps_posnr]
    BP_TYPE,                         -- Business Part. Type [ppmrp_bp_type]
    REQUIREMENTCOUNTER,              -- Requirement Counter [ppmrp_req_count]
    MRPELEMENT_INT,                  -- MRP element number [del12]
    MRPELEMENTITEM_INT,              -- MRP elemnt item [delps]
    MRPELEMENTSCHEDULELINE_INT,      -- Scheduling [delet]
    MRPELEMENTBUSINESSPARTNERID,     -- BusinessPartner [ppmrp_businesspartner]
    MRPELEMENTBUSINESSPARTNERNAME,   -- Bus.Partner Name [ppmrp_businesspartnername]
    MRPELEMENTBUSINESSPARTNERTYPE,   -- Business Part. Type [ppmrp_bp_type]
    ISPROPOSAL,                      -- TRUE [boole_d]
    ISSIMULATIONACTIVE,              -- TRUE [boole_d]
    SIMULATE,                        -- TRUE [boole_d]
    SOLUTIONINDEX,                   -- Loop Index [syst_index]
    SIMULATIONQUANTIY,               -- Quantity [mrpquantity]
    SIMULATIONDATE,                  -- Time Stamp [timestamp]
    SOLUTIONRESCHEDULE,              -- Number of Days to Reschulde [mrpreschudledays]
    AGGREGATEDMRPELEMENTS,           -- INT4 [int4]
    CREATIONDATETIME,                -- Time Stamp [timestampl]
    PRIMARY KEY (ITEMINDEX, ORDERID, ORDERITEMID, ORDERSCHEDULELINEID, USERID)
);

Learn More