SAP ABAP Table PA0493 (HR-SG-PS: Extension of infotype 0022)

Hierarchy

☛ SAP_HRCSG (Software Component) Sub component SAP_HRCSG of SAP_HR
   ⤷ PY-SG-PS (Application Component) Public Sector
     ⤷ P25P1 (Package) Public Sector Singapore

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0493	Table Relationship Diagram
Short Description	HR-SG-PS: Extension of infotype 0022

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☑				0	0	Key for HR Master Data
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
4	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
5	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
6	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
9	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
10	.INCLUDE	☐				0	0	HR Master Record: Control Field
11	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
14	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
15	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
16	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
17	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
18	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
19	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
24	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
26	.INCLUDE	☐				0	0	HR-SG-PS: Extension of infotype 0022
27	EDYER	☐	PSG_EDYER	NUM4	NUMC	4	0	Year When Qualification Obtained
28	EDIHE	☐	PSG_EDIHE	XFELD	CHAR	1	0	Indicator For Highest Education
29	GRGPA	☐	PSG_GRGPA	DEC3_2	DEC	5	2	Grade Point Average
30	GRGPB	☐	PSG_GRGPA	DEC3_2	DEC	5	2	Grade Point Average
31	EDEXT	☐	PSG_EDEXT	CHAR1	CHAR	1	0	Indicator For External Course
32	EDPFT	☐	PSG_EDPFT	XFELD	CHAR	1	0	INDICATOR FOR FULL/PART TIME STUDY
33	EDCOM	☐	PSG_EDCOM	CHAR1	CHAR	1	0	Indicator For Completion Of Study
34	SJC01	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
35	GRC01	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
36	SJC02	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
37	GRC02	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
38	SJC03	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
39	GRC03	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
40	SJC04	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
41	GRC04	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
42	SJC05	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
43	GRC05	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
44	SJC06	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
45	GRC06	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
46	SJC07	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
47	GRC07	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
48	SJC08	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
49	GRC08	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
50	SJC09	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
51	GRC09	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
52	SJC10	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
53	GRC10	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
54	SJC11	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
55	GRC11	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
56	SJC12	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
57	GRC12	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
58	SJC13	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
59	GRC13	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
60	SJC14	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
61	GRC14	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
62	SJC15	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
63	GRC15	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
64	SJC16	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
65	GRC16	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
66	SJC17	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
67	GRC17	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
68	SJC18	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
69	GRC18	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
70	SJC19	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
71	GRC19	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
72	SJC20	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
73	GRC20	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
74	SJC21	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
75	GRC21	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
76	SJC22	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
77	GRC22	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
78	SJC23	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
79	GRC23	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
80	SJC24	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
81	GRC24	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
82	SJC25	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
83	GRC25	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
84	SJC26	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
85	GRC26	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
86	SJC27	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
87	GRC27	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
88	SJC28	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
89	GRC28	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
90	SJC29	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
91	GRC29	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
92	SJC30	☐	PSG_SJCOD	PSG_SJCOD	CHAR	4	0	Subject	T5PBSR1O
93	GRC30	☐	PSG_GRCOD	PSG_GRCOD	CHAR	2	0	Grade	T5PBSR1O
94	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0493	GRC01	T5PBSR1O	GRCOD	KEY	1	CN
2	PA0493	GRC02	T5PBSR1O	GRCOD	KEY	1	CN
3	PA0493	GRC03	T5PBSR1O	GRCOD	KEY	1	CN
4	PA0493	GRC04	T5PBSR1O	GRCOD	KEY	1	CN
5	PA0493	GRC05	T5PBSR1O	GRCOD	KEY	1	CN
6	PA0493	GRC06	T5PBSR1O	GRCOD	KEY	1	CN
7	PA0493	GRC07	T5PBSR1O	GRCOD	KEY	1	CN
8	PA0493	GRC08	T5PBSR1O	GRCOD	KEY	1	CN
9	PA0493	GRC09	T5PBSR1O	GRCOD	KEY	1	CN
10	PA0493	GRC10	T5PBSR1O	GRCOD	KEY	1	CN
11	PA0493	GRC11	T5PBSR1O	GRCOD	KEY	1	CN
12	PA0493	GRC12	T5PBSR1O	GRCOD	KEY	1	CN
13	PA0493	GRC13	T5PBSR1O	GRCOD	KEY	1	CN
14	PA0493	GRC14	T5PBSR1O	GRCOD	KEY	1	CN
15	PA0493	GRC15	T5PBSR1O	GRCOD	KEY	1	CN
16	PA0493	GRC16	T5PBSR1O	GRCOD	KEY	1	CN
17	PA0493	GRC17	T5PBSR1O	GRCOD	KEY	1	CN
18	PA0493	GRC18	T5PBSR1O	GRCOD	KEY	1	CN
19	PA0493	GRC19	T5PBSR1O	GRCOD	KEY	1	CN
20	PA0493	GRC20	T5PBSR1O	GRCOD	KEY	1	CN
21	PA0493	GRC21	T5PBSR1O	GRCOD	KEY	1	CN
22	PA0493	GRC22	T5PBSR1O	GRCOD	KEY	1	CN
23	PA0493	GRC23	T5PBSR1O	GRCOD	KEY	1	CN
24	PA0493	GRC24	T5PBSR1O	GRCOD	KEY	1	CN
25	PA0493	GRC25	T5PBSR1O	GRCOD	KEY	1	CN
26	PA0493	GRC26	T5PBSR1O	GRCOD	KEY	1	CN
27	PA0493	GRC27	T5PBSR1O	GRCOD	KEY	1	CN
28	PA0493	GRC28	T5PBSR1O	GRCOD	KEY	1	CN
29	PA0493	GRC29	T5PBSR1O	GRCOD	KEY	1	CN
30	PA0493	GRC30	T5PBSR1O	GRCOD	KEY	1	CN
31	PA0493	PERNR	PA0003	PERNR
32	PA0493	PREAS	T530E	PREAS
33	PA0493	SJC01	T5PBSR1O	SJCOD	KEY	1	CN
34	PA0493	SJC02	T5PBSR1O	SJCOD	KEY	1	CN
35	PA0493	SJC03	T5PBSR1O	SJCOD	KEY	1	CN
36	PA0493	SJC04	T5PBSR1O	SJCOD	KEY	1	CN
37	PA0493	SJC05	T5PBSR1O	SJCOD	KEY	1	CN
38	PA0493	SJC06	T5PBSR1O	SJCOD	KEY	1	CN
39	PA0493	SJC07	T5PBSR1O	SJCOD	KEY	1	CN
40	PA0493	SJC08	T5PBSR1O	SJCOD	KEY	1	CN
41	PA0493	SJC09	T5PBSR1O	SJCOD	KEY	1	CN
42	PA0493	SJC10	T5PBSR1O	SJCOD	KEY	1	CN
43	PA0493	SJC11	T5PBSR1O	SJCOD	KEY	1	CN
44	PA0493	SJC12	T5PBSR1O	SJCOD	KEY	1	CN
45	PA0493	SJC13	T5PBSR1O	SJCOD	KEY	1	CN
46	PA0493	SJC14	T5PBSR1O	SJCOD	KEY	1	CN
47	PA0493	SJC15	T5PBSR1O	SJCOD	KEY	1	CN
48	PA0493	SJC16	T5PBSR1O	SJCOD	KEY	1	CN
49	PA0493	SJC17	T5PBSR1O	SJCOD	KEY	1	CN
50	PA0493	SJC18	T5PBSR1O	SJCOD	KEY	1	CN
51	PA0493	SJC19	T5PBSR1O	SJCOD	KEY	1	CN
52	PA0493	SJC20	T5PBSR1O	SJCOD	KEY	1	CN
53	PA0493	SJC21	T5PBSR1O	SJCOD	KEY	1	CN
54	PA0493	SJC22	T5PBSR1O	SJCOD	KEY	1	CN
55	PA0493	SJC23	T5PBSR1O	SJCOD	KEY	1	CN
56	PA0493	SJC24	T5PBSR1O	SJCOD	KEY	1	CN
57	PA0493	SJC25	T5PBSR1O	SJCOD	KEY	1	CN
58	PA0493	SJC26	T5PBSR1O	SJCOD	KEY	1	CN
59	PA0493	SJC27	T5PBSR1O	SJCOD	KEY	1	CN
60	PA0493	SJC28	T5PBSR1O	SJCOD	KEY	1	CN
61	PA0493	SJC29	T5PBSR1O	SJCOD	KEY	1	CN
62	PA0493	SJC30	T5PBSR1O	SJCOD	KEY	1	CN

History

Last changed by/on	SAP	20080626
SAP Release Created in