SAP Table P0023
HR Master Record: Infotype 0023 (Other/Previous Employers)
P0023 (HR Master Record: Infotype 0023 (Other/Previous Employers)) 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 P0023 to other SAP tables.
P0023 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
REFEX
Reference Fields Exist (Primary/Secondary Costs)
|
PRFEX |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ORDEX
Confirmation Fields Exist
|
ORDEX |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
ARBGB
Name of employer
|
VORAG |
CHAR
|
60 | 0 | ||||||||
|
ORT01
City
|
ORT01 |
CHAR
|
25 | 0 | ||||||||
|
LAND1
Country Key
|
LAND1 | T005 |
CHAR
|
3 | 0 | |||||||
|
BRANC
Industry key
|
BRSCH | T016 |
CHAR
|
4 | 0 | |||||||
|
TAETE
Job at former employer(s)
|
TAETE | T513C |
NUMC
|
8 | 0 | |||||||
|
ANSVX
Work Contract - Other Employers
|
ANSVX | T542C |
CHAR
|
2 | 0 | |||||||
|
ORTJ1
First address line (Kanji)
|
P22J_ADDR1 |
CHAR
|
40 | 0 | ||||||||
|
ORTJ2
Second address line (Kanji)
|
P22J_ADDR2 |
CHAR
|
40 | 0 | ||||||||
|
ORTJ3
Third address line (Kanji)
|
P22J_ADDR3 |
CHAR
|
40 | 0 | ||||||||
P0023 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| P0023 | ANSVX | P0023 | ANSVX |
T542C
Work Contract - Other/Previous Employers
|
ANSVX |
| P0023 | ANSVX | SYST | MANDT |
T542C
Work Contract - Other/Previous Employers
|
MANDT |
| P0023 | BRANC | SYST | MANDT |
T016
Industries
|
MANDT |
| P0023 | BRANC | P0023 | BRANC |
T016
Industries
|
BRSCH |
| P0023 | INFTY | SYST | MANDT |
T582A
Infotypes: Customer-Specific Settings
|
MANDT |
| P0023 | INFTY | P0023 | INFTY |
T582A
Infotypes: Customer-Specific Settings
|
INFTY |
| P0023 | LAND1 | SYST | MANDT |
T005
Countries
|
MANDT |
| P0023 | LAND1 | P0023 | LAND1 |
T005
Countries
|
LAND1 |
| P0023 | PREAS | SYST | MANDT |
T530E
Reasons for Changes
|
MANDT |
| P0023 | PREAS | P0023 | INFTY |
T530E
Reasons for Changes
|
INFTY |
| P0023 | PREAS | P0023 | PREAS |
T530E
Reasons for Changes
|
PREAS |
| P0023 | TAETE | P0023 | TAETE |
T513C
Jobs With Other/Previous Employers
|
TAETE |
| P0023 | TAETE | SYST | MANDT |
T513C
Jobs With Other/Previous Employers
|
MANDT |
| P0023 | TAETE | SYST | LANGU |
T513C
Jobs With Other/Previous Employers
|
SPRAS |