SAP ABAP Table HCMT_BSP_PA_TH_R0021 (Additional Family Data (Thailand))
Hierarchy
☛
EA-HRCTH (Software Component) Sub component EA-HRCTH of EA-HR
⤷ PA-PA-TH (Application Component) Thailand
⤷ PAOC_PAD_UI_INFTY_0021_TH (Package) PY-TH : Layout package for IT0021(view 187)
⤷ PA-PA-TH (Application Component) Thailand
⤷ PAOC_PAD_UI_INFTY_0021_TH (Package) PY-TH : Layout package for IT0021(view 187)
Basic Data
Table Category | INTTAB | Structure |
Structure | HCMT_BSP_PA_TH_R0021 | Table Relationship Diagram |
Short Description | Additional Family Data (Thailand) |
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 | .INCLUDE | 0 | 0 | Single Screen for Infotype 0021 | |||||
2 | OBJECT_KEY | HCM_OBJECT_KEY | CHAR | 100 | 0 | HCM Object Key | |||
3 | .INCLUDE | 0 | 0 | Header Fields of an Infotype Version | |||||
4 | .INCLUDE | 0 | 0 | Header Fields of an Infotype Version | |||||
5 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
6 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
7 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
8 | SPRPS | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
9 | SPRTX | SPRPSTEXT | SPRPSTEXT | CHAR | 40 | 0 | Lock indicator for HR master record (text) | ||
10 | ITBLD | ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
11 | BEGDA | PAD_BEGDA | DATUM | DATS | 8 | 0 | Valid-From Date | ||
12 | ENDDA | PAD_ENDDA | DATUM | DATS | 8 | 0 | Valid To Date | ||
13 | FAMSA | FAMSA | SUBTY | CHAR | 4 | 0 | Type of Family Record | ||
14 | STEXT | SBTTX | TEXT40 | CHAR | 40 | 0 | Name of Subtype | ||
15 | OBJTX | PAD_OBJTX | TEXT12 | CHAR | 12 | 0 | Object number text | ||
16 | OBJPS | OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
17 | OBJPS1 | PAD_UI_OBJPS1 | OBJPS | CHAR | 2 | 0 | Object Identification | ||
18 | OBJPS2 | PAD_UI_OBJPS2 | OBJPS | CHAR | 2 | 0 | Object Identification | ||
19 | FANAM | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
20 | FGBNA | PAD_NAME2 | PAD_NACHN | CHAR | 40 | 0 | Name at Birth | ||
21 | FAVOR | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
22 | FINIT | INITS | TEXT10 | CHAR | 10 | 0 | Initials | ||
23 | FNMZU | NAMZU | TITEL | CHAR | 15 | 0 | Other Title | T535N | |
24 | KNZNM | PAD_KNZNM | KNZN2 | NUMC | 2 | 0 | Name Format Indicator for Employee in a List | T522N | |
25 | KNZNMTEXT | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
26 | FVRSW | VORSW | TITEL | CHAR | 15 | 0 | Name Prefix | T535N | |
27 | FVRS2 | VORSW | TITEL | CHAR | 15 | 0 | Name Prefix | T535N | |
28 | FGBDT | PAD_UI_GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
29 | FGBOT | PAD_GBORT | PAD_ORT01 | CHAR | 40 | 0 | Birthplace | ||
30 | FGBLD | PAD_UI_GBLND | LAND1 | CHAR | 3 | 0 | Country of Birth | T005 | |
31 | FGBLD_TEXT | AS4TEXT | AS4TEXT | CHAR | 60 | 0 | Short Description of Repository Objects | ||
32 | FANAT | NATSL | LAND1 | CHAR | 3 | 0 | Nationality | T005 | |
33 | NATTX | NATIO | TEXT15 | CHAR | 15 | 0 | Nationality | ||
34 | FANA2 | PAD_NATS2 | LAND1 | CHAR | 3 | 0 | Second Nationality | T005 | |
35 | NA2TX | NATIO | TEXT15 | CHAR | 15 | 0 | Nationality | ||
36 | FANA3 | PAD_NATS3 | LAND1 | CHAR | 3 | 0 | Third Nationality | T005 | |
37 | NA3TX | NATIO | TEXT15 | CHAR | 15 | 0 | Nationality | ||
38 | FASEX | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
39 | SETXT | CHAR | 30 | 0 | |||||
40 | .INCLUDE | 0 | 0 | ||||||
41 | AGE | PTH_UI_RPAGE | NUM03 | NUMC | 3 | 0 | Age in Years | ||
42 | ALDEC | PTH_ALDEC | XFELD | CHAR | 1 | 0 | Deceased Indicator | ||
43 | EFAML | PTH_EFAML | TEXT40 | CHAR | 40 | 0 | Employer of Family Member (TH) | ||
44 | JOBTL | STLTX | TEXT25 | CHAR | 25 | 0 | Job Title | ||
45 | ANRED | ANRDE | ANRDE | CHAR | 1 | 0 | Form-of-Address Key | T522G | |
46 | FTXID | PTH_FTXID | CHAR13 | CHAR | 13 | 0 | Identity Number for Father | ||
47 | MTXID | PTH_MTXID | CHAR13 | CHAR | 13 | 0 | Identity Number for Mother | ||
48 | STXID | PTH_STXID | CHAR13 | CHAR | 13 | 0 | Identity Number for Spouse | ||
49 | SFXID | PTH_SFXID | CHAR13 | CHAR | 13 | 0 | Identity Number for Spouse's Father | ||
50 | SMXID | PTH_SMXID | CHAR13 | CHAR | 13 | 0 | Identity Number for Spouse's Mother | ||
51 | .INCLUDE | 0 | 0 | Address Data for Family member/Dependent | |||||
52 | STRAS | PTH_STRAS | TEXT60 | CHAR | 60 | 0 | Address Number, Soi Trok (TH) | ||
53 | LOCAT | PTH_LOCAT | TEXT60 | CHAR | 60 | 0 | Street/Road, Tambol | ||
54 | ORT02 | PTH_TORT2 | TEXT40 | CHAR | 40 | 0 | District (TH) | ||
55 | ORT01 | PTH_TORT1 | TEXT40 | CHAR | 40 | 0 | Province | ||
56 | PSTLZ | PSTLZ_HR | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
57 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
58 | CNTRY | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
59 | TELNR | TELNR | TELNR | CHAR | 14 | 0 | Telephone Number | ||
60 | COM01 | COMKY | COMKY | CHAR | 4 | 0 | Communication Type | T536B | |
61 | NUM01 | COMNR | CHAR20 | CHAR | 20 | 0 | Communication Number | ||
62 | COM02 | COMKY | COMKY | CHAR | 4 | 0 | Communication Type | T536B | |
63 | NUM02 | COMNR | CHAR20 | CHAR | 20 | 0 | Communication Number | ||
64 | COM03 | COMKY | COMKY | CHAR | 4 | 0 | Communication Type | T536B | |
65 | NUM03 | COMNR | CHAR20 | CHAR | 20 | 0 | Communication Number | ||
66 | COM04 | COMKY | COMKY | CHAR | 4 | 0 | Communication Type | T536B | |
67 | NUM04 | COMNR | CHAR20 | CHAR | 20 | 0 | Communication Number | ||
68 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HCMT_BSP_PA_TH_R0021 | ANRED | T522G | ANRED | |||
2 | HCMT_BSP_PA_TH_R0021 | COM01 | T536B | COMKY | |||
3 | HCMT_BSP_PA_TH_R0021 | COM02 | T536B | COMKY | |||
4 | HCMT_BSP_PA_TH_R0021 | COM03 | T536B | COMKY | |||
5 | HCMT_BSP_PA_TH_R0021 | COM04 | T536B | COMKY | |||
6 | HCMT_BSP_PA_TH_R0021 | FANA2 | T005 | LAND1 | |||
7 | HCMT_BSP_PA_TH_R0021 | FANA3 | T005 | LAND1 | |||
8 | HCMT_BSP_PA_TH_R0021 | FANAT | T005 | LAND1 | |||
9 | HCMT_BSP_PA_TH_R0021 | FGBLD | T005 | LAND1 | |||
10 | HCMT_BSP_PA_TH_R0021 | FNMZU | T535N | TITEL | |||
11 | HCMT_BSP_PA_TH_R0021 | FVRS2 | T535N | TITEL | |||
12 | HCMT_BSP_PA_TH_R0021 | FVRSW | T535N | TITEL | |||
13 | HCMT_BSP_PA_TH_R0021 | KNZNM | T522N | KNZNM | 1 | CN | |
14 | HCMT_BSP_PA_TH_R0021 | LAND1 | T005 | LAND1 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 100 |