SAP ABAP View V_FTPT_FL_TSTK (View of DB Table FTPT_FLIGHT_TSTK (Airline Ticket Data))

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_FTPT_FL_TSTK
Short Description	View of DB Table FTPT_FLIGHT_TSTK (Airline Ticket Data)
Root table	FTPT_FLIGHT_TSTK	Ticket Information

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	FTPT_FLIGHT_TSTK	FTPT_FLIGHT_TSTK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	FTPT_FLIGHT_TSTK	MANDT		☐	MANDT	☐	Client
2	PERNR	FTPT_FLIGHT_TSTK	PERNR		☐	PERNR_D	☐	Personnel Number
3	REINR	FTPT_FLIGHT_TSTK	REINR		☐	REINR	☐	Trip Number
4	PLANNR	FTPT_FLIGHT_TSTK	PLANNR		☐	PLAN_NR	☐	Travel Plan Number (Sequential Number)
5	VARIANTE	FTPT_FLIGHT_TSTK	VARIANTE		☐	VARIANT_NR	☐	Plan variant number (sequential number)
6	VARIANTVRS	FTPT_FLIGHT_TSTK	VARIANTVRS		☐	VARIANT_VERSION	☐	Version of travel plan
7	TICKET	FTPT_FLIGHT_TSTK	TICKET		☐	TICKET	☐	Ticket
8	PLATING_CARRIER	FTPT_FLIGHT_TSTK	PLATING_CARRIER		☐	PLATING_CARRIER	☐	Plating Carrier
9	LOCAL_TST	FTPT_FLIGHT_TSTK	LOCAL_TST		☐	LOCAL_TST	☐	Ticket element is local (not in booking system)
10	LAST_DATE	FTPT_FLIGHT_TSTK	LAST_DATE		☐	TST_LAST_DATE	☐	Last Ticketing Date
11	TICKET_MODE	FTPT_FLIGHT_TSTK	TICKET_MODE		☐	TST_TICKET_MODE	☐	Ticketing Mode of Airline Ticket
12	SALES_IND	FTPT_FLIGHT_TSTK	SALES_IND		☐	TST_SALES_IND	☐	Sales Type of Airline Ticket Rate
13	FARE	FTPT_FLIGHT_TSTK	FARE		☐	TST_FARE	☐	Basic rate for flight ticket without tax
14	FARE_CURR	FTPT_FLIGHT_TSTK	FARE_CURR		☐	TST_FARE_CURR	☐	Currency
15	ISSUE_TYPE	FTPT_FLIGHT_TSTK	ISSUE_TYPE		☐	TST_ISSUE_TYPE	☐	Airline Ticket Issue
16	TOTAL_FARE_PAID	FTPT_FLIGHT_TSTK	TOTAL_FARE_PAID		☐	TST_TOTAL_FARE	☐	Total price of flight ticket
17	TOTAL_FARE_CURR	FTPT_FLIGHT_TSTK	TOTAL_FARE_CURR		☐	TST_TOTAL_FARE_CURR	☐	Currency
18	REBATE_FARE	FTPT_FLIGHT_TSTK	REBATE_FARE		☐	TST_REBATED_FARE	☐	Discount price of flight ticket
19	REBATE_FARE_CURR	FTPT_FLIGHT_TSTK	REBATE_FARE_CURR		☐	TST_REBATED_FARE_CURR	☐	Currency
20	TICKETNUMBER	FTPT_FLIGHT_TSTK	TICKETNUMBER		☐	TICKET_NUMBER	☐	Ticket Number
21	TICKETTYPE	FTPT_FLIGHT_TSTK	TICKETTYPE		☐	TICKETTYPE	☐	Ticket Type
22	INFO	FTPT_FLIGHT_TSTK	INFO		☐	TICKETINFO	☐	Ticket Information
23	TST_FARE_TYPE	FTPT_FLIGHT_TSTK	TST_FARE_TYPE		☐	TST_FARE_TYPE	☐	Fare Type (Normal, Negotiated, Etc.)
24	FULL_FARE	FTPT_FLIGHT_TSTK	FULL_FARE		☐	FLIGHT_FULL_FARE	☐	Unrestricted Rate in the same Cabin Class
25	FULL_FARE_CURR	FTPT_FLIGHT_TSTK	FULL_FARE_CURR		☐	FLIGHT_FULL_FARE_CURR	☐	Currency
26	CHEAPEST_FARE	FTPT_FLIGHT_TSTK	CHEAPEST_FARE		☐	CHEAPEST_ALT_FARE	☐	Lowest-Cost Alternative Airfare Rate
27	CHEAPEST_FARE_C	FTPT_FLIGHT_TSTK	CHEAPEST_FARE_C		☐	CHEAPEST_ALT_FARE_CURR	☐	Currency of Lowest-Cost Alternative Airfare Rate
28	LCC	FTPT_FLIGHT_TSTK	LCC		☐	LCC	☐	Low-Cost Carrier
29	URL_LCC	FTPT_FLIGHT_TSTK	URL_LCC		☐	URL_LCC	☐	Low-Cost Carrier: URL for Web Page

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