I_DEMANDDRIVENMATERIAL

CDS View
14 Fields 1 CDS Views

Demand Driven Material Data

I_DEMANDDRIVENMATERIAL is a CDS View in S/4HANA. Demand Driven Material Data. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DemandDrivenCalcValues view from CONSUMPTION Calculated Values for DD MRP

Fields (14)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MRPArea MRPArea 1
KEY Plant Plant 1
BaseUnitofMeasure BaseUnitofMeasure 1
MaterialBaseUnit MaterialBaseUnit 1
MaterialGroup MaterialGroup 1
MaterialMaxStockLevelQuantity MaterialMaxStockLevelQuantity 1
MaterialSafetyStockQty MaterialSafetyStockQty 1
MaterialSafetyStockTodayQty MaterialSafetyStockTodayQty 1
MRPController MRPController 1
MRPGroup MRPGroup 1
MRPType MRPType 1
ReorderThresholdQuantity ReorderThresholdQuantity 1
ThresholdPercentage ThresholdPercentage 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.

-- Demand Driven Material Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DEMANDDRIVENMATERIAL (
    MATERIAL,
    MRPAREA,
    PLANT,
    BASEUNITOFMEASURE,
    MATERIALBASEUNIT,
    MATERIALGROUP,
    MATERIALMAXSTOCKLEVELQUANTITY,
    MATERIALSAFETYSTOCKQTY,
    MATERIALSAFETYSTOCKTODAYQTY,
    MRPCONTROLLER,
    MRPGROUP,
    MRPTYPE,
    REORDERTHRESHOLDQUANTITY,
    THRESHOLDPERCENTAGE,
    PRIMARY KEY (MATERIAL, MRPAREA, PLANT)
);

Learn More