SPFLI

Flight schedule | #masterdata | Component: Training and Demo

🔑 Keys (3)
💰 Amounts
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (1)
Other (2)
🔗 Relations (8)

Column Name	Description
MANDT FK	Client
CARRID FK	Airline Code
CONNID	Flight Connection Number

Column Name	Description

Column Name	Description
📏 Mass unit of distance (kms, miles) (DISTID):
DISTANCE	Distance

Column Name	Description
DEPTIME	Departure time
ARRTIME	Arrival time

Column Name	Description
FLTYPE	Flight type	Show values

Column Name	Description	Domain name
FLTIME	Flight time	S_DURA
PERIOD	Arrival n day(s) later	INT1

Master Data Relations	Join Conditions
Check against airport Client Departure airport	`SPFLI.MANDT == SAIRPORT.MANDT` `SPFLI.AIRPFROM == SAIRPORT.ID`
Check against airport Client Destination airport	`SPFLI.MANDT == SAIRPORT.MANDT` `SPFLI.AIRPTO == SAIRPORT.ID`
Check Against Airline Client Airline Code	`SPFLI.MANDT == SCARR.MANDT` `SPFLI.CARRID == SCARR.CARRID`
Check against city Country/Region Key Client Departure city	`SPFLI.COUNTRYFR == SGEOCITY.COUNTRY` `SPFLI.MANDT == SGEOCITY.MANDT` `SPFLI.CITYFROM == SGEOCITY.CITY`
Check against city Country/Region Key Client Arrival city	`SPFLI.COUNTRYTO == SGEOCITY.COUNTRY` `SPFLI.MANDT == SGEOCITY.MANDT` `SPFLI.CITYTO == SGEOCITY.CITY`
Check against country of departure city Country/Region Key Client Departure city	`SPFLI.COUNTRYFR == SGEOCITY.COUNTRY` `SPFLI.MANDT == SGEOCITY.MANDT` `SPFLI.CITYFROM == SGEOCITY.CITY`
Check against country of arrival city Country/Region Key Client Arrival city	`SPFLI.COUNTRYTO == SGEOCITY.COUNTRY` `SPFLI.MANDT == SGEOCITY.MANDT` `SPFLI.CITYTO == SGEOCITY.CITY`
Check against client	`SPFLI.MANDT == T000.MANDT`