MRP_ACC_SHORTAGE

Transparent Table Application Table
6 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 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AcceptedShortage view from BASIC MRP Accepted Shortage

Fields (6)

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

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]
    PRIMARY KEY (MANDT, ACCEPTSHORTAGEID)
);

Learn More