TA21L

IATA Locations | #masterdata | Component: Travel Planning
Column Name Description
MANDT Client
LOCID IATA location
Column Name Description
Column Name Description
Column Name Description
DLSAVING_1_BEGDA Daylight saving time period: Begin date
DLSAVING_1_ENDDA Daylight saving time period: End date
DLSAVING_2_BEGDA Daylight saving time period: Begin date
DLSAVING_2_ENDDA Daylight saving time period: End date
Column Name Description
LOC_TYPE Type of IATA location Show values
TIME_IND Time difference operator (before or after GMT) Show values
IND_CITY Indicator: Location is a city Show values
IND_CITYAPT Indicator: Location is an airport Show values
IND_MULTAPT Indicator: Location groups airports Show values
IND_IATA Indicator: Location is an IATA location Show values
LONGITUDE_O Orientation of longitude of location Show values
LATITUDE_O Latitude orientation of location Show values
IND_INACTAPT Location Is Not an Active Airport Show values
Column Name Description Domain name
ADD_NAME Additional Description for IATA Location TEXT30
REGIO_1A Region (IATA Code) CHAR2
TIME_ZONE Time zone (Amadeus-specific) CHAR3
TIME_DIFF Time difference from GMT (in 1/4 hrs) CHAR2
LONGITUDE Longitude of location NUMC07
LATITUDE Latitude of location NUMC06
DIST Distance to Town NUMC03
DISTANCE_ORIENT Orientation for distance to town CHAR2
DLSAVING_TIMEDIF Daylight Saving: Time difference in 1/4 hours to normal time CHAR2
Master Data Relations Join Conditions
Check Against Country
  • Country/Region Key
  • Client
  • TA21L.COUNTRY == T005.LAND1
  • TA21L.MANDT == T005.MANDT
Check Against Location
  • Reference to an IATA location
  • Client
  • TA21L.REF_LOCID == TA21L.LOCID
  • TA21L.MANDT == TA21L.MANDT
Check against region
  • Country/Region Key
  • Region (State, Province, County)
  • TA21L.MANDT == T005S.MANDT
  • TA21L.COUNTRY == T005S.LAND1
  • TA21L.REGION == T005S.BLAND