SAP ABAP Table HCMT_BSP_PA_SP_R0022 (Single Screen for Infotype 0022 (Education))

Hierarchy

☛ EA-HRCSG (Software Component) Sub component EA-HRCSG of EA-HR
   ⤷ PY-SG-PS (Application Component) Public Sector
     ⤷ PAOC_PAD_UI_SG_PS (Package) User Interface for Personnel Administration - Singapore

Basic Data

Table Category	INTTAB	Structure
Structure	HCMT_BSP_PA_SP_R0022	Table Relationship Diagram
Short Description	Single Screen for Infotype 0022 (Education)

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	SLART	☐	SLART	SLART	CHAR	2	0	Educational establishment	T517T
13	STEXT01	☐	SLTXT	TEXT20	CHAR	20	0	Education establishment text
14	AUSBI	☐	AUSBI	AUSBI	NUMC	8	0	Education/training	T518A
15	AUSGR	☑	AUSGR	AUSGR	NUMC	3	0	Education/training categories	T518D
16	GTEXT	☐	AGRTX	TEXT25	CHAR	25	0	Education/training category text
17	INSTI	☐	INSTI	TEXT80	CHAR	80	0	Institute/location of training
18	SLAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
19	SLABS	☐	SLABS	SLABS	CHAR	2	0	Certificate	T519T
20	STEXT02	☐	SATXT	TEXT40	CHAR	40	0	Certificate text
21	ANZKL	☐	ANZKL	DEC3	DEC	3	0	Duration of training course
22	ANZEH	☐	EINHTXT	TEXT20	CHAR	20	0	Time/Measurement Unit Text
23	EMARK	☐	EMARK	EMARK	CHAR	4	0	Final Grade
24	SLTP1	☐	FACH1	FACHR	NUMC	5	0	Branch of study	T517Y
25	FACHTXT1	☐	FRTXT	TEXT40	CHAR	40	0	Text for branch of study
26	SLTP2	☐	FACH2	FACHR	NUMC	5	0	Branch of study	T517Y
27	FACHTXT2	☐	FRTXT	TEXT40	CHAR	40	0	Text for branch of study
28	KSBEZ	☐	KSBEZ	TEXT25	CHAR	25	0	Course name
29	TX122	☐	KSBUR	TEXT40	CHAR	40	0	Course appraisal
30	JBEZ1	☐	KSGEB	WERT6	CURR	11	2	Course fees
31	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
32	SLRZG	☐	SLRZG	XFELD	CHAR	1	0	Repayment obligation
33	EDIHE	☐	PSG_EDIHE	XFELD	CHAR	1	0	Indicator For Highest Education
34	EDPFT	☐	PSG_EDPFT	XFELD	CHAR	1	0	INDICATOR FOR FULL/PART TIME STUDY
35	GRGPA	☐	PSG_GRGPA	DEC3_2	DEC	5	2	Grade Point Average
36	GRGPB	☐	PSG_GRGPA	DEC3_2	DEC	5	2	Grade Point Average
37	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HCMT_BSP_PA_SP_R0022	AUSBI	T518A	AUSBI
2	HCMT_BSP_PA_SP_R0022	AUSGR	T518D	AUSGR	KEY	1	CN
3	HCMT_BSP_PA_SP_R0022	SLABS	T519T	SLABS
4	HCMT_BSP_PA_SP_R0022	SLAND	T005	LAND1
5	HCMT_BSP_PA_SP_R0022	SLART	T517T	SLART
6	HCMT_BSP_PA_SP_R0022	SLTP1	T517Y	FACHR
7	HCMT_BSP_PA_SP_R0022	SLTP2	T517Y	FACHR
8	HCMT_BSP_PA_SP_R0022	WAERS	TCURC	WAERS

History

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