_FIRSTSTOCKOUTVAL

27 Fields

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

Fields (27)

KeyField CDS FieldsUsed in Views
FirstBelowSFTDate FirstBelowSFTDate 1
FirstBelowSFTFromTodayInDays FirstBelowSFTFromTodayInDays 2
FirstBelowSFTProjtdSFTPct FirstBelowSFTProjtdSFTPct 2
FirstBelowSFTProjtdSFTQty FirstBelowSFTProjtdSFTQty 2
FirstBelowSFTProjtdStkQty FirstBelowSFTProjtdStkQty 2
FirstBelowSFTThldLvlQty FirstBelowSFTThldLvlQty 2
FirstBelowThldDate FirstBelowThldDate 1
FirstBelowThldFromTodayInDays FirstBelowThldFromTodayInDays 2
FirstBelowThldProjtdSFTPct FirstBelowThldProjtdSFTPct 2
FirstBelowThldProjtdSFTQty FirstBelowThldProjtdSFTQty 2
FirstBelowThldProjtdStkQty FirstBelowThldProjtdStkQty 2
FirstBelowThldThldLvlQty FirstBelowThldThldLvlQty 2
FirstStkOutDate FirstStkOutDate 1
FirstStkOutFromTodayInDays FirstStkOutFromTodayInDays 2
FirstStkOutProjtdSFTPct FirstStkOutProjtdSFTPct 2
FirstStkOutProjtdSFTQty FirstStkOutProjtdSFTQty 2
FirstStkOutProjtdStkQty FirstStkOutProjtdStkQty 2
IsWithinDLT IsWithinLeadTime 1
NetFlowPositionQuantity NetFlowPositionQuantity 1
OnHandStockQuantity OnHandStockQuantity 1
OpenSupplyQuantity OpenSupplyQuantity 1
ProjectedOnHandStockStatus ProjectedOnHandStockStatus 1
ProjectedStockOutStatus ProjectedStockOutStatus 1
QualifiedDemandQuantity QualifiedDemandQuantity 1
SafetyStockAlertIsPresent SafetyStockAlertIsPresent 1
StockOutAlertIsPresent StockOutAlertIsPresent 1
ThresholdAlertIsPresent ThresholdAlertIsPresent 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 _FIRSTSTOCKOUTVAL (
    FIRSTBELOWSFTDATE,
    FIRSTBELOWSFTFROMTODAYINDAYS,
    FIRSTBELOWSFTPROJTDSFTPCT,
    FIRSTBELOWSFTPROJTDSFTQTY,
    FIRSTBELOWSFTPROJTDSTKQTY,
    FIRSTBELOWSFTTHLDLVLQTY,
    FIRSTBELOWTHLDDATE,
    FIRSTBELOWTHLDFROMTODAYINDAYS,
    FIRSTBELOWTHLDPROJTDSFTPCT,
    FIRSTBELOWTHLDPROJTDSFTQTY,
    FIRSTBELOWTHLDPROJTDSTKQTY,
    FIRSTBELOWTHLDTHLDLVLQTY,
    FIRSTSTKOUTDATE,
    FIRSTSTKOUTFROMTODAYINDAYS,
    FIRSTSTKOUTPROJTDSFTPCT,
    FIRSTSTKOUTPROJTDSFTQTY,
    FIRSTSTKOUTPROJTDSTKQTY,
    ISWITHINDLT,
    NETFLOWPOSITIONQUANTITY,
    ONHANDSTOCKQUANTITY,
    OPENSUPPLYQUANTITY,
    PROJECTEDONHANDSTOCKSTATUS,
    PROJECTEDSTOCKOUTSTATUS,
    QUALIFIEDDEMANDQUANTITY,
    SAFETYSTOCKALERTISPRESENT,
    STOCKOUTALERTISPRESENT,
    THRESHOLDALERTISPRESENT
);

Learn More