SADL_GW_MDE_Merge_SelectionFld

test merge selectionfields | view: VSADLGWMDESLF | Extraction: Not supported | Component: REST Integration für CDS und BOPF via SADL
Tables used: SFLIGHT
Column Name Description
carrid FK Airline Code
connid FK Flight Connection Number
fldate Flight date
Column Name Description
💲 Local currency of airline (currency):
price Airfare
Column Name Description
Column Name Description
fldate Flight date
Column Name Description
seatsmax Maximum Capacity in Economy Class Show values
seatsocc_b Occupied seats in business class Show values
seatsmax_f Maximum Capacity in First Class Show values
seatsocc_f Occupied seats in first class Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Generic foreign key
  • Airline Code
  • ?
  • SADL_GW_MDE_MERGE_SELECTIONFLD.CARRID == SCARR.CARRID
  • SADL_GW_MDE_MERGE_SELECTIONFLD.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Flight Plan
  • Flight Connection Number
  • Airline Code
  • ?
  • SADL_GW_MDE_MERGE_SELECTIONFLD.CONNID == SPFLI.CONNID
  • SADL_GW_MDE_MERGE_SELECTIONFLD.CARRID == SPFLI.CARRID
  • SADL_GW_MDE_MERGE_SELECTIONFLD.[column in domain "S_MANDT"] == SPFLI.MANDT
Check Against Airplane
  • Aircraft Type
  • ?
  • SADL_GW_MDE_MERGE_SELECTIONFLD.PLANETYPE == SAPLANE.PLANETYPE
  • SADL_GW_MDE_MERGE_SELECTIONFLD.[column in domain "S_MANDT"] == SAPLANE.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline SADL_GW_MDE_MERGE_SELECTIONFLD.CURRENCY == SCURX.CURRKEY