SAP ABAP Table PS0471 (HR Master Record Infotype 0471 (Flight Preferences))

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	PS0471	Table Relationship Diagram
Short Description	HR Master Record Infotype 0471 (Flight Preferences)

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	SMOKE	☐	PREF_SMOKER	FTPD_PREF_SMOKER	CHAR	1	0	Smoker/Nonsmoker
2	SEATP	☐	FLIGHT_PREF_SEATPOS	FTPD_FLIGHT_PREF_SEAT	CHAR	1	0	Preferred seating position in airplane
3	BHEAD	☐	FLIGHT_PREF_BULKHEAD	CHAR1_X	CHAR	1	0	Preference: Seat with Ample Leg Room
4	MEALS	☐	FLIGHT_PREF_MEAL	FTPD_MEALCODE	CHAR	4	0	Preferred meal on flight
5	HDCAP	☐	FLIGHT_PREF_HDCAP	CHAR1_X	CHAR	1	0	Seating Request: Suitable for Challenged Person
6	HDCAP_DESCR	☐	FLIGHT_PREF_HDCAP_DESCR	TEXT120	CHAR	120	0	Description of challenge
7	MEDIC	☐	FLIGHT_PREF_MEDIC	CHAR1_X	CHAR	1	0	Seating Request: Medical Care
8	MEDIC_DESCR	☐	FLIGHT_PREF_MEDIC_DESCR	TEXT120	CHAR	120	0	Description of medical care
9	MINOR	☐	FLIGHT_PREF_MINOR	CHAR1_X	CHAR	1	0	Seating requisition: unaccompanied minor
10	INFAN	☐	FLIGHT_PREF_INFAN	CHAR1_X	CHAR	1	0	Seating requisition: child's seat
11	PREF1	☐	FLIGHT_PREF_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	First preference airline	TA21P
12	PREF2	☐	FLIGHT_PREF_PROVIDER2	FTPD_PROVIDER_CODE	CHAR	3	0	Second preference airline	TA21P
13	PREF3	☐	FLIGHT_PREF_PROVIDER3	FTPD_PROVIDER_CODE	CHAR	3	0	Third preference airline	TA21P
14	DEFAP	☐	FLIGHT_PREF_AIRPORT	FTPD_IATA_LOCATION	CHAR	3	0	Preferred airport	TA21L
15	BLIND	☐	FLIGHT_PREF_BLIND	CHAR1_X	CHAR	1	0	Challenge: Blindness (for OSI information)
16	DEAF	☐	FLIGHT_PREF_DEAF	CHAR1_X	CHAR	1	0	Challenge: Deafness (for OSI information)
17	ASIST	☐	FLIGHT_PREF_ASIST	CHAR1_X	CHAR	1	0	Pickup and assistance required (for OSI information)
18	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PS0471	DEFAP	TA21L	LOCID	REF	1	CN
2	PS0471	PREF1	TA21P	PROVIDER	REF	1	CN
3	PS0471	PREF2	TA21P	PROVIDER	REF	1	CN
4	PS0471	PREF3	TA21P	PROVIDER	REF	1	CN

History

Last changed by/on	SAP	20091125
SAP Release Created in