SAP ABAP Table V_FTPT_FL_TSTK (Generated Table for View V_FTPT_FL_TSTK)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_FTPT_FL_TSTK	Table Relationship Diagram
Short Description	Generated Table for View V_FTPT_FL_TSTK

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	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	REINR	☑	REINR	REINR	NUMC	10	0	Trip Number
4	PLANNR	☑	PLAN_NR	FTPD_PLAN_NR	NUMC	2	0	Travel Plan Number (Sequential Number)
5	VARIANTE	☑	VARIANT_NR	FTPD_VARIANT_NR	NUMC	2	0	Plan variant number (sequential number)
6	VARIANTVRS	☑	VARIANT_VERSION	FTPD_VARIANT_VERSION	NUMC	2	0	Version of travel plan	FTPT_VARIANT
7	TICKET	☑	TICKET	FTPD_TICK_ID	NUMC	3	0	Ticket
8	PLATING_CARRIER	☐	PLATING_CARRIER	FTPD_PROVIDER_CODE	CHAR	3	0	Plating Carrier	TA21P
9	LOCAL_TST	☐	LOCAL_TST	CHAR1_X	CHAR	1	0	Ticket element is local (not in booking system)
10	LAST_DATE	☐	TST_LAST_DATE	FTPD_DATE	DATS	8	0	Last Ticketing Date
11	TICKET_MODE	☐	TST_TICKET_MODE	FTPD_TST_MODE	CHAR	1	0	Ticketing Mode of Airline Ticket
12	SALES_IND	☐	TST_SALES_IND	FTPD_TST_SALES_IND	CHAR	4	0	Sales Type of Airline Ticket Rate
13	FARE	☐	TST_FARE	FTPD_PRICE	CURR	10	2	Basic rate for flight ticket without tax
14	FARE_CURR	☐	TST_FARE_CURR	WAERS	CUKY	5	0	Currency	TCURC
15	ISSUE_TYPE	☐	TST_ISSUE_TYPE	FTPD_TST_ISSUE_TYPE	CHAR	1	0	Airline Ticket Issue
16	TOTAL_FARE_PAID	☐	TST_TOTAL_FARE	FTPD_PRICE	CURR	10	2	Total price of flight ticket
17	TOTAL_FARE_CURR	☐	TST_TOTAL_FARE_CURR	WAERS	CUKY	5	0	Currency	TCURC
18	REBATE_FARE	☐	TST_REBATED_FARE	FTPD_PRICE	CURR	10	2	Discount price of flight ticket
19	REBATE_FARE_CURR	☐	TST_REBATED_FARE_CURR	WAERS	CUKY	5	0	Currency	TCURC
20	TICKETNUMBER	☐	TICKET_NUMBER	FTPD_TICKET_NUMBER	NUMC	15	0	Ticket Number
21	TICKETTYPE	☐	TICKETTYPE	FTPD_TICKET_TYPE	CHAR	1	0	Ticket Type
22	INFO	☐	TICKETINFO	FTPD_TICKET_INFO	CHAR	77	0	Ticket Information
23	TST_FARE_TYPE	☐	TST_FARE_TYPE	FTPD_TST_FARE_TYPE	CHAR	2	0	Fare Type (Normal, Negotiated, Etc.)
24	FULL_FARE	☐	FLIGHT_FULL_FARE	FTPD_PRICE	CURR	10	2	Unrestricted Rate in the same Cabin Class
25	FULL_FARE_CURR	☐	FLIGHT_FULL_FARE_CURR	WAERS	CUKY	5	0	Currency	TCURC
26	CHEAPEST_FARE	☐	CHEAPEST_ALT_FARE	FTPD_PRICE	CURR	10	2	Lowest-Cost Alternative Airfare Rate
27	CHEAPEST_FARE_C	☐	CHEAPEST_ALT_FARE_CURR	WAERS	CUKY	5	0	Currency of Lowest-Cost Alternative Airfare Rate
28	LCC	☐	LCC	XFELD	CHAR	1	0	Low-Cost Carrier
29	URL_LCC	☐	URL_LCC	TEXT255	CHAR	255	0	Low-Cost Carrier: URL for Web Page

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_FTPT_FL_TSTK	FARE_CURR	TCURC	WAERS	REF	1	CN
2	V_FTPT_FL_TSTK	FULL_FARE_CURR	TCURC	WAERS	REF	1	CN
3	V_FTPT_FL_TSTK	PLATING_CARRIER	TA21P	PROVIDER	REF	1	CN
4	V_FTPT_FL_TSTK	REBATE_FARE_CURR	TCURC	WAERS	REF	1	CN
5	V_FTPT_FL_TSTK	TOTAL_FARE_CURR	TCURC	WAERS	REF	1	CN
6	V_FTPT_FL_TSTK	VARIANTVRS	FTPT_VARIANT	VARIANT	KEY	1	CN

History

Last changed by/on	SAP	20050520
SAP Release Created in