SAP Table PA0001
HR Master Record: Infotype 0001 (Org. Assignment)
PA0001 (HR Master Record: Infotype 0001 (Org. Assignment)) 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 PA0001 to other SAP tables.
PA0001 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| PERNR | Personnel number | PERSNO | PA0003 | NUMC | 8 | 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 | |||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||
| WERKS | Personnel Area | PERSA | T500P | CHAR | 4 | 0 | ||||||
| PERSG | Employee Group | PERSG | T501 | CHAR | 1 | 0 | ||||||
| PERSK | Employee Subgroup | PERSK | T503K | CHAR | 2 | 0 | ||||||
| VDSK1 | Organizational Key | VDSK1 | T527O | CHAR | 14 | 0 | ||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||
| BTRTL | Personnel Subarea | BTRTL | T001P | CHAR | 4 | 0 | ||||||
| JUPER | Legal Person | JUPER | CHAR | 4 | 0 | |||||||
| ABKRS | Payroll Area | ABKRS | T549A | CHAR | 2 | 0 | ||||||
| ANSVH | Work Contract | ANSVH | T542A | CHAR | 2 | 0 | ||||||
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||||||
| ORGEH | Organizational Unit | ORGEH | T527X | NUMC | 8 | 0 | ||||||
| PLANS | Position | PLANS | T528B | NUMC | 8 | 0 | ||||||
| STELL | Job | STELL | T513 | NUMC | 8 | 0 | ||||||
| MSTBR | Supervisor Area | MSTBR | CHAR | 8 | 0 | |||||||
| SACHA | Payroll Administrator | SACHA | T526 | CHAR | 3 | 0 | ||||||
| SACHP | Administrator for HR Master Data | SACHP | T526 | CHAR | 3 | 0 | ||||||
| SACHZ | Administrator for Time Recording | SACHZ | T526 | CHAR | 3 | 0 | ||||||
| SNAME | Employee's Name (Sortable by LAST NAME FIRST NAME) | SMNAM | CHAR | 30 | 0 | |||||||
| ENAME | Formatted Name of Employee or Applicant | EMNAM | CHAR | 40 | 0 | |||||||
| OTYPE | Object Type | OTYPE | T778O | CHAR | 2 | 0 | ||||||
| SBMOD | Administrator Group | SBMOD | CHAR | 4 | 0 | |||||||
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||
| FISTL | Funds Center | FISTL | CHAR | 16 | 0 | |||||||
| GEBER | Fund | BP_GEBER | CHAR | 10 | 0 | |||||||
| FKBER | Functional Area | FKBER | CHAR | 16 | 0 | |||||||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | 0 | |||||||
| SGMNT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | 0 | |||||||
| BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | 0 | |||||||
PA0001 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PA0001 | ABKRS | PA0001 | ABKRS | T549A | Payroll areas | ABKRS |
| PA0001 | ABKRS | PA0001 | MANDT | T549A | Payroll areas | MANDT |
| PA0001 | ANSVH | SYST | MANDT | T542A | Work Contract | MANDT |
| PA0001 | ANSVH | T500P | MOLGA | T542A | Work Contract | MOLGA |
| PA0001 | ANSVH | PA0001 | ANSVH | T542A | Work Contract | ANSVH |
| PA0001 | BTRTL | PA0001 | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
| PA0001 | BTRTL | PA0001 | MANDT | T001P | Personnel Area/Subarea | MANDT |
| PA0001 | BTRTL | PA0001 | WERKS | T001P | Personnel Area/Subarea | WERKS |
| PA0001 | BUKRS | PA0001 | MANDT | T001 | Company Codes | MANDT |
| PA0001 | BUKRS | PA0001 | BUKRS | T001 | Company Codes | BUKRS |
| PA0001 | GSBER | PA0001 | MANDT | TGSB | Business Areas | MANDT |
| PA0001 | GSBER | PA0001 | GSBER | TGSB | Business Areas | GSBER |
| PA0001 | KOKRS | PA0001 | KOKRS | TKA01 | Controlling Areas | KOKRS |
| PA0001 | KOKRS | PA0001 | MANDT | TKA01 | Controlling Areas | MANDT |
| PA0001 | KOSTL | PA0001 | MANDT | CSKS | Cost Center Master Data | MANDT |
| PA0001 | KOSTL | PA0001 | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| PA0001 | KOSTL | PA0001 | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| PA0001 | KOSTL | * | CSKS | Cost Center Master Data | DATBI | |
| PA0001 | MANDT | PA0001 | MANDT | T000 | Clients | MANDT |
| PA0001 | ORGEH | SYST | MANDT | T527X | Organizational Units | MANDT |
| PA0001 | ORGEH | * | T527X | Organizational Units | SPRSL | |
| PA0001 | ORGEH | PA0001 | ORGEH | T527X | Organizational Units | ORGEH |
| PA0001 | ORGEH | * | T527X | Organizational Units | ENDDA | |
| PA0001 | OTYPE | PA0001 | MANDT | T778O | Object Types | MANDT |
| PA0001 | OTYPE | PA0001 | OTYPE | T778O | Object Types | OTYPE |
| PA0001 | PERNR | PA0001 | MANDT | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
| PA0001 | PERNR | PA0001 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
| PA0001 | PERSG | PA0001 | MANDT | T501 | Employee Group | MANDT |
| PA0001 | PERSG | PA0001 | PERSG | T501 | Employee Group | PERSG |
| PA0001 | PERSK | PA0001 | MANDT | T503K | Employee subgroup | MANDT |
| PA0001 | PERSK | PA0001 | PERSK | T503K | Employee subgroup | PERSK |
| PA0001 | PLANS | PA0001 | OTYPE | T528B | Positions | OTYPE |
| PA0001 | PLANS | PA0001 | PLANS | T528B | Positions | PLANS |
| PA0001 | PLANS | * | T528B | Positions | ENDDA | |
| PA0001 | PLANS | PA0001 | MANDT | T528B | Positions | MANDT |
| PA0001 | PREAS | PA0001 | PREAS | T530E | Reasons for Changes | PREAS |
| PA0001 | PREAS | PA0001 | MANDT | T530E | Reasons for Changes | MANDT |
| PA0001 | PREAS | '0001' | T530E | Reasons for Changes | INFTY | |
| PA0001 | SACHA | PA0001 | SBMOD | T526 | Administrators | WERKS |
| PA0001 | SACHA | PA0001 | SACHA | T526 | Administrators | SACHX |
| PA0001 | SACHA | SYST | MANDT | T526 | Administrators | MANDT |
| PA0001 | SACHP | SYST | MANDT | T526 | Administrators | MANDT |
| PA0001 | SACHP | PA0001 | SBMOD | T526 | Administrators | WERKS |
| PA0001 | SACHP | PA0001 | SACHP | T526 | Administrators | SACHX |
| PA0001 | SACHZ | SYST | MANDT | T526 | Administrators | MANDT |
| PA0001 | SACHZ | PA0001 | SBMOD | T526 | Administrators | WERKS |
| PA0001 | SACHZ | PA0001 | SACHZ | T526 | Administrators | SACHX |
| PA0001 | STELL | PA0001 | MANDT | T513 | Jobs | MANDT |
| PA0001 | STELL | PA0001 | STELL | T513 | Jobs | STELL |
| PA0001 | STELL | * | T513 | Jobs | ENDDA | |
| PA0001 | VDSK1 | PA0001 | VDSK1 | T527O | Organizational Key Validation | ORGKY |
| PA0001 | VDSK1 | SYST | MANDT | T527O | Organizational Key Validation | MANDT |
| PA0001 | VDSK1 | '1' | T527O | Organizational Key Validation | HIRAR | |
| PA0001 | WERKS | PA0001 | MANDT | T500P | Personnel Areas | MANDT |
| PA0001 | WERKS | PA0001 | WERKS | T500P | Personnel Areas | PERSA |
