TA20NRADD SAP table for – Additional Info for Negotiated Rates and Discounts

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

SAP TA20NRADD table

Table TA20NRADD technical data

TableTA20NRADD
Data storingAdditional Info for Negotiated Rates and Discounts
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRGXX
Table CategoryTRANSP

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

  • ADD_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
  • FLIGHT_NUMBER : Flight Number
    Its data type is CHAR (Character String) with field length 6
  • ADV_PURCHASE : Number of Days Between Purchase and Utilization
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TICKET_DATE : Last Possible Date for Ticket Issue
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BOOKING_DATE : Last Possible Booking Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RESERVATION_DATE : Last Possible Date for Reservation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WEEK_DATES : Week Days – 1:Monday. 2:Tuesday… (e.g.: 1,2)
    Its data type is CHAR (Character String) with field length 15
  • START_TIME : Start Time for Request Item
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • END_TIME : End time for request item
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ADD_TYPE : Remark Type
    Its data type is CHAR (Character String) with field length 1
  • ADD_TEXT : Remarks
    Its data type is CHAR (Character String) with field length 132