TA23ADR SAP table for – Predefined Addresses in Travel Management

Here we would like to draw your attention to TA23ADR 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). TA23ADR is a SAP standard transp table used for storing Predefined Addresses in Travel Management related data in SAP. It comes under the package PTRM_WEB_INTERFACE.

SAP TA23ADR table

Table TA23ADR technical data

TableTA23ADR
Data storingPredefined Addresses in Travel Management
ModuleFI
Sub ModuleFI-TV
SAP PackagePTRM_WEB_INTERFACE
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-HRGXX
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ADRKEY : Key of Table TA23ADR (Sequence Number)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • .INCLUDE : Predefined Addresses / Customizing
  • CATEGORY : Custom Categories for Predefined Addresses
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Travel Web Interface: Addresses
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • REGION : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • CITY : City
    Its data type is CHAR (Character String) with field length 40
  • POST_CODE : City postal code
    Its data type is CHAR (Character String) with field length 10
  • STREET : Street
    Its data type is CHAR (Character String) with field length 60
  • HOUSE_NUM : House Number
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Travel Web Interface: Geocoding
  • LATITUDE : Geo location latitude
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LONGITUDE : Geo location longitude
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • IATA_FLIGHT : IATA Location for Airport
    Its data type is CHAR (Character String) with field length 3
  • IATA_GROUND : IATA Location for Hotel
    Its data type is CHAR (Character String) with field length 3
  • TRAIN_STATION : International Unique Train Station Number
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10