MRP_SUP_DEM_ITEM

Transparent Table Temporary Data
56 Fields 1 CDS Views

Supply Demand Item

MRP_SUP_DEM_ITEM is an SAP database table in S/4HANA. Supply Demand Item. It contains 56 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StockRequirementItem view_entity from BASIC MRP Stock Requirement Item

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY line syst_index Loop Index
KEY mrpplant werks_d Plant
KEY materialid matnr Material
KEY mrparea berid MRP Area
KEY materialshortagedefinitionid ppmrp_short_def_id Shortage Def. ID
KEY mrpplanningsegmenttype plaab MRP segment
KEY mrpplanningsegmentnumber planr Plng Segmnt No.
KEY userid vdm_userid User ID
mrpelement del12 MRP element number
mrpelementitem ppmrp_elemitem_ext MRP Element Item
mrpelementscheduleline ppmrp_elemline_ext Schedule Line
mrpelementcategory delkz MRP Elmnt Ind.
mrpelementcategoryshortname delb0 MRP element
mrpelementavailyorrqmtdate timestamp Time Stamp
mrpavailablequantity vrfmg Avail. Quantity
mrpelementopenquantity mng01 Rec./reqd qty
mrpelementquantityisfirm fix01 Fixed Lot Size
mrpelementdocumenttype baart P.O./Order type
mfgorderstatusinternalcode mdfst Status
storagelocation lgort_d Location
assembly baugr Pegged Reqmt
productionversion verid Prod. Version
requirementplan pbdnr Requirements Plan
sourcemrpelement del12 MRP element number
sourcemrpelementitem ppmrp_sourcelemitem_ext MRP Element Item
sourcemrpelementscheduleline ppmrp_sourcelemline_ext Schedule Line
sourcemrpelementcategory delkz MRP Elmnt Ind.
mrpelementbusinesspartnerid ppmrp_businesspartner BusinessPartner
mrpelementbusinesspartnername ppmrp_businesspartnername Bus.Partner Name
mrpelementbusinesspartnertype ppmrp_bp_type Business Part. Type
materialbaseunit abap.char Do not use MEINS to avoid Gateway conversion
materialbaseunittext mseh6 Technical
unitofmeasurecommercialname mseh3 Commercial
quantityprecision andec Rounding
materialshortagestatus char01 Char01
released char01 Char01
partiallydelivered char01 Char01
requeststatus char2 Component of the Version Number
vendorstatus char2 Component of the Version Number
mrpavailability vrfkz Availability
materialshortagecriticalqty mng01 Rec./reqd qty
materialshortagethresholdqty mng01 Rec./reqd qty
mrpevaluationhorizonindays int4 INT4
decisionsupport char01 Char01
shortagecount int2 INT2
materialsafetystockqty eisbe Safety Stock
mrpelementdocumenttypename abap.char
supplyaggregation int1 INT1
demandaggregation int1 INT1
mrpelementcategorygroup demandcategorygroup Demand Groups
mrpelementcategorygroupname val_text Short Description
supplyinthepast char01 Char01
aggregatedmrpelements int4 INT4
targetquantityunitdisplaydcmls decan Decimal Places
creationdatetime timestampl Time Stamp
materialexternalid matnr Material

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.

