TA20NEGOF

Negotiated Flight Fares (Corporate Nego Fares) | #masterdata | Component: Travel Planning
Column Name Description
MANDT Client
PROVIDER FK Provider of negotiated rate
GEOORG_TYPE Geographical Origin Type Show values
GEOORG Geographical Origin
GEODEST_TYPE Type of Geographical Destination Show values
GEODEST Geographical Destination
DIRECTIONALITY Direction Show values
FAREBASIS Fare Basis
ENDDA End Date
Column Name Description
💲 Currency of negotiated rate (CURRENCY):
BASE_PRICE Price of negotiated rate
PRICE Price of negotiated rate
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
GEOORG_TYPE Geographical Origin Type Show values
GEODEST_TYPE Type of Geographical Destination Show values
DIRECTIONALITY Direction Show values
FARETYPE Type of Negotiated Airfare Rate Show values
FARENATURE Rate Type (One-Way or Round Trip) Show values
PUSE Private usage permitted Show values
CABIN Flight Cabin Class Show values
MANDATORY_USE Usage of Rate is Mandatory Show values
Column Name Description Domain name
PTC Flight Passenger Category FTPD_PTC
CLASS Booking Code FTPD_BOOKING_CODE
FARE_INDEX Rate Index Tables NUMC06
Master Data Relations Join Conditions
Contract
Check Against Currency
  • TA20NEGOF.MANDT == TCURC.MANDT
  • TA20NEGOF.CURRENCY == TCURC.WAERS
Route
  • Route
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Airline
  • ?
  • Provider of negotiated rate
  • Client
  • TA20NEGOF.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • TA20NEGOF.PROVIDER == TA21P.PROVIDER
  • TA20NEGOF.MANDT == TA21P.MANDT