SAP ABAP Table BW_FI_TV_FARE (Generated Table for View BW_FI_TV_FARE)

Basic Data

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

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	FARE_COMP	☑	FARE_COMP	FTPD_FARE_ID	NUMC	3	0	Rate component
8	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)
9	SERVICE	☑	FLIGHT_SERVICE_NR	FTPD_FLIGHT_ID	NUMC	3	0	Travel service item number of flight	FTPT_FLIGHT
10	FARE_BASIS_CODE	☐	FARE_BASIS_CODE	CHAR10	CHAR	10	0	Basis code of rate component
11	FARE_SURCHARGE	☐	FARE_SURCHARGE	FTPD_PRICE	CURR	10	2	Surcharge price
12	SUR_CURRENCY	☐	FARE_SURCHARGE_CURR	WAERS	CUKY	5	0	Currency
13	FARE_STOPOVER	☐	FARE_STOPOVER	FTPD_PRICE	CURR	10	2	Stopover surcharge
14	STOP_CURRENCY	☐	FARE_STOPOVER_CURR	WAERS	CUKY	5	0	Currency
15	FARE_COMPONENT	☐	FARE_COMPONENT	FTPD_PRICE	CURR	10	2	Rate price
16	COMP_CURRENCY	☐	FARE_COMPONENT_CURR	WAERS	CUKY	5	0	Currency
17	TICKET	☐	TICKET	FTPD_TICK_ID	NUMC	3	0	Ticket	FTPT_FLIGHT_TSTK

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BW_FI_TV_FARE	SERVICE	FTPT_FLIGHT	ITEM	KEY	1	C
2	BW_FI_TV_FARE	TICKET	FTPT_FLIGHT_TSTK	VARIANTVRS	REF	1	CN
3	BW_FI_TV_FARE	VARIANTVRS	FTPT_VARIANT	VARIANT	KEY	1	CN

History

Last changed by/on	SAP	20020108
SAP Release Created in