SAP ABAP Table V_DB_TA21L (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_DB_TA21L	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	SPRAS_LOC	☑	SPRAS	SPRAS	LANG	1	0	Language Key
4	SPRAS_LAND	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
5	ADD_NAME	☐	NAME_ADDITION	TEXT30	CHAR	30	0	Additional Description for IATA Location
6	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
7	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
8	REGIO_1A	☐	REGION_1A	CHAR2	CHAR	2	0	Region (IATA Code)
9	REF_LOCID	☐	REF_IATA_LOCATION	FTPD_IATA_LOCATION	CHAR	3	0	Reference to an IATA location	TA21L
10	LOC_TYPE	☐	IATA_LOCATION_TYPE	FTPD_IATA_LOCATION_TYPE	CHAR	5	0	Type of IATA location
11	TIME_ZONE	☐	AMADEUS_TIME_ZONE	CHAR3	CHAR	3	0	Time zone (Amadeus-specific)
12	TIME_DIFF	☐	TIME_DIFF	CHAR2	CHAR	2	0	Time difference from GMT (in 1/4 hrs)
13	TIME_IND	☐	TIME_IND	FTPD_TIME_IND	CHAR	1	0	Time difference operator (before or after GMT)
14	IND_CITY	☐	IND_CITY	CHAR1_X	CHAR	1	0	Indicator: Location is a city
15	IND_CITYAPT	☐	IND_CITYAPT	CHAR1_X	CHAR	1	0	Indicator: Location is an airport
16	IND_MULTAPT	☐	IND_MULTAPT	CHAR1_X	CHAR	1	0	Indicator: Location groups airports
17	IND_IATA	☐	IND_IATA	CHAR1_X	CHAR	1	0	Indicator: Location is an IATA location
18	LONGITUDE	☐	LONGITUDE	NUMC07	NUMC	7	0	Longitude of location
19	LONGITUDE_O	☐	LONGITUDE_O	FTPD_LONGITUDE_O	CHAR	1	0	Orientation of longitude of location
20	LATITUDE	☐	LATITUDE	NUMC06	NUMC	6	0	Latitude of location
21	LATITUDE_O	☐	LATITUDE_O	FTPD_LATITUDE_O	CHAR	1	0	Latitude orientation of location
22	DIST	☐	DIST	NUMC03	NUMC	3	0	Distance to Town
23	DISTANCE_ORIENT	☐	DIST_ORIENT	CHAR2	CHAR	2	0	Orientation for distance to town
24	NAME	☐	IATA_LOCATION_NAME	TEXT30	CHAR	30	0	IATA Location Name
25	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
26	NATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_DB_TA21L	COUNTRY	T005	LAND1	REF	1	CN
2	V_DB_TA21L	REF_LOCID	TA21L	LOCID	REF	1	CN
3	V_DB_TA21L	REGION	T005S	BLAND	REF	1	CN
4	V_DB_TA21L	SPRAS_LAND	T002	SPRAS	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in