TA20NHS

Negotiated Hotel Rates (Nego Rates) with Catalog Hotel | #other | Component: Travel Planning
Column Name Description
MANDT Client
HOTEL_ID FK Hotel Catalog Item (enterprise-specific)
BEDTYPE Bed type of negotiated rate Show values
BEDS Negotiated rate: Number of beds
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
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
GUARANTEE_NEEDED Reservation Guarantee Required Show values
DEPOSIT Deposit Required for Reservation Show values
HOLD_IND Guarantee for Room Availability Show values
CORPORATE_ID_IND Company Identification Required Show values
MIN_STAY_IND Minimum Stay Required Show values
MEALS Hotel Meals 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
  • TA20NHS.MANDT == TCURC.MANDT
  • TA20NHS.CURRENCY == TCURC.WAERS
Check Against Car Rental Rate
  • Negotiated hotel rate
  • Client
  • TA20NHS.RATECODE == TA21H.RATECODE
  • TA20NHS.MANDT == TA21H.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Check Against Hotel Catalog
  • TA20NHS.MANDT == TA21PH.MANDT
  • TA20NHS.HOTEL_ID == TA21PH.HOTEL_ID