SAP ABAP Table HCMT_BSP_PA_SP_R0186 (CPF Main screen structure)

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_R0186	Table Relationship Diagram
Short Description	CPF Main screen structure

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	Screen 2000 for CPF Singapore
2	OBJECT_KEY	☐	HCM_OBJECT_KEY		CHAR	100	0	HCM Object Key
3	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
4	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
5	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
6	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
7	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
9	SPRTX	☐	SPRPSTEXT	SPRPSTEXT	CHAR	40	0	Lock indicator for HR master record (text)
10	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
11	BEGDA	☐	PAD_BEGDA	DATUM	DATS	8	0	Valid-From Date
12	ENDDA	☐	PAD_ENDDA	DATUM	DATS	8	0	Valid To Date
13	SIGRP	☐	P25M_SIGRP	P25M_SIGRP	CHAR	2	0	Institution of soc. provident funds SG	T5R1A
14	SISRT	☐	P25M_SISRT	CHAR3	CHAR	3	0	Short text for the institution of social insurance
15	SIGTX	☐	P25M_SIGTX	TEXT25	CHAR	25	0	Text for SI-institution SG
16	CPFVO	☐	P25M_CPFVO	XFELD	CHAR	1	0	Switch for the CPF voluntary
17	CPFID	☐	P25M_FUNTY	P25M_FUNTY	CHAR	2	0	Fund type	T5R1S
18	FUNDN	☐	P25M_FUNDN	P25M_FUNDN	CHAR	5	0	Fund name
19	ENTTX	☐	P25M_ENTTX	TEXT30	CHAR	30	0	Text not found
20	FWTYP	☐	P25M_FWTYP	P25M_FWTYP	CHAR	2	0	Types of foreign workers	T5R1D
21	FWTXT	☐	P25M_FWTXT	TEXT20	CHAR	20	0	Text for types of foreign workers
22	CPFAC	☐	P25M_CPFAC	CHAR15	CHAR	15	0	CPF account number
23	FWSGR	☐	P25M_FWSGR	P25M_FWSGR	CHAR	1	0	Subgroup of foreign workers
24	FWGTX	☐	P25M_FWGTX	TEXT30	CHAR	30	0	Text for subgroup of foreign workers
25	AWADJ	☐	P25M_AWADJ	XFELD	CHAR	1	0	CPF adjustments for CPF contribution on AW
26	FWLPR	☐	P25M_FWLPR	XFELD	CHAR	1	0	Permanent resident (PR)
27	SGPRD	☐	P25M_SGPRD	DATUM	DATS	8	0	Date of being granted permanent resident status
28	RTCPF	☐	P25M_RTCPF	CHAR2	CHAR	2	0	Type of PR/NRIC Rate- Graduated/Full Rate
29	RTYTX	☐	P25M_RTYTX	CHAR20	CHAR	20	0	Type of PR/NRIC Rate-Graduated/Full RateText
30	EYPER	☐	P25M_EYPER	DEC3_2	DEC	5	2	Fixed rate for the CPF voluntary countr. of employer
31	EEPER	☐	P25M_EEPER	DEC3_2	DEC	5	2	Fixed rate for the CPF voluntary countr. of employee
32	EYEPC	☐	P25M_EYEPC	DEC3_2	DEC	5	2	In excess of statutory rate for CPF voluntary of e'yer
33	EEEPC	☐	P25M_EEEPC	DEC3_2	DEC	5	2	In excess of the statutory rate for CPF voluntary of e'yee
34	EYAMT	☐	P25M_EYAMT	WERTV5	CURR	9	2	Flat amount for CPF voluntary contribution of employer
35	EYWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
36	EEAMT	☐	P25M_EEAMT	WERTV5	CURR	9	2	Flat amount for CPF voluntary contribution of employee
37	EEWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
38	EYEAM	☐	P25M_EYEAM	WERTV5	CURR	9	2	Excess of statutory amount for CPF voluntary of employer
39	EYCUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
40	EEEAM	☐	P25M_EEEAM	WERTV5	CURR	9	2	In excess of satutory amount for CPF voluntary of employee
41	EECUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
42	VCLMT	☐	P25M_VCLMT	XFELD	CHAR	1	0	Switch for Monthly Voluntary Contribution Adjustment
43	.INCLUDE	☐				0	0
44	PSCPF	☐	PSG_PSCPF	PSG_PSCPF	CHAR	1	0	Indicator for public sector CPF contribution	*
45	PSCPF_TEXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
46	SCH84	☐	PSG_SCH84	XFELD	CHAR	1	0	Indicator for 10/84 scheme
47	SAL84	☐	PSG_SAL84	WERTV5	CURR	9	2	Salary for 10/84 scheme
48	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HCMT_BSP_PA_SP_R0186	CPFID	T5R1S	FUNTY	REF	1	CN
2	HCMT_BSP_PA_SP_R0186	EECUR	TCURC	WAERS
3	HCMT_BSP_PA_SP_R0186	EEWAE	TCURC	WAERS
4	HCMT_BSP_PA_SP_R0186	EYCUR	TCURC	WAERS
5	HCMT_BSP_PA_SP_R0186	EYWAE	TCURC	WAERS
6	HCMT_BSP_PA_SP_R0186	FWTYP	T5R1D	FWTYP	REF	1	CN
7	HCMT_BSP_PA_SP_R0186	SIGRP	T5R1A	SIGRP	REF	1	CN

History

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