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
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