SAP ABAP Table TA21L (IATA Locations)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP (Package) Travel Planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TA21L	Table Relationship Diagram
Short Description	IATA Locations

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	LOCID	☑	IATA_LOCATION	FTPD_IATA_LOCATION	CHAR	3	0	IATA location
3	ADD_NAME	☐	NAME_ADDITION	TEXT30	CHAR	30	0	Additional Description for IATA Location
4	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
5	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
6	REGIO_1A	☐	REGION_1A	CHAR2	CHAR	2	0	Region (IATA Code)
7	REF_LOCID	☐	REF_IATA_LOCATION	FTPD_IATA_LOCATION	CHAR	3	0	Reference to an IATA location	TA21L
8	LOC_TYPE	☐	IATA_LOCATION_TYPE	FTPD_IATA_LOCATION_TYPE	CHAR	5	0	Type of IATA location
9	TIME_ZONE	☐	AMADEUS_TIME_ZONE	CHAR3	CHAR	3	0	Time zone (Amadeus-specific)
10	TIME_DIFF	☐	TIME_DIFF	CHAR2	CHAR	2	0	Time difference from GMT (in 1/4 hrs)
11	TIME_IND	☐	TIME_IND	FTPD_TIME_IND	CHAR	1	0	Time difference operator (before or after GMT)
12	IND_CITY	☐	IND_CITY	CHAR1_X	CHAR	1	0	Indicator: Location is a city
13	IND_CITYAPT	☐	IND_CITYAPT	CHAR1_X	CHAR	1	0	Indicator: Location is an airport
14	IND_MULTAPT	☐	IND_MULTAPT	CHAR1_X	CHAR	1	0	Indicator: Location groups airports
15	IND_IATA	☐	IND_IATA	CHAR1_X	CHAR	1	0	Indicator: Location is an IATA location
16	LONGITUDE	☐	LONGITUDE	NUMC07	NUMC	7	0	Longitude of location
17	LONGITUDE_O	☐	LONGITUDE_O	FTPD_LONGITUDE_O	CHAR	1	0	Orientation of longitude of location
18	LATITUDE	☐	LATITUDE	NUMC06	NUMC	6	0	Latitude of location
19	LATITUDE_O	☐	LATITUDE_O	FTPD_LATITUDE_O	CHAR	1	0	Latitude orientation of location
20	DIST	☐	DIST	NUMC03	NUMC	3	0	Distance to Town
21	DISTANCE_ORIENT	☐	DIST_ORIENT	CHAR2	CHAR	2	0	Orientation for distance to town
22	.INCLU--AP	☐				0	0	Append Structure for TA21L
23	IND_INACTAPT	☐	IND_INACTAPT	CHAR1_X	CHAR	1	0	Location Is Not an Active Airport
24	DLSAVING_TIMEDIF	☐	DAYLIGHTSAVING_TIMEDIFF	CHAR2	CHAR	2	0	Daylight Saving: Time difference in 1/4 hours to normal time
25	DLSAVING_1_BEGDA	☐	DAYLIGHTSAVING_BEGDA	DATS	DATS	8	0	Daylight saving time period: Begin date
26	DLSAVING_1_ENDDA	☐	DAYLIGHTSAVING_ENDDA	DATS	DATS	8	0	Daylight saving time period: End date
27	DLSAVING_2_BEGDA	☐	DAYLIGHTSAVING_BEGDA	DATS	DATS	8	0	Daylight saving time period: Begin date
28	DLSAVING_2_ENDDA	☐	DAYLIGHTSAVING_ENDDA	DATS	DATS	8	0	Daylight saving time period: End date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TA21L	COUNTRY	T005	LAND1	REF	1	CN
2	TA21L	REF_LOCID	TA21L	LOCID	REF	1	CN
3	TA21L	REGION	T005S	BLAND	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in