SAP ABAP Table BW_FI_TV_CAR (Generated Table for View BW_FI_TV_CAR)

Basic Data

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

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
7	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)	FTPT_ITEM
8	SERVICE	☑	CAR_SERVICE_NR	FTPD_CAR_ID	NUMC	3	0	Rental car number
9	CAR_PROVIDER	☐	CAR_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Car Rental Provider	TA21P
10	CAR_DATE_BEG	☐	CAR_DATE_BEG	FTPD_DATE	DATS	8	0	Start Date for Rental Car
11	CAR_LOC_BEG	☐	CAR_LOC_BEG	FTPD_IATA_LOCATION	CHAR	3	0	Rental Car Starting Location	TA21L
12	CAR_DATE_END	☐	CAR_DATE_END	FTPD_DATE	DATS	8	0	End date for car rental
13	CAR_LOC_END	☐	CAR_LOC_END	FTPD_IATA_LOCATION	CHAR	3	0	Dropoff Location	TA21L
14	CAR_CLASS	☐	CAR_CLASS	FTPD_CAR_CLASS	CHAR	1	0	Rental Car Vehicle Class
15	CAR_TYPE	☐	CAR_TYPE	FTPD_CAR_TYPE	CHAR	1	0	Rental Car Vehicle Type
16	CAR_PRICE	☐	CAR_PRICE	FTPD_PRICE	CURR	10	2	Car Rental Price Per Day/Week/Etc.
17	CAR_RATE_PLAN	☐	CAR_RATE_PLAN	CHAR8	CHAR	8	0	Rental Car Rate Rule (by day/weekend/week/month)
18	CAR_RATE_CODE	☐	CAR_RATECODE	CHAR12	CHAR	12	0	Rental Car Rate Key (Provider-Dependent)
19	CAR_TOT_RATETYPE	☐	CAR_TOTAL_RATE_TYPE	FTPD_CAR_RATE_CODE	CHAR	3	0	Car rental rate indicator (total amount)
20	CAR_TOTAL_RATE	☐	CAR_TOTAL_RATE_AMOUNT	FTPD_PRICE	CURR	10	2	Total Price for Car Rental
21	CAR_TOT_CURRENCY	☐	CAR_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
22	CAR_CURRENCY	☐	CAR_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
23	CAR_STATUS	☐	CAR_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Car Rental Status
24	CAR_AREA	☐	CAR_AREA	FTPD_CAR_AREA	CHAR	1	0	City of car rental office (location)
25	CAR_PICKUP_LOC	☐	CAR_PICKUP_LOC	CHAR6	CHAR	6	0	Car rental branch office for vehicle pickup
26	CAR_CORPORATE_ID	☐	CAR_CORPORATE_ID	FTPD_CORPORATION_ID	CHAR	30	0	Company ID for Negotiated Rates

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BW_FI_TV_CAR	CAR_CURRENCY	TCURC	WAERS	REF	1	CN
2	BW_FI_TV_CAR	CAR_LOC_BEG	TA21L	LOCID	REF	1	CN
3	BW_FI_TV_CAR	CAR_LOC_END	TA21L	LOCID	KEY	1	CN
4	BW_FI_TV_CAR	CAR_PROVIDER	TA21P	PROVIDER	REF	1	CN
5	BW_FI_TV_CAR	CAR_TOT_CURRENCY	TCURC	WAERS	REF	1	CN
6	BW_FI_TV_CAR	ITEM	FTPT_ITEM	VARIANTVRS	KEY	1	CN

History

Last changed by/on	SAP	20071120
SAP Release Created in