SAP ABAP Table HCMT_BSP_PA_SG_R0186 (Screen 2000 for CPF Singapore)

Hierarchy

☛ EA-HRCSG (Software Component) Sub component EA-HRCSG of EA-HR
   ⤷ PA-PA-SG (Application Component) Singapore
     ⤷ PAOC_PAD_UI_SG (Package) User Interface for Personnel Administration - Singapore

Basic Data

Table Category	INTTAB	Structure
Structure	HCMT_BSP_PA_SG_R0186	Table Relationship Diagram
Short Description	Screen 2000 for CPF Singapore

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	SIGRP	☐	P25M_SIGRP	P25M_SIGRP	CHAR	2	0	Institution of soc. provident funds SG	T5R1A
13	SISRT	☐	P25M_SISRT	CHAR3	CHAR	3	0	Short text for the institution of social insurance
14	SIGTX	☐	P25M_SIGTX	TEXT25	CHAR	25	0	Text for SI-institution SG
15	CPFVO	☐	P25M_CPFVO	XFELD	CHAR	1	0	Switch for the CPF voluntary
16	CPFID	☐	P25M_FUNTY	P25M_FUNTY	CHAR	2	0	Fund type	T5R1S
17	FUNDN	☐	P25M_FUNDN	P25M_FUNDN	CHAR	5	0	Fund name
18	ENTTX	☐	P25M_ENTTX	TEXT30	CHAR	30	0	Text not found
19	FWTYP	☐	P25M_FWTYP	P25M_FWTYP	CHAR	2	0	Types of foreign workers	T5R1D
20	FWTXT	☐	P25M_FWTXT	TEXT20	CHAR	20	0	Text for types of foreign workers
21	CPFAC	☐	P25M_CPFAC	CHAR15	CHAR	15	0	CPF account number
22	FWSGR	☐	P25M_FWSGR	P25M_FWSGR	CHAR	1	0	Subgroup of foreign workers
23	FWGTX	☐	P25M_FWGTX	TEXT30	CHAR	30	0	Text for subgroup of foreign workers
24	AWADJ	☐	P25M_AWADJ	XFELD	CHAR	1	0	CPF adjustments for CPF contribution on AW
25	FWLPR	☐	P25M_FWLPR	XFELD	CHAR	1	0	Permanent resident (PR)
26	SGPRD	☐	P25M_SGPRD	DATUM	DATS	8	0	Date of being granted permanent resident status
27	RTCPF	☐	P25M_RTCPF	CHAR2	CHAR	2	0	Type of PR/NRIC Rate- Graduated/Full Rate
28	RTYTX	☐	P25M_RTYTX	CHAR20	CHAR	20	0	Type of PR/NRIC Rate-Graduated/Full RateText
29	EYPER	☐	P25M_EYPER	DEC3_2	DEC	5	2	Fixed rate for the CPF voluntary countr. of employer
30	EEPER	☐	P25M_EEPER	DEC3_2	DEC	5	2	Fixed rate for the CPF voluntary countr. of employee
31	EYEPC	☐	P25M_EYEPC	DEC3_2	DEC	5	2	In excess of statutory rate for CPF voluntary of e'yer
32	EEEPC	☐	P25M_EEEPC	DEC3_2	DEC	5	2	In excess of the statutory rate for CPF voluntary of e'yee
33	EYAMT	☐	P25M_EYAMT	WERTV5	CURR	9	2	Flat amount for CPF voluntary contribution of employer
34	EYWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
35	EEAMT	☐	P25M_EEAMT	WERTV5	CURR	9	2	Flat amount for CPF voluntary contribution of employee
36	EEWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
37	EYEAM	☐	P25M_EYEAM	WERTV5	CURR	9	2	Excess of statutory amount for CPF voluntary of employer
38	EYCUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
39	EEEAM	☐	P25M_EEEAM	WERTV5	CURR	9	2	In excess of satutory amount for CPF voluntary of employee
40	EECUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
41	VCLMT	☐	P25M_VCLMT	XFELD	CHAR	1	0	Switch for Monthly Voluntary Contribution Adjustment
42	.INCLUDE	☐				0	0

Foreign Keys

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

History

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