SAP Table HCMT_BSP_PA_ID_R0021 (ID family data)

Field Description Data Type Length Decimals Checktable Data Element
OBJECT_KEY HCM Object Key CHAR 100 0 HCM_OBJECT_KEY
PERNR Personnel Number NUMC 8 0 PERNR_D
AEDTM Last Changed On DATS 8 0 AEDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
SPRPS Lock Indicator for HR Master Data Record CHAR 1 0 SPRPS
SPRTX Lock indicator for HR master record (text) CHAR 40 0 SPRPSTEXT
ITBLD Infotype Screen Control CHAR 2 0 ITBLD
ITXEX Text Exists for Infotype CHAR 1 0 ITXEX
BEGDA Valid-From Date DATS 8 0 PAD_BEGDA
ENDDA Valid To Date DATS 8 0 PAD_ENDDA
INFTX Infotype text CHAR 132 0 INFTX
FAMSA Type of Family Record CHAR 4 0 FAMSA
STEXT Name of Subtype CHAR 40 0 SBTTX
OBJPS Object Identification CHAR 2 0 OBJPS
FCNAM Complete Name CHAR 80 0 PAD_CNAME
TITEL Title CHAR 15 0 T535N TITEL
FNMZU Other Title CHAR 15 0 T535N NAMZU
FKNZN Name Format Indicator for Employee in a List NUMC 2 0 KNZNM
ENAME Name of referenced personnel number CHAR 40 0 FEDNM
FGBOT Birthplace CHAR 40 0 PAD_GBORT
FGBDT Date of Birth DATS 8 0 GBDAT
FANAT Nationality CHAR 3 0 T005 NATSL
NATTX Nationality CHAR 15 0 NATIO
FGBLD Country/Region of Birth CHAR 3 0 T005 GBLND
LNDTX Name of Country/Region (Short) CHAR 15 0 LANDX
IDTYP Identity Type CHAR 3 0 PID_IDTYP
IDDES Description CHAR 38 0 PID_DESCR
MARCT Marriage certificate CHAR 25 0 PID_MARCT
JOBTL Job Title CHAR 25 0 STLTX
DEPTX Dependent for Tax purposes (Yes/No) (Indonesia) CHAR 1 0 PID_DEPTX
SPEMS Employer of family member (Indonesia) CHAR 40 0 PID_SPEMS
KDZUG Child bonuses CHAR 2 0 T577 PID_UI_KDZUG
KNDTX Text (20 Characters) CHAR 20 0 TEXT20
GESC2 Gender Key CHAR 1 0 GESCH
unknown
1 Male
2 Female
FAVOR First Name CHAR 40 0 PAD_VORNA
DEPDP BPJS Health Insurance Dependent Type CHAR 1 0 PID_DEPDP
A Additional Dependent
S Standard Dependent
BPJSI BPJS ID CHAR 13 0 P34_BPJSI
BECLS Benefit Class for BPJS NUMC 1 0 P34_BECLS
1 Class 1
2 Class 2
3 Class 3
IDNUM Identity Card Number CHAR 30 0 PID_IDNUM
IDCTY Type of Identity Card (Indonesia) CHAR 5 0 PID_IDCTY
IDDAT Date of Issue of Identity Card (Indonesia) DATS 8 0 PID_IDDAT
IDEXP Expiry Date of Identity Card (Indonesia) DATS 8 0 PID_IDEXP
IDPLA Place of Issue of Identity Card CHAR 30 0 PID_IDPLA
TELNR Telephone Number CHAR 14 0 TELNR
STRAS Street and House Number CHAR 30 0 STRAS
LOCAT 2nd Address Line CHAR 30 0 LOCAT
ORT01 City CHAR 25 0 ORT01
PSTLZ Postal Code CHAR 10 0 PSTLZ_HR
ORT02 District CHAR 25 0 ORT02
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
LAND101 Name of Country/Region (Short) CHAR 15 0 LANDX
PASNR Passport Number CHAR 30 0 PID_PASNR
PASTY Passport Type CHAR 20 0 PID_PASTY
ISSUE Date of issue of Passport (Indonesia) DATS 8 0 PID_ISSUE
EXPIR Date of expiry of Passport (Indonesia) DATS 8 0 PID_EXPIR
PLACE Place of Issue of Passport CHAR 25 0 PID_PLACE
CNTRY Country/Region Key CHAR 3 0 T005 LAND1
CNTRY01 Name of Country/Region (Short) CHAR 15 0 LANDX
SETXT Selection version description CHAR 40 0 SETXT

HCMT_BSP_PA_ID_R0021 foreign key relationships

Table Field Check Table Check Field
0 HCMT_BSP_PA_ID_R0021 CNTRY T005 Countries MANDT
0 HCMT_BSP_PA_ID_R0021 CNTRY T005 Countries LAND1
1 HCMT_BSP_PA_ID_R0021 FANAT T005 Countries MANDT
1 HCMT_BSP_PA_ID_R0021 FANAT T005 Countries LAND1
0 HCMT_BSP_PA_ID_R0021 FGBLD T005 Countries MANDT
0 HCMT_BSP_PA_ID_R0021 FGBLD T005 Countries LAND1
1 HCMT_BSP_PA_ID_R0021 FNMZU T535N Name affixes MANDT
1 HCMT_BSP_PA_ID_R0021 FNMZU T535N Name affixes ART
1 HCMT_BSP_PA_ID_R0021 FNMZU T535N Name affixes TITEL
0 HCMT_BSP_PA_ID_R0021 KDZUG T577 Family Characteristics MANDT
0 HCMT_BSP_PA_ID_R0021 KDZUG T577 Family Characteristics MOLGA
0 HCMT_BSP_PA_ID_R0021 KDZUG T577 Family Characteristics EIGSH
1 HCMT_BSP_PA_ID_R0021 LAND1 T005 Countries MANDT
1 HCMT_BSP_PA_ID_R0021 LAND1 T005 Countries LAND1
0 HCMT_BSP_PA_ID_R0021 TITEL T535N Name affixes MANDT
0 HCMT_BSP_PA_ID_R0021 TITEL T535N Name affixes ART
0 HCMT_BSP_PA_ID_R0021 TITEL T535N Name affixes TITEL