SAP ABAP Table FTPT_IMR_CAR (IMR - Car Rental)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FTPT_IMR_CAR	Table Relationship Diagram
Short Description	IMR - Car Rental

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Key for Information Management record
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	RECORD_LOCATOR	☑	PNR_RECORD_LOCATOR	FTPD_PNR_RECORD_LOCATOR	CHAR	20	0	Passenger Name Record Locator
4	AIR_NUMBER	☑	AIR_RECORD_NUMBER		NUMC	12	0	Air record unique identifier	FTPT_IMR
5	RUNNING_NUMBER	☑	RUNNING_NUMBER	FTPD_RUNNING_NUMBER	NUMC	4	0	Index
6	.INCLUDE	☐				0	0	AIR : Structure to describe CAR information for Automated
7	CAR_SEG_TYPE	☐	API_1A_AIR_SEGMENT_TYPE	FTPD_AIR_SEGMENT_TYPE	NUMC	2	0	AIR : Description of segment type for itinerary portion
8	TATTOO_NUMBER	☐	API_1A_TATTOO_NUMBER		NUMC	4	0	Amadeus unique identifier for each element stored in PNR
9	DISPLAY_NUMBER	☐	API_1A_DISPLAY_NUMBER		NUMC	4	0	Amadeus unique identifier for each element displayed in PNR
10	PROVIDER_CODE	☐			CHAR	4	0
11	STATUS_CODE	☐	API_1A_STATUS_CODE		CHAR	2	0	Real status code from Amadeus
12	NUMBER_OF_CARS	☐			NUMC	2	0
13	IN_DATE	☐			DATS	8	0
14	OUT_DATE	☐			DATS	8	0
15	ARPT_CITY_CODE	☐	API_1A_CITY_CODE		CHAR	5	0	5 character code identifying a City Code
16	ARPT_CITY_NAME	☐			CHAR	20	0
17	CAR_TYPE_CODE	☐	API_1A_CAR_TYPE		CHAR	5	0	Car Type Code
18	CAR_TYPE_DECODE	☐			CHAR	25	0
19	ARRIVAL_INFO	☐			CHAR	40	0
20	BOOKING_AGENCY	☐			CHAR	15	0
21	BILLING_NUMBER	☐			CHAR	15	0
22	BILLING_REF	☐			CHAR	15	0
23	BS_TYPE	☐			CHAR	1	0
24	BS	☐	API_1A_BOOKING_SOURCE		CHAR	10	0	Booking source for reservation identification
25	CORP_ID	☐	API_1A_CORPORATE_ID		CHAR	25	0	Confirmation Code returned after Hotel reservation
26	CONF_NUMBER	☐	API_1A_CONFIRMATION		CHAR	20	0	Confirmation Code returned after Hotel reservation
27	VOUCHER_CODE	☐			CHAR	25	0
28	DROPOFF_CHARGE	☐			CHAR	20	0
29	DROPOFF_INFO	☐			CHAR	70	0
30	FOP	☐			CHAR	50	0
31	FQTV_NUMBER	☐			CHAR	30	0
32	GUARANTEE_INFO	☐			CHAR	45	0
33	CUSTOMER_ID	☐			CHAR	25	0
34	INCLUSE_TOUR	☐			CHAR	20	0
35	LOCATION_CODE	☐			CHAR	10	0
36	CITY_DISTANCE	☐			CHAR	10	0
37	RESA_NAME	☐			CHAR	30	0
38	PICKUP_INFO	☐			CHAR	70	0
39	BASE_RATE_INFO	☐			CHAR	30	0
40	CAR_RATE_CODE	☐	API_1A_CAR_RATE_CODE		CHAR	10	0	Car Rate Code
41	RATE_GUARANTEE	☐			CHAR	60	0
42	RATE_QUOTED	☐			CHAR	60	0
43	SUPP_INFO	☐			CHAR	90	0
44	SPECIAL_REQ	☐			CHAR	20	0
45	TRACKING_INFO	☐			CHAR	30	0
46	VOUCHER_VALUE	☐			CHAR	20	0
47	ACCOUNT_INFO	☐			CHAR	30	0
48	PAST_DATED_IND	☐			CHAR	1	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_IMR_CAR	AIR_NUMBER	FTPT_IMR	RECORD_LOCATOR	KEY	1	CN

History

Last changed by/on	SAP	20010720
SAP Release Created in