PS0001 (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 PS0001 to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
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 |
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| PS0001 | ABKRS | SYST | MANDT |
T549A
Payroll areas
|
MANDT |
| PS0001 | ABKRS | PS0001 | ABKRS |
T549A
Payroll areas
|
ABKRS |
| PS0001 | ANSVH | SYST | MANDT |
T542A
Work Contract
|
MANDT |
| PS0001 | ANSVH | T500P | MOLGA |
T542A
Work Contract
|
MOLGA |
| PS0001 | ANSVH | PS0001 | ANSVH |
T542A
Work Contract
|
ANSVH |
| PS0001 | BTRTL | SYST | MANDT |
T001P
Personnel Area/Subarea
|
MANDT |
| PS0001 | BTRTL | PS0001 | WERKS |
T001P
Personnel Area/Subarea
|
WERKS |
| PS0001 | BTRTL | PS0001 | BTRTL |
T001P
Personnel Area/Subarea
|
BTRTL |
| PS0001 | BUKRS | SYST | MANDT |
T001
Company Codes
|
MANDT |
| PS0001 | BUKRS | PS0001 | BUKRS |
T001
Company Codes
|
BUKRS |
| PS0001 | GSBER | SYST | MANDT |
TGSB
Business Areas
|
MANDT |
| PS0001 | GSBER | PS0001 | GSBER |
TGSB
Business Areas
|
GSBER |
| PS0001 | KOKRS | PS0001 | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| PS0001 | KOKRS | SYST | MANDT |
TKA01
Controlling Areas
|
MANDT |
| PS0001 | KOSTL | SYST | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| PS0001 | KOSTL | PS0001 | KOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| PS0001 | KOSTL | PS0001 | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| PS0001 | KOSTL | * |
CSKS
Cost Center Master Data
|
DATBI | |
| PS0001 | ORGEH | PS0001 | ORGEH |
T527X
Organizational Units
|
ORGEH |
| PS0001 | ORGEH | * |
T527X
Organizational Units
|
ENDDA | |
| PS0001 | ORGEH | SYST | MANDT |
T527X
Organizational Units
|
MANDT |
| PS0001 | ORGEH | * |
T527X
Organizational Units
|
SPRSL | |
| PS0001 | OTYPE | SYST | MANDT |
T778O
Object Types
|
MANDT |
| PS0001 | OTYPE | PS0001 | OTYPE |
T778O
Object Types
|
OTYPE |
| PS0001 | PERSG | SYST | MANDT |
T501
Employee Group
|
MANDT |
| PS0001 | PERSG | PS0001 | PERSG |
T501
Employee Group
|
PERSG |
| PS0001 | PERSK | SYST | MANDT |
T503K
Employee subgroup
|
MANDT |
| PS0001 | PERSK | PS0001 | PERSK |
T503K
Employee subgroup
|
PERSK |
| PS0001 | PLANS | SYST | MANDT |
T528B
Positions
|
MANDT |
| PS0001 | PLANS | PS0001 | OTYPE |
T528B
Positions
|
OTYPE |
| PS0001 | PLANS | PS0001 | PLANS |
T528B
Positions
|
PLANS |
| PS0001 | PLANS | * |
T528B
Positions
|
ENDDA | |
| PS0001 | SACHA | SYST | MANDT |
T526
Administrators
|
MANDT |
| PS0001 | SACHA | PS0001 | SBMOD |
T526
Administrators
|
WERKS |
| PS0001 | SACHA | PS0001 | SACHA |
T526
Administrators
|
SACHX |
| PS0001 | SACHP | PS0001 | SBMOD |
T526
Administrators
|
WERKS |
| PS0001 | SACHP | PS0001 | SACHP |
T526
Administrators
|
SACHX |
| PS0001 | SACHP | SYST | MANDT |
T526
Administrators
|
MANDT |
| PS0001 | SACHZ | SYST | MANDT |
T526
Administrators
|
MANDT |
| PS0001 | SACHZ | PS0001 | SBMOD |
T526
Administrators
|
WERKS |
| PS0001 | SACHZ | PS0001 | SACHZ |
T526
Administrators
|
SACHX |
| PS0001 | STELL | PS0001 | STELL |
T513
Jobs
|
STELL |
| PS0001 | STELL | * |
T513
Jobs
|
ENDDA | |
| PS0001 | STELL | SYST | MANDT |
T513
Jobs
|
MANDT |
| PS0001 | VDSK1 | SYST | MANDT |
T527O
Organizational Key Validation
|
MANDT |
| PS0001 | VDSK1 | '1' |
T527O
Organizational Key Validation
|
HIRAR | |
| PS0001 | VDSK1 | PS0001 | VDSK1 |
T527O
Organizational Key Validation
|
ORGKY |
| PS0001 | WERKS | SYST | MANDT |
T500P
Personnel Areas
|
MANDT |
| PS0001 | WERKS | PS0001 | WERKS |
T500P
Personnel Areas
|
PERSA |