SAP Table HCMT_BSP_PA_IN_R0002
Single Screen for Infotype 0002
HCMT_BSP_PA_IN_R0002 (Single Screen for Infotype 0002) 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_IN_R0002 to other SAP tables.
HCMT_BSP_PA_IN_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 | ||||||||
ANREX | Form of address text | ANREX | CHAR | 5 | 0 | |||||||||
KNZNM | Name Format Indicator for Employee in a List | PAD_KNZNM | NUMC | 2 | 0 | |||||||||
KNZNMTEXT | Short Description of Repository Objects | AS4TEXT | CHAR | 60 | 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 | |||||||||
VORSW | Name Prefix | VORSW | T535N | CHAR | 15 | 0 | ||||||||
VORS2 | Name prefix for name at birth | PAD_UI_VORS2 | T535N | CHAR | 15 | 0 | ||||||||
TITEL | Title | TITEL | T535N | CHAR | 15 | 0 | ||||||||
TITL2 | Second Title | PAD_TITL2 | T535N | CHAR | 15 | 0 | ||||||||
NAMZU | Other Title | NAMZU | T535N | CHAR | 15 | 0 | ||||||||
NAMZ2 | Name affix for name at birth | PAD_UI_NAMZ2 | CHAR | 15 | 0 | |||||||||
RUFNM | Nickname | PAD_RUFNM | CHAR | 40 | 0 | |||||||||
GBDAT | Date of Birth | PAD_GBDAT | DATS | 8 | 0 | |||||||||
SPRSL | Communication Language | PAD_SPRAS | T002 | LANG | 1 | 0 | ||||||||
SPTXT | Name of Language | SPTXT | CHAR | 16 | 0 | |||||||||
GBORT | Birthplace | PAD_GBORT | CHAR | 40 | 0 | |||||||||
FAMST | Marital Status Key | FAMST | T502T | CHAR | 1 | 0 | ||||||||
FATXT | Marital Status | FATXT | CHAR | 6 | 0 | |||||||||
GBLND | Country of Birth | PAD_GBLND | T005 | CHAR | 3 | 0 | ||||||||
LANDX | Country Name | LANDX | CHAR | 15 | 0 | |||||||||
FAMDT | Valid From Date of Current Marital Status | FAMDT | DATS | 8 | 0 | |||||||||
GBDEP | State | GBDEP | T005S | CHAR | 3 | 0 | ||||||||
BEZEI | Description | BEZEI20 | CHAR | 20 | 0 | |||||||||
ANZKD | Number of Children | ANZKD | DEC | 3 | 0 | |||||||||
NATIO | Nationality | NATSL | T005 | CHAR | 3 | 0 | ||||||||
NATTX | Nationality (long text) | NATTX | CHAR | 15 | 0 | |||||||||
KONFE | Religious Denomination Key | KONFE | T516T | CHAR | 2 | 0 | ||||||||
KITXT | Religious Denomination | KITXT | CHAR | 4 | 0 | |||||||||
NATI2 | Second Nationality | PAD_NATS2 | T005 | CHAR | 3 | 0 | ||||||||
NA2TX | Nationality (long text) | NATTX | CHAR | 15 | 0 | |||||||||
NATI3 | Third Nationality | PAD_NATS3 | T005 | CHAR | 3 | 0 | ||||||||
NA3TX | Nationality (long text) | NATTX | CHAR | 15 | 0 | |||||||||
FORMATTED_NAME | Formatted Name | PAD_FORMATTED_NAME | CHAR | 40 | 0 | |||||||||
KONFE_DESCR | Religious Denomination Long Text | KNFTX | CHAR | 25 | 0 | |||||||||
GESCH | Gender Key | GESCH | CHAR | 1 | 0 |
Possible values
|
||||||||
PERID | Occupation Identifier | PIN_UI_PERID | CHAR | 20 | 0 | |||||||||
MIDNM | Middle Name | PAD_MIDNM | CHAR | 40 | 0 | |||||||||
GESCHTXT | Business area description | GTEXT | CHAR | 30 | 0 | |||||||||
NATIO50 | Nationality (Max. 50 Characters) | NATIO50 | CHAR | 50 | 0 |
HCMT_BSP_PA_IN_R0002 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
HCMT_BSP_PA_IN_R0002 | ANRED | SYST | MANDT | T522G | Title Keys | MANDT |
HCMT_BSP_PA_IN_R0002 | ANRED | HCMT_BSP_PA_IN_R0002 | ANRED | T522G | Title Keys | ANRED |
HCMT_BSP_PA_IN_R0002 | FAMST | SYST | MANDT | T502T | Marital Status Designators | MANDT |
HCMT_BSP_PA_IN_R0002 | FAMST | SYST | LANGU | T502T | Marital Status Designators | SPRSL |
HCMT_BSP_PA_IN_R0002 | FAMST | HCMT_BSP_PA_IN_R0002 | FAMST | T502T | Marital Status Designators | FAMST |
HCMT_BSP_PA_IN_R0002 | GBDEP | HCMT_BSP_PA_IN_R0002 | GBLND | T005S | Taxes: Region (Province) Key | LAND1 |
HCMT_BSP_PA_IN_R0002 | GBDEP | HCMT_BSP_PA_IN_R0002 | GBDEP | T005S | Taxes: Region (Province) Key | BLAND |
HCMT_BSP_PA_IN_R0002 | GBDEP | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
HCMT_BSP_PA_IN_R0002 | GBLND | SYST | MANDT | T005 | Countries | MANDT |
HCMT_BSP_PA_IN_R0002 | GBLND | HCMT_BSP_PA_IN_R0002 | GBLND | T005 | Countries | LAND1 |
HCMT_BSP_PA_IN_R0002 | KONFE | SYST | LANGU | T516T | Religious Denomination Texts | SPRSL |
HCMT_BSP_PA_IN_R0002 | KONFE | HCMT_BSP_PA_IN_R0002 | KONFE | T516T | Religious Denomination Texts | KONFE |
HCMT_BSP_PA_IN_R0002 | KONFE | SYST | MANDT | T516T | Religious Denomination Texts | MANDT |
HCMT_BSP_PA_IN_R0002 | NAMZU | 'Z' | T535N | Name affixes | ART | |
HCMT_BSP_PA_IN_R0002 | NAMZU | HCMT_BSP_PA_IN_R0002 | NAMZU | T535N | Name affixes | TITEL |
HCMT_BSP_PA_IN_R0002 | NAMZU | SYST | MANDT | T535N | Name affixes | MANDT |
HCMT_BSP_PA_IN_R0002 | NATI2 | SYST | MANDT | T005 | Countries | MANDT |
HCMT_BSP_PA_IN_R0002 | NATI2 | HCMT_BSP_PA_IN_R0002 | NATI2 | T005 | Countries | LAND1 |
HCMT_BSP_PA_IN_R0002 | NATI3 | SYST | MANDT | T005 | Countries | MANDT |
HCMT_BSP_PA_IN_R0002 | NATI3 | HCMT_BSP_PA_IN_R0002 | NATI3 | T005 | Countries | LAND1 |
HCMT_BSP_PA_IN_R0002 | NATIO | SYST | MANDT | T005 | Countries | MANDT |
HCMT_BSP_PA_IN_R0002 | NATIO | HCMT_BSP_PA_IN_R0002 | NATIO | T005 | Countries | LAND1 |
HCMT_BSP_PA_IN_R0002 | SPRSL | HCMT_BSP_PA_IN_R0002 | SPRSL | T002 | Language Keys (Component BC-I18) | SPRAS |
HCMT_BSP_PA_IN_R0002 | TITEL | SYST | MANDT | T535N | Name affixes | MANDT |
HCMT_BSP_PA_IN_R0002 | TITEL | 'T' | T535N | Name affixes | ART | |
HCMT_BSP_PA_IN_R0002 | TITEL | HCMT_BSP_PA_IN_R0002 | TITEL | T535N | Name affixes | TITEL |
HCMT_BSP_PA_IN_R0002 | TITL2 | SYST | MANDT | T535N | Name affixes | MANDT |
HCMT_BSP_PA_IN_R0002 | TITL2 | 'S' | T535N | Name affixes | ART | |
HCMT_BSP_PA_IN_R0002 | TITL2 | HCMT_BSP_PA_IN_R0002 | TITL2 | T535N | Name affixes | TITEL |
HCMT_BSP_PA_IN_R0002 | VORS2 | SYST | MANDT | T535N | Name affixes | MANDT |
HCMT_BSP_PA_IN_R0002 | VORS2 | 'V' | T535N | Name affixes | ART | |
HCMT_BSP_PA_IN_R0002 | VORS2 | HCMT_BSP_PA_IN_R0002 | VORS2 | T535N | Name affixes | TITEL |
HCMT_BSP_PA_IN_R0002 | VORSW | SYST | MANDT | T535N | Name affixes | MANDT |
HCMT_BSP_PA_IN_R0002 | VORSW | 'V' | T535N | Name affixes | ART | |
HCMT_BSP_PA_IN_R0002 | VORSW | HCMT_BSP_PA_IN_R0002 | VORSW | T535N | Name affixes | TITEL |