TA20NRHS

Discount Agreement for Hotels (Individual Hotel) | #other | Component: Travel Planning
Column Name Description
MANDT Client
HOTEL_ID FK Hotel Catalog Item (enterprise-specific)
RATECODE FK Hotel rate
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
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
  • TA20NRHS.MANDT == TCURC.MANDT
  • TA20NRHS.CURRENCY == TCURC.WAERS
Check Against Hotel Rate
  • Hotel rate
  • Client
  • TA20NRHS.RATECODE == TA21H.RATECODE
  • TA20NRHS.MANDT == TA21H.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Hotel Catalog
  • TA20NRHS.MANDT == TA21PH.MANDT
  • TA20NRHS.HOTEL_ID == TA21PH.HOTEL_ID