SAP ABAP Table FTPT_CAR_PREF (Rental car service preferences of a travel plan)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP (Package) Travel Planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FTPT_CAR_PREF	Table Relationship Diagram
Short Description	Rental car service preferences of a travel plan

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☑				0	0	Key to travel plan table
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	REINR	☑	REINR	REINR	NUMC	10	0	Trip Number
5	PLANNR	☑	PLAN_NR	FTPD_PLAN_NR	NUMC	2	0	Travel Plan Number (Sequential Number)	*
6	VARIANT	☑	VARIANT_NR	FTPD_VARIANT_NR	NUMC	2	0	Plan variant number (sequential number)
7	VARIANTVRS	☑	VARIANT_VERSION	FTPD_VARIANT_VERSION	NUMC	2	0	Version of travel plan	*
8	ITEM	☑	ITEMPOS_NR	FTPD_ITEM_ID	NUMC	3	0	Travel Request Item Number (Sequential Number)	*
9	SERVICE	☑	CAR_SERVICE_NR	FTPD_CAR_ID	NUMC	3	0	Rental car number	FTPT_CAR
10	SMOKE	☐	CAR_PREF_SMOKER	CHAR1_X	CHAR	1	0	Nonsmoking Car Requested
11	KLIMA	☐	CAR_PREF_KLIMA	CHAR1_X	CHAR	1	0	Air Conditioning Requested
12	GEAR	☐	CAR_PREF_GEAR	CHAR1	CHAR	1	0	Manual Gear Shift Requested
13	AUTOM	☐	CAR_PREF_AUTOM	CHAR1	CHAR	1	0	Automatic Transmission Requested
14	CBRAND	☐	CAR_PREF_BRAND	TEXT12	CHAR	12	0	Preferred Car Make
15	PREF1	☐	CAR_PREF_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	First Preference for Car Rental Company	*
16	PREF2	☐	CAR_PREF_PROVIDER2	FTPD_PROVIDER_CODE	CHAR	3	0	Second Preference for Car Rental Company	*
17	PREF3	☐	CAR_PREF_PROVIDER3	FTPD_PROVIDER_CODE	CHAR	3	0	Third Preference for Car Rental Company	*
18	INFO_TEXT	☐	CAR_INFO_TEXT	CHAR45	CHAR	45	0	Additional information on traveler's request

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_CAR_PREF	SERVICE	FTPT_CAR	ITEM	KEY	1	C

History

Last changed by/on	SAP	20040819
SAP Release Created in