SAP ABAP Table PA0186 (HR Master Record: Infotype 0186 [Social Insurance] (SG))

Hierarchy

☛ SAP_HRCSG (Software Component) Sub component SAP_HRCSG of SAP_HR
   ⤷ PA-PA-SG (Application Component) Singapore
     ⤷ PB25 (Package) HR Singapore: Master data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0186	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0186 [Social Insurance] (SG)

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	T000
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	Personal master record Infotyp 0186 (SV Singapore)
27	SIGRP	☐	P25M_SIGRP	P25M_SIGRP	CHAR	2	0	Institution of soc. provident funds SG	*
28	SIOFC	☐	P25M_SIOFC	CHAR6	CHAR	6	0	Social insurance branch office
29	CPFID	☐	P25M_FUNTY	P25M_FUNTY	CHAR	2	0	Fund type	*
30	CPFAC	☐	P25M_CPFAC	CHAR15	CHAR	15	0	CPF account number
31	FUNCL	☐	P25M_FUNCL	CHAR1	CHAR	1	0	Fund class
32	CPFNA	☐	P25M_FUNDN	P25M_FUNDN	CHAR	5	0	Fund name
33	FWTYP	☐	P25M_FWTYP	P25M_FWTYP	CHAR	2	0	Types of foreign workers	*
34	FWSGR	☐	P25M_FWSGR	P25M_FWSGR	CHAR	1	0	Subgroup of foreign workers
35	FWLPR	☐	P25M_FWLPR	XFELD	CHAR	1	0	Permanent resident (PR)
36	SGPRD	☐	P25M_SGPRD	DATUM	DATS	8	0	Date of being granted permanent resident status
37	EEPER	☐	P25M_EEPER	DEC3_2	DEC	5	2	Fixed rate for the CPF voluntary countr. of employee
38	EEEPC	☐	P25M_EEEPC	DEC3_2	DEC	5	2	In excess of the statutory rate for CPF voluntary of e'yee
39	EEAMT	☐	P25M_EEAMT	WERTV5	CURR	9	2	Flat amount for CPF voluntary contribution of employee
40	EEEAM	☐	P25M_EEEAM	WERTV5	CURR	9	2	In excess of satutory amount for CPF voluntary of employee
41	EEWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
42	EECUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
43	EYPER	☐	P25M_EYPER	DEC3_2	DEC	5	2	Fixed rate for the CPF voluntary countr. of employer
44	EYEPC	☐	P25M_EYEPC	DEC3_2	DEC	5	2	In excess of statutory rate for CPF voluntary of e'yer
45	EYAMT	☐	P25M_EYAMT	WERTV5	CURR	9	2	Flat amount for CPF voluntary contribution of employer
46	EYEAM	☐	P25M_EYEAM	WERTV5	CURR	9	2	Excess of statutory amount for CPF voluntary of employer
47	EYWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
48	EYCUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
49	AWADJ	☐	P25M_AWADJ	XFELD	CHAR	1	0	CPF adjustments for CPF contribution on AW
50	POSOV	☐	P25M_POSOV	XFELD	CHAR	1	0	Employee's CPF contr. in respect of overseas posting
51	CPFVO	☐	P25M_CPFVO	XFELD	CHAR	1	0	Switch for the CPF voluntary
52	SCHEM	☐	P25M_CPFVO	XFELD	CHAR	1	0	Switch for the CPF voluntary
53	SCH84	☐	PSG_SCH84	XFELD	CHAR	1	0	Indicator for 10/84 scheme
54	SAL84	☐	PSG_SAL84	WERTV5	CURR	9	2	Salary for 10/84 scheme
55	PSCPF	☐	PSG_PSCPF	PSG_PSCPF	CHAR	1	0	Indicator for public sector CPF contribution	T5RCPF_SCH
56	RTCPF	☐	P25M_RTCPF	CHAR2	CHAR	2	0	Type of PR/NRIC Rate- Graduated/Full Rate
57	VCLMT	☐	P25M_VCLMT	XFELD	CHAR	1	0	Switch for Monthly Voluntary Contribution Adjustment
58	APIND	☐	P25M_APIND	XFELD	CHAR	1	0	Approval Indicator for full Contribution
59	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0186	EECUR	TCURC	WAERS
2	PA0186	EEWAE	TCURC	WAERS
3	PA0186	EYCUR	TCURC	WAERS
4	PA0186	EYWAE	TCURC	WAERS
5	PA0186	MANDT	T000	MANDT	KEY	1	CN
6	PA0186	PERNR	PA0003	PERNR
7	PA0186	PREAS	T530E	PREAS
8	PA0186	PSCPF	T5RCPF_SCH	PSCPF

History

Last changed by/on	SAP	20110809
SAP Release Created in