Fdt_Test_Book_Cds

BOOK CDS | view: FDT_TEST_BOOK | Extraction: Not supported | Component: BRFplus - ABAP-Based Business Rules
Tables used: SBOOK
Column Name Description
carrid FK Airline Code
connid FK Flight Connection Number
fldate FK Flight date
bookid Booking number
Column Name Description
💲 Payment currency (forcurkey):
forcuram Booking price in foreign currency (dependent on location)
💲 Local currency of airline (loccurkey):
loccuram Price of booking in local currency of airline
Column Name Description
📏 Weight Unit (wunit):
luggweight Weight of Luggage
Column Name Description
fldate FK Flight date
order_date Booking Date
passbirth Date of Birth of a Passenger
Column Name Description
custtype Customer type Show values
smoker Smoker Show values
invoice Invoice flag Show values
class Flight Class Show values
cancelled Cancelation flag Show values
reserved Reservation flag Show values
Column Name Description Domain name
passname Name of the Passenger S_CUSTNAME
passform Form of address S_TEXT15
Master Data Relations | to Other Relations ↓ Join Conditions
Check Against Travel Agency
  • Travel Agency Number
  • ?
  • FDT_TEST_BOOK_CDS.AGENCYNUM == STRAVELAG.AGENCYNUM
  • FDT_TEST_BOOK_CDS.[column in domain "S_MANDT"] == STRAVELAG.MANDT
Check Against Airline
  • Airline Code
  • ?
  • FDT_TEST_BOOK_CDS.CARRID == SCARR.CARRID
  • FDT_TEST_BOOK_CDS.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Flight Connection
  • Airline Code
  • Flight Connection Number
  • ?
  • FDT_TEST_BOOK_CDS.CARRID == SPFLI.CARRID
  • FDT_TEST_BOOK_CDS.CONNID == SPFLI.CONNID
  • FDT_TEST_BOOK_CDS.[column in domain "S_MANDT"] == SPFLI.MANDT
Check Against Sales Office
  • Airline Code
  • Client
  • Number of sales office
  • FDT_TEST_BOOK_CDS.CARRID == SCOUNTER.CARRID
  • FDT_TEST_BOOK_CDS.MANDT == SCOUNTER.MANDT
  • FDT_TEST_BOOK_CDS.COUNTER == SCOUNTER.COUNTNUM
Check against customer table
  • Customer Number
  • ?
  • FDT_TEST_BOOK_CDS.CUSTOMID == SCUSTOM.ID
  • FDT_TEST_BOOK_CDS.[column in domain "S_MANDT"] == SCUSTOM.MANDT
Check Against Units
  • Client
  • Weight Unit
  • FDT_TEST_BOOK_CDS.MANDT == T006.MANDT
  • FDT_TEST_BOOK_CDS.WUNIT == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Payment currency FDT_TEST_BOOK_CDS.FORCURKEY == SCURX.CURRKEY
Check Currency FDT_TEST_BOOK_CDS.LOCCURKEY == SCURX.CURRKEY