SAP ABAP Table FTPS_PNR_CAR_RES (PNR Car Rental)

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	INTTAB	Structure
Structure	FTPS_PNR_CAR_RES	Table Relationship Diagram
Short Description	PNR Car Rental

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	PROVIDER	☐	CAR_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Car Rental Provider	*
2	LOC_BEG	☐	CAR_LOC_BEG	FTPD_IATA_LOCATION	CHAR	3	0	Rental Car Starting Location	*
3	DATE_BEG	☐	CAR_DATE_BEG	FTPD_DATE	DATS	8	0	Start Date for Rental Car
4	TIME_BEG	☐	CAR_TIME_BEG	FTPD_TIME	TIMS	6	0	Rental Car Starting Time
5	LOC_END	☐	CAR_LOC_END	FTPD_IATA_LOCATION	CHAR	3	0	Dropoff Location	*
6	DATE_END	☐	CAR_DATE_END	FTPD_DATE	DATS	8	0	End date for car rental
7	TIME_END	☐	CAR_TIME_END	FTPD_TIME	TIMS	6	0	End time for car rental
8	PICKUP_LOC	☐	CAR_PICKUP_LOC	CHAR6	CHAR	6	0	Car rental branch office for vehicle pickup
9	DROPOFF_LOC	☐	CAR_DROPOFF_LOC	CHAR6	CHAR	6	0	Car rental office for dropoff
10	ARRIVAL_INFO	☐			CHAR	36	0
11	RETURN_TIME_INFO	☐			CHAR	6	0
12	STATUS_CODE	☐	CAR_STATUS	FTPD_SERVICE_STATUS	CHAR	2	0	Car Rental Status
13	QUANTITY	☐	CAR_QUANTITY	FTPD_INT1	INT1	3	0	Number of cars
14	CLASS	☐	CAR_CLASS	FTPD_CAR_CLASS	CHAR	1	0	Rental Car Vehicle Class
15	TYPE	☐	CAR_TYPE	FTPD_CAR_TYPE	CHAR	1	0	Rental Car Vehicle Type
16	TRANSMISSION	☐	CAR_TRANSMISSION	FTPD_CAR_TRANSMISSION	CHAR	1	0	Car Transmission
17	AIR_CONDITION	☐	CAR_AIR_CONDITION	FTPD_CAR_AIR_CONDITION	CHAR	1	0	Vehicle Air-Conditioning
18	NAME_GIVEN	☐			CHAR	25	0
19	RATE_CODE	☐	CAR_RATECODE	CHAR12	CHAR	12	0	Rental Car Rate Key (Provider-Dependent)
20	CONF_NUM	☐	CAR_CONFIRMATION_NUMBER	FTPD_CAR_CONF_NUMBER	CHAR	17	0	Car Rental Reservation Number
21	BOOKING_SOURCE	☐	BOOKING_SOURCE	CHAR40	CHAR	40	0	Identification for booking/reservations
22	CORPORATE_ID	☐	CAR_CORPORATE_ID	FTPD_CORPORATION_ID	CHAR	30	0	Company ID for Negotiated Rates
23	MEMBERSHIP_ID	☐	PROV_PROGRAM_NR	CHAR20	CHAR	20	0	Customer number
24	SPECIAL_INFO	☐			CHAR	132	0
25	.INCLUDE	☐				0	0	Rental Car Rate
26	RATE_PROVIDER	☐	CAR_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Car Rental Provider	*
27	CURRENCY	☐	CAR_CURRENCY	WAERS	CUKY	5	0	Currency	*
28	BASE_RATE	☐	CAR_PRICE	FTPD_PRICE	CURR	10	2	Car Rental Price Per Day/Week/Etc.
29	RATE_TYPE	☐	CAR_RATE_PLAN	CHAR8	CHAR	8	0	Rental Car Rate Rule (by day/weekend/week/month)
30	EXTRA_CHARGE	☐	CAR_EXTRA_CHARGE	FTPD_PRICE	CURR	10	2	Surcharge for Car Rental Excess Usage
31	EXTRA_CHARGE_TYPE	☐	CAR_EXTRA_CHARGE_TYPE	FTPD_CAR_RATE_CODE	CHAR	3	0	Surcharge time unit for car rental usage exceeding
32	TOTAL_RATE	☐	CAR_TOTAL_RATE_AMOUNT	FTPD_PRICE	CURR	10	2	Total Price for Car Rental
33	PERMILE_CHARGE	☐	CAR_EXTRA_MILAGE	FTPD_PRICE	CURR	10	2	Surcharge for Exceeding Miles/Kms Limit for Rental Car
34	UNLIMITED_IND	☐			CHAR	1	0
35	FREE_MILES	☐	CAR_FREE_MILES	CHAR5	CHAR	5	0	Distance Restriction (miles/kilometers)
36	DISTANCE_TYPE	☐			CHAR	1	0
37	ADDITIONAL_INFO	☐			CHAR	132	0
38	DROP_OFF_CHARGE	☐	CAR_DROPOFF_CHARGE	FTPD_PRICE	CURR	10	2	Charges for Rental Car Dropoff
39	BOOKING_AGENT	☐			CHAR	12	0
40	FREQUENT_TRAVELLER_NUMBER	☐			CHAR	26	0
41	OPTIONAL_EQUIPMENT	☐			CHAR	15	0
42	GUARANTEE_CREDIT_CARD_VENDOR	☐			CHAR	3	0
43	GUARANTEE_CREDIT_CARD_NUMBER	☐			CHAR	21	0
44	GUARANTEE_CREDIT_CARD_DATE	☐			CHAR	7	0
45	.INCLU--AP	☐				0	0	Append Structure for FTPS_PNR_CAR_RES
46	NON_GDS_PUP_LOC	☐	CAR_PICKUP_LOC_NONGDS	CHAR11	CHAR	11	0	Car Rental Branch Office for Pickup (Provider-Specific)
47	NON_GDS_DO_LOC	☐	CAR_DROPOFF_LOC_NONGDS	CHAR11	CHAR	11	0	Car Rental Branch Office for Dropoff (Provider-Specific)

History

Last changed by/on	SAP	20041209
SAP Release Created in	46C