TA20NREX SAP table for – Exceptions to Negotiated Rates

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

SAP TA20NREX table

Table TA20NREX technical data

TableTA20NREX
Data storingExceptions to Negotiated Rates
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRGXX
Table CategoryTRANSP

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

  • EXCEPTION_INDEX : Exception Index Table
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • FARE_INDEX : Rate Index Tables
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • DISCOUNT_TYPE : Discount Type – Negotiated Rate or Discount
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • EXORG_TYPE : Geographical Origin Type
    Its data type is CHAR (Character String) with field length 1
  • EXORIGIN : Geographical Origin
    Its data type is CHAR (Character String) with field length 3
  • EXDST_TYPE : Type of Geographical Destination
    Its data type is CHAR (Character String) with field length 1
  • EXDESTIN : Geographical Destination
    Its data type is CHAR (Character String) with field length 3
  • BLACKOUT_TYPE : Service Type That Is Excluded from Discount
    Its data type is CHAR (Character String) with field length 2
  • BLACKOUT_DATE : Forbidden Weekdays – 1:Monday. 2:Tuesday… (e.g.: 1,2)
    Its data type is CHAR (Character String) with field length 15
  • BOUT_TIME_BEG : Beginning Time – Discount Application Forbidden
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • BOUT_TIME_END : End Time – Discount Application Forbidden
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • FLIGHT_NUMBER : Flight Number
    Its data type is CHAR (Character String) with field length 6