PPMRP_SUP_DEM_IT

Transparent Table Application Table
9 Fields 2 CDS Views

Supply and Demand Items

PPMRP_SUP_DEM_IT is an SAP database table in S/4HANA. Supply and Demand Items. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SupplyDemandItem view_entity from CONSUMPTION Supply And Demand Items
E_SupplyDemandItem view_entity from EXTENSION Supply and Demand Items - Extension

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY line SYST_INDEX Loop Index
KEY mrpplant WERKS_D Plant
KEY mrparea BERID MRP Area
KEY matnr MATNR Material
materialshortagedefinitionid PPMRP_SHORT_DEF_ID Shortage Def. ID
mrpplanningsegmenttype PLAAB MRP Segment
mrpplanningsegmentnumber PLANR Plng Segmnt No.
dummy_mrp_sdi_incl_eew_ps 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.

-- Supply and Demand Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPMRP_SUP_DEM_IT (
    MANDT,                         -- Client [MANDT]
    LINE,                          -- Loop Index [SYST_INDEX]
    MRPPLANT,                      -- Plant [WERKS_D]
    MRPAREA,                       -- MRP Area [BERID]
    MATNR,                         -- Material [MATNR]
    MATERIALSHORTAGEDEFINITIONID,  -- Shortage Def. ID [PPMRP_SHORT_DEF_ID]
    MRPPLANNINGSEGMENTTYPE,        -- MRP Segment [PLAAB]
    MRPPLANNINGSEGMENTNUMBER,      -- Plng Segmnt No. [PLANR]
    DUMMY_MRP_SDI_INCL_EEW_PS,     -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, LINE, MRPPLANT, MRPAREA, MATNR)
);

Learn More