SFLCONN

Flight connection offered by travel agency | #masterdata | Component: Training and Demo
Column Name Description
MANDT FK Client
AGENCYNUM FK Travel Agency Number
FLCONN Flight connection number at travel agency
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
Column Name Description Domain name
FLTIME Flight time S_DURA
PERIOD Arrival n day(s) later INT1
Master Data Relations Join Conditions
Check the Number of the Travel Agency
  • Travel Agency Number
  • Client
Check the Airport ID
  • Client
  • Departure airport
Check the Airport ID
  • Client
  • Destination airport
Check the Town Names
  • Country/Region Key
  • Client
  • Departure city
Arrival city
  • Country/Region Key
  • Client
  • Arrival city
Check Departure Country
  • Country/Region Key
  • Client
  • Departure city
Check Destination Country
  • Country/Region Key
  • Client
  • Arrival city
Check Customers SFLCONN.MANDT == T000.MANDT