/AIF/FLBOOK_IDX

Standard index table | #index | Component: Application Interface Framework
Column Name Description
MANDT Client
MSGGUID GUID in 'CHAR' Format in Uppercase
Column Name Description
Column Name Description
Column Name Description
TL_EXP_DATE Expiration Date
TL_EXP_TIME Expiration Time
CREATE_DATE Creation Date
CREATE_TIME Creation Time
LAST_DATE Last Date
LAST_TIME Last Time
END_DATE End Date
END_TIME End Time
FLIGHTDATE_FL Flight date
PASSBIRTH_FL Date of Birth of a Passenger
Column Name Description
STATUS Processing Status Show values
SUB_STATUS Sub status for 'In Process' status Show values
AIF_LOCATION Message Location Show values
TRACE_LEVEL AIF Trace Level Show values
EXTERNAL_MESSAGE Indicates source of message: internal or extenal (e.g CPI) Show values
CLASS_FL Flight Class Show values
Column Name Description Domain name
NUMBEROFABORTS Abort Number
NUMBEROFERRORS Error Number
NUMBEROFWARNINGS Warning Number
NUMBEROFSUCCESS Success Number
NUMBEROFINFOS Information Number
NSRECIP Namespace /AIF/NS
RECIPIENT Alert Management Recipient /AIF/ALRT_REC
LOGNUMBER Application Log: Log Number BALOGNR
CREATE_USER Create User BNAME
LAST_USER Last User BNAME
END_USER End User BNAME
AIF_ALERT_ID External ID for an Alert SALRTEXTID
AIF_VARIANT_NS Variant Namespace /AIF/NS
AIF_VARIANT_NAME Name of Interface Variant /AIF/VARIANT_NAME
TIME_ZONE Time Zone TZNZONE
PROCESSING_END_TSTMP Message Processing Timestamp in UTC Timezone TZNTSTMPS
PID Integration Engine: Pipeline ID SXMSPID
PASSNAME_FL Name of the Passenger S_CUSTNAME
PASSFORM_FL Form of address S_TEXT15
BOOKINGNUMBER Booking number S_BOOK_ID
PRICE Flight booking price BAPICURR
TAX Flight taxes BAPICURR
CURR_ISO ISO currency code ISOCD
Master Data Relations Join Conditions
Check Against Travel Agency
  • Travel Agency Number
  • Client
  • /AIF/FLBOOK_IDX.AGENCYNUM_FL == STRAVELAG.AGENCYNUM
  • /AIF/FLBOOK_IDX.MANDT == STRAVELAG.MANDT
Check Against Airline
  • /AIF/FLBOOK_IDX.MANDT == SCARR.MANDT
  • /AIF/FLBOOK_IDX.AIRLINEID_FL == SCARR.CARRID
Check Against Flight Connection
  • Flight Connection Number
  • Airline Code
  • Client
  • /AIF/FLBOOK_IDX.CONNECTID_FL == SPFLI.CONNID
  • /AIF/FLBOOK_IDX.AIRLINEID_FL == SPFLI.CARRID
  • /AIF/FLBOOK_IDX.MANDT == SPFLI.MANDT
Check Against Sales Office
  • Airline Code
  • Number of sales office
  • Client
  • /AIF/FLBOOK_IDX.AIRLINEID_FL == SCOUNTER.CARRID
  • /AIF/FLBOOK_IDX.COUNTER_FL == SCOUNTER.COUNTNUM
  • /AIF/FLBOOK_IDX.MANDT == SCOUNTER.MANDT
Customer Number
  • Customer Number
  • Client
  • /AIF/FLBOOK_IDX.CUSTOMERID_FL == SCUSTOM.ID
  • /AIF/FLBOOK_IDX.MANDT == SCUSTOM.MANDT
Interface Name
  • Namespace
  • Interface Name
  • Interface Version
Interface Version
  • Namespace
  • Interface Name
  • Interface Version
Namespace