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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0061	CNAEC	T5E4F	CNAEC	KEY
2	P0061	GRCOT	T5E4J	GRCOT
3	P0061	INFTY	T582A	INFTY
4	P0061	METO2	T5ES3	METOD
5	P0061	METO3	T5ES3	METOD
6	P0061	METO4	T5ES3	METOD
7	P0061	METOD	T5ES3	METOD
8	P0061	OCUPA	T5E4C	OCUPA	KEY
9	P0061	PLNS2	T5E3A	CONSS
10	P0061	PREAS	T530E	PREAS
11	P0061	SOASV	T5E03	COSOC
12	P0061	SOILT	T5E03	COSOC

History

Last changed by/on	SAP	20130529
SAP Release Created in