TA20NH1 SAP table for – Negotiated hotel rates (language-dependent)

Here we would like to draw your attention to TA20NH1 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). TA20NH1 is a SAP standard transp table used for storing Negotiated hotel rates (language-dependent) related data in SAP. It comes under the package PTRP.

SAP TA20NH1 table

Table TA20NH1 technical data

TableTA20NH1
Data storingNegotiated hotel rates (language-dependent)
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP TA20NH1 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 TA20NH1 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LANGU : Language Key
    Its a key field. Its data type is LANG (Language key character with length 1) with field length 1
  • PROVIDER : Provider of negotiated rate
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • LOCATIONTYPE : Geographical area type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • LOCATION : Geographical area of negotiated hotel rate
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • PROPERTY : Identification of individual hotel
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • HOTELCLASS : Hotel category
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • BEDTYPE : Bed type of negotiated rate
    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 : 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
  • SHORTTXT : Description of Rate
    Its data type is CHAR (Character String) with field length 20
  • LONGTXT : Rate Description
    Its data type is CHAR (Character String) with field length 132