TA20NC

Negotiated rental car rates (corporate nego rates) | #masterdata | Component: Travel Planning
Column Name Description
MANDT Client
PROVIDER FK Provider of negotiated rate
LOCATIONTYPE Geographical area type Show values
LOCATION Geographical Area of Negotiated Car Rental Rate
CAR_CODE FK Car rental specification of necotiated rate
RATECODE FK Negotiated car rental rate
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
LOCATIONTYPE Geographical area type Show values
PUSE Private usage permitted Show values
Column Name Description Domain name
CORPDISC Contract number for identification CHAR20
Master Data Relations Join Conditions
Check Against Car Rental Specification
  • TA20NC.MANDT == TA21CA.MANDT
  • TA20NC.CAR_CODE == TA21CA.CAR_CODE
Check Against Currency
  • TA20NC.MANDT == TCURC.MANDT
  • TA20NC.CURRENCY == TCURC.WAERS
Check Against Car Rental Rate
  • Negotiated car rental rate
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Car Rental Company
  • ?
  • Provider of negotiated rate
  • Client
  • TA20NC.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • TA20NC.PROVIDER == TA21P.PROVIDER
  • TA20NC.MANDT == TA21P.MANDT