SAP Table HCMT_BSP_PA_FI_R0002
Single Screen for Infotyp 0002 (Various Countries)
HCMT_BSP_PA_FI_R0002 (Single Screen for Infotyp 0002 (Various Countries)) 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_FI_R0002 to other SAP tables.
HCMT_BSP_PA_FI_R0002 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 | |||||||||
| ANRED | Form-of-Address Key | ANRDE | T522G | CHAR | 1 | 0 | ||||||||
| NACHN | Last Name | PAD_NACHN | CHAR | 40 | 0 | |||||||||
| NAME2 | Name at Birth | PAD_NAME2 | CHAR | 40 | 0 | |||||||||
| VORNA | First Name | PAD_VORNA | CHAR | 40 | 0 | |||||||||
| INITS | Initials | INITS | CHAR | 10 | 0 | |||||||||
| MIDNM | Middle Name | PAD_MIDNM | CHAR | 40 | 0 | |||||||||
| NACH2 | Second Name | PAD_NACH2 | CHAR | 40 | 0 | |||||||||
| VORSW | Name Prefix | VORSW | T535N | CHAR | 15 | 0 | ||||||||
| VORS2 | Second Name Prefix | VORS2 | T535N | CHAR | 15 | 0 | ||||||||
| TITEL | Title | TITEL | T535N | CHAR | 15 | 0 | ||||||||
| TITL2 | Second Title | TITL2 | T535N | CHAR | 15 | 0 | ||||||||
| NAMZU | Other Title | NAMZU | T535N | CHAR | 15 | 0 | ||||||||
| RUFNM | Nickname | PAD_RUFNM | CHAR | 40 | 0 | |||||||||
| KNZNM | Name Format Indicator for Employee in a List | KNZNM | NUMC | 2 | 0 | |||||||||
| ENAME | Formatted Name of Employee or Applicant | EMNAM | CHAR | 40 | 0 | |||||||||
| PERID_LABEL | Placeholder for UI Field | PAD_DUMMY | CHAR | 1 | 0 | |||||||||
| PERID | Personnel ID Number | PRDNI | CHAR | 20 | 0 | |||||||||
| GBDAT | Date of Birth | GBDAT | DATS | 8 | 0 | |||||||||
| GBORT | Birthplace | PAD_GBORT | CHAR | 40 | 0 | |||||||||
| GESCH | Gender Key | GESCH | CHAR | 1 | 0 |
Possible values
|
||||||||
| GBLND | Country of Birth | GBLND | T005 | CHAR | 3 | 0 | ||||||||
| GBDEP_LABEL | Screen label for IT0002 dynpro 2044 | P_CNT_IT0002_LABEL | CHAR | 12 | 0 | |||||||||
| GBDEP | State | GBDEP | T005S | CHAR | 3 | 0 | ||||||||
| NATIO | Nationality | NATSL | T005 | CHAR | 3 | 0 | ||||||||
| NATI2 | Second Nationality | NATS2 | T005 | CHAR | 3 | 0 | ||||||||
| NATI3 | Third Nationality | NATS3 | T005 | CHAR | 3 | 0 | ||||||||
| SPRSL | Communication Language | PAD_SPRAS | T002 | LANG | 1 | 0 | ||||||||
| FAMST | Marital Status Key | FAMST | CHAR | 1 | 0 | |||||||||
| FAMDT | Valid From Date of Current Marital Status | FAMDT | DATS | 8 | 0 | |||||||||
| ANZKD | Number of Children | ANZKD | DEC | 3 | 0 | |||||||||
| KONFE | Religious Denomination Key | KONFE | CHAR | 2 | 0 | |||||||||
| NATIOTX | Nationality (Max. 50 Characters) | NATIO50 | CHAR | 50 | 0 | |||||||||
| FATXT | Marital Status | FATXT | CHAR | 6 | 0 | |||||||||
| GESCHTX | Business area description | GTEXT | CHAR | 30 | 0 | |||||||||
HCMT_BSP_PA_FI_R0002 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| HCMT_BSP_PA_FI_R0002 | ANRED | SYST | MANDT | T522G | Title Keys | MANDT |
| HCMT_BSP_PA_FI_R0002 | ANRED | HCMT_BSP_PA_FI_R0002 | ANRED | T522G | Title Keys | ANRED |
| HCMT_BSP_PA_FI_R0002 | GBDEP | HCMT_BSP_PA_FI_R0002 | GBDEP | T005S | Taxes: Region (Province) Key | BLAND |
| HCMT_BSP_PA_FI_R0002 | GBDEP | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| HCMT_BSP_PA_FI_R0002 | GBDEP | HCMT_BSP_PA_FI_R0002 | GBLND | T005S | Taxes: Region (Province) Key | LAND1 |
| HCMT_BSP_PA_FI_R0002 | GBLND | SYST | MANDT | T005 | Countries | MANDT |
| HCMT_BSP_PA_FI_R0002 | GBLND | HCMT_BSP_PA_FI_R0002 | GBLND | T005 | Countries | LAND1 |
| HCMT_BSP_PA_FI_R0002 | NAMZU | HCMT_BSP_PA_FI_R0002 | NAMZU | T535N | Name affixes | TITEL |
| HCMT_BSP_PA_FI_R0002 | NAMZU | SYST | MANDT | T535N | Name affixes | MANDT |
| HCMT_BSP_PA_FI_R0002 | NAMZU | 'Z' | T535N | Name affixes | ART | |
| HCMT_BSP_PA_FI_R0002 | NATI2 | SYST | MANDT | T005 | Countries | MANDT |
| HCMT_BSP_PA_FI_R0002 | NATI2 | HCMT_BSP_PA_FI_R0002 | NATI2 | T005 | Countries | LAND1 |
| HCMT_BSP_PA_FI_R0002 | NATI3 | HCMT_BSP_PA_FI_R0002 | NATI3 | T005 | Countries | LAND1 |
| HCMT_BSP_PA_FI_R0002 | NATI3 | SYST | MANDT | T005 | Countries | MANDT |
| HCMT_BSP_PA_FI_R0002 | NATIO | SYST | MANDT | T005 | Countries | MANDT |
| HCMT_BSP_PA_FI_R0002 | NATIO | HCMT_BSP_PA_FI_R0002 | NATIO | T005 | Countries | LAND1 |
| HCMT_BSP_PA_FI_R0002 | SPRSL | HCMT_BSP_PA_FI_R0002 | SPRSL | T002 | Language Keys (Component BC-I18) | SPRAS |
| HCMT_BSP_PA_FI_R0002 | TITEL | SYST | MANDT | T535N | Name affixes | MANDT |
| HCMT_BSP_PA_FI_R0002 | TITEL | 'T' | T535N | Name affixes | ART | |
| HCMT_BSP_PA_FI_R0002 | TITEL | HCMT_BSP_PA_FI_R0002 | TITEL | T535N | Name affixes | TITEL |
| HCMT_BSP_PA_FI_R0002 | TITL2 | HCMT_BSP_PA_FI_R0002 | TITL2 | T535N | Name affixes | TITEL |
| HCMT_BSP_PA_FI_R0002 | TITL2 | SYST | MANDT | T535N | Name affixes | MANDT |
| HCMT_BSP_PA_FI_R0002 | TITL2 | 'S' | T535N | Name affixes | ART | |
| HCMT_BSP_PA_FI_R0002 | VORS2 | SYST | MANDT | T535N | Name affixes | MANDT |
| HCMT_BSP_PA_FI_R0002 | VORS2 | 'V' | T535N | Name affixes | ART | |
| HCMT_BSP_PA_FI_R0002 | VORS2 | HCMT_BSP_PA_FI_R0002 | VORS2 | T535N | Name affixes | TITEL |
| HCMT_BSP_PA_FI_R0002 | VORSW | 'V' | T535N | Name affixes | ART | |
| HCMT_BSP_PA_FI_R0002 | VORSW | HCMT_BSP_PA_FI_R0002 | VORSW | T535N | Name affixes | TITEL |
| HCMT_BSP_PA_FI_R0002 | VORSW | SYST | MANDT | T535N | Name affixes | MANDT |
