SAP ABAP View BW_FI_TV_FARE (View for Rate Components)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV (Application Component) Travel Management
     ⤷ FTBW (Package) Data Transfer FI-TV to BW

Basic Data

View Type	D	Database View
Database View	BW_FI_TV_FARE
Short Description	View for Rate Components
Root table	FTPT_FARE_COMP	Rate components

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	FTPT_FARE_COMP	FTPT_FARE_COMP
2	FTPT_FLIGHT_FCMP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	FTPT_FARE_COMP	MANDT	JL	EQ				0	0
2	FTPT_FLIGHT_FCMP	MANDT	JR	EQ			AND	0	0
3	FTPT_FARE_COMP	PERNR	JL	EQ				0	0
4	FTPT_FLIGHT_FCMP	PERNR	JR	EQ			AND	0	0
5	FTPT_FARE_COMP	REINR	JL	EQ				0	0
6	FTPT_FLIGHT_FCMP	REINR	JR	EQ			AND	0	0
7	FTPT_FARE_COMP	PLANNR	JL	EQ				0	0
8	FTPT_FLIGHT_FCMP	PLANNR	JR	EQ			AND	0	0
9	FTPT_FARE_COMP	VARIANT	JL	EQ				0	0
10	FTPT_FLIGHT_FCMP	VARIANTE	JR	EQ			AND	0	0
11	FTPT_FARE_COMP	VARIANTVRS	JL	EQ				0	0
12	FTPT_FLIGHT_FCMP	VARIANTVRS	JR	EQ			AND	0	0
13	FTPT_FARE_COMP	FARE_COMP	JL	EQ				0	0
14	FTPT_FLIGHT_FCMP	FARE_COMP	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	FTPT_FARE_COMP	MANDT		☐	MANDT	☐	Client
2	PERNR	FTPT_FARE_COMP	PERNR		☐	PERNR_D	☐	Personnel Number
3	REINR	FTPT_FARE_COMP	REINR		☐	REINR	☐	Trip Number
4	PLANNR	FTPT_FARE_COMP	PLANNR		☐	PLAN_NR	☐	Travel Plan Number (Sequential Number)
5	VARIANTE	FTPT_FARE_COMP	VARIANT		☐	VARIANT_NR	☐	Plan variant number (sequential number)
6	VARIANTVRS	FTPT_FARE_COMP	VARIANTVRS		☐	VARIANT_VERSION	☐	Version of travel plan
7	FARE_COMP	FTPT_FARE_COMP	FARE_COMP		☐	FARE_COMP	☐	Rate component
8	ITEM	FTPT_FLIGHT_FCMP	ITEM		☐	ITEMPOS_NR	☐	Travel Request Item Number (Sequential Number)
9	SERVICE	FTPT_FLIGHT_FCMP	SERVICE		☐	FLIGHT_SERVICE_NR	☐	Travel service item number of flight
10	FARE_BASIS_CODE	FTPT_FARE_COMP	BASIS_CODE		☐	FARE_BASIS_CODE	☐	Basis code of rate component
11	FARE_SURCHARGE	FTPT_FARE_COMP	FARE_SURCHARGE		☐	FARE_SURCHARGE	☐	Surcharge price
12	SUR_CURRENCY	FTPT_FARE_COMP	SUR_CURRENCY		☐	FARE_SURCHARGE_CURR	☐	Currency
13	FARE_STOPOVER	FTPT_FARE_COMP	FARE_STOPOVER		☐	FARE_STOPOVER	☐	Stopover surcharge
14	STOP_CURRENCY	FTPT_FARE_COMP	STOP_CURRENCY		☐	FARE_STOPOVER_CURR	☐	Currency
15	FARE_COMPONENT	FTPT_FARE_COMP	FARE_COMPONENT		☐	FARE_COMPONENT	☐	Rate price
16	COMP_CURRENCY	FTPT_FARE_COMP	COMP_CURRENCY		☐	FARE_COMPONENT_CURR	☐	Currency
17	TICKET	FTPT_FARE_COMP	TICKET		☐	TICKET	☐	Ticket

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