SAP ABAP Table P0471 (HR master record for infotype 0471)

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	P0471	Table Relationship Diagram
Short Description	HR master record for infotype 0471

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	.INCLUDE	☐				0	0	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	HR Master Record Infotype 0471 (Flight Preferences)
28	SMOKE	☐	PREF_SMOKER	FTPD_PREF_SMOKER	CHAR	1	0	Smoker/Nonsmoker
29	SEATP	☐	FLIGHT_PREF_SEATPOS	FTPD_FLIGHT_PREF_SEAT	CHAR	1	0	Preferred seating position in airplane
30	BHEAD	☐	FLIGHT_PREF_BULKHEAD	CHAR1_X	CHAR	1	0	Preference: Seat with Ample Leg Room
31	MEALS	☐	FLIGHT_PREF_MEAL	FTPD_MEALCODE	CHAR	4	0	Preferred meal on flight
32	HDCAP	☐	FLIGHT_PREF_HDCAP	CHAR1_X	CHAR	1	0	Seating Request: Suitable for Challenged Person
33	HDCAP_DESCR	☐	FLIGHT_PREF_HDCAP_DESCR	TEXT120	CHAR	120	0	Description of challenge
34	MEDIC	☐	FLIGHT_PREF_MEDIC	CHAR1_X	CHAR	1	0	Seating Request: Medical Care
35	MEDIC_DESCR	☐	FLIGHT_PREF_MEDIC_DESCR	TEXT120	CHAR	120	0	Description of medical care
36	MINOR	☐	FLIGHT_PREF_MINOR	CHAR1_X	CHAR	1	0	Seating requisition: unaccompanied minor
37	INFAN	☐	FLIGHT_PREF_INFAN	CHAR1_X	CHAR	1	0	Seating requisition: child's seat
38	PREF1	☐	FLIGHT_PREF_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	First preference airline	TA21P
39	PREF2	☐	FLIGHT_PREF_PROVIDER2	FTPD_PROVIDER_CODE	CHAR	3	0	Second preference airline	TA21P
40	PREF3	☐	FLIGHT_PREF_PROVIDER3	FTPD_PROVIDER_CODE	CHAR	3	0	Third preference airline	TA21P
41	DEFAP	☐	FLIGHT_PREF_AIRPORT	FTPD_IATA_LOCATION	CHAR	3	0	Preferred airport	TA21L
42	BLIND	☐	FLIGHT_PREF_BLIND	CHAR1_X	CHAR	1	0	Challenge: Blindness (for OSI information)
43	DEAF	☐	FLIGHT_PREF_DEAF	CHAR1_X	CHAR	1	0	Challenge: Deafness (for OSI information)
44	ASIST	☐	FLIGHT_PREF_ASIST	CHAR1_X	CHAR	1	0	Pickup and assistance required (for OSI information)
45	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0471	DEFAP	TA21L	LOCID	REF	1	CN
2	P0471	INFTY	T582A	INFTY
3	P0471	PREAS	T530E	PREAS
4	P0471	PREF1	TA21P	PROVIDER	REF	1	CN
5	P0471	PREF2	TA21P	PROVIDER	REF	1	CN
6	P0471	PREF3	TA21P	PROVIDER	REF	1	CN

History

Last changed by/on	SAP	20091125
SAP Release Created in