SAP ABAP Table FTPT_CAR (Travel Request Item - Car Rental Service)

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	Table Relationship Diagram
Short Description	Travel Request Item - Car Rental Service

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)	FTPT_ITEM
9	SERVICE	☑	CAR_SERVICE_NR	FTPD_CAR_ID	NUMC	3	0	Rental car number
10	PROVIDER	☐	CAR_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Car Rental Provider	TA21P
11	DATE_BEG	☐	CAR_DATE_BEG	FTPD_DATE	DATS	8	0	Start Date for Rental Car
12	TIME_BEG	☐	CAR_TIME_BEG	FTPD_TIME	TIMS	6	0	Rental Car Starting Time
13	LOC_BEG	☐	CAR_LOC_BEG	FTPD_IATA_LOCATION	CHAR	3	0	Rental Car Starting Location	TA21L
14	DATE_END	☐	CAR_DATE_END	FTPD_DATE	DATS	8	0	End date for car rental
15	TIME_END	☐	CAR_TIME_END	FTPD_TIME	TIMS	6	0	End time for car rental
16	LOC_END	☐	CAR_LOC_END	FTPD_IATA_LOCATION	CHAR	3	0	Dropoff Location	TA21L
17	PICKUP_LOC	☐	CAR_PICKUP_LOC	CHAR6	CHAR	6	0	Car rental branch office for vehicle pickup
18	ADDRESS	☐	CAR_ADDRESS	TEXT40	CHAR	40	0	Address of car rental branch office for pickup
19	DROPOFF_LOC	☐	CAR_DROPOFF_LOC	CHAR6	CHAR	6	0	Car rental office for dropoff
20	ADDRESS_DROPOFF	☐	CAR_ADDRESS_DROPOFF	TEXT40	CHAR	40	0	Address of car rental office for dropoff
21	CLASS	☐	CAR_CLASS	FTPD_CAR_CLASS	CHAR	1	0	Rental Car Vehicle Class
22	TYPE	☐	CAR_TYPE	FTPD_CAR_TYPE	CHAR	1	0	Rental Car Vehicle Type
23	TRANSMISSION	☐	CAR_TRANSMISSION	FTPD_CAR_TRANSMISSION	CHAR	1	0	Car Transmission
24	AIR_CONDITION	☐	CAR_AIR_CONDITION	FTPD_CAR_AIR_CONDITION	CHAR	1	0	Vehicle Air-Conditioning
25	QUANTITY	☐	CAR_QUANTITY	FTPD_INT1	INT1	3	0	Number of cars
26	SEGMENT_INDEX	☐	CAR_SEGMENT_INDEX	FTPD_INT1	INT1	3	0	Current line number of PNR
27	CONF_NUM	☐	CAR_CONFIRMATION_NUMBER	FTPD_CAR_CONF_NUMBER	CHAR	17	0	Car Rental Reservation Number
28	PRICE	☐	CAR_PRICE	FTPD_PRICE	CURR	10	2	Car Rental Price Per Day/Week/Etc.
29	RATE_PLAN	☐	CAR_RATE_PLAN	CHAR8	CHAR	8	0	Rental Car Rate Rule (by day/weekend/week/month)
30	RATE_CODE	☐	CAR_RATECODE	CHAR12	CHAR	12	0	Rental Car Rate Key (Provider-Dependent)
31	CORPORATE_ID	☐	CAR_CORPORATE_ID	FTPD_CORPORATION_ID	CHAR	30	0	Company ID for Negotiated Rates
32	GUARANTEE_NEEDED	☐	CAR_GUARANTEE_NEEDED	CHAR1_X	CHAR	1	0	Reservation guarantee required
33	GUARANTEE	☐	CAR_GUARANTEE	CHAR40	CHAR	40	0	Guarantee for rental care reservation at booking
34	DEPOSIT_NEEDED	☐	CAR_DEPOSIT_NEEDED	CHAR1_X	CHAR	1	0	Rental car: Down payment required
35	DEPOSIT	☐	CAR_DEPOSIT	CHAR40	CHAR	40	0	Deposit payment method for room reservation
36	FREE_MILES	☐	CAR_FREE_MILES	CHAR5	CHAR	5	0	Distance Restriction (miles/kilometers)
37	EXTRA_CHARGE	☐	CAR_EXTRA_CHARGE	FTPD_PRICE	CURR	10	2	Surcharge for Car Rental Excess Usage
38	DROPOFF_CHARGE	☐	CAR_DROPOFF_CHARGE	FTPD_PRICE	CURR	10	2	Charges for Rental Car Dropoff
39	EXTRA_CHARGE_TYP	☐	CAR_EXTRA_CHARGE_TYPE	FTPD_CAR_RATE_CODE	CHAR	3	0	Surcharge time unit for car rental usage exceeding
40	TOTAL_RATE_TYPE	☐	CAR_TOTAL_RATE_TYPE	FTPD_CAR_RATE_CODE	CHAR	3	0	Car rental rate indicator (total amount)
41	TOT_RATE_AMOUNT	☐	CAR_TOTAL_RATE_AMOUNT	FTPD_PRICE	CURR	10	2	Total Price for Car Rental
42	TOT_CURRENCY	☐	CAR_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
43	EXTRA_MILAGE	☐	CAR_EXTRA_MILAGE	FTPD_PRICE	CURR	10	2	Surcharge for Exceeding Miles/Kms Limit for Rental Car
44	CURRENCY	☐	CAR_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
45	STATUS	☐	CAR_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Car Rental Status
46	TEMPLATE	☐	VARIANT_TEMPLATE	FTPD_TEMPLATE	CHAR	1	0	Template indicator
47	CAR_AREA	☐	CAR_AREA	FTPD_CAR_AREA	CHAR	1	0	City of car rental office (location)
48	MEMBSHIP_PROVCAT	☐	MEMBSHIP_PROVIDER_CATEGORY	FTPD_PROVIDER_CATEGORY	CHAR	1	0	Customer Program: Provider Category
49	MEMBSHIP_PROV	☐	MEMBSHIP_PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Customer Program: Provider Code	*
50	MEMBSHIP_KRZL	☐	PROV_PROGRAM_SHORTHAND	FTPD_PROV_PROGRAM_SHORTHAND	CHAR	3	0	Customer Program Code	TA21PF
51	MEMBSHIP_ID	☐	PROV_PROGRAM_NR	CHAR20	CHAR	20	0	Customer number
52	FLIGHT_MEM_PROV	☐	FLIGHT_PROGRAM_PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Frequent flyer program: Provider code	*
53	FLIGHT_MEM_KRZL	☐	FLIGHT_PROGRAM_SHORTHAND	FTPD_PROV_PROGRAM_SHORTHAND	CHAR	3	0	Frequent Flyer Program ID	TA21PF
54	FLIGHT_MEM_ID	☐	FLIGHT_PROGRAM_NR	CHAR20	CHAR	20	0	Frequent flyer number
55	PNR_NR	☐	CAR_LINENUMBER	FTPD_LINENUMBER	INT2	5	0	Zeilennummer der CAR in der Itinerary
56	PROFILE	☐	PROF_ID	FTPD_PROF_ID	CHAR	8	0	Travel Profile	*
57	PROFITEM	☐	PROF_ITEM	FTPD_PROF_ITEM	CHAR	8	0	Trip rule	*
58	KZTKT	☐	PLAN_ACTIVITY	FTPD_PLAN_ACTIVITY	CHAR	1	0	Trip Activity Type	*
59	SPECCID	☐	SSPECID	FTPD_SSPEC_ID	CHAR	8	0	Class rule	*
60	PRIORITY	☐	PROFIL_PRIROITY	FTPD_PROF_PRIORITY	CHAR	1	0	Priority of trip rule
61	HIGHEST_PRIORITY	☐	PROFIL_PRIROITY	FTPD_PROF_PRIORITY	CHAR	1	0	Priority of trip rule
62	CANCEL_TIME	☐	CAR_CANCEL_TIME	FTPD_CANCEL_TIME	CHAR	5	0	Car rental reser.: Latest possible cancellation time
63	CANCEL_TYPE	☐	CAR_CANCEL_TYPE	FTPD_HOTEL_CANCEL_TYPE	CHAR	1	0	Car rental res.: Time unit - latest poss. cancellation time
64	.INCLUDE	☐				0	0	HR Master Record Infotype 0473 (Rental Car Preferences)
65	SMOKE	☐	CAR_PREF_SMOKER	CHAR1_X	CHAR	1	0	Nonsmoking Car Requested
66	KLIMA	☐	CAR_PREF_KLIMA	CHAR1_X	CHAR	1	0	Air Conditioning Requested
67	GEAR	☐	CAR_PREF_GEAR	CHAR1	CHAR	1	0	Manual Gear Shift Requested
68	AUTOM	☐	CAR_PREF_AUTOM	CHAR1	CHAR	1	0	Automatic Transmission Requested
69	CBRAND	☐	CAR_PREF_BRAND	TEXT12	CHAR	12	0	Preferred Car Make
70	PREF1	☐	CAR_PREF_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	First Preference for Car Rental Company	TA21P
71	PREF2	☐	CAR_PREF_PROVIDER2	FTPD_PROVIDER_CODE	CHAR	3	0	Second Preference for Car Rental Company	TA21P
72	PREF3	☐	CAR_PREF_PROVIDER3	FTPD_PROVIDER_CODE	CHAR	3	0	Third Preference for Car Rental Company	TA21P
73	.INCLUDE	☐				0	0
74	.INCLUDE	☐				0	0	Reason Code
75	REASON_CODE	☐	REASON_CODE	FTPD_REASON_CODE	CHAR	2	0	Reason Code	*
76	REASON_TEXT	☐	REASON_TEXT	TEXT132	CHAR	132	0	Reason Text
77	.INCLUDE	☐				0	0	Encryption of Credit Card Data for Rental Cars
78	GUARANTEE_GUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
79	DEPOSIT_GUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
80	.INCLU--AP	☐				0	0	Append Structure for FTPT_CAR
81	NON_GDS_PUP_LOC	☐	CAR_PICKUP_LOC_NONGDS	CHAR11	CHAR	11	0	Car Rental Branch Office for Pickup (Provider-Specific)
82	NON_GDS_DO_LOC	☐	CAR_DROPOFF_LOC_NONGDS	CHAR11	CHAR	11	0	Car Rental Branch Office for Dropoff (Provider-Specific)
83	ADDITIONAL_INFO	☐	CAR_ADDITIONAL_INFO	CHAR128	CHAR	128	0	Additional Information on Vehicle from Provider
84	EST_PRICE	☐	CAR_TOTAL_RATE_AMOUNT	FTPD_PRICE	CURR	10	2	Total Price for Car Rental
85	EST_CURRENCY	☐	CAR_CURRENCY	WAERS	CUKY	5	0	Currency	*
86	CHECK_POLICY	☐	CAR_CHECK_POLICY	CHAR1_X	CHAR	1	0	Indicates Whether Policy Check Necessary
87	ADVANCE_PAYMENT	☐	CAR_ADVANCE_PAYMENT	CHAR1_X	CHAR	1	0	Payment in Advance Required
88	DELIVERY_ADDR	☐	CAR_DELIVERY_ADDRESS	CHAR60	CHAR	60	0	Address to Which Car Is Delivered
89	COLLECTION_ADDR	☐	CAR_COLLECTION_ADDRESS	CHAR60	CHAR	60	0	Address at Which Car Is Collected
90	FARE_TYPE	☐	CAR_FARE_TYPE	CHAR6	CHAR	6	0	Rental Car: Rate Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_CAR	CURRENCY	TCURC	WAERS	REF	1	CN
2	FTPT_CAR	FLIGHT_MEM_KRZL	TA21PF	KRZL	REF	C	CN
3	FTPT_CAR	ITEM	FTPT_ITEM	VARIANTVRS	KEY	1	CN
4	FTPT_CAR	LOC_BEG	TA21L	LOCID	REF	1	CN
5	FTPT_CAR	LOC_END	TA21L	LOCID	KEY	1	CN
6	FTPT_CAR	MEMBSHIP_KRZL	TA21PF	KRZL	REF	C	CN
7	FTPT_CAR	PREF1	TA21P	PROVIDER	REF	C	CN
8	FTPT_CAR	PREF2	TA21P	PROVIDER	REF	C	CN
9	FTPT_CAR	PREF3	TA21P	PROVIDER	REF	C	CN
10	FTPT_CAR	PROVIDER	TA21P	PROVIDER	REF	1	CN
11	FTPT_CAR	TOT_CURRENCY	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20071120
SAP Release Created in