SAP ABAP View V_DB_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

View Type	D	Database View
Database View	V_DB_TA21L
Short Description	IATA Locations
Root table	TA21L	IATA Locations

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TA21L	TA21L
2	TA21L1
3	T005
4	T005T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TA21L	MANDT	JL	EQ				0	0
2	TA21L1	MANDT	JR	EQ			AND	0	0
3	TA21L	LOCID	JL	EQ				0	0
4	TA21L1	LOCID	JR	EQ			AND	0	0
5	T005	MANDT	JL	EQ				0	0
6	TA21L	MANDT	JR	EQ			AND	0	0
7	T005	LAND1	JL	EQ				0	0
8	TA21L	COUNTRY	JR	EQ			AND	0	0
9	T005	MANDT	JL	EQ				0	0
10	T005T	MANDT	JR	EQ			AND	0	0
11	T005	LAND1	JL	EQ				0	0
12	T005T	LAND1	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TA21L	MANDT		☐	MANDT	☐	Client
2	LOCID	TA21L	LOCID		☐	IATA_LOCATION	☐	IATA location
3	SPRAS_LOC	TA21L1	SPRAS		☐	SPRAS	☐	Language Key
4	SPRAS_LAND	T005T	SPRAS		☐	SPRAS	☐	Language Key
5	ADD_NAME	TA21L	ADD_NAME		☐	NAME_ADDITION	☐	Additional Description for IATA Location
6	COUNTRY	TA21L	COUNTRY		☐	LAND1	☐	Country Key
7	REGION	TA21L	REGION		☐	REGIO	☐	Region (State, Province, County)
8	REGIO_1A	TA21L	REGIO_1A		☐	REGION_1A	☐	Region (IATA Code)
9	REF_LOCID	TA21L	REF_LOCID		☐	REF_IATA_LOCATION	☐	Reference to an IATA location
10	LOC_TYPE	TA21L	LOC_TYPE		☐	IATA_LOCATION_TYPE	☐	Type of IATA location
11	TIME_ZONE	TA21L	TIME_ZONE		☐	AMADEUS_TIME_ZONE	☐	Time zone (Amadeus-specific)
12	TIME_DIFF	TA21L	TIME_DIFF		☐	TIME_DIFF	☐	Time difference from GMT (in 1/4 hrs)
13	TIME_IND	TA21L	TIME_IND		☐	TIME_IND	☐	Time difference operator (before or after GMT)
14	IND_CITY	TA21L	IND_CITY		☐	IND_CITY	☐	Indicator: Location is a city
15	IND_CITYAPT	TA21L	IND_CITYAPT		☐	IND_CITYAPT	☐	Indicator: Location is an airport
16	IND_MULTAPT	TA21L	IND_MULTAPT		☐	IND_MULTAPT	☐	Indicator: Location groups airports
17	IND_IATA	TA21L	IND_IATA		☐	IND_IATA	☐	Indicator: Location is an IATA location
18	LONGITUDE	TA21L	LONGITUDE		☐	LONGITUDE	☐	Longitude of location
19	LONGITUDE_O	TA21L	LONGITUDE_O		☐	LONGITUDE_O	☐	Orientation of longitude of location
20	LATITUDE	TA21L	LATITUDE		☐	LATITUDE	☐	Latitude of location
21	LATITUDE_O	TA21L	LATITUDE_O		☐	LATITUDE_O	☐	Latitude orientation of location
22	DIST	TA21L	DIST		☐	DIST	☐	Distance to Town
23	DISTANCE_ORIENT	TA21L	DISTANCE_ORIENT		☐	DIST_ORIENT	☐	Orientation for distance to town
24	NAME	TA21L1	NAME		☐	IATA_LOCATION_NAME	☐	IATA Location Name
25	LANDX	T005T	LANDX		☐	LANDX	☐	Country Name
26	NATIO	T005T	NATIO		☐	NATIO	☐	Nationality

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20140121
SAP Release Created in