TA21L SAP table for – IATA Locations

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

SAP TA21L table

Table TA21L technical data

TableTA21L
Data storingIATA Locations
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRGXX
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LOCID : IATA location
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ADD_NAME : Additional Description for IATA Location
    Its data type is CHAR (Character String) with field length 30
  • 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
  • REGIO_1A : Region (IATA Code)
    Its data type is CHAR (Character String) with field length 2
  • REF_LOCID : Reference to an IATA location
    Its data type is CHAR (Character String) with field length 3
  • LOC_TYPE : Type of IATA location
    Its data type is CHAR (Character String) with field length 5
  • TIME_ZONE : Time zone (Amadeus-specific)
    Its data type is CHAR (Character String) with field length 3
  • TIME_DIFF : Time difference from GMT (in 1/4 hrs)
    Its data type is CHAR (Character String) with field length 2
  • TIME_IND : Time difference operator (before or after GMT)
    Its data type is CHAR (Character String) with field length 1
  • IND_CITY : Indicator: Location is a city
    Its data type is CHAR (Character String) with field length 1
  • IND_CITYAPT : Indicator: Location is an airport
    Its data type is CHAR (Character String) with field length 1
  • IND_MULTAPT : Indicator: Location groups airports
    Its data type is CHAR (Character String) with field length 1
  • IND_IATA : Indicator: Location is an IATA location
    Its data type is CHAR (Character String) with field length 1
  • LONGITUDE : Longitude of location
    Its data type is NUMC (Character String with Digits Only) with field length 7
  • LONGITUDE_O : Orientation of longitude of location
    Its data type is CHAR (Character String) with field length 1
  • LATITUDE : Latitude of location
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • LATITUDE_O : Latitude orientation of location
    Its data type is CHAR (Character String) with field length 1
  • DIST : Distance to Town
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DISTANCE_ORIENT : Orientation for distance to town
    Its data type is CHAR (Character String) with field length 2
  • .INCLU–AP : Append Structure for TA21L
  • IND_INACTAPT : Location Is Not an Active Airport
    Its data type is CHAR (Character String) with field length 1
  • DLSAVING_TIMEDIF : Daylight Saving: Time difference in 1/4 hours to normal time
    Its data type is CHAR (Character String) with field length 2
  • DLSAVING_1_BEGDA : Daylight saving time period: Begin date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DLSAVING_1_ENDDA : Daylight saving time period: End date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DLSAVING_2_BEGDA : Daylight saving time period: Begin date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DLSAVING_2_ENDDA : Daylight saving time period: End date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8