MRP_ACC_SHORTAGE

Transparent Table Application Table
17 Fields 1 CDS Views

All shortages that are accepted

MRP_ACC_SHORTAGE is an SAP database table in S/4HANA. All shortages that are accepted. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AcceptedShortage view from BASIC MRP Accepted Shortage

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY acceptshortageid GUID GUID
creationdate SYDATUM Current Date
createdbyuser SYUNAME User Name
lastchangedate SYDATUM Current Date
lastchangedbyuser SYUNAME User Name
materialshortageprofile MATERIALSHORTAGEPROFILE Shortage Prf.
materialshortageprofilecount SDM_COUNTER Counter
material MATNR Material
mrpplant WERKS_D Plant
mrparea BERID MRP Area
mrpplanningsegmenttype PLAAB MRP segment
mrpplanningsegmentnumber PLANR Plng Segmnt No.
materialshortagestartdate MATERIALSHORTAGESTARTDATE Shortage Start
materialshortageenddate MATERIALSHORTAGEENDDATE Shortage End
minavailableqtyatshortage MATERIALSHORTAGEQUANTITY Shortage Qty
acceptshortagenote MRPREQNOTE Change Request Note

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.

-- All shortages that are accepted
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MRP_ACC_SHORTAGE (
    MANDT,                         -- Client [MANDT]
    ACCEPTSHORTAGEID,              -- GUID [GUID]
    CREATIONDATE,                  -- Current Date [SYDATUM]
    CREATEDBYUSER,                 -- User Name [SYUNAME]
    LASTCHANGEDATE,                -- Current Date [SYDATUM]
    LASTCHANGEDBYUSER,             -- User Name [SYUNAME]
    MATERIALSHORTAGEPROFILE,       -- Shortage Prf. [MATERIALSHORTAGEPROFILE]
    MATERIALSHORTAGEPROFILECOUNT,  -- Counter [SDM_COUNTER]
    MATERIAL,                      -- Material [MATNR]
    MRPPLANT,                      -- Plant [WERKS_D]
    MRPAREA,                       -- MRP Area [BERID]
    MRPPLANNINGSEGMENTTYPE,        -- MRP segment [PLAAB]
    MRPPLANNINGSEGMENTNUMBER,      -- Plng Segmnt No. [PLANR]
    MATERIALSHORTAGESTARTDATE,     -- Shortage Start [MATERIALSHORTAGESTARTDATE]
    MATERIALSHORTAGEENDDATE,       -- Shortage End [MATERIALSHORTAGEENDDATE]
    MINAVAILABLEQTYATSHORTAGE,     -- Shortage Qty [MATERIALSHORTAGEQUANTITY]
    ACCEPTSHORTAGENOTE,            -- Change Request Note [MRPREQNOTE]
    PRIMARY KEY (MANDT, ACCEPTSHORTAGEID)
);

Learn More