SAP Table Q0106
Screen Fields: Infotype 0106 (Related Persons - NA)
Q0106 (Screen Fields: 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 Q0106 to other SAP tables.
Q0106 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||
| LANDX | Country Name | LANDX | CHAR | 15 | 0 | |||||||
| AREAC | Telephone number area code | AREAC | NUMC | 3 | 0 | |||||||
| FTEXT | Marital Status | FATXT | CHAR | 6 | 0 | |||||||
Q0106 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| Q0106 | FAMST | SYST | MANDT | T502T | Marital Status Designators | MANDT |
| Q0106 | FAMST | SYST | LANGU | T502T | Marital Status Designators | SPRSL |
| Q0106 | FAMST | Q0106 | FAMST | T502T | Marital Status Designators | FAMST |
| Q0106 | LAND1 | SYST | MANDT | T005 | Countries | MANDT |
| Q0106 | LAND1 | Q0106 | LAND1 | T005 | Countries | LAND1 |
| Q0106 | PMRES | SYST | MANDT | T5R03 | Residency type | MANDT |
| Q0106 | PMRES | T001P | MOLGA | T5R03 | Residency type | MOLGA |
| Q0106 | PMRES | Q0106 | PMRES | T5R03 | Residency type | PMRES |
| Q0106 | RACKY | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
| Q0106 | RACKY | Q0106 | RACKY | T505R | Ethnic Origin | RACKY |
| Q0106 | RACKY | SYST | MANDT | T505R | Ethnic Origin | MANDT |
| Q0106 | STATE | Q0106 | STATE | T005S | Taxes: Region (Province) Key | BLAND |
| Q0106 | STATE | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| Q0106 | STATE | Q0106 | LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
