SAP ABAP Table FTPT_FLIGHT_TSTK (Ticket Information)

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

Table Category	TRANSP	Transparent table
Transparent table	FTPT_FLIGHT_TSTK	Table Relationship Diagram
Short Description	Ticket Information

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

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

History

Last changed by/on	SAP	20050411
SAP Release Created in