SAP table P0471 (HR master record for infotype 0471)

Field Description Data Type Length Decimals Checktable Data Element
PERNR Personnel Number NUMC 8 0 PERNR_D
INFTY Infotype CHAR 4 0 T582A INFTY
SUBTY Subtype CHAR 4 0 SUBTY
OBJPS Object Identification CHAR 2 0 OBJPS
SPRPS Lock Indicator for HR Master Data Record CHAR 1 0 SPRPS
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
AEDTM Last Changed On DATS 8 0 AEDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXEX Text Exists for Infotype CHAR 1 0 ITXEX
REFEX Reference Fields Exist (Primary/Secondary Costs) CHAR 1 0 PRFEX
ORDEX Confirmation Fields Exist CHAR 1 0 ORDEX
ITBLD Infotype Screen Control CHAR 2 0 ITBLD
PREAS Reason for Changing Master Data CHAR 2 0 T530E PREAS
FLAG1 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG2 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG3 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG4 Reserved Field/Unused Field CHAR 1 0 NUSED
RESE1 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
RESE2 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
GRPVL Grouping Value for Personnel Assignments CHAR 4 0 PCCE_GPVAL
SMOKE Smoker/Nonsmoker CHAR 1 0 PREF_SMOKER
SEATP Preferred seating position in airplane CHAR 1 0 FLIGHT_PREF_SEATPOS
BHEAD Preference: Seat with Ample Leg Room CHAR 1 0 FLIGHT_PREF_BULKHEAD
MEALS Preferred meal on flight CHAR 4 0 FLIGHT_PREF_MEAL
HDCAP Seating Request: Suitable for Challenged Person CHAR 1 0 FLIGHT_PREF_HDCAP
HDCAP_DESCR Description of challenge CHAR 120 0 FLIGHT_PREF_HDCAP_DESCR
MEDIC Seating Request: Medical Care CHAR 1 0 FLIGHT_PREF_MEDIC
MEDIC_DESCR Description of medical care CHAR 120 0 FLIGHT_PREF_MEDIC_DESCR
MINOR Seating requisition: unaccompanied minor CHAR 1 0 FLIGHT_PREF_MINOR
INFAN Seating requisition: child's seat CHAR 1 0 FLIGHT_PREF_INFAN
PREF1 First preference airline CHAR 3 0 TA21P FLIGHT_PREF_PROVIDER
PREF2 Second preference airline CHAR 3 0 TA21P FLIGHT_PREF_PROVIDER2
PREF3 Third preference airline CHAR 3 0 TA21P FLIGHT_PREF_PROVIDER3
DEFAP Preferred airport CHAR 3 0 TA21L FLIGHT_PREF_AIRPORT
BLIND Challenge: Blindness (for OSI information) CHAR 1 0 FLIGHT_PREF_BLIND
DEAF Challenge: Deafness (for OSI information) CHAR 1 0 FLIGHT_PREF_DEAF
ASIST Pickup and assistance required (for OSI information) CHAR 1 0 FLIGHT_PREF_ASIST

P0471 foreign key relationships

Table Field Check Table Check Field
0 P0471 DEFAP TA21L IATA Locations MANDT
0 P0471 DEFAP TA21L IATA Locations LOCID
1 P0471 INFTY T582A Infotypes: Customer-Specific Settings MANDT
1 P0471 INFTY T582A Infotypes: Customer-Specific Settings INFTY
0 P0471 PREAS T530E Reasons for Changes MANDT
0 P0471 PREAS T530E Reasons for Changes INFTY
0 P0471 PREAS T530E Reasons for Changes PREAS
1 P0471 PREF1 TA21P Travel Service Providers MANDT
1 P0471 PREF1 TA21P Travel Service Providers CATEGORY
1 P0471 PREF1 TA21P Travel Service Providers PROVIDER
0 P0471 PREF2 TA21P Travel Service Providers MANDT
0 P0471 PREF2 TA21P Travel Service Providers CATEGORY
0 P0471 PREF2 TA21P Travel Service Providers PROVIDER
1 P0471 PREF3 TA21P Travel Service Providers MANDT
1 P0471 PREF3 TA21P Travel Service Providers CATEGORY
1 P0471 PREF3 TA21P Travel Service Providers PROVIDER