TA20NF

Negotiated Flight Fares (Corporate Nego Fares) | #masterdata | Component: Travel Planning
Column Name Description
MANDT Client
PROVIDER FK Provider of negotiated rate
DEPLOC FK Departure location of negotiated airfare rate
ARRLOC FK Arrival Location of Negotiated Airfare Rate
FAREBASIS Fare Basis
ENDDA End Date
Column Name Description
💲 Currency of negotiated rate (CURRENCY):
PRICE Price of negotiated rate
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
FARETYPE Type of negotiated airfare Show values
FARENATURE Rate Type (One-Way or Round Trip) Show values
PUSE Private usage permitted Show values
CABIN Flight Cabin Class Show values
Column Name Description Domain name
CORPID Contract Number FTPD_CORP_ID
PTC Flight Passenger Category FTPD_PTC
Master Data Relations Join Conditions
Check Against Location
  • Arrival Location of Negotiated Airfare Rate
  • Client
  • TA20NF.ARRLOC == TA21L.LOCID
  • TA20NF.MANDT == TA21L.MANDT
Check Against Currency
  • TA20NF.MANDT == TCURC.MANDT
  • TA20NF.CURRENCY == TCURC.WAERS
Check Against IATA Location
  • Departure location of negotiated airfare rate
  • Client
  • TA20NF.DEPLOC == TA21L.LOCID
  • TA20NF.MANDT == TA21L.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Airline
  • ?
  • Provider of negotiated rate
  • Client
  • TA20NF.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • TA20NF.PROVIDER == TA21P.PROVIDER
  • TA20NF.MANDT == TA21P.MANDT