TA20NF SAP table for – Negotiated Flight Fares (Corporate Nego Fares)

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

SAP TA20NF table

Table TA20NF technical data

TableTA20NF
Data storingNegotiated Flight Fares (Corporate Nego Fares)
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRGXX
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PROVIDER : Provider of negotiated rate
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • DEPLOC : Departure location of negotiated airfare rate
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ARRLOC : Arrival Location of Negotiated Airfare Rate
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • FAREBASIS : Fare Basis
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • 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
  • FARETYPE : Type of negotiated airfare
    Its data type is CHAR (Character String) with field length 1
  • FARENATURE : Rate Type (One-Way or Round Trip)
    Its data type is CHAR (Character String) with field length 2
  • CORPID : Contract Number
    Its data type is CHAR (Character String) with field length 8
  • PTC : Flight Passenger Category
    Its data type is CHAR (Character String) with field length 1
  • PUSE : Private usage permitted
    Its data type is CHAR (Character String) with field length 1
  • CABIN : Flight Cabin Class
    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