TA20REBF SAP table for – Discount Agreement for Flights

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

SAP TA20REBF table

Table TA20REBF technical data

TableTA20REBF
Data storingDiscount Agreement for Flights
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRGXX
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PROVIDER : Discount provider
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • GEOORG_TYPE : Geographical Origin Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • GEOORG : Geographical Origin
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • GEODEST_TYPE : Type of Geographical Destination
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • GEODEST : Geographical Destination
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • DIRECTIONALITY : Direction
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ON_CABIN : Flight Cabin Class
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ON_CLASS : Booking Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • ON_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
  • TXN_USE : Usage with Reservation
    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
  • ROUTING : Route
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DISC_NATURE : Rate Type (One-Way or Round Trip)
    Its data type is CHAR (Character String) with field length 2
  • DISCTYPE : Discount Type
    Its data type is CHAR (Character String) with field length 1
  • DISCPERCENT : Discount in Percent
  • DISCAMOUNT : Discount Amount
    Its data type is CURR (Currency Field) with field length 10
  • AMOUNT_FIRST : Deduct Amount First
    Its data type is CHAR (Character String) with field length 1
  • CURRENCY : Currency of Rebate Amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MANDATORY_USE : Usage of Rate is Mandatory
    Its data type is CHAR (Character String) with field length 1
  • FARE_INDEX : Rate Index Tables
    Its data type is NUMC (Character String with Digits Only) with field length 6