I_DEMANDDRIVENMATERIALDATA

CDS View

Data related to materials

I_DEMANDDRIVENMATERIALDATA is a CDS View in S/4HANA. Data related to materials. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_DemandDrivenBOMComponents view from CONSUMPTION Lists out BOM Components
C_DmndDrivenSupDmndList view from CONSUMPTION Lists out Demand Driven MRP Elements
C_DmndDrivenSupOrder view_entity from CONSUMPTION CRUD operation in DDMRP
C_MRPSupplyOrder view_entity from CONSUMPTION MRP Supply Order

Fields (6)

KeyField CDS FieldsUsed in Views
KEY Material Material 2
KEY MRPArea MRPArea 1
KEY Plant Plant 2
MRPController MRPController 2
MRPMaterialStatus MRPMaterialStatus 1
MRPType MRPType 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.

-- Data related to materials
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DEMANDDRIVENMATERIALDATA (
    MATERIAL,
    MRPAREA,
    PLANT,
    MRPCONTROLLER,
    MRPMATERIALSTATUS,
    MRPTYPE,
    PRIMARY KEY (MATERIAL, MRPAREA, PLANT)
);