SAP Table PA0859
HR Master data for infotype 0859
PA0859 (HR Master data for infotype 0859) 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 PA0859 to other SAP tables.
PA0859 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | 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 | |||||||
| CNTTY | Contract type | PPL_CNTTY | T591A | CHAR | 4 | 0 | ||||||
| VBELN | Sales Document | VBELN_VA | VBUK | CHAR | 10 | 0 | ||||||
| POSNR | Sales Document Item | POSNR_VA | VBUP | NUMC | 6 | 0 | ||||||
| KOKRS_CUST | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||
| KOSTL_CUST | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||
| KOKRS_INT | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||
| KOSTL_INT | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||||||
| ADM_ORDER | Order adminstrator | PPL_ADMORDER | CHAR | 12 | 0 | |||||||
| FIRE_REASON | Fire reason | PPL_FIRE_REAS | T7PLT0 | CHAR | 2 | 0 | ||||||
| CUSTNR | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 0 | ||||||
| CUST_NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | 0 | |||||||
| CUST_NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | 0 | |||||||
| CUST_CITY | City | AD_CITY1 | CHAR | 40 | 0 | |||||||
| CUST_STREET | Street and House Number | PAD_STRAS | CHAR | 60 | 0 | |||||||
| CUST_HOUSE | House Number | AD_HSNM1 | CHAR | 10 | 0 | |||||||
| CUST_ROOM | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | 0 | |||||||
| CUST_POST_CODE | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||||||
| CUST_POST | Post office | PPL_POST_OFFICE | CHAR | 40 | 0 | |||||||
| CUST_COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||
| WRK_NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | 0 | |||||||
| WRK_NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | 0 | |||||||
| WRK_CITY | City | AD_CITY1 | CHAR | 40 | 0 | |||||||
| WRK_STREET | Street and House Number | PAD_STRAS | CHAR | 60 | 0 | |||||||
| WRK_HOUSE | House Number | AD_HSNM1 | CHAR | 10 | 0 | |||||||
| WRK_ROOM | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | 0 | |||||||
| WRK_POST_CODE | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||||||
| WRK_POST | Post office | PPL_POST_OFFICE | CHAR | 40 | 0 | |||||||
| WRK_COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||
| WRK_BEG | Start Time | BEGUZ | TIMS | 6 | 0 | |||||||
| WRK_END | End Time | ENDUZ | TIMS | 6 | 0 | |||||||
| JOB_POS | Job position | PPL_JOB | CHAR | 40 | 0 | |||||||
| EMPCT | Employment percentage | EMPCT | DEC | 5 | 2 | |||||||
| BREAK_TIME | Unpaid Break Period | PDUNB | DEC | 4 | 2 | |||||||
| BREAK_BEG | Start of Break | PDBEG | TIMS | 6 | 0 | |||||||
| BREAK_END | End of Break | PDEND | TIMS | 6 | 0 | |||||||
| CURR_CODE | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| LGA01 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET01 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ01 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN01 | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
| OPK01 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| LGA02 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET02 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ02 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN02 | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
| OPK02 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| LGA03 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET03 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ03 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN03 | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
| OPK03 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| LGA04 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET04 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ04 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN04 | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
| OPK04 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| LGA05 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET05 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ05 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN05 | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
| OPK05 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| LGA06 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET06 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ06 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN06 | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
| OPK06 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| LGA07 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET07 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ07 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN07 | Time/Measurement Unit | PT_ZEINH | T538A | CHAR | 3 | 0 | ||||||
| OPK07 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| LGA08 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET08 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ08 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN08 | Time/Measurement Unit | PT_ZEINH | CHAR | 3 | 0 | |||||||
| OPK08 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| LGA09 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET09 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ09 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN09 | Time/Measurement Unit | PT_ZEINH | CHAR | 3 | 0 | |||||||
| OPK09 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| LGA10 | Wage Type | LGART | T512Z | CHAR | 4 | 0 | ||||||
| BET10 | Wage Type Amount for Payments | PAD_AMT7S | CURR | 13 | 2 | |||||||
| ANZ10 | Number | ANZHL | DEC | 7 | 2 | |||||||
| EIN10 | Time/Measurement Unit | PT_ZEINH | CHAR | 3 | 0 | |||||||
| OPK10 | Operation Indicator for Wage Types | OPKEN | CHAR | 1 | 0 |
Possible values
|
||||||
| CNTDT | Date of contract | PPL_CNTDT | DATS | 8 | 0 | |||||||
| CNANN | Date of contract annexe | PPL_CNANN | DATS | 8 | 0 | |||||||
PA0859 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PA0859 | CNTTY | SYST | MANDT | T591A | Subtype Characteristics | MANDT |
| PA0859 | CNTTY | '0859' | T591A | Subtype Characteristics | INFTY | |
| PA0859 | CNTTY | PA0859 | CNTTY | T591A | Subtype Characteristics | SUBTY |
| PA0859 | CURR_CODE | SYST | MANDT | TCURC | Currency Codes | MANDT |
| PA0859 | CURR_CODE | PA0859 | CURR_CODE | TCURC | Currency Codes | WAERS |
| PA0859 | CUSTNR | SYST | MANDT | KNA1 | General Data in Customer Master | MANDT |
| PA0859 | CUSTNR | PA0859 | CUSTNR | KNA1 | General Data in Customer Master | KUNNR |
| PA0859 | CUST_COUNTRY | SYST | MANDT | T005 | Countries | MANDT |
| PA0859 | CUST_COUNTRY | PA0859 | CUST_COUNTRY | T005 | Countries | LAND1 |
| PA0859 | EIN01 | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| PA0859 | EIN01 | PA0859 | EIN01 | T538A | HR Time/Measurement Units | ZEINH |
| PA0859 | EIN02 | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| PA0859 | EIN02 | PA0859 | EIN02 | T538A | HR Time/Measurement Units | ZEINH |
| PA0859 | EIN03 | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| PA0859 | EIN03 | PA0859 | EIN03 | T538A | HR Time/Measurement Units | ZEINH |
| PA0859 | EIN04 | PA0859 | EIN04 | T538A | HR Time/Measurement Units | ZEINH |
| PA0859 | EIN04 | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| PA0859 | EIN05 | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| PA0859 | EIN05 | PA0859 | EIN05 | T538A | HR Time/Measurement Units | ZEINH |
| PA0859 | EIN06 | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| PA0859 | EIN06 | PA0859 | EIN06 | T538A | HR Time/Measurement Units | ZEINH |
| PA0859 | EIN07 | PA0859 | EIN07 | T538A | HR Time/Measurement Units | ZEINH |
| PA0859 | EIN07 | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| PA0859 | FIRE_REASON | PA0859 | FIRE_REASON | T7PLT0 | Conversion table for leave codes fot tempolary workers | MASSG |
| PA0859 | FIRE_REASON | * | T7PLT0 | Conversion table for leave codes fot tempolary workers | ENDDA | |
| PA0859 | FIRE_REASON | SYST | MANDT | T7PLT0 | Conversion table for leave codes fot tempolary workers | MANDT |
| PA0859 | KOKRS_CUST | PA0859 | KOKRS_CUST | TKA01 | Controlling Areas | KOKRS |
| PA0859 | KOKRS_CUST | SYST | MANDT | TKA01 | Controlling Areas | MANDT |
| PA0859 | KOKRS_INT | SYST | MANDT | TKA01 | Controlling Areas | MANDT |
| PA0859 | KOKRS_INT | PA0859 | KOKRS_INT | TKA01 | Controlling Areas | KOKRS |
| PA0859 | KOSTL_CUST | * | CEPC | Profit Center Master Data Table | DATBI | |
| PA0859 | KOSTL_CUST | PA0859 | KOKRS_CUST | CEPC | Profit Center Master Data Table | KOKRS |
| PA0859 | KOSTL_CUST | SYST | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| PA0859 | KOSTL_CUST | PA0859 | KOSTL_CUST | CEPC | Profit Center Master Data Table | PRCTR |
| PA0859 | KOSTL_INT | * | CSKS | Cost Center Master Data | DATBI | |
| PA0859 | KOSTL_INT | SYST | MANDT | CSKS | Cost Center Master Data | MANDT |
| PA0859 | KOSTL_INT | PA0859 | KOKRS_INT | CSKS | Cost Center Master Data | KOKRS |
| PA0859 | KOSTL_INT | PA0859 | KOSTL_INT | CSKS | Cost Center Master Data | KOSTL |
| PA0859 | LGA01 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA01 | PA0859 | LGA01 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA01 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | LGA01 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA01 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA02 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA02 | PA0859 | LGA02 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA02 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | LGA02 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA02 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA03 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA03 | PA0859 | LGA03 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA03 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | LGA03 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA03 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA04 | PA0859 | LGA04 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA04 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | LGA04 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA04 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA04 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA05 | PA0859 | LGA05 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA05 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | LGA05 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA05 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA05 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA06 | PA0859 | LGA06 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA06 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | LGA06 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA06 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA06 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA07 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | LGA07 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA07 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA07 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA07 | PA0859 | LGA07 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA08 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | LGA08 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA08 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA08 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA08 | PA0859 | LGA08 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA09 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | LGA09 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA09 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA09 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA09 | PA0859 | LGA09 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA10 | SYST | MANDT | T512Z | Permissibility of Wage Types per Infotype | MANDT |
| PA0859 | LGA10 | '0859' | T512Z | Permissibility of Wage Types per Infotype | INFTY | |
| PA0859 | LGA10 | T001P | MOLGA | T512Z | Permissibility of Wage Types per Infotype | MOLGA |
| PA0859 | LGA10 | PA0859 | LGA10 | T512Z | Permissibility of Wage Types per Infotype | LGART |
| PA0859 | LGA10 | * | T512Z | Permissibility of Wage Types per Infotype | ENDDA | |
| PA0859 | PERNR | SYST | MANDT | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
| PA0859 | PERNR | PA0859 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
| PA0859 | POSNR | PA0859 | VBELN | VBUP | Sales Document: Item Status | VBELN |
| PA0859 | POSNR | PA0859 | POSNR | VBUP | Sales Document: Item Status | POSNR |
| PA0859 | POSNR | SYST | MANDT | VBUP | Sales Document: Item Status | MANDT |
| PA0859 | PREAS | SYST | MANDT | T530E | Reasons for Changes | MANDT |
| PA0859 | PREAS | PSKEY | INFTY | T530E | Reasons for Changes | INFTY |
| PA0859 | PREAS | PA0859 | PREAS | T530E | Reasons for Changes | PREAS |
| PA0859 | VBELN | SYST | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| PA0859 | VBELN | PA0859 | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| PA0859 | WRK_COUNTRY | SYST | MANDT | T005 | Countries | MANDT |
| PA0859 | WRK_COUNTRY | PA0859 | WRK_COUNTRY | T005 | Countries | LAND1 |
