SAP ABAP View V_TA23PAF_CONNDB (TA23PAF_CONN with Airline Information)

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_TA23PAF_CONNDB
Short Description	TA23PAF_CONN with Airline Information
Root table	TA23PAF_CONN	Assignment of Airline Programs Corporate Cust. - Route/Class

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TA23PAF_CONN	TA23PAF_CONN
2	TA23PAF
3	TA23PAF1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TA23PAF	MANDT	JL	EQ				0	0
2	TA23PAF_CONN	MANDT	JR	EQ			AND	0	0
3	TA23PAF	PROGRAM_ID	JL	EQ				0	0
4	TA23PAF_CONN	PROGRAM_ID	JR	EQ			AND	0	0
5	TA23PAF	MANDT	JL	EQ				0	0
6	TA23PAF1	MANDT	JR	EQ			AND	0	0
7	TA23PAF	PROGRAM_ID	JL	EQ				0	0
8	TA23PAF1	PROGRAM_ID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TA23PAF_CONN	MANDT		☐	MANDT	☐	Client
2	PROGRAM_ID	TA23PAF_CONN	PROGRAM_ID		☐	FLIGHT_CORP_PROGRAM_ID	☐	ID of Airline Program for Corporate Customers
3	GEOORG_TYPE	TA23PAF_CONN	GEOORG_TYPE		☐	GEO_ORIGIN_TYPE	☐	Geographical Origin Type
4	GEOORG	TA23PAF_CONN	GEOORG		☐	GEO_ORIGIN	☐	Geographical Origin
5	GEODEST_TYPE	TA23PAF_CONN	GEODEST_TYPE		☐	GEO_DESTINATION_TYPE	☐	Type of Geographical Destination
6	GEODEST	TA23PAF_CONN	GEODEST		☐	GEO_DESTINATION	☐	Geographical Destination
7	CLASS	TA23PAF_CONN	CLASS		☐	FLIGHT_BOOKING_CODE	☐	Booking Code
8	ENDDA	TA23PAF_CONN	ENDDA		☐	ENDDA	☐	End Date
9	BEGDA	TA23PAF_CONN	BEGDA		☐	BEGDA	☐	Start Date
10	ROUTING_NUMBER	TA23PAF_CONN	ROUTING_NUMBER		☐	ROUTING_NUMBER	☐	Route
11	DIRECTIONALITY	TA23PAF_CONN	DIRECTIONALITY		☐	DIRECTIONALITY	☐	Direction
12	BASE_PRICE	TA23PAF_CONN	BASE_PRICE		☐	NEGO_FARE	☐	Price of negotiated rate
13	PRICE	TA23PAF_CONN	PRICE		☐	NEGO_FARE	☐	Price of negotiated rate
14	CURRENCY	TA23PAF_CONN	CURRENCY		☐	NEGO_FARE_CURRENCY	☐	Currency of negotiated rate
15	AIRLINE	TA23PAF	AIRLINE		☐	FLIGHT_AIRLINE	☐	Airline
16	CORPORATE_ID	TA23PAF	CORPORATE_ID		☐	CORPORATE_ID	☐	Corporate Identification
17	TRAVELER_ID_TYPE	TA23PAF	TRAVELER_ID_TYPE		☐	TRAVELER_ID_TYPE	☐	Airline Corporate Program: Valid Personal Identification
18	PROGRAM_NAME	TA23PAF1	PROGRAM_NAME		☐	FLIGHT_CORP_PROGRAM_NAME	☐	Name of Airline Corporate Program

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