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 |