TA20NRC

Discount Agreement for Rental Car Usage | #other | Component: Travel Planning
Column Name Description
MANDT Client
PROVIDER FK Provider Code
LOCATION_TYP Geographical area type Show values
LOCATION Geographical Area of Negotiated Car Rental Rate
CAR_CODE FK Car rental specification of necotiated rate
RATECODE FK Rental car rate
ENDDA End Date
Column Name Description
💲 Currency of negotiated rate (CURRENCY):
DISCAMOUNT Discount Amount
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
LOCATION_TYP Geographical area type Show values
PUSE Private usage permitted Show values
DISCTYPE Discount Type Show values
Column Name Description Domain name
CORP_DISC Contract number for identification CHAR20
DISCPERCENT Discount in Percent INT2
Master Data Relations Join Conditions
Check Against Car Rental Specification
  • TA20NRC.MANDT == TA21CA.MANDT
  • TA20NRC.CAR_CODE == TA21CA.CAR_CODE
Check Against Currency
  • TA20NRC.MANDT == TCURC.MANDT
  • TA20NRC.CURRENCY == TCURC.WAERS
Check Against Car Rental Rate
  • Rental car rate
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Provider
  • ?
  • Provider Code
  • Client
  • TA20NRC.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • TA20NRC.PROVIDER == TA21P.PROVIDER
  • TA20NRC.MANDT == TA21P.MANDT