_DDRMATERIAL

27 Fields

_DDRMATERIAL is an SAP database table in S/4HANA. It contains 27 fields.

Fields (27)

KeyField CDS FieldsUsed in Views
DecoupledLeadTime DecoupledLeadTime 1
FirstBelowSFTFromTodayInDays FirstBelowSFTFromTodayInDays 1
FirstBelowSFTProjtdSFTPct FirstBelowSFTProjtdSFTPct 1
FirstBelowSFTProjtdSFTQty FirstBelowSFTProjtdSFTQty 1
FirstBelowSFTProjtdStkQty FirstBelowSFTProjtdStkQty 1
FirstBelowSFTThldLvlQty FirstBelowSFTThldLvlQty 1
FirstBelowThldFromTodayInDays FirstBelowThldFromTodayInDays 1
FirstBelowThldProjtdSFTPct FirstBelowThldProjtdSFTPct 1
FirstBelowThldProjtdSFTQty FirstBelowThldProjtdSFTQty 1
FirstBelowThldProjtdStkQty FirstBelowThldProjtdStkQty 1
FirstBelowThldThldLvlQty FirstBelowThldThldLvlQty 1
FirstStkOutFromTodayInDays FirstStkOutFromTodayInDays 1
FirstStkOutProjtdSFTPct FirstStkOutProjtdSFTPct 1
FirstStkOutProjtdSFTQty FirstStkOutProjtdSFTQty 1
FirstStkOutProjtdStkQty FirstStkOutProjtdStkQty 1
FutureHrznDLTMultiplierValue FutureHrznDLTMultiplierValue 1
IsWithinDLT IsWithinLeadTime 1
MaterialPlanningPriority MaterialPlanningPriority 1
MaterialPlanningPriorityStatus MaterialPlanningPriorityStatus 1
NetFlowPositionQuantity NetFlowPositionQuantity 1
OnHandBufferStatusQuantity OnHandBufferStatusQuantity 1
OnHandStockQuantity OnHandStockQuantity 1
OnHandStockStatus OnHandStockStatus 1
OrderPlanningStatusText OrderPlanningStatusText 1
PastHorizonDLTMultiplierValue PastHorizonDLTMultiplierValue 1
ProjectedOnHandStockStatus ProjectedOnHandStockStatus 1
ProposedQuantity ProposedQuantity 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _DDRMATERIAL (
    DECOUPLEDLEADTIME,
    FIRSTBELOWSFTFROMTODAYINDAYS,
    FIRSTBELOWSFTPROJTDSFTPCT,
    FIRSTBELOWSFTPROJTDSFTQTY,
    FIRSTBELOWSFTPROJTDSTKQTY,
    FIRSTBELOWSFTTHLDLVLQTY,
    FIRSTBELOWTHLDFROMTODAYINDAYS,
    FIRSTBELOWTHLDPROJTDSFTPCT,
    FIRSTBELOWTHLDPROJTDSFTQTY,
    FIRSTBELOWTHLDPROJTDSTKQTY,
    FIRSTBELOWTHLDTHLDLVLQTY,
    FIRSTSTKOUTFROMTODAYINDAYS,
    FIRSTSTKOUTPROJTDSFTPCT,
    FIRSTSTKOUTPROJTDSFTQTY,
    FIRSTSTKOUTPROJTDSTKQTY,
    FUTUREHRZNDLTMULTIPLIERVALUE,
    ISWITHINDLT,
    MATERIALPLANNINGPRIORITY,
    MATERIALPLANNINGPRIORITYSTATUS,
    NETFLOWPOSITIONQUANTITY,
    ONHANDBUFFERSTATUSQUANTITY,
    ONHANDSTOCKQUANTITY,
    ONHANDSTOCKSTATUS,
    ORDERPLANNINGSTATUSTEXT,
    PASTHORIZONDLTMULTIPLIERVALUE,
    PROJECTEDONHANDSTOCKSTATUS,
    PROPOSEDQUANTITY
);

Learn More