TA20NRH

Discount Agreement for Hotel Accommodations | #other | Component: Travel Planning
Column Name Description
MANDT Client
PROVIDER FK Provider Code
RATECODE FK Hotel rate
LOCATIONTYPE Geographical area type Show values
LOCATION Geographical area of negotiated hotel rate
PROPERTY Hotel Code (Key for an Individual Hotel)
HOTELCLASS Hotel category Show values
ROOMTYPE Room type of negotiated rate Show values
BEDTYPE Bed type of negotiated rate Show values
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
LOCATIONTYPE Geographical area type Show values
HOTELCLASS Hotel category Show values
ROOMTYPE Room type of negotiated rate Show values
BEDTYPE Bed type of negotiated rate 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 Currency
  • TA20NRH.MANDT == TCURC.MANDT
  • TA20NRH.CURRENCY == TCURC.WAERS
Check Against Hotel Rate
  • Hotel rate
  • Client
  • TA20NRH.RATECODE == TA21H.RATECODE
  • TA20NRH.MANDT == TA21H.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Provider
  • ?
  • Provider Code
  • Client
  • TA20NRH.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • TA20NRH.PROVIDER == TA21P.PROVIDER
  • TA20NRH.MANDT == TA21P.MANDT