TA20NHS SAP table for – Negotiated Hotel Rates (Nego Rates) with Catalog Hotel

Here we would like to draw your attention to TA20NHS table in SAP. As we know it is being mainly used with the SAP FI-TV (Travel Management in FI) component which is coming under FI module (Financial Accounting). TA20NHS is a SAP standard transp table used for storing Negotiated Hotel Rates (Nego Rates) with Catalog Hotel related data in SAP. It comes under the package PTRP.

SAP TA20NHS table

Table TA20NHS technical data

TableTA20NHS
Data storingNegotiated Hotel Rates (Nego Rates) with Catalog Hotel
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP TA20NHS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in TA20NHS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • HOTEL_ID : Hotel Catalog Item (enterprise-specific)
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • BEDTYPE : Bed type of negotiated rate
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • BEDS : Negotiated rate: Number of beds
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ROOMTYPE : Room type of negotiated rate
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RATECODE : Negotiated hotel rate
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CORPDISC : Contract number for identification
    Its data type is CHAR (Character String) with field length 20
  • PUSE : Private usage permitted
    Its data type is CHAR (Character String) with field length 1
  • PRICE : Price of negotiated rate
    Its data type is CURR (Currency Field) with field length 10
  • CURRENCY : Currency of negotiated rate
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TOTAL_RATE_IND : Total price
    Its data type is CHAR (Character String) with field length 1
  • GUARANTEE_NEEDED : Reservation Guarantee Required
    Its data type is CHAR (Character String) with field length 1
  • GUARANTEE : Guarantee for room reservation at booking
    Its data type is CHAR (Character String) with field length 40
  • DEPOSIT : Deposit Required for Reservation
    Its data type is CHAR (Character String) with field length 1
  • HOLD_IND : Guarantee for Room Availability
    Its data type is CHAR (Character String) with field length 1
  • CORPORATE_ID_IND : Company Identification Required
    Its data type is CHAR (Character String) with field length 1
  • MIN_STAY_IND : Minimum Stay Required
    Its data type is CHAR (Character String) with field length 1
  • MEALS : Hotel Meals
    Its data type is CHAR (Character String) with field length 1