1. Home
  2. Resources
  3. SAP Tables
  4. TA21L - IATA Locations

SAP Table TA21L

IATA Locations

TA21L (IATA Locations) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TA21L to other SAP tables.

TA21L table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LOCID IATA location IATA_LOCATION CHAR 3 0
ADD_NAME Additional Description for IATA Location NAME_ADDITION CHAR 30 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
REGION Region (State, Province, County) REGIO T005S CHAR 3 0
REGIO_1A Region (IATA Code) REGION_1A CHAR 2 0
REF_LOCID Reference to an IATA location REF_IATA_LOCATION TA21L CHAR 3 0
LOC_TYPE Type of IATA location IATA_LOCATION_TYPE CHAR 5 0
A Airport
B Bus station
C City
CA City and airport
CH City and heliport
CR City and train station
CB City and bus station
H Heliport
O Offline location
R Train station
TIME_ZONE Time zone (Amadeus-specific) AMADEUS_TIME_ZONE CHAR 3 0
TIME_DIFF Time difference from GMT (in 1/4 hrs) TIME_DIFF CHAR 2 0
TIME_IND Time difference operator (before or after GMT) TIME_IND CHAR 1 0
P Before GMT
N After GMT
IND_CITY Indicator: Location is a city IND_CITY CHAR 1 0
NULL Not Selected
X Selected
IND_CITYAPT Indicator: Location is an airport IND_CITYAPT CHAR 1 0
NULL Not Selected
X Selected
IND_MULTAPT Indicator: Location groups airports IND_MULTAPT CHAR 1 0
NULL Not Selected
X Selected
IND_IATA Indicator: Location is an IATA location IND_IATA CHAR 1 0
NULL Not Selected
X Selected
LONGITUDE Longitude of location LONGITUDE NUMC 7 0
LONGITUDE_O Orientation of longitude of location LONGITUDE_O CHAR 1 0
E East
W West
LATITUDE Latitude of location LATITUDE NUMC 6 0
LATITUDE_O Latitude orientation of location LATITUDE_O CHAR 1 0
N North
S South
DIST Distance to Town DIST NUMC 3 0
DISTANCE_ORIENT Orientation for distance to town DIST_ORIENT CHAR 2 0
IND_INACTAPT Location Is Not an Active Airport IND_INACTAPT CHAR 1 0
NULL Not Selected
X Selected
DLSAVING_TIMEDIF Daylight Saving: Time difference in 1/4 hours to normal time DAYLIGHTSAVING_TIMEDIFF CHAR 2 0
DLSAVING_1_BEGDA Daylight saving time period: Begin date DAYLIGHTSAVING_BEGDA DATS 8 0
DLSAVING_1_ENDDA Daylight saving time period: End date DAYLIGHTSAVING_ENDDA DATS 8 0
DLSAVING_2_BEGDA Daylight saving time period: Begin date DAYLIGHTSAVING_BEGDA DATS 8 0
DLSAVING_2_ENDDA Daylight saving time period: End date DAYLIGHTSAVING_ENDDA DATS 8 0

TA21L foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TA21L COUNTRY TA21L MANDT T005 Countries MANDT
TA21L COUNTRY TA21L COUNTRY T005 Countries LAND1
TA21L REF_LOCID TA21L MANDT TA21L IATA Locations MANDT
TA21L REF_LOCID TA21L REF_LOCID TA21L IATA Locations LOCID
TA21L REGION TA21L REGION T005S Taxes: Region (Province) Key BLAND
TA21L REGION TA21L MANDT T005S Taxes: Region (Province) Key MANDT
TA21L REGION TA21L COUNTRY T005S Taxes: Region (Province) Key LAND1