SAP ABAP Table HCMT_BSP_PA_CN_R0021 (Infotype View 0021/0528 (China))
Hierarchy
☛
EA-HRCCN (Software Component) Sub component EA-HRCCN of EA-HR
⤷ PA-PA-CN (Application Component) China
⤷ PAOC_PAD_UI_INFTY_0021_CN (Package) User Interface for Infotype 0021 - China
⤷ PA-PA-CN (Application Component) China
⤷ PAOC_PAD_UI_INFTY_0021_CN (Package) User Interface for Infotype 0021 - China
Basic Data
Table Category | INTTAB | Structure |
Structure | HCMT_BSP_PA_CN_R0021 | Table Relationship Diagram |
Short Description | Infotype View 0021/0528 (China) |
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 | FAMSA | FAMSA | SUBTY | CHAR | 4 | 0 | Type of Family Record | ||
13 | STEXT | SBTTX | TEXT40 | CHAR | 40 | 0 | Name of Subtype | ||
14 | OBJPS | OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
15 | .INCLUDE | 0 | 0 | General data of employee's family member | |||||
16 | ENAME | FEDNM | TEXT40 | CHAR | 40 | 0 | Name of referenced personnel number | ||
17 | ANRED | ANRDE | ANRDE | CHAR | 1 | 0 | Form-of-Address Key | T522G | |
18 | FKNZN | KNZNM | KNZN2 | NUMC | 2 | 0 | Name Format Indicator for Employee in a List | ||
19 | FANAM | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
20 | FAVOR | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
21 | FAMST | FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | T502T | |
22 | FATXT | FATXT | FATXT | CHAR | 6 | 0 | Marital Status | ||
23 | FAMDT | FAMDT | DATUM | DATS | 8 | 0 | Valid From Date of Current Marital Status | ||
24 | FGBDT | GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
25 | FAAGE | PCN_FAAGE | CHAR3 | CHAR | 3 | 0 | Age | ||
26 | FANAT | NATSL | LAND1 | CHAR | 3 | 0 | Nationality | T005 | |
27 | NATTX | NATTX | TEXT15 | CHAR | 15 | 0 | Nationality (long text) | ||
28 | FGBLD | GBLND | LAND1 | CHAR | 3 | 0 | Country of Birth | T005 | |
29 | LNDTX | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
30 | FGBOT | PAD_GBORT | PAD_ORT01 | CHAR | 40 | 0 | Birthplace | ||
31 | FASEX | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
32 | CNNAM | PCN_CNNAM | TEXT40 | CHAR | 40 | 0 | Chinese Name | ||
33 | .INCLUDE | 0 | 0 | IC number of family member | |||||
34 | ICTY1 | ICTYP | ICTYP | CHAR | 2 | 0 | Type of identification (IC type) | T5R05 | |
35 | IDNM1 | PCN_IDNUM | TEXT20 | CHAR | 20 | 0 | Identification number | ||
36 | ICTXT1 | ICTXT | TEXT30 | CHAR | 30 | 0 | IC description | ||
37 | ICTY2 | ICTYP | ICTYP | CHAR | 2 | 0 | Type of identification (IC type) | T5R05 | |
38 | IDNM2 | PCN_IDNUM | TEXT20 | CHAR | 20 | 0 | Identification number | ||
39 | ICTXT2 | ICTXT | TEXT30 | CHAR | 30 | 0 | IC description | ||
40 | ICTY3 | ICTYP | ICTYP | CHAR | 2 | 0 | Type of identification (IC type) | T5R05 | |
41 | IDNM3 | PCN_IDNUM | TEXT20 | CHAR | 20 | 0 | Identification number | ||
42 | ICTXT3 | ICTXT | TEXT30 | CHAR | 30 | 0 | IC description | ||
43 | ICTY4 | ICTYP | ICTYP | CHAR | 2 | 0 | Type of identification (IC type) | T5R05 | |
44 | IDNM4 | PCN_IDNUM | TEXT20 | CHAR | 20 | 0 | Identification number | ||
45 | ICTXT4 | ICTXT | TEXT30 | CHAR | 30 | 0 | IC description | ||
46 | ICTY5 | ICTYP | ICTYP | CHAR | 2 | 0 | Type of identification (IC type) | T5R05 | |
47 | IDNM5 | PCN_IDNUM | TEXT20 | CHAR | 20 | 0 | Identification number | ||
48 | ICTXT5 | ICTXT | TEXT30 | CHAR | 30 | 0 | IC description | ||
49 | .INCLUDE | 0 | 0 | Communication mode of employee's family member | |||||
50 | TELNR | PCN_TELNR | CHAR20 | CHAR | 20 | 0 | Telephone number | ||
51 | COM01 | COMKY | COMKY | CHAR | 4 | 0 | Communication Type | T536B | |
52 | TYP01 | TEXT20 | TEXT20 | CHAR | 20 | 0 | Text (20 Characters) | ||
53 | NUM01 | COMNR | CHAR20 | CHAR | 20 | 0 | Communication Number | ||
54 | COM02 | COMKY | COMKY | CHAR | 4 | 0 | Communication Type | T536B | |
55 | TYP02 | TEXT20 | TEXT20 | CHAR | 20 | 0 | Text (20 Characters) | ||
56 | NUM02 | COMNR | CHAR20 | CHAR | 20 | 0 | Communication Number | ||
57 | COM03 | COMKY | COMKY | CHAR | 4 | 0 | Communication Type | T536B | |
58 | TYP03 | TEXT20 | TEXT20 | CHAR | 20 | 0 | Text (20 Characters) | ||
59 | NUM03 | COMNR | CHAR20 | CHAR | 20 | 0 | Communication Number | ||
60 | COM04 | COMKY | COMKY | CHAR | 4 | 0 | Communication Type | T536B | |
61 | TYP04 | TEXT20 | TEXT20 | CHAR | 20 | 0 | Text (20 Characters) | ||
62 | NUM04 | COMNR | CHAR20 | CHAR | 20 | 0 | Communication Number | ||
63 | .INCLUDE | 0 | 0 | Address of employee's family member | |||||
64 | PSTLZ | PSTLZ_HR | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
65 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
66 | NA2TX | NATTX | TEXT15 | CHAR | 15 | 0 | Nationality (long text) | ||
67 | STATE | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
68 | BEZEI | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
69 | CITY1 | PAD_ORT01 | PAD_ORT01 | CHAR | 40 | 0 | City | ||
70 | DISTR | PAD_ORT02 | PAD_ORT01 | CHAR | 40 | 0 | District | ||
71 | STRAS | PAD_STRAS | PAD_STRAS | CHAR | 60 | 0 | Street and House Number | ||
72 | FULLA | PCN_FULLA | TEXT60 | CHAR | 60 | 0 | Full address | ||
73 | .INCLUDE | 0 | 0 | Additional data of employee's family member | |||||
74 | EGAGA | EGAGA | VARGA | CHAR | 8 | 0 | Employer of Family Member | ||
75 | ANTXT | ADRTX | TEXT40 | CHAR | 40 | 0 | Address Text (Name, Street, City, Tel. No.) | ||
76 | OCCUP | PCN_OCCTY | PCN_OCCTY | CHAR | 8 | 0 | Occupation | T7CN53 | |
77 | STATU | PCN_STATU | PCN_STATU | CHAR | 2 | 0 | Job status | T7CN65 | |
78 | PSTAT | PCN_PCODE | PCN_PCODE | CHAR | 2 | 0 | Political status | T7CN59 | |
79 | SAMER | PCN_SAMER | XFELD | CHAR | 1 | 0 | Indicator: Work in same company | ||
80 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HCMT_BSP_PA_CN_R0021 | ANRED | T522G | ANRED | |||
2 | HCMT_BSP_PA_CN_R0021 | COM01 | T536B | COMKY | |||
3 | HCMT_BSP_PA_CN_R0021 | COM02 | T536B | COMKY | |||
4 | HCMT_BSP_PA_CN_R0021 | COM03 | T536B | COMKY | |||
5 | HCMT_BSP_PA_CN_R0021 | COM04 | T536B | COMKY | |||
6 | HCMT_BSP_PA_CN_R0021 | FAMST | T502T | FAMST | |||
7 | HCMT_BSP_PA_CN_R0021 | FANAT | T005 | LAND1 | |||
8 | HCMT_BSP_PA_CN_R0021 | FGBLD | T005 | LAND1 | |||
9 | HCMT_BSP_PA_CN_R0021 | ICTY1 | T5R05 | ICTYP | KEY | 1 | CN |
10 | HCMT_BSP_PA_CN_R0021 | ICTY2 | T5R05 | ICTYP | KEY | 1 | CN |
11 | HCMT_BSP_PA_CN_R0021 | ICTY3 | T5R05 | ICTYP | |||
12 | HCMT_BSP_PA_CN_R0021 | ICTY4 | T5R05 | ICTYP | |||
13 | HCMT_BSP_PA_CN_R0021 | ICTY5 | T5R05 | ICTYP | |||
14 | HCMT_BSP_PA_CN_R0021 | LAND1 | T005 | LAND1 | KEY | 1 | CN |
15 | HCMT_BSP_PA_CN_R0021 | OCCUP | T7CN53 | OCCTY | KEY | 1 | CN |
16 | HCMT_BSP_PA_CN_R0021 | PSTAT | T7CN59 | PCODE | KEY | 1 | CN |
17 | HCMT_BSP_PA_CN_R0021 | STATE | T005S | BLAND | KEY | 1 | CN |
18 | HCMT_BSP_PA_CN_R0021 | STATU | T7CN65 | STATU | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 100 |