SAP ABAP Table PS0061 (HR Master Record Infotype 0061 (Social Insurance - Spain))

Hierarchy

☛ SAP_HRCES (Software Component) Sub component SAP_HRCES of SAP_HR
   ⤷ PA-PA-ES (Application Component) Spain
     ⤷ PB04 (Package) HR Master Data: Spain

Basic Data

Table Category	INTTAB	Structure
Structure	PS0061	Table Relationship Diagram
Short Description	HR Master Record Infotype 0061 (Social Insurance - Spain)

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	NATSS	☐	NATSS	NUM12	NUMC	12	0	Employee's Social insurance number
2	EPIGR	☐	EPIGR	EPIGR	NUMC	3	0	Epigraph	*
3	GRCOT	☐	GRCOT	GRCOT	NUMC	2	0	Key for the contribution group	T5E4J
4	BERKT	☐	BERK1	CHAR3	CHAR	3	0	Professional category
5	TICON	☐	TICON	TICON	NUMC	2	0	Contract type key	*
6	DICON	☐	DICON	DEC2	DEC	2	0	Monthly workdays (part-time contracts)
7	HOCON	☐	HOCON	DEC3_2	DEC	5	2	Working hours in month (part-time contracts)
8	NRHIJ	☐	NRHIJ	DEC2	DEC	2	0	Number of children
9	NRHMI	☐	NRHMI	DEC2	DEC	2	0	Number of challenged children
10	PEPFI	☐	PEPFI	WERTV5	CURR	9	2	Previous family allowance
11	PETPC	☐	PETPC	DEC3_2	DEC	5	2	Percentage for non-industrial risks (min.)
12	PENSS	☐	PENSS	CHAR13	CHAR	13	0	Authorization number for multiple employment
13	PESOC	☐	PESOC	CHAR15	CHAR	15	0	Contract type key
14	SOILT	☐	SOILT	COSOC	CHAR	3	0	Healthcare company for ind. accidents and ind. disease	T5E03
15	SOASV	☐	SOASV	COSOC	CHAR	3	0	Healthcare company for non-industrial disease	T5E03
16	EPIG2	☐	EPIG2	XFELD	CHAR	1	0	Epigraph 114
17	INDRE	☐	PES_CONSE	PES_EXESS	CHAR	1	0	Employee special status code
18	FERED	☐	FERED	DATUM	DATS	8	0	Start date for reduction/allowance
19	INDFN	☐	INDFN	CHAR1	CHAR	1	0	Indicator for large family
20	NOMAT	☐	NRMAT	NUM6	NUMC	6	0	Employee registration number
21	PLNSS	☐	PES_CON11	PES_CON11	NUMC	11	0	Pay scale code	*
22	PPCG2	☐	PPCG2	DEC3_2	DEC	5	2	Percentage for non-industrial risks
23	PPAT1	☐	PPAT1	DEC3_2	DEC	5	2	IA and ID risk percentage (min.)
24	PPAT2	☐	PPAT2	DEC3_2	DEC	5	2	IA and ID risk percentage (max.)
25	PCILT	☐	PCILT	PES_CARIT	CHAR	1	0	Temporary incapcity grace period indicator
26	PCMAT	☐	PES_EXREC	PES_EXREC	CHAR	1	0	Surcharge exemption in extra payroll runs
27	EXESS	☐	EXESS	XFELD	CHAR	1	0	Exemption indicator
28	CUOAD	☐	PES_CUOAD	XFELD	CHAR	1	0	Additional contribution indicator
29	CODES	☐	PES_CODES	PES_CODES	CHAR	1	0	Unemployed
30	FEINI	☐	PES_FECH_I	DATUM	DATS	8	0	Contracts start date
31	INDSU	☐	PES_INDSUB	CHAR1	CHAR	1	0	Partial subrogation indicator
32	RELAB	☐	PES_RELLAB	PES_RELLAB	CHAR	4	0	Special work relationship
33	NUSST	☐	PES_NUSS	NUM12	NUMC	12	0	Replaced employee Social Insurance number
34	CAUSU	☐	PES_CAUSAS	PES_CAUSAS	CHAR	2	0	Reason for substitution
35	PLPOR	☐	PES_PLPOR	DEC3_2	DEC	5	2	FOGASA percentage multiple employment
36	METOD	☐	PES_METODO	PES_METODO	CHAR	4	0	Contract process method	T5ES3
37	RACIN	☐	PES_RACIN	XFELD	CHAR	1	0	Active Insertion Income
38	ALUMB	☐	PES_ALUMB	XFELD	CHAR	1	0	Contract after giving birth
39	REDJB	☐	PES_REDJB	NUMC2	NUMC	2	0	Retirement age reduction coefficient
40	METO2	☐	PES_METO2	PES_METODO	CHAR	4	0	Contract processing method (other methods)	T5ES3
41	FERE2	☐	PES_FERE2	DATUM	DATS	8	0	Start date for reduction/allowance (other methods)
42	RELEV	☐	PES_RELEV	CAT_FLAG	CHAR	1	0	Relief contract
43	RESOL	☐	PES_RESOL	NUM5	NUMC	5	0	Legal regulation applicable
44	RESO2	☐	PES_RESOL	NUM5	NUMC	5	0	Legal regulation applicable
45	PLPDE	☐	PES_PLPDE	DEC3_2	DEC	5	2	Percentage of Unemployment concurrent employees
46	COLTR	☐	PES_COLTR	PES_COLTR	NUMC	3	0	Worker group
47	MREIN	☐	PES_MREIN	PES_MREIN	CHAR	1	0	Rehired female employee
48	AUTTR	☐	PES_AUTTR1	CHAR3	CHAR	3	0	Authorization to work (foreigners)
49	AUTVI	☐	PES_AUTVI	DATS	DATS	8	0	Validity of authorization to work (foreigners)
50	NISSE	☐	NISS1	NUM11	NUMC	11	0	Company CA code
51	OCUPA	☐	PES_OCUPA	PES_OCUPA	CHAR	2	0	Employment (IA and ID contribution)	T5E4C
52	PTPAR	☐	PES_PTPAR	DEC3_2	DEC	5	2	Part-time percentage of the normal working time
53	CNAEC	☐	PES_CNAEC	CHAR5	CHAR	5	0	National classification of business activities	T5E4F
54	DTRTP	☐	PES_DTRTP	NUMC2	NUMC	2	0	Days worked part-time
55	CPTRA	☐	PES_CPTRA	PES_CPTRA	NUMC	2	0	Change of work center
56	METO3	☐	PES_METO2	PES_METODO	CHAR	4	0	Contract processing method (other methods)	T5ES3
57	METO4	☐	PES_METO2	PES_METODO	CHAR	4	0	Contract processing method (other methods)	T5ES3
58	FERE3	☐	PES_FERE2	DATUM	DATS	8	0	Start date for reduction/allowance (other methods)
59	FERE4	☐	PES_FERE2	DATUM	DATS	8	0	Start date for reduction/allowance (other methods)
60	RESO3	☐	PES_RESOL	NUM5	NUMC	5	0	Legal regulation applicable
61	RESO4	☐	PES_RESOL	NUM5	NUMC	5	0	Legal regulation applicable
62	PLNS2	☐	PES_CON20	PES_CON20	NUMC	20	0	Pay scale code	T5E3A
63	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PS0061	CNAEC	T5E4F	CNAEC	KEY
2	PS0061	GRCOT	T5E4J	GRCOT	REF	1	CN
3	PS0061	METO2	T5ES3	METOD
4	PS0061	METO3	T5ES3	METOD
5	PS0061	METO4	T5ES3	METOD
6	PS0061	METOD	T5ES3	METOD
7	PS0061	OCUPA	T5E4C	OCUPA	KEY
8	PS0061	PLNS2	T5E3A	CONSS
9	PS0061	SOASV	T5E03	COSOC
10	PS0061	SOILT	T5E03	COSOC

History

Last changed by/on	SAP	20130529
SAP Release Created in