SAP ABAP View BW_FI_TV_CAR (View for Table FTPT_CAR)

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_CAR
Short Description	View for Table FTPT_CAR
Root table	FTPT_CAR	Travel Request Item - Car Rental Service

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	FTPT_CAR	FTPT_CAR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	FTPT_CAR	MANDT		☐	MANDT	☐	Client
2	PERNR	FTPT_CAR	PERNR		☐	PERNR_D	☐	Personnel Number
3	REINR	FTPT_CAR	REINR		☐	REINR	☐	Trip Number
4	PLANNR	FTPT_CAR	PLANNR		☐	PLAN_NR	☐	Travel Plan Number (Sequential Number)
5	VARIANTE	FTPT_CAR	VARIANT		☐	VARIANT_NR	☐	Plan variant number (sequential number)
6	VARIANTVRS	FTPT_CAR	VARIANTVRS		☐	VARIANT_VERSION	☐	Version of travel plan
7	ITEM	FTPT_CAR	ITEM		☐	ITEMPOS_NR	☐	Travel Request Item Number (Sequential Number)
8	SERVICE	FTPT_CAR	SERVICE		☐	CAR_SERVICE_NR	☐	Rental car number
9	CAR_PROVIDER	FTPT_CAR	PROVIDER		☐	CAR_PROVIDER	☐	Car Rental Provider
10	CAR_DATE_BEG	FTPT_CAR	DATE_BEG		☐	CAR_DATE_BEG	☐	Start Date for Rental Car
11	CAR_LOC_BEG	FTPT_CAR	LOC_BEG		☐	CAR_LOC_BEG	☐	Rental Car Starting Location
12	CAR_DATE_END	FTPT_CAR	DATE_END		☐	CAR_DATE_END	☐	End date for car rental
13	CAR_LOC_END	FTPT_CAR	LOC_END		☐	CAR_LOC_END	☐	Dropoff Location
14	CAR_CLASS	FTPT_CAR	CLASS		☐	CAR_CLASS	☐	Rental Car Vehicle Class
15	CAR_TYPE	FTPT_CAR	TYPE		☐	CAR_TYPE	☐	Rental Car Vehicle Type
16	CAR_PRICE	FTPT_CAR	PRICE		☐	CAR_PRICE	☐	Car Rental Price Per Day/Week/Etc.
17	CAR_RATE_PLAN	FTPT_CAR	RATE_PLAN		☐	CAR_RATE_PLAN	☐	Rental Car Rate Rule (by day/weekend/week/month)
18	CAR_RATE_CODE	FTPT_CAR	RATE_CODE		☐	CAR_RATECODE	☐	Rental Car Rate Key (Provider-Dependent)
19	CAR_TOT_RATETYPE	FTPT_CAR	TOTAL_RATE_TYPE		☐	CAR_TOTAL_RATE_TYPE	☐	Car rental rate indicator (total amount)
20	CAR_TOTAL_RATE	FTPT_CAR	TOT_RATE_AMOUNT		☐	CAR_TOTAL_RATE_AMOUNT	☐	Total Price for Car Rental
21	CAR_TOT_CURRENCY	FTPT_CAR	TOT_CURRENCY		☐	CAR_CURRENCY	☐	Currency
22	CAR_CURRENCY	FTPT_CAR	CURRENCY		☐	CAR_CURRENCY	☐	Currency
23	CAR_STATUS	FTPT_CAR	STATUS		☐	CAR_STATUS	☐	Car Rental Status
24	CAR_AREA	FTPT_CAR	CAR_AREA		☐	CAR_AREA	☐	City of car rental office (location)
25	CAR_PICKUP_LOC	FTPT_CAR	PICKUP_LOC		☐	CAR_PICKUP_LOC	☐	Car rental branch office for vehicle pickup
26	CAR_CORPORATE_ID	FTPT_CAR	CORPORATE_ID		☐	CAR_CORPORATE_ID	☐	Company ID for Negotiated Rates

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