Salv_Ida_Test_Sbook_X_Sbook

SALV IDA Test CDS view for Cartesian Product | view: SALV_IDA_TEST_CA | Extraction: Not supported | Component: SAP List Viewer
Tables used: SBOOK
Column Name Description
Column Name Description
💲 Local currency of airline (loccurkey):
loccuram Price of booking in local currency of airline
Column Name Description
Column Name Description
fldate FK Flight date
fldate2 FK Flight date
Column Name Description
Column Name Description Domain name
bookid Booking number S_BOOK_ID
bookid2 Booking number S_BOOK_ID
count_field null
Master Data Relations Join Conditions
Check Against Airline
  • Airline Code
  • Airline Code
  • ?
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID == SCARR.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID2 == SCARR.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Airline
  • Airline Code
  • Airline Code
  • ?
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID == SCARR.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID2 == SCARR.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Flight Connection
  • Airline Code
  • Airline Code
  • Flight Connection Number
  • Flight Connection Number
  • ?
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID == SPFLI.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID2 == SPFLI.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CONNID == SPFLI.CONNID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CONNID2 == SPFLI.CONNID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.[column in domain "S_MANDT"] == SPFLI.MANDT
Check Against Flight Connection
  • Airline Code
  • Airline Code
  • Flight Connection Number
  • Flight Connection Number
  • ?
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID == SPFLI.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID2 == SPFLI.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CONNID == SPFLI.CONNID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CONNID2 == SPFLI.CONNID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.[column in domain "S_MANDT"] == SPFLI.MANDT
Check Against Sales Office
  • Airline Code
  • Airline Code
  • Client
  • Number of sales office
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID == SCOUNTER.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.CARRID2 == SCOUNTER.CARRID
  • SALV_IDA_TEST_SBOOK_X_SBOOK.MANDT == SCOUNTER.MANDT
  • SALV_IDA_TEST_SBOOK_X_SBOOK.COUNTER == SCOUNTER.COUNTNUM
Other Relations | to Master Data Relations ↑ Join Conditions
Check Currency SALV_IDA_TEST_SBOOK_X_SBOOK.LOCCURKEY == SCURX.CURRKEY