SAP Table P0471
HR master record for infotype 0471
P0471 (HR master record for infotype 0471) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link P0471 to other SAP tables.
Source: P0471 (HR master record for infotype 0471)
P0471 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||||
| INFTY | Infotype | INFTY | T582A | CHAR | 4 | 0 | ||||||||
| SUBTY | Subtype | SUBTY | CHAR | 4 | 0 | |||||||||
| OBJPS | Object Identification | OBJPS | CHAR | 2 | 0 | |||||||||
| SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | 0 | |||||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||||
| AEDTM | Changed On | AEDAT | DATS | 8 | 0 | |||||||||
| UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||||
| ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | 0 | |||||||||
| PREAS | Reason for Changing Master Data | PREAS | T530E | CHAR | 2 | 0 | ||||||||
| FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
| RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
| GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | 0 | |||||||||
| SMOKE | Smoker/Nonsmoker | PREF_SMOKER | CHAR | 1 | 0 |
Possible values
|
||||||||
| SEATP | Preferred seating position in airplane | FLIGHT_PREF_SEATPOS | CHAR | 1 | 0 |
Possible values
|
||||||||
| BHEAD | Preference: Seat with Ample Leg Room | FLIGHT_PREF_BULKHEAD | CHAR | 1 | 0 |
Possible values
|
||||||||
| MEALS | Preferred meal on flight | FLIGHT_PREF_MEAL | CHAR | 4 | 0 | |||||||||
| HDCAP | Seating Request: Suitable for Challenged Person | FLIGHT_PREF_HDCAP | CHAR | 1 | 0 |
Possible values
|
||||||||
| HDCAP_DESCR | Description of challenge | FLIGHT_PREF_HDCAP_DESCR | CHAR | 120 | 0 | |||||||||
| MEDIC | Seating Request: Medical Care | FLIGHT_PREF_MEDIC | CHAR | 1 | 0 |
Possible values
|
||||||||
| MEDIC_DESCR | Description of medical care | FLIGHT_PREF_MEDIC_DESCR | CHAR | 120 | 0 | |||||||||
| MINOR | Seating requisition: unaccompanied minor | FLIGHT_PREF_MINOR | CHAR | 1 | 0 |
Possible values
|
||||||||
| INFAN | Seating requisition: child's seat | FLIGHT_PREF_INFAN | CHAR | 1 | 0 |
Possible values
|
||||||||
| PREF1 | First preference airline | FLIGHT_PREF_PROVIDER | TA21P | CHAR | 3 | 0 | ||||||||
| PREF2 | Second preference airline | FLIGHT_PREF_PROVIDER2 | TA21P | CHAR | 3 | 0 | ||||||||
| PREF3 | Third preference airline | FLIGHT_PREF_PROVIDER3 | TA21P | CHAR | 3 | 0 | ||||||||
| DEFAP | Preferred airport | FLIGHT_PREF_AIRPORT | TA21L | CHAR | 3 | 0 | ||||||||
| BLIND | Challenge: Blindness (for OSI information) | FLIGHT_PREF_BLIND | CHAR | 1 | 0 |
Possible values
|
||||||||
| DEAF | Challenge: Deafness (for OSI information) | FLIGHT_PREF_DEAF | CHAR | 1 | 0 |
Possible values
|
||||||||
| ASIST | Pickup and assistance required (for OSI information) | FLIGHT_PREF_ASIST | CHAR | 1 | 0 |
Possible values
|
||||||||
P0471 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P0471 | DEFAP | SYST | MANDT | TA21L | IATA Locations | MANDT |
| P0471 | DEFAP | P0471 | DEFAP | TA21L | IATA Locations | LOCID |
| P0471 | INFTY | SYST | MANDT | T582A | Infotypes: Customer-Specific Settings | MANDT |
| P0471 | INFTY | P0471 | INFTY | T582A | Infotypes: Customer-Specific Settings | INFTY |
| P0471 | PREAS | SYST | MADNT | T530E | Reasons for Changes | MANDT |
| P0471 | PREAS | P0471 | INFTY | T530E | Reasons for Changes | INFTY |
| P0471 | PREAS | P0471 | PREAS | T530E | Reasons for Changes | PREAS |
| P0471 | PREF1 | SYST | MANDT | TA21P | Travel Service Providers | MANDT |
| P0471 | PREF1 | 'F' | TA21P | Travel Service Providers | CATEGORY | |
| P0471 | PREF1 | P0471 | PREF1 | TA21P | Travel Service Providers | PROVIDER |
| P0471 | PREF2 | SYST | MANDT | TA21P | Travel Service Providers | MANDT |
| P0471 | PREF2 | 'F' | TA21P | Travel Service Providers | CATEGORY | |
| P0471 | PREF2 | P0471 | PREF2 | TA21P | Travel Service Providers | PROVIDER |
| P0471 | PREF3 | SYST | MANDT | TA21P | Travel Service Providers | MANDT |
| P0471 | PREF3 | 'F' | TA21P | Travel Service Providers | CATEGORY | |
| P0471 | PREF3 | P0471 | PREF3 | TA21P | Travel Service Providers | PROVIDER |
