TA23PAF_CONN SAP table for – Assignment of Airline Programs Corporate Cust. – Route/Class

Here we would like to draw your attention to TA23PAF_CONN 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). TA23PAF_CONN is a SAP standard transp table used for storing Assignment of Airline Programs Corporate Cust. – Route/Class related data in SAP. It comes under the package PTRP_ADDON.

SAP TA23PAF_CONN table

Table TA23PAF_CONN technical data

TableTA23PAF_CONN
Data storingAssignment of Airline Programs Corporate Cust. – Route/Class
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP_ADDON
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-HRGXX
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PROGRAM_ID : ID of Airline Program for Corporate Customers
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • 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
  • CLASS : Booking Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • 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
  • ROUTING_NUMBER : Route
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DIRECTIONALITY : Direction
    Its data type is CHAR (Character String) with field length 1
  • BASE_PRICE : Price of negotiated rate
    Its data type is CURR (Currency Field) with field length 10
  • 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