SAP Table P0106
HR Master Record: Infotype 0106 (Related Persons NA)
P0106 (HR Master Record: Infotype 0106 (Related Persons NA)) 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 P0106 to other SAP tables.
P0106 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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 | |||||||
| PERMO | Modifier for Personnel Identifier | PIDMO | CHAR | 2 | 0 | |||||||
| PERID | Personnel ID Number | PRDNI | CHAR | 20 | 0 | |||||||
| BEN01 | Not Used | BEN01 | CHAR | 1 | 0 |
Possible values
|
||||||
| BEN02 | Not Used | BEN02 | CHAR | 1 | 0 |
Possible values
|
||||||
| BEN03 | Student Indicator | BEN03 | CHAR | 1 | 0 |
Possible values
|
||||||
| BEN04 | COBRA Indicator | BEN04 | CHAR | 1 | 0 |
Possible values
|
||||||
| BEN05 | Smoker Indicator | BEN05 | CHAR | 1 | 0 | |||||||
| STRAS | House number and street | STRAS | CHAR | 30 | 0 | |||||||
| LOCAT | House number and street | STRAS | CHAR | 30 | 0 | |||||||
| ORT01 | City | ORT01 | CHAR | 25 | 0 | |||||||
| STATE | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||
| PSTLZ | Postal Code | PSTLZ | CHAR | 10 | 0 | |||||||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||
| TELNR | Telephone Number | TELNR | CHAR | 14 | 0 | |||||||
| SEPDT | Legal Separation Date | SEPDT | DATS | 8 | 0 | |||||||
| DOCNM | Benefit Physician Name | BEN_DOCNAM | CHAR | 30 | 0 | |||||||
| DOCID | Benefit Physician ID | BEN_DOCID | CHAR | 20 | 0 | |||||||
| DOCN2 | Benefit Physician Name | BEN_DOCNAM | CHAR | 30 | 0 | |||||||
| DOCI2 | Benefit Physician ID | BEN_DOCID | CHAR | 20 | 0 | |||||||
| DISAB | Disability | DISABTY | CHAR | 1 | 0 |
Possible values
|
||||||
| DISDT | Date of Determination of Disability Status | DISDT | DATS | 8 | 0 | |||||||
| DISLE | Date Employer Learned of Disability Status | DISLE | DATS | 8 | 0 | |||||||
| DEPIN | Benefit dependent indicator | BEN_DEPIN | CHAR | 1 | 0 |
Possible values
|
||||||
| MEDIC | Benefit Indicator for Medicare | BEN_MEDIC | CHAR | 1 | 0 |
Possible values
|
||||||
| SMOKE | Benefit smoker indicator | BEN_SMOKER | CHAR | 1 | 0 | |||||||
| FAMST | Marital Status Key | FAMST | T502T | CHAR | 1 | 0 | ||||||
| PROVI | Benefit identification number for the provider | BEN_PROVID | CHAR | 20 | 0 | |||||||
| POLNR | Benefit policy number | BEN_POLNR | CHAR | 20 | 0 | |||||||
| TAXNB | Tax ID | TAXID | CHAR | 15 | 0 | |||||||
| PMRES | Residency type | PMRES | T5R03 | CHAR | 2 | 0 | ||||||
| RACKY | Ethnic origin | RACKY | T505R | CHAR | 2 | 0 | ||||||
| SPEMS | Spouse employment status | SPEMS | CHAR | 1 | 0 |
Possible values
|
||||||
| MILSV | Benefits Indicator: Person is on Military Service | BEN_MILSV | CHAR | 1 | 0 |
Possible values
|
||||||
| FININ | Benefits Indicator: Person is Financially Independent | BEN_FININ | CHAR | 1 | 0 |
Possible values
|
||||||
| NONTX | Benefits Indicator: Person is Non-Taxable | BEN_NONTX | CHAR | 1 | 0 |
Possible values
|
||||||
| PMADT | Date of providing Proof of Medical Absence | BEN_PMADT | DATS | 8 | 0 | |||||||
| LEGID | Proof Submission Indicator for Legal Dependents | BEN_LEGID | CHAR | 1 | 0 | |||||||
| LEGDT | Proof Submission Date for Legal Dependents | BEN_LEGDT | DATS | 8 | 0 | |||||||
P0106 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P0106 | FAMST | SYST | MANDT | T502T | Marital Status Designators | MANDT |
| P0106 | FAMST | SYST | LANGU | T502T | Marital Status Designators | SPRSL |
| P0106 | FAMST | P0106 | FAMST | T502T | Marital Status Designators | FAMST |
| P0106 | INFTY | SYST | MANDT | T582A | Infotypes: Customer-Specific Settings | MANDT |
| P0106 | INFTY | P0106 | INFTY | T582A | Infotypes: Customer-Specific Settings | INFTY |
| P0106 | LAND1 | SYST | MANDT | T005 | Countries | MANDT |
| P0106 | LAND1 | P0106 | LAND1 | T005 | Countries | LAND1 |
| P0106 | PMRES | P0106 | PMRES | T5R03 | Residency type | PMRES |
| P0106 | PMRES | SYST | MANDT | T5R03 | Residency type | MANDT |
| P0106 | PMRES | T001P | MOLGA | T5R03 | Residency type | MOLGA |
| P0106 | PREAS | P0106 | PREAS | T530E | Reasons for Changes | PREAS |
| P0106 | PREAS | SYST | MANDT | T530E | Reasons for Changes | MANDT |
| P0106 | PREAS | P0106 | INFTY | T530E | Reasons for Changes | INFTY |
| P0106 | RACKY | SYST | MANDT | T505R | Ethnic Origin | MANDT |
| P0106 | RACKY | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
| P0106 | RACKY | P0106 | RACKY | T505R | Ethnic Origin | RACKY |
| P0106 | STATE | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| P0106 | STATE | P0106 | LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
| P0106 | STATE | P0106 | STATE | T005S | Taxes: Region (Province) Key | BLAND |
