TA20NH

Negotiated hotel 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 hotel rate
PROPERTY Identification of individual hotel
HOTELCLASS Negotiated rate: Number of beds
BEDTYPE Bed type of negotiated rate Show values
ROOMTYPE Room type of negotiated rate Show values
RATECODE FK Negotiated hotel 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
BEDTYPE Bed type of negotiated rate Show values
ROOMTYPE Room type of negotiated rate Show values
PUSE Private usage permitted Show values
TOTAL_RATE_IND Total price Show values
Column Name Description Domain name
CORPDISC Contract number for identification CHAR20
GUARANTEE Guarantee for room reservation at booking CHAR40
Master Data Relations Join Conditions
Check Against Currency
  • TA20NH.MANDT == TCURC.MANDT
  • TA20NH.CURRENCY == TCURC.WAERS
Check Against Car Rental Rate
  • Negotiated hotel rate
  • Client
  • TA20NH.RATECODE == TA21H.RATECODE
  • TA20NH.MANDT == TA21H.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Travel Service Provider
  • ?
  • Provider of negotiated rate
  • Client
  • TA20NH.[column in domain "PROVIDER_CATEGORY"] == TA21P.CATEGORY
  • TA20NH.PROVIDER == TA21P.PROVIDER
  • TA20NH.MANDT == TA21P.MANDT