SAP ABAP Table PSG02 (Leave scheme records)

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	INTTAB	Structure
Structure	PSG02	Table Relationship Diagram
Short Description	Leave scheme records

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	.INCLUDE	☐				0	0	Field String for Feature in T549B
2	SCHEM	☐	PSG_SCHEM	PSG_SCHEM	CHAR	2	0	Scheme code	T5PBSR3A
3	DIVIS	☐	PSG_DIVIS	PSG_DIVIS	CHAR	2	0	Division	T5PBSR3G
4	QTTYP	☐	ABWKO	ABWKO	NUMC	2	0	Absence Quota Type	T556A
5	CUTYR	☐	PSG_CUTYR	DATS	DATS	8	0	Year for calculation
6	SALGP	☐	PSG_SALGP	CHAR2	CHAR	2	0	Salary Group Code	T5PBSR3H
7	MOPGK	☐	MOPGK	CHAR1	CHAR	1	0	Employee Subgroup Grouping for Time Quota Types
8	MOZKO	☐	MOZKO	MOZKO	NUMC	2	0	Grouping of Personnel Subareas for Time Quota Types
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
10	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
11	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
12	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	*
13	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
14	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	*
15	MOURA	☐	MOURA	MODIF	NUMC	2	0	Personnel Subarea Grouping for Leave Types
16	URART	☐	URART	URART	CHAR	2	0	Leave type	*
17	SBGRU	☐	SBGRU	SBGRD	CHAR	2	0	Challenge group	*
18	SBPRO	☐	SBPRO	DEC3	DEC	3	0	Severe challenge: Percentage
19	AGEJJ	☐	AGEJJ	NUM2	NUMC	2	0	Age in years
20	DAUER	☐	DDAUER	NUM4	NUMC	4	0	Seniority in years
21	TRFAR	☐	TRFAR	TRFAR	CHAR	2	0	Pay scale type	*
22	TRFGB	☐	TRFGB	TRFGB	CHAR	2	0	Pay Scale Area	*
23	TRFGR	☐	TRFGR	TRFGR	CHAR	8	0	Pay Scale Group	*
24	TRFST	☐	TRFST	TRFST	CHAR	2	0	Pay Scale Level	*
25	SCHKZ	☐	SCHKN	SCHKN	CHAR	8	0	Work Schedule Rule	*
26	URLZK	☐	URLZK	NUMC1	NUMC	1	0	Counting class for period work schedule
27	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
28	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
29	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
30	ELIGB	☐	PSG_ELIGB	DEC03_2	DEC	5	2	Eligibility percentage
31	AMUNT	☐	BETRG	WERTV5	CURR	9	2	Amount
32	ENTIT	☐	PSG_ENTIL	PTM_QUONUM	DEC	10	5	Entitlement
33	AWRKH	☐	JRSTD	JRSTD	DEC	7	2	Annual working hours
34	AWRKD	☐	NUM4	NUM04	NUMC	4	0	Four-digit number
35	YWRKH	☐	JRSTD	JRSTD	DEC	7	2	Annual working hours
36	YWRKD	☐	NUM4	NUM04	NUMC	4	0	Four-digit number
37	CTYPE	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSG02	DIVIS	T5PBSR3G	DIVIS
2	PSG02	QTTYP	T556A	KTART
3	PSG02	SALGP	T5PBSR3H	SALGP
4	PSG02	SCHEM	T5PBSR3A	SCHEM

History

Last changed by/on	SAP	20110901
SAP Release Created in