SAP ABAP Table FTPT_FLIGHT_PREF (Flight 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_FLIGHT_PREF	Table Relationship Diagram
Short Description	Flight 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	☑	FLIGHT_SERVICE_NR	FTPD_FLIGHT_ID	NUMC	3	0	Travel service item number of flight	FTPT_FLIGHT
10	MEAL_CODE	☐	SSR_MEAL_CODE	FTPD_MEALCODE	CHAR	4	0	Preferred Meal on Flight
11	FREQ_CODE	☐	SSR_FREQ_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Provider to which the SSR refers	*
12	HDCAP_CODE	☐	SSR_HDCAP_CODE	CHAR1_X	CHAR	1	0	Seating Request: Suitable for Challenged Person
13	MEDIC_CODE	☐	SSR_MEDIC_CODE	CHAR1_X	CHAR	1	0	Seating Request: Medical Care
14	MINOR_CODE	☐	SSR_MINOR_CODE	CHAR1_X	CHAR	1	0	Seating requisition: unaccompanied minor
15	INFANT_CODE	☐	SSR_INFANT_CODE	CHAR1_X	CHAR	1	0	Seating requisition: child's seat
16	AIRLINE_CODE	☐	SSR_AIRLINE_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Airline	TA21P
17	STATUS_CODE	☐	SSR_STATUS_CODE	CHAR2	CHAR	2	0	SSR status
18	TEXT_INFO	☐	SSR_TEXT_INFO	FTPD_INFO	CHAR	132	0	Text description for an SSR element
19	LINENUMBER	☐	SSR_LINENUMBER	FTPD_LINENUMBER	INT2	5	0	Line number of SSR in the itinerary
20	FREQ_CARD_CODE	☐	SSR_FREQ_CARD_AIRLINE	FTPD_PROVIDER_CODE	CHAR	3	0	SSR Frequent Flyer Affiliated Airline Code	*
21	FREQ_CARD_USAGE	☐	SSR_FREQ_CARD_USAGE	CHAR1_X	CHAR	1	0	Type of Usage for Frequent Flyer Card
22	FREQ_CARD_NUMBER	☐	SSR_FREQ_CARD_NUMBER	FTPD_FLIGHT_PREF_FREQ_FLYER_NR	CHAR	21	0	Frequent Flyer Card Number
23	HDCAP_DESCR	☐	FLIGHT_PREF_HDCAP_DESCR	TEXT120	CHAR	120	0	Description of challenge
24	MEDIC_DESCR	☐	FLIGHT_PREF_MEDIC_DESCR	TEXT120	CHAR	120	0	Description of medical care
25	BLIND	☐	FLIGHT_PREF_BLIND	CHAR1_X	CHAR	1	0	Challenge: Blindness (for OSI information)
26	DEAF	☐	FLIGHT_PREF_DEAF	CHAR1_X	CHAR	1	0	Challenge: Deafness (for OSI information)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTPT_FLIGHT_PREF	AIRLINE_CODE	TA21P	PROVIDER	REF	1	CN
2	FTPT_FLIGHT_PREF	SERVICE	FTPT_FLIGHT	ITEM	KEY	1	CN

History

Last changed by/on	SAP	20091125
SAP Release Created in