_FLIGHTAGGR

_FLIGHTAGGR is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
SitnDemo1stClPrice SitnDemo1stClPrice 1
SitnDemo1stClSalesRatio SitnDemo1stClSalesRatio 1
SitnDemo1stClSoldAmount SitnDemo1stClSoldAmount 1
SitnDemoBusClPrice SitnDemoBusClPrice 1
SitnDemoBusClSalesRatio SitnDemoBusClSalesRatio 1
SitnDemoBusClSoldAmount SitnDemoBusClSoldAmount 1
SitnDemoCurrentSoldAmount SitnDemoCurrentSoldAmount 1
SitnDemoEconomyClSalesRatio SitnDemoEconomyClSalesRatio 1
SitnDemoEconomyClSoldAmount SitnDemoEconomyClSoldAmount 1
SitnDemoLuggageWgtChtRatio SitnDemoLuggageWgtChtRatio 1
SitnDemoLuggageWgtRatio SitnDemoLuggageWgtRatio 1
SitnDemoMaxSoldAmount SitnDemoMaxSoldAmount 1
SitnDemoOccupiedSeatsChtRatio SitnDemoOccupiedSeatsChtRatio 1
SitnDemoOccupiedSeatsRatio SitnDemoOccupiedSeatsRatio 1
SitnDemoSalesDiff1stClAmount SitnDemoSalesDiff1stClAmount 1
SitnDemoSalesDiffAmount SitnDemoSalesDiffAmount 1
SitnDemoSalesDiffBusClAmount SitnDemoSalesDiffBusClAmount 1
SitnDemoSalesRatio SitnDemoSalesRatio 1
SitnDemoSeatOccpcyEconomyRatio SitnDemoSeatOccpcyEconomyRatio 1
SitnDemoSeatsOccpcy1stClRatio SitnDemoSeatsOccpcy1stClRatio 1
SitnDemoSeatsOccpcyBusClRatio SitnDemoSeatsOccpcyBusClRatio 1
SitnDemoSlsDiffEconomyClAmount SitnDemoSlsDiffEconomyClAmount 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 _FLIGHTAGGR (
    SITNDEMO1STCLPRICE,
    SITNDEMO1STCLSALESRATIO,
    SITNDEMO1STCLSOLDAMOUNT,
    SITNDEMOBUSCLPRICE,
    SITNDEMOBUSCLSALESRATIO,
    SITNDEMOBUSCLSOLDAMOUNT,
    SITNDEMOCURRENTSOLDAMOUNT,
    SITNDEMOECONOMYCLSALESRATIO,
    SITNDEMOECONOMYCLSOLDAMOUNT,
    SITNDEMOLUGGAGEWGTCHTRATIO,
    SITNDEMOLUGGAGEWGTRATIO,
    SITNDEMOMAXSOLDAMOUNT,
    SITNDEMOOCCUPIEDSEATSCHTRATIO,
    SITNDEMOOCCUPIEDSEATSRATIO,
    SITNDEMOSALESDIFF1STCLAMOUNT,
    SITNDEMOSALESDIFFAMOUNT,
    SITNDEMOSALESDIFFBUSCLAMOUNT,
    SITNDEMOSALESRATIO,
    SITNDEMOSEATOCCPCYECONOMYRATIO,
    SITNDEMOSEATSOCCPCY1STCLRATIO,
    SITNDEMOSEATSOCCPCYBUSCLRATIO,
    SITNDEMOSLSDIFFECONOMYCLAMOUNT
);