Fields (22)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA