MRP_EXCEPTIONS

Transparent Table Application Table
25 Fields 1 CDS Views

MRP Exceptions

MRP_EXCEPTIONS is an SAP database table in S/4HANA. MRP Exceptions. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MRPExceptionListBasic view from BASIC List of MRP Exceptions

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY material MATNR Material
KEY mrpplant WERKS_D Plant
KEY mrparea BERID MRP Area
KEY mrpelement DEL12 MRP element number
KEY mrpelementitem DELPS MRP elemnt item
KEY mrpelementscheduleline DELET Scheduling
KEY mrpelementcategory DELKZ MRP Elmnt Ind.
KEY mrpplanningsegmenttype PLAAB MRP segment
KEY mrpplanningsegment PLANR Plng Segmnt No.
request_id GUID GUID
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
proposeddatasource PROPOSEDDATASOURCE Proposed Data Source
prioritycode MRP_CR_PRIORITY_CODE Priority
reasoncode MRP_CR_REASON_CODE Reason Code
dummy_mrp_req_note DUMMY Dummy function in length 1

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 Exceptions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MRP_EXCEPTIONS (
    MANDT,                         -- Client [MANDT]
    MATERIAL,                      -- Material [MATNR]
    MRPPLANT,                      -- Plant [WERKS_D]
    MRPAREA,                       -- MRP Area [BERID]
    MRPELEMENT,                    -- MRP element number [DEL12]
    MRPELEMENTITEM,                -- MRP elemnt item [DELPS]
    MRPELEMENTSCHEDULELINE,        -- Scheduling [DELET]
    MRPELEMENTCATEGORY,            -- MRP Elmnt Ind. [DELKZ]
    MRPPLANNINGSEGMENTTYPE,        -- MRP segment [PLAAB]
    MRPPLANNINGSEGMENT,            -- Plng Segmnt No. [PLANR]
    REQUEST_ID,                    -- GUID [GUID]
    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]
    PROPOSEDDATASOURCE,            -- Proposed Data Source [PROPOSEDDATASOURCE]
    PRIORITYCODE,                  -- Priority [MRP_CR_PRIORITY_CODE]
    REASONCODE,                    -- Reason Code [MRP_CR_REASON_CODE]
    DUMMY_MRP_REQ_NOTE,            -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, MATERIAL, MRPPLANT, MRPAREA, MRPELEMENT, MRPELEMENTITEM, MRPELEMENTSCHEDULELINE, MRPELEMENTCATEGORY, MRPPLANNINGSEGMENTTYPE, MRPPLANNINGSEGMENT)
);

Learn More