1. Home
  2. Resources
  3. SAP Tables
  4. HCMT_BSP_PA_CA_R0106_VIEW - Subscreen infotype 0106 Add. Family Data Canada

SAP Table HCMT_BSP_PA_CA_R0106_VIEW

Subscreen infotype 0106 Add. Family Data Canada

HCMT_BSP_PA_CA_R0106_VIEW (Subscreen infotype 0106 Add. Family Data Canada) 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 HCMT_BSP_PA_CA_R0106_VIEW to other SAP tables.

HCMT_BSP_PA_CA_R0106_VIEW table fields

Field Data element Checktable Datatype Length Decimals
PERID FACE : Social Insurance Number P07_UI_SINNO CHAR 20 0
AREAC Telephone number area code AREAC NUMC 3 0
TELNR Telephone Number TELNR CHAR 14 0
STRAS House number and street STRAS CHAR 30 0
SEPDT Legal Separation Date SEPDT DATS 8 0
LOCAT House number and street STRAS CHAR 30 0
FAMST Marital Status Key FAMST T502T CHAR 1 0
FTEXT Marital Status FATXT CHAR 6 0
ORT01 City ORT01 CHAR 25 0
STATE Region (State, Province, County) REGIO T005S CHAR 3 0
BEZEI Description BEZEI20 CHAR 20 0
NONTX Benefits Indicator: Person is Non-Taxable BEN_NONTX CHAR 1 0
X Yes
NULL No
PSTLZ Postal Code PSTLZ CHAR 10 0
LAND1 Country Key LAND1 T005 CHAR 3 0
LANDX Country Name LANDX CHAR 15 0
DOCNM Benefit Physician Name BEN_DOCNAM CHAR 30 0
DISAB Person disabled DISAB CHAR 1 0
X Yes
NULL No
BEN03 Student Indicator BEN03 CHAR 1 0
X Yes
NULL No
DOCID Benefit Physician ID BEN_DOCID CHAR 20 0
DISDT Date of Determination of Disability Status DISDT DATS 8 0
SMOKE Benefit smoker indicator BEN_SMOKER CHAR 1 0
DOCN2 Benefit Physician Name BEN_DOCNAM CHAR 30 0
DISLE Date Employer Learned of Disability Status DISLE DATS 8 0
MILSV Benefits Indicator: Person is on Military Service BEN_MILSV CHAR 1 0
X Yes
NULL No
DOCI2 Benefit Physician ID BEN_DOCID CHAR 20 0
FININ Benefits Indicator: Person is Financially Independent BEN_FININ CHAR 1 0
X Yes
NULL No

HCMT_BSP_PA_CA_R0106_VIEW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
HCMT_BSP_PA_CA_R0106_VIEW FAMST SYST LANGU T502T Marital Status Designators SPRSL
HCMT_BSP_PA_CA_R0106_VIEW FAMST HCMT_BSP_PA_CA_R0106_VIEW FAMST T502T Marital Status Designators FAMST
HCMT_BSP_PA_CA_R0106_VIEW FAMST SYST MANDT T502T Marital Status Designators MANDT
HCMT_BSP_PA_CA_R0106_VIEW LAND1 HCMT_BSP_PA_CA_R0106_VIEW LAND1 T005 Countries LAND1
HCMT_BSP_PA_CA_R0106_VIEW LAND1 SYST MANDT T005 Countries MANDT
HCMT_BSP_PA_CA_R0106_VIEW STATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
HCMT_BSP_PA_CA_R0106_VIEW STATE HCMT_BSP_PA_CA_R0106_VIEW LAND1 T005S Taxes: Region (Province) Key LAND1
HCMT_BSP_PA_CA_R0106_VIEW STATE HCMT_BSP_PA_CA_R0106_VIEW STATE T005S Taxes: Region (Province) Key BLAND