SAP table TA21L (IATA Locations)

SAP table TA21L has 2 primary key fields being MANDT,LOCID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
LOCID IATA location CHAR 3 0 IATA_LOCATION
ADD_NAME Additional Description for IATA Location CHAR 30 0 NAME_ADDITION
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
REGION Region (State, Province, County) CHAR 3 0 T005S REGIO
REGIO_1A Region (IATA Code) CHAR 2 0 REGION_1A
REF_LOCID Reference to an IATA location CHAR 3 0 TA21L REF_IATA_LOCATION
LOC_TYPE Type of IATA location CHAR 5 0 IATA_LOCATION_TYPE
TIME_ZONE Time zone (Amadeus-specific) CHAR 3 0 AMADEUS_TIME_ZONE
TIME_DIFF Time difference from GMT (in 1/4 hrs) CHAR 2 0 TIME_DIFF
TIME_IND Time difference operator (before or after GMT) CHAR 1 0 TIME_IND
IND_CITY Indicator: Location is a city CHAR 1 0 IND_CITY
IND_CITYAPT Indicator: Location is an airport CHAR 1 0 IND_CITYAPT
IND_MULTAPT Indicator: Location groups airports CHAR 1 0 IND_MULTAPT
IND_IATA Indicator: Location is an IATA location CHAR 1 0 IND_IATA
LONGITUDE Longitude of location NUMC 7 0 LONGITUDE
LONGITUDE_O Orientation of longitude of location CHAR 1 0 LONGITUDE_O
LATITUDE Latitude of location NUMC 6 0 LATITUDE
LATITUDE_O Latitude orientation of location CHAR 1 0 LATITUDE_O
DIST Distance to Town NUMC 3 0 DIST
DISTANCE_ORIENT Orientation for distance to town CHAR 2 0 DIST_ORIENT
IND_INACTAPT Location Is Not an Active Airport CHAR 1 0 IND_INACTAPT
DLSAVING_TIMEDIF Daylight Saving: Time difference in 1/4 hours to normal time CHAR 2 0 DAYLIGHTSAVING_TIMEDIFF
DLSAVING_1_BEGDA Daylight saving time period: Begin date DATS 8 0 DAYLIGHTSAVING_BEGDA
DLSAVING_1_ENDDA Daylight saving time period: End date DATS 8 0 DAYLIGHTSAVING_ENDDA
DLSAVING_2_BEGDA Daylight saving time period: Begin date DATS 8 0 DAYLIGHTSAVING_BEGDA
DLSAVING_2_ENDDA Daylight saving time period: End date DATS 8 0 DAYLIGHTSAVING_ENDDA

TA21L foreign key relationships

Table Field Check Table Check Field
0 TA21L COUNTRY T005 Countries MANDT
0 TA21L COUNTRY T005 Countries LAND1
1 TA21L REF_LOCID TA21L IATA Locations MANDT
1 TA21L REF_LOCID TA21L IATA Locations LOCID
0 TA21L REGION T005S Taxes: Region (Province) Key LAND1