- Home
- Resources
- SAP Tables
- HCMT_BSP_PA_IT_R0021 - Family (0021) Italy
SAP Table HCMT_BSP_PA_IT_R0021
Family (0021) Italy
HCMT_BSP_PA_IT_R0021 (Family (0021) Italy) 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_IT_R0021 to other SAP tables.
Source: HCMT_BSP_PA_IT_R0021 (Family (0021) Italy)
HCMT_BSP_PA_IT_R0021 table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| OBJECT_KEY |
HCM Object Key |
HCM_OBJECT_KEY |
|
CHAR |
|
100 |
0 |
|
| PERNR |
Personnel Number |
PERNR_D |
|
NUMC |
|
8 |
0 |
|
| AEDTM |
Changed On |
AEDAT |
|
DATS |
|
8 |
0 |
|
| UNAME |
Name of Person Who Changed Object |
AENAM |
|
CHAR |
|
12 |
0 |
|
| SPRPS |
Lock Indicator for HR Master Data Record |
SPRPS |
|
CHAR |
|
1 |
0 |
|
| SPRTX |
Lock indicator for HR master record (text) |
SPRPSTEXT |
|
CHAR |
|
40 |
0 |
|
| ITBLD |
Infotype Screen Control |
ITBLD |
|
CHAR |
|
2 |
0 |
|
| BEGDA |
Valid-From Date |
PAD_BEGDA |
|
DATS |
|
8 |
0 |
|
| ENDDA |
Valid To Date |
PAD_ENDDA |
|
DATS |
|
8 |
0 |
|
| FAMSA |
Type of Family Record |
FAMSA |
|
CHAR |
|
4 |
0 |
|
| STEXT |
Name of Subtype |
SBTTX |
|
CHAR |
|
40 |
0 |
|
| OBJTX |
Object number text |
PAD_OBJTX |
|
CHAR |
|
12 |
0 |
|
| OBJPS |
Object Identification |
OBJPS |
|
CHAR |
|
2 |
0 |
|
| FANAM |
Last Name |
PAD_NACHN |
|
CHAR |
|
40 |
0 |
|
| FKNZN |
Name Format Indicator for Employee in a List |
KNZNM |
|
NUMC |
|
2 |
0 |
|
| FAVOR |
First Name |
PAD_VORNA |
|
CHAR |
|
40 |
0 |
|
| CFCFM |
Tax payer's ref. no. of the family member |
P15_CFCFM |
|
CHAR |
|
16 |
0 |
|
| FNMZU |
Other Title |
NAMZU |
T535N
|
CHAR |
|
15 |
0 |
|
| FINIT |
Initials |
INITS |
|
CHAR |
|
10 |
0 |
|
| FGBNA |
Name at Birth |
PAD_NAME2 |
|
CHAR |
|
40 |
0 |
|
| SPERD |
Percentage due to heirs |
P15_SPERD |
|
DEC |
|
5 |
2 |
|
| SETFR |
Percentage due to heirs for severance indemnity |
P15_SETFR |
|
DEC |
|
5 |
2 |
|
| FGBDT |
Date of Birth |
GBDAT |
|
DATS |
|
8 |
0 |
|
| FGBLD |
Country of Birth |
GBLND |
T005
|
CHAR |
|
3 |
0 |
|
| FGBOT |
Birthplace |
PAD_GBORT |
|
CHAR |
|
40 |
0 |
|
| FANAT |
Nationality |
NATSL |
T005
|
CHAR |
|
3 |
0 |
|
| FGDEP |
State |
GBDEP |
T005S
|
CHAR |
|
3 |
0 |
|
| BEZEI |
Description |
BEZEI20 |
|
CHAR |
|
20 |
0 |
|
| FANA2 |
Second Nationality |
NATS2 |
T005
|
CHAR |
|
3 |
0 |
|
| FANA3 |
Third Nationality |
NATS3 |
T005
|
CHAR |
|
3 |
0 |
|
| FASEX |
Gender Key |
GESCH |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
unknown |
| 1 |
Male |
| 2 |
Female |
|
| PRCT1 |
Percentage |
PAD_PRCNT |
|
CHAR |
|
1 |
0 |
Possible values
|
| PRCT2 |
Percentage |
PAD_PRCNT |
|
CHAR |
|
1 |
0 |
Possible values
|
| SOSPE |
Flag for Maintenance Beneficiary |
P15_SOSP |
|
CHAR |
|
1 |
0 |
Possible values
|
| MSDTR |
Deduction measure |
P15_MSDTR |
|
DEC |
|
5 |
2 |
|
| SOSTC |
Substitution of Spouse |
P15_SOST |
|
CHAR |
|
1 |
0 |
Possible values
|
| MITAN |
Inferior than three Years |
P15_MTAN |
|
CHAR |
|
1 |
0 |
Possible values
|
| PHNDC |
Severly Challenged Person |
P15_PHND |
|
CHAR |
|
1 |
0 |
Possible values
|
| RECOM |
Total income |
P15_RECOM |
|
CURR |
|
12 |
2 |
|
| REDIP |
Direct employment income |
P15_REDIP |
|
CURR |
|
12 |
2 |
|
| CFANF |
Family member indicator (FM) for family allowance |
P15_CFANF |
|
CHAR |
|
2 |
0 |
|
| CFDTR |
Family member indicator (FM) for tax deduction (TXD) |
P15_CFDTR |
|
CHAR |
|
2 |
0 |
|
| FGDEX |
State |
GBDEP |
|
CHAR |
|
3 |
0 |
|
| RELDT |
Relevant for Deduction |
P15_RELDT |
|
CHAR |
|
1 |
0 |
Possible values
|
| WAERS |
Currency Key |
WAERS |
|
CUKY |
|
5 |
0 |
|
| TXMUN |
Municipality code description |
P15_TXMUN |
|
CHAR |
|
40 |
0 |
|
| MUNIC |
Municipality key |
P15_MUNIC |
|
CHAR |
|
8 |
0 |
|
HCMT_BSP_PA_IT_R0021 foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| HCMT_BSP_PA_IT_R0021 |
FANA2 |
SYST |
MANDT |
T005 |
Countries |
MANDT |
| HCMT_BSP_PA_IT_R0021 |
FANA2 |
HCMT_BSP_PA_IT_R0021 |
FANA2 |
T005 |
Countries |
LAND1 |
| HCMT_BSP_PA_IT_R0021 |
FANA3 |
SYST |
MANDT |
T005 |
Countries |
MANDT |
| HCMT_BSP_PA_IT_R0021 |
FANA3 |
HCMT_BSP_PA_IT_R0021 |
FANA3 |
T005 |
Countries |
LAND1 |
| HCMT_BSP_PA_IT_R0021 |
FANAT |
SYST |
MANDT |
T005 |
Countries |
MANDT |
| HCMT_BSP_PA_IT_R0021 |
FANAT |
HCMT_BSP_PA_IT_R0021 |
FANAT |
T005 |
Countries |
LAND1 |
| HCMT_BSP_PA_IT_R0021 |
FGBLD |
SYST |
MANDT |
T005 |
Countries |
MANDT |
| HCMT_BSP_PA_IT_R0021 |
FGBLD |
HCMT_BSP_PA_IT_R0021 |
FGBLD |
T005 |
Countries |
LAND1 |
| HCMT_BSP_PA_IT_R0021 |
FGDEP |
SYST |
MANDT |
T005S |
Taxes: Region (Province) Key |
MANDT |
| HCMT_BSP_PA_IT_R0021 |
FGDEP |
HCMT_BSP_PA_IT_R0021 |
FGBLD |
T005S |
Taxes: Region (Province) Key |
LAND1 |
| HCMT_BSP_PA_IT_R0021 |
FGDEP |
HCMT_BSP_PA_IT_R0021 |
FGDEP |
T005S |
Taxes: Region (Province) Key |
BLAND |
| HCMT_BSP_PA_IT_R0021 |
FNMZU |
SYST |
MANDT |
T535N |
Name affixes |
MANDT |
| HCMT_BSP_PA_IT_R0021 |
FNMZU |
'Z' |
|
T535N |
Name affixes |
ART |
| HCMT_BSP_PA_IT_R0021 |
FNMZU |
HCMT_BSP_PA_IT_R0021 |
FNMZU |
T535N |
Name affixes |
TITEL |
