SAP ABAP Table V_TA21L_1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TA21L_1	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

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	NAME	☐	IATA_LOCATION_NAME	TEXT30	CHAR	30	0	IATA Location Name
4	ADD_NAME	☐	NAME_ADDITION	TEXT30	CHAR	30	0	Additional Description for IATA Location
5	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
6	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
7	REGIO_1A	☐	REGION_1A	CHAR2	CHAR	2	0	Region (IATA Code)
8	REF_LOCID	☐	REF_IATA_LOCATION	FTPD_IATA_LOCATION	CHAR	3	0	Reference to an IATA location	TA21L
9	LOC_TYPE	☐	IATA_LOCATION_TYPE	FTPD_IATA_LOCATION_TYPE	CHAR	5	0	Type of IATA location
10	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
11	BEZEI	☐	BEZEI20	TEXT20	CHAR	20	0	Description
12	TIME_ZONE	☐	AMADEUS_TIME_ZONE	CHAR3	CHAR	3	0	Time zone (Amadeus-specific)
13	TIME_DIFF	☐	TIME_DIFF	CHAR2	CHAR	2	0	Time difference from GMT (in 1/4 hrs)
14	TIME_IND	☐	TIME_IND	FTPD_TIME_IND	CHAR	1	0	Time difference operator (before or after GMT)
15	IND_CITY	☐	IND_CITY	CHAR1_X	CHAR	1	0	Indicator: Location is a city
16	IND_CITYAPT	☐	IND_CITYAPT	CHAR1_X	CHAR	1	0	Indicator: Location is an airport
17	IND_MULTAPT	☐	IND_MULTAPT	CHAR1_X	CHAR	1	0	Indicator: Location groups airports
18	IND_IATA	☐	IND_IATA	CHAR1_X	CHAR	1	0	Indicator: Location is an IATA location
19	LONGITUDE	☐	LONGITUDE	NUMC07	NUMC	7	0	Longitude of location
20	LONGITUDE_O	☐	LONGITUDE_O	FTPD_LONGITUDE_O	CHAR	1	0	Orientation of longitude of location
21	LATITUDE	☐	LATITUDE	NUMC06	NUMC	6	0	Latitude of location
22	LATITUDE_O	☐	LATITUDE_O	FTPD_LATITUDE_O	CHAR	1	0	Latitude orientation of location
23	DIST	☐	DIST	NUMC03	NUMC	3	0	Distance to Town
24	DISTANCE_ORIENT	☐	DIST_ORIENT	CHAR2	CHAR	2	0	Orientation for distance to town
25	IND_INACTAPT	☐	IND_INACTAPT	CHAR1_X	CHAR	1	0	Location Is Not an Active Airport
26	DLSAVING_TIMEDIF	☐	DAYLIGHTSAVING_TIMEDIFF	CHAR2	CHAR	2	0	Daylight Saving: Time difference in 1/4 hours to normal time
27	DLSAVING_1_BEGDA	☐	DAYLIGHTSAVING_BEGDA	DATS	DATS	8	0	Daylight saving time period: Begin date
28	DLSAVING_1_ENDDA	☐	DAYLIGHTSAVING_ENDDA	DATS	DATS	8	0	Daylight saving time period: End date
29	DLSAVING_2_BEGDA	☐	DAYLIGHTSAVING_BEGDA	DATS	DATS	8	0	Daylight saving time period: Begin date
30	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	V_TA21L_1	COUNTRY	T005	LAND1	REF	1	CN
2	V_TA21L_1	REF_LOCID	TA21L	LOCID	REF	1	CN
3	V_TA21L_1	REGION	T005S	BLAND	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in