SAP ABAP Table P0186 (Personal master record Infotyp 0186 (SV Singapore))

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	INTTAB	Structure
Structure	P0186	Table Relationship Diagram
Short Description	Personal master record Infotyp 0186 (SV 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	.INCLUDE	☐				0	0	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	Personal master record Infotyp 0186 (SV Singapore)
28	SIGRP	☐	P25M_SIGRP	P25M_SIGRP	CHAR	2	0	Institution of soc. provident funds SG	*
29	SIOFC	☐	P25M_SIOFC	CHAR6	CHAR	6	0	Social insurance branch office
30	CPFID	☐	P25M_FUNTY	P25M_FUNTY	CHAR	2	0	Fund type	*
31	CPFAC	☐	P25M_CPFAC	CHAR15	CHAR	15	0	CPF account number
32	FUNCL	☐	P25M_FUNCL	CHAR1	CHAR	1	0	Fund class
33	CPFNA	☐	P25M_FUNDN	P25M_FUNDN	CHAR	5	0	Fund name
34	FWTYP	☐	P25M_FWTYP	P25M_FWTYP	CHAR	2	0	Types of foreign workers	*
35	FWSGR	☐	P25M_FWSGR	P25M_FWSGR	CHAR	1	0	Subgroup of foreign workers
36	FWLPR	☐	P25M_FWLPR	XFELD	CHAR	1	0	Permanent resident (PR)
37	SGPRD	☐	P25M_SGPRD	DATUM	DATS	8	0	Date of being granted permanent resident status
38	EEPER	☐	P25M_EEPER	DEC3_2	DEC	5	2	Fixed rate for the CPF voluntary countr. of employee
39	EEEPC	☐	P25M_EEEPC	DEC3_2	DEC	5	2	In excess of the statutory rate for CPF voluntary of e'yee
40	EEAMT	☐	P25M_EEAMT	WERTV5	CURR	9	2	Flat amount for CPF voluntary contribution of employee
41	EEEAM	☐	P25M_EEEAM	WERTV5	CURR	9	2	In excess of satutory amount for CPF voluntary of employee
42	EEWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
43	EECUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
44	EYPER	☐	P25M_EYPER	DEC3_2	DEC	5	2	Fixed rate for the CPF voluntary countr. of employer
45	EYEPC	☐	P25M_EYEPC	DEC3_2	DEC	5	2	In excess of statutory rate for CPF voluntary of e'yer
46	EYAMT	☐	P25M_EYAMT	WERTV5	CURR	9	2	Flat amount for CPF voluntary contribution of employer
47	EYEAM	☐	P25M_EYEAM	WERTV5	CURR	9	2	Excess of statutory amount for CPF voluntary of employer
48	EYWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
49	EYCUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
50	AWADJ	☐	P25M_AWADJ	XFELD	CHAR	1	0	CPF adjustments for CPF contribution on AW
51	POSOV	☐	P25M_POSOV	XFELD	CHAR	1	0	Employee's CPF contr. in respect of overseas posting
52	CPFVO	☐	P25M_CPFVO	XFELD	CHAR	1	0	Switch for the CPF voluntary
53	SCHEM	☐	P25M_CPFVO	XFELD	CHAR	1	0	Switch for the CPF voluntary
54	SCH84	☐	PSG_SCH84	XFELD	CHAR	1	0	Indicator for 10/84 scheme
55	SAL84	☐	PSG_SAL84	WERTV5	CURR	9	2	Salary for 10/84 scheme
56	PSCPF	☐	PSG_PSCPF	PSG_PSCPF	CHAR	1	0	Indicator for public sector CPF contribution	T5RCPF_SCH
57	RTCPF	☐	P25M_RTCPF	CHAR2	CHAR	2	0	Type of PR/NRIC Rate- Graduated/Full Rate
58	VCLMT	☐	P25M_VCLMT	XFELD	CHAR	1	0	Switch for Monthly Voluntary Contribution Adjustment
59	APIND	☐	P25M_APIND	XFELD	CHAR	1	0	Approval Indicator for full Contribution
60	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0186	EECUR	TCURC	WAERS
2	P0186	EEWAE	TCURC	WAERS
3	P0186	EYCUR	TCURC	WAERS
4	P0186	EYWAE	TCURC	WAERS
5	P0186	INFTY	T582A	INFTY
6	P0186	PREAS	T530E	PREAS
7	P0186	PSCPF	T5RCPF_SCH	PSCPF

History

Last changed by/on	SAP	20110809
SAP Release Created in