In this post, I will try and describe everything you need to know about the SAP p0001 table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for P0001 what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from P0001....Right lets get started!
Object Name: P0001
Dictionary Type: Structure
Description: HR Master Record: Infotype 0001 (Org. Assignment)
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| PERNR | PERNR_D | NUMC | 8(0) | Personnel Number | PERNR | PER | PB | |||||
| INFTY | INFTY | CHAR | 4(0) | T582A | Infotype | INFOTYP | ITP | PINF | ||||
| SUBTY | SUBTY | CHAR | 4(0) | Subtype | SUBTY | SUB | PINF | |||||
| OBJPS | OBJPS | CHAR | 2(0) | Object Identification | OBJPS | OPS | PINF | |||||
| SPRPS | SPRPS | CHAR | 1(0) | Lock Indicator for HR Master Data Record | SPRPS | PINF | ||||||
| ENDDA | ENDDA | DATS | 8(0) | End Date | DATUM | PB | ||||||
| BEGDA | BEGDA | DATS | 8(0) | Start Date | DATUM | PB | ||||||
| SEQNR | SEQNR | NUMC | 3(0) | Number of Infotype Record with Same Key | NUM03 | PP | ||||||
| AEDTM | AEDAT | DATS | 8(0) | Changed On | DATUM | SAP | ||||||
| UNAME | AENAM | CHAR | 12(0) | Name of Person Who Changed Object | USNAM | SAP | ||||||
| HISTO | HISTO | CHAR | 1(0) | Historical Record Flag | CHAR1 | PP | ||||||
| ITXEX | ITXEX | CHAR | 1(0) | Text Exists for Infotype | XFELD | |||||||
| REFEX | PRFEX | CHAR | 1(0) | Reference Fields Exist (Primary/Secondary Costs) | XFELD | |||||||
| ORDEX | ORDEX | CHAR | 1(0) | Confirmation Fields Exist | XFELD | |||||||
| ITBLD | ITBLD | CHAR | 2(0) | Infotype Screen Control | CHAR2 | PSTA | ||||||
| PREAS | PREAS | CHAR | 2(0) | T530E | Reason for Changing Master Data | PREAS | PB | |||||
| FLAG1 | NUSED | CHAR | 1(0) | Reserved Field/Unused Field | NUSED | PLOH | ||||||
| FLAG2 | NUSED | CHAR | 1(0) | Reserved Field/Unused Field | NUSED | PLOH | ||||||
| FLAG3 | NUSED | CHAR | 1(0) | Reserved Field/Unused Field | NUSED | PLOH | ||||||
| FLAG4 | NUSED | CHAR | 1(0) | Reserved Field/Unused Field | NUSED | PLOH | ||||||
| RESE1 | NUSED2 | CHAR | 2(0) | Reserved Field/Unused Field of Length 2 | NUSED2 | PLOH | ||||||
| RESE2 | NUSED2 | CHAR | 2(0) | Reserved Field/Unused Field of Length 2 | NUSED2 | PLOH | ||||||
| GRPVL | PCCE_GPVAL | CHAR | 4(0) | Grouping Value for Personnel Assignments | PCCE_GPVAL | |||||||
| BUKRS | BUKRS | CHAR | 4(0) | T001 | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | ||
| WERKS | PERSA | CHAR | 4(0) | T500P | Personnel Area | PERSA | PBR | |||||
| PERSG | PERSG | CHAR | 1(0) | T501 | Employee Group | PERSG | PRG | PSTA | ||||
| PERSK | PERSK | CHAR | 2(0) | T503K | Employee Subgroup | PERSK | PKR | PSTA | ||||
| VDSK1 | VDSK1 | CHAR | 14(0) | T527O | Organizational Key | VDSK1 | PSTA | |||||
| GSBER | GSBER | CHAR | 4(0) | TGSB | Business Area | GSBER | GSB | FB | ||||
| BTRTL | BTRTL | CHAR | 4(0) | T001P | Personnel Subarea | BTRTL | PBS | PAST | ||||
| JUPER | JUPER | CHAR | 4(0) | Legal Person | JUPER | PAST | ||||||
| ABKRS | ABKRS | CHAR | 2(0) | T549A | Payroll Area | ABKRS | ABK | PABR | ||||
| ANSVH | ANSVH | CHAR | 2(0) | T542A | Work Contract | ANSVH | PSTA | |||||
| KOSTL | KOSTL | CHAR | 10(0) | CSKS | Cost Center | KOSTL | KOS | KS | ||||
| ORGEH | ORGEH | NUMC | 8(0) | T527X | Organizational Unit | ORGEH | PSTA | |||||
| PLANS | PLANS | NUMC | 8(0) | T528B | Position | PLANS | PINF | |||||
| STELL | STELL | NUMC | 8(0) | T513 | Job | STELL | PSTA | |||||
| MSTBR | MSTBR | CHAR | 8(0) | Supervisor Area | MSTBR | PINF | ||||||
| SACHA | SACHA | CHAR | 3(0) | T526 | Payroll Administrator | SACHA | PSTA | |||||
| SACHP | SACHP | CHAR | 3(0) | T526 | Administrator for HR Master Data | SACHA | PSTA | |||||
| SACHZ | SACHZ | CHAR | 3(0) | T526 | Administrator for Time Recording | SACHA | PSTA | |||||
| SNAME | SMNAM | CHAR | 30(0) | Employee's Name (Sortable by LAST NAME FIRST NAME) | CHAR30 | PINF | ||||||
| ENAME | EMNAM | CHAR | 40(0) | Formatted Name of Employee or Applicant | TEXT40 | PINF | ||||||
| OTYPE | OTYPE | CHAR | 2(0) | T778O | Object Type | OTYPE | POT | PP | ||||
| SBMOD | SBMOD | CHAR | 4(0) | Administrator Group | CHAR4 | SGR | ||||||
| KOKRS | KOKRS | CHAR | 4(0) | TKA01 | Controlling Area | CACCD | CAC | KS | ||||
| FISTL | FISTL | CHAR | 16(0) | * | Funds Center | FISTL | FIS | |||||
| GEBER | BP_GEBER | CHAR | 10(0) | * | Fund | BP_GEBER | FIC | |||||
| FKBER | FKBER | CHAR | 16(0) | * | Functional Area | FKBER | FBE | |||||
| GRANT_NBR | GM_GRANT_NBR | CHAR | 20(0) | Grant | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | GRANT_NUMBER | ||||
| SGMNT | FB_SEGMENT | CHAR | 10(0) | * | Segment for Segmental Reporting | FB_SEGMENT | ||||||
| BUDGET_PD | FM_BUDGET_PERIOD | CHAR | 10(0) | * | FM: Budget Period | FM_BUDGET_PERIOD | BUDPER |