SAP ABAP Table HCMT_BSP_PA_SG_R0002 (Single Screen for Infotype 0002 (Personal Data - Singapore))
Hierarchy
☛
EA-HRCSG (Software Component) Sub component EA-HRCSG of EA-HR
⤷ PA-PA-SG (Application Component) Singapore
⤷ PAOC_PAD_UI_INFTY_0002_SG (Package) Layout for 0002(singapore)
⤷ PA-PA-SG (Application Component) Singapore
⤷ PAOC_PAD_UI_INFTY_0002_SG (Package) Layout for 0002(singapore)
Basic Data
Table Category | INTTAB | Structure |
Structure | HCMT_BSP_PA_SG_R0002 | Table Relationship Diagram |
Short Description | Single Screen for Infotype 0002 (Personal Data - Singapore) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | OBJECT_KEY | HCM_OBJECT_KEY | CHAR | 100 | 0 | HCM Object Key | |||
2 | .INCLUDE | 0 | 0 | Header Fields of an Infotype Version | |||||
3 | .INCLUDE | 0 | 0 | Header Fields of an Infotype Version | |||||
4 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
5 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
6 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
7 | SPRPS | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
8 | SPRTX | SPRPSTEXT | SPRPSTEXT | CHAR | 40 | 0 | Lock indicator for HR master record (text) | ||
9 | ITBLD | ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
10 | BEGDA | PAD_BEGDA | DATUM | DATS | 8 | 0 | Valid-From Date | ||
11 | ENDDA | PAD_ENDDA | DATUM | DATS | 8 | 0 | Valid To Date | ||
12 | ANRED | ANRDE | ANRDE | CHAR | 1 | 0 | Form-of-Address Key | * | |
13 | ANREX | ANREX | ANREX | CHAR | 5 | 0 | Form of address text | ||
14 | KNZNM | KNZNM | KNZN2 | NUMC | 2 | 0 | Name Format Indicator for Employee in a List | ||
15 | KNZNMTEXT | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
16 | VORNA | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
17 | NAME2 | PAD_NAME2 | PAD_NACHN | CHAR | 40 | 0 | Name at Birth | ||
18 | NACHN | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
19 | VORSW | VORSW | TITEL | CHAR | 15 | 0 | Name Prefix | T535N | |
20 | TITEL | TITEL | TITEL | CHAR | 15 | 0 | Title | T535N | |
21 | RUFNM | PAD_RUFNM | PAD_VORNM | CHAR | 40 | 0 | Nickname | ||
22 | ENAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
23 | PERID | PRDNI | CHAR20 | CHAR | 20 | 0 | Personnel ID Number | ||
24 | GBDAT | GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
25 | GBORT | PAD_GBORT | PAD_ORT01 | CHAR | 40 | 0 | Birthplace | ||
26 | SPRSL | PAD_SPRAS | SPRAS | LANG | 1 | 0 | Communication Language | T002 | |
27 | GBLND | GBLND | LAND1 | CHAR | 3 | 0 | Country of Birth | T005 | |
28 | NATIO | NATSL | LAND1 | CHAR | 3 | 0 | Nationality | T005 | |
29 | KONFE | KONFE | KONFE | CHAR | 2 | 0 | Religious Denomination Key | T516T | |
30 | KITXT | KITXT | KITXT | CHAR | 4 | 0 | Religious Denomination | ||
31 | NATI2 | NATS2 | LAND1 | CHAR | 3 | 0 | Second Nationality | T005 | |
32 | FAMST | FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | T502T | |
33 | FAMDT | FAMDT | DATUM | DATS | 8 | 0 | Valid From Date of Current Marital Status | ||
34 | NATI3 | NATS3 | LAND1 | CHAR | 3 | 0 | Third Nationality | T005 | |
35 | ANZKD | ANZKD | DEC03 | DEC | 3 | 0 | Number of Children | ||
36 | GESCH | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
37 | FATXT | FATXT | FATXT | CHAR | 6 | 0 | Marital Status | ||
38 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HCMT_BSP_PA_SG_R0002 | FAMST | T502T | FAMST | |||
2 | HCMT_BSP_PA_SG_R0002 | GBLND | T005 | LAND1 | |||
3 | HCMT_BSP_PA_SG_R0002 | KONFE | T516T | KONFE | |||
4 | HCMT_BSP_PA_SG_R0002 | NATI2 | T005 | LAND1 | |||
5 | HCMT_BSP_PA_SG_R0002 | NATI3 | T005 | LAND1 | |||
6 | HCMT_BSP_PA_SG_R0002 | NATIO | T005 | LAND1 | |||
7 | HCMT_BSP_PA_SG_R0002 | SPRSL | T002 | SPRAS | |||
8 | HCMT_BSP_PA_SG_R0002 | TITEL | T535N | TITEL | |||
9 | HCMT_BSP_PA_SG_R0002 | VORSW | T535N | TITEL |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 100 |