SAP ABAP View V_TA21L_DB (Database View TA21L)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP_ADDON (Package) Travel Planning Add-On

Basic Data

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

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TA21L	TA21L
2	TA21L1

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				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	TA21L1	SPRAS		☐	SPRAS	☐	Language Key
4	ADD_NAME	TA21L	ADD_NAME		☐	NAME_ADDITION	☐	Additional Description for IATA Location
5	COUNTRY	TA21L	COUNTRY		☐	LAND1	☐	Country Key
6	REGION	TA21L	REGION		☐	REGIO	☐	Region (State, Province, County)
7	REGIO_1A	TA21L	REGIO_1A		☐	REGION_1A	☐	Region (IATA Code)
8	REF_LOCID	TA21L	REF_LOCID		☐	REF_IATA_LOCATION	☐	Reference to an IATA location
9	LOC_TYPE	TA21L	LOC_TYPE		☐	IATA_LOCATION_TYPE	☐	Type of IATA location
10	IND_CITY	TA21L	IND_CITY		☐	IND_CITY	☐	Indicator: Location is a city
11	IND_CITYAPT	TA21L	IND_CITYAPT		☐	IND_CITYAPT	☐	Indicator: Location is an airport
12	IND_MULTAPT	TA21L	IND_MULTAPT		☐	IND_MULTAPT	☐	Indicator: Location groups airports
13	IND_IATA	TA21L	IND_IATA		☐	IND_IATA	☐	Indicator: Location is an IATA location
14	LONGITUDE	TA21L	LONGITUDE		☐	LONGITUDE	☐	Longitude of location
15	LONGITUDE_O	TA21L	LONGITUDE_O		☐	LONGITUDE_O	☐	Orientation of longitude of location
16	LATITUDE	TA21L	LATITUDE		☐	LATITUDE	☐	Latitude of location
17	LATITUDE_O	TA21L	LATITUDE_O		☐	LATITUDE_O	☐	Latitude orientation of location
18	IND_INACTAPT	TA21L	IND_INACTAPT		☐	IND_INACTAPT	☐	Location Is Not an Active Airport
19	NAME	TA21L1	NAME		☐	IATA_LOCATION_NAME	☐	IATA Location Name

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	20130529
SAP Release Created in	600