SAP ABAP Table HCMT_BSP_PA_HK_R0021 (Infotype view 0021/0344 ------- Hong Kong)

Hierarchy

☛ EA-HRCHK (Software Component) Sub component EA-HRCHK of EA-HR
   ⤷ PA-PA-HK (Application Component) Hong Kong
     ⤷ PAOC_PAD_UI_INFTY_0021_HK (Package) User Interface for Infotype 0021 - Hong Kong

Basic Data

Table Category	INTTAB	Structure
Structure	HCMT_BSP_PA_HK_R0021	Table Relationship Diagram
Short Description	Infotype view 0021/0344 ------- Hong Kong

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	Additional family infomation - Hongkong
16	FANAM	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
17	FAVOR	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
18	FGBNA	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
19	FINIT	☐	INITS	TEXT10	CHAR	10	0	Initials
20	FANAT	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
21	FANA2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
22	FANA3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
23	FGBDT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
24	FGBOT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
25	GBDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
26	FGBLD	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
27	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
28	FTEXT	☐	FATXT	FATXT	CHAR	6	0	Marital Status
29	SEPDT	☐	SEPDT	DATUM	DATS	8	0	Legal Separation Date
30	FASAR	☐	FASAR	SLART	CHAR	2	0	School Type of Family Member	T517T
31	STEX2	☐	SLTXT	TEXT20	CHAR	20	0	Education establishment text
32	FASIN	☐	FASIN	TEXT20	CHAR	20	0	Educational Institute
33	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
34	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	T500W
35	ERBNR	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
36	OCCUP	☐	PHK_OCCUP	PHK_OCCUP	CHAR	4	0	Occupations for familiy members	T7HK01
37	OCTXT	☐	PHK_OCTXT	TEXT25	CHAR	25	0	Occupation text
38	EAMES	☐	PHK_EAMES	DEC3_2	DEC	5	2	Status of occupation for familiy members
39	PERCT	☐	PAD_PRCNT	PAD_PRCNT	CHAR	1	0	Percentage
40	ERNAM	☐	PHK_ERNAM	CHAR50	CHAR	50	0	Name of family member's employer
41	FASEX	☐	GESCH	GESCH	CHAR	1	0	Gender Key
42	EGAGA	☐	EGAGA	VARGA	CHAR	8	0	Employer of Family Member
43	ANTXT	☐	ADRTX	TEXT40	CHAR	40	0	Address Text (Name, Street, City, Tel. No.)
44	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	*
45	.INCLUDE	☐				0	0	ID and Passport
46	ICTY1	☐	ICTYP	ICTYP	CHAR	2	0	Type of identification (IC type)	T5R05
47	ICTX1	☐	ICTXT	TEXT30	CHAR	30	0	IC description
48	ICNM1	☐	ICNUM	ICNUM	CHAR	20	0	IC number
49	AUTH1	☐	AUTH1	TEXT30	CHAR	30	0	Issuing authority
50	FPDT1	☐	FPDAT	DDATE	DATS	8	0	Date of issue for personal ID
51	EXPD1	☐	EXPID	DDATE	DATS	8	0	ID expiry date
52	IDCT1	☐	PHK_IDCOT	LAND1	CHAR	3	0	Country of ID	T005
53	ISCT1	☐	PHK_ISCOT	LAND1	CHAR	3	0	Country of issue	T005
54	ICTY2	☐	ICTYP	ICTYP	CHAR	2	0	Type of identification (IC type)	T5R05
55	ICTX2	☐	ICTXT	TEXT30	CHAR	30	0	IC description
56	ICNM2	☐	ICNUM	ICNUM	CHAR	20	0	IC number
57	AUTH2	☐	AUTH1	TEXT30	CHAR	30	0	Issuing authority
58	FPDT2	☐	FPDAT	DDATE	DATS	8	0	Date of issue for personal ID
59	EXPD2	☐	EXPID	DDATE	DATS	8	0	ID expiry date
60	IDCT2	☐	PHK_IDCOT	LAND1	CHAR	3	0	Country of ID	T005
61	ISCT2	☐	PHK_ISCOT	LAND1	CHAR	3	0	Country of issue	T005
62	.INCLUDE	☐				0	0	Alternative name
63	NAMT1	☐	SUBTY_591A	SUBTY_591A	CHAR	4	0	Subtype	T591A
64	NMTX1	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
65	VORN1	☐	VORNA	VORNM	CHAR	25	0	First Name
66	NACH1	☐	NACHN	NACHN	CHAR	25	0	Last Name
67	NAMT2	☐	SUBTY_591A	SUBTY_591A	CHAR	4	0	Subtype	T591A
68	NMTX2	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
69	VORN2	☐	VORNA	VORNM	CHAR	25	0	First Name
70	NACH2	☐	NACHN	NACHN	CHAR	25	0	Last Name
71	.INCLUDE	☐				0	0	Address
72	NAME2	☐	CONAM	NACHN	CHAR	25	0	C/O Name
73	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
74	LOCAT	☐	STRAS	TEXT30	CHAR	30	0	House number and street
75	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
76	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
77	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
78	BEZEI02	☐	BEZEI20	TEXT20	CHAR	20	0	Description
79	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
80	COM01	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
81	COMTYTXT01	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
82	NUM01	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
83	COM02	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
84	COMTYTXT02	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
85	NUM02	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
86	COMTYTXT03	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
87	COM03	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
88	NUM03	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
89	COM04	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
90	COMTYTXT04	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
91	NUM04	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
92	COM05	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
93	COMTYTXT05	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
94	NUM05	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
95	COM06	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
96	COMTYTXT06	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
97	NUM06	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
98	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HCMT_BSP_PA_HK_R0021	COM01	T536B	COMKY
2	HCMT_BSP_PA_HK_R0021	COM02	T536B	COMKY
3	HCMT_BSP_PA_HK_R0021	COM03	T536B	COMKY
4	HCMT_BSP_PA_HK_R0021	COM04	T536B	COMKY
5	HCMT_BSP_PA_HK_R0021	COM05	T536B	COMKY
6	HCMT_BSP_PA_HK_R0021	COM06	T536B	COMKY
7	HCMT_BSP_PA_HK_R0021	COUNC	T005E	COUNC
8	HCMT_BSP_PA_HK_R0021	FAMST	T502T	FAMST
9	HCMT_BSP_PA_HK_R0021	FANA2	T005	LAND1
10	HCMT_BSP_PA_HK_R0021	FANA3	T005	LAND1
11	HCMT_BSP_PA_HK_R0021	FANAT	T005	LAND1
12	HCMT_BSP_PA_HK_R0021	FASAR	T517T	SLART
13	HCMT_BSP_PA_HK_R0021	FGBLD	T005	LAND1
14	HCMT_BSP_PA_HK_R0021	GBDEP	T005S	BLAND
15	HCMT_BSP_PA_HK_R0021	ICTY1	T5R05	ICTYP
16	HCMT_BSP_PA_HK_R0021	ICTY2	T5R05	ICTYP
17	HCMT_BSP_PA_HK_R0021	IDCT1	T005	LAND1
18	HCMT_BSP_PA_HK_R0021	IDCT2	T005	LAND1
19	HCMT_BSP_PA_HK_R0021	ISCT1	T005	LAND1
20	HCMT_BSP_PA_HK_R0021	ISCT2	T005	LAND1
21	HCMT_BSP_PA_HK_R0021	LAND1	T005	LAND1
22	HCMT_BSP_PA_HK_R0021	NAMT1	T591A	SUBTY
23	HCMT_BSP_PA_HK_R0021	NAMT2	T591A	SUBTY
24	HCMT_BSP_PA_HK_R0021	OCCUP	T7HK01	OCCUP
25	HCMT_BSP_PA_HK_R0021	STATE	T005S	BLAND
26	HCMT_BSP_PA_HK_R0021	WAERS	T500W	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	100