SAP ABAP Table BW_FI_TV_TICKET (Generated Table for View BW_FI_TV_TICKET)

Basic Data

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

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	☐	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	TST_FARE_TYPE	☐	TST_FARE_TYPE	FTPD_TST_FARE_TYPE	CHAR	2	0	Fare Type (Normal, Negotiated, Etc.)

Foreign Keys

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

History

Last changed by/on	SAP	20040210
SAP Release Created in