SAP ABAP Table PA0061 (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	TRANSP	Transparent table
Transparent table	PA0061	Table Relationship Diagram
Short Description	HR Master Record Infotype 0061 (Social Insurance - Spain)

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0061	CNAEC	T5E4F	CNAEC	KEY
2	PA0061	GRCOT	T5E4J	GRCOT
3	PA0061	MANDT	T000	MANDT	KEY	1	CN
4	PA0061	METO2	T5ES3	METOD
5	PA0061	METO3	T5ES3	METOD
6	PA0061	METO4	T5ES3	METOD
7	PA0061	METOD	T5ES3	METOD
8	PA0061	OCUPA	T5E4C	OCUPA	KEY
9	PA0061	PERNR	PA0003	PERNR	KEY	1	CN
10	PA0061	PLNS2	T5E3A	CONSS
11	PA0061	PREAS	T530E	PREAS	REF	C	CN
12	PA0061	SOASV	T5E03	COSOC
13	PA0061	SOILT	T5E03	COSOC

History

Last changed by/on	SAP	20130529
SAP Release Created in