MRP_SITUATIONS

Transparent Table Application Table
22 Fields 1 CDS Views

MRP Material Situations

MRP_SITUATIONS is an SAP database table in S/4HANA. MRP Material Situations. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MRPMaterialSituation view from BASIC Material Situations View

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY materialid MATNR Material
KEY mrpplant WERKS_D Plant
KEY mrparea BERID MRP Area
KEY mrpelementnumber DEL12 MRP element number
KEY mrpelementitem DELPS MRP elemnt item
KEY schedulelinenumber DELET Scheduling
KEY mrpelementcategory DELKZ MRP Elmnt Ind.
KEY mrpplanningsegmenttype PLAAB MRP segment
KEY mrpplanningsegment PLANR Plng Segmnt No.
materialexceptionid abap.char
mrpcontroller DISPO MRP Controller
reschedulingdate UMDAT Rescheduling date
mrpelementindicator UKZ01 Bring forward
excessstockquantity RDMNG Excess Stock
exceptionkey AUSSL Key
exceptionmessage abap.char
materialshortagedefinitionid abap.char
mrpelementcategoryshortname DELB1 MRP element
mrpelementbusinesspartnerid LIFNR Supplier
materialgroup MATKL Material Group
mrpsituation MRPSITUATION MRP Situation

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 Material Situations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MRP_SITUATIONS (
    MANDT,                         -- Client [MANDT]
    MATERIALID,                    -- Material [MATNR]
    MRPPLANT,                      -- Plant [WERKS_D]
    MRPAREA,                       -- MRP Area [BERID]
    MRPELEMENTNUMBER,              -- MRP element number [DEL12]
    MRPELEMENTITEM,                -- MRP elemnt item [DELPS]
    SCHEDULELINENUMBER,            -- Scheduling [DELET]
    MRPELEMENTCATEGORY,            -- MRP Elmnt Ind. [DELKZ]
    MRPPLANNINGSEGMENTTYPE,        -- MRP segment [PLAAB]
    MRPPLANNINGSEGMENT,            -- Plng Segmnt No. [PLANR]
    MATERIALEXCEPTIONID,           -- abap.char
    MRPCONTROLLER,                 -- MRP Controller [DISPO]
    RESCHEDULINGDATE,              -- Rescheduling date [UMDAT]
    MRPELEMENTINDICATOR,           -- Bring forward [UKZ01]
    EXCESSSTOCKQUANTITY,           -- Excess Stock [RDMNG]
    EXCEPTIONKEY,                  -- Key [AUSSL]
    EXCEPTIONMESSAGE,              -- abap.char
    MATERIALSHORTAGEDEFINITIONID,  -- abap.char
    MRPELEMENTCATEGORYSHORTNAME,   -- MRP element [DELB1]
    MRPELEMENTBUSINESSPARTNERID,   -- Supplier [LIFNR]
    MATERIALGROUP,                 -- Material Group [MATKL]
    MRPSITUATION,                  -- MRP Situation [MRPSITUATION]
    PRIMARY KEY (MANDT, MATERIALID, MRPPLANT, MRPAREA, MRPELEMENTNUMBER, MRPELEMENTITEM, SCHEDULELINENUMBER, MRPELEMENTCATEGORY, MRPPLANNINGSEGMENTTYPE, MRPPLANNINGSEGMENT)
);

Learn More