-- Supply Demand Item
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MRP_SUP_DEM_ITEM (
    LINE,                            -- Loop Index [syst_index]
    MRPPLANT,                        -- Plant [werks_d]
    MATERIALID,                      -- Material [matnr]
    MRPAREA,                         -- MRP Area [berid]
    MATERIALSHORTAGEDEFINITIONID,    -- Shortage Def. ID [ppmrp_short_def_id]
    MRPPLANNINGSEGMENTTYPE,          -- MRP segment [plaab]
    MRPPLANNINGSEGMENTNUMBER,        -- Plng Segmnt No. [planr]
    USERID,                          -- User ID [vdm_userid]
    MRPELEMENT,                      -- MRP element number [del12]
    MRPELEMENTITEM,                  -- MRP Element Item [ppmrp_elemitem_ext]
    MRPELEMENTSCHEDULELINE,          -- Schedule Line [ppmrp_elemline_ext]
    MRPELEMENTCATEGORY,              -- MRP Elmnt Ind. [delkz]
    MRPELEMENTCATEGORYSHORTNAME,     -- MRP element [delb0]
    MRPELEMENTAVAILYORRQMTDATE,      -- Time Stamp [timestamp]
    MRPAVAILABLEQUANTITY,            -- Avail. Quantity [vrfmg]
    MRPELEMENTOPENQUANTITY,          -- Rec./reqd qty [mng01]
    MRPELEMENTQUANTITYISFIRM,        -- Fixed Lot Size [fix01]
    MRPELEMENTDOCUMENTTYPE,          -- P.O./Order type [baart]
    MFGORDERSTATUSINTERNALCODE,      -- Status [mdfst]
    STORAGELOCATION,                 -- Location [lgort_d]
    ASSEMBLY,                        -- Pegged Reqmt [baugr]
    PRODUCTIONVERSION,               -- Prod. Version [verid]
    REQUIREMENTPLAN,                 -- Requirements Plan [pbdnr]
    SOURCEMRPELEMENT,                -- MRP element number [del12]
    SOURCEMRPELEMENTITEM,            -- MRP Element Item [ppmrp_sourcelemitem_ext]
    SOURCEMRPELEMENTSCHEDULELINE,    -- Schedule Line [ppmrp_sourcelemline_ext]
    SOURCEMRPELEMENTCATEGORY,        -- MRP Elmnt Ind. [delkz]
    MRPELEMENTBUSINESSPARTNERID,     -- BusinessPartner [ppmrp_businesspartner]
    MRPELEMENTBUSINESSPARTNERNAME,   -- Bus.Partner Name [ppmrp_businesspartnername]
    MRPELEMENTBUSINESSPARTNERTYPE,   -- Business Part. Type [ppmrp_bp_type]
    MATERIALBASEUNIT,                -- Do not use MEINS to avoid Gateway conversion [abap.char]
    MATERIALBASEUNITTEXT,            -- Technical [mseh6]
    UNITOFMEASURECOMMERCIALNAME,     -- Commercial [mseh3]
    QUANTITYPRECISION,               -- Rounding [andec]
    MATERIALSHORTAGESTATUS,          -- Char01 [char01]
    RELEASED,                        -- Char01 [char01]
    PARTIALLYDELIVERED,              -- Char01 [char01]
    REQUESTSTATUS,                   -- Component of the Version Number [char2]
    VENDORSTATUS,                    -- Component of the Version Number [char2]
    MRPAVAILABILITY,                 -- Availability [vrfkz]
    MATERIALSHORTAGECRITICALQTY,     -- Rec./reqd qty [mng01]
    MATERIALSHORTAGETHRESHOLDQTY,    -- Rec./reqd qty [mng01]
    MRPEVALUATIONHORIZONINDAYS,      -- INT4 [int4]
    DECISIONSUPPORT,                 -- Char01 [char01]
    SHORTAGECOUNT,                   -- INT2 [int2]
    MATERIALSAFETYSTOCKQTY,          -- Safety Stock [eisbe]
    MRPELEMENTDOCUMENTTYPENAME,      -- abap.char
    SUPPLYAGGREGATION,               -- INT1 [int1]
    DEMANDAGGREGATION,               -- INT1 [int1]
    MRPELEMENTCATEGORYGROUP,         -- Demand Groups [demandcategorygroup]
    MRPELEMENTCATEGORYGROUPNAME,     -- Short Description [val_text]
    SUPPLYINTHEPAST,                 -- Char01 [char01]
    AGGREGATEDMRPELEMENTS,           -- INT4 [int4]
    TARGETQUANTITYUNITDISPLAYDCMLS,  -- Decimal Places [decan]
    CREATIONDATETIME,                -- Time Stamp [timestampl]
    MATERIALEXTERNALID,              -- Material [matnr]
    PRIMARY KEY (LINE, MRPPLANT, MATERIALID, MRPAREA, MATERIALSHORTAGEDEFINITIONID, MRPPLANNINGSEGMENTTYPE, MRPPLANNINGSEGMENTNUMBER, USERID)
);

Learn More