SAP ABAP Table HCMT_BSP_PA_ES_R0061 (Social insurance Spain)

Hierarchy

☛ EA-HRCES (Software Component) Sub component EA-HRCES of EA-HR
   ⤷ PA-PA-ES (Application Component) Spain
     ⤷ PAOC_PAD_UI_ES (Package) User Interface for Personnel Administration - Spain

Basic Data

Table Category	INTTAB	Structure
Structure	HCMT_BSP_PA_ES_R0061	Table Relationship Diagram
Short Description	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	OBJECT_KEY	☑	HCM_OBJECT_KEY		CHAR	100	0	HCM Object Key
2	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
3	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
6	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	SPRTX	☐	SPRPSTEXT	SPRPSTEXT	CHAR	40	0	Lock indicator for HR master record (text)
9	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
10	BEGDA	☐	PAD_BEGDA	DATUM	DATS	8	0	Valid-From Date
11	ENDDA	☐	PAD_ENDDA	DATUM	DATS	8	0	Valid To Date
12	NISSE	☐	NISS1	NUM11	NUMC	11	0	Company CA code
13	NISS2	☐	NISS2	NUM11	NUMC	11	0	CA code for training contracts
14	NISS3	☐	NISS3	NUM11	NUMC	11	0	CA Code for Foreigners
15	CODPR	☐	PES_CODPR	REGIO	CHAR	3	0	Province code	T005S
16	NRAFI	☐	PES_NRAFI	NUM8	NUMC	8	0	Affiliation number
17	NACON	☐	PES_NACON	CHAR2	CHAR	2	0	Social Insurance check digit
18	PENSS	☐	PENSS	CHAR13	CHAR	13	0	Authorization number for multiple employment
19	NOMAT	☐	NRMAT	NUM6	NUMC	6	0	Employee registration number
20	PETPC	☐	PETPC	DEC3_2	DEC	5	2	Percentage for non-industrial risks (min.)
21	PPCG2	☐	PPCG2	DEC3_2	DEC	5	2	Percentage for non-industrial risks
22	PLNSS	☐	PES_CONSS	NUM7	NUMC	7	0	Pay scale code	T5E34
23	CONTX	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
24	PPAT1	☐	PPAT1	DEC3_2	DEC	5	2	IA and ID risk percentage (min.)
25	PPAT2	☐	PPAT2	DEC3_2	DEC	5	2	IA and ID risk percentage (max.)
26	EPIGR	☐	EPIGR	EPIGR	NUMC	3	0	Epigraph	T5E6T
27	TTEXT01	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
28	GRCOT	☐	GRCOT	GRCOT	NUMC	2	0	Key for the contribution group	T5E3T
29	TTEXT02	☐	TGRCT	TEXT32	CHAR	32	0	Contribution group description
30	BERKT	☐	CATEG	CATEG	CHAR	3	0	Professional category	T5E48
31	CTEXT	☐	TEXT32	TEXT32	CHAR	32	0	Text length 32
32	EXESS	☐	EXESS	XFELD	CHAR	1	0	Exemption indicator
33	CLCON	☐	PES_CLCON	PES_IDSEG	CHAR	3	0	Contract Key for Social Insurance
34	EPIG2	☐	EPIG2	XFELD	CHAR	1	0	Epigraph 114
35	IDSEG	☐	PES_IDSEG	PES_IDSEG	CHAR	3	0	Main contract key
36	TTEXT03	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
37	INDRE	☐	PES_CONSE	PES_EXESS	CHAR	1	0	Employee special status code
38	METOD	☐	PES_UI_0061_METOD	PES_METODO	CHAR	4	0	Contract processing method
39	FERED	☐	FERED	DATUM	DATS	8	0	Start date for reduction/allowance
40	CUOAD	☐	PES_CUOAD	XFELD	CHAR	1	0	Additional contribution indicator
41	METO2	☐	PES_METO2	PES_METODO	CHAR	4	0	Contract processing method (other methods)	T5ES3
42	FERE2	☐	PES_FERE2	DATUM	DATS	8	0	Start date for reduction/allowance (other methods)
43	ARR	☐	PES_ARR	PES_ARR	CHAR	1	0	Indicator of allowances and reductions carried forward
44	DICON	☐	DICON	DEC2	DEC	2	0	Monthly workdays (part-time contracts)
45	HOCON	☐	HOCON	DEC3_2	DEC	5	2	Working hours in month (part-time contracts)
46	PORC1	☐	PAD_PRCNT	PAD_PRCNT	CHAR	1	0	Percentage
47	PTPAR	☐	PES_PTPAR	DEC3_2	DEC	5	2	Part-time percentage of the normal working time
48	PCILT	☐	PCILT	PES_CARIT	CHAR	1	0	Temporary incapcity grace period indicator
49	SOILT	☐	SOILT	COSOC	CHAR	3	0	Healthcare company for ind. accidents and ind. disease	T5E03
50	PCMAT	☐	PES_EXREC	PES_EXREC	CHAR	1	0	Surcharge exemption in extra payroll runs
51	SOASV	☐	SOASV	COSOC	CHAR	3	0	Healthcare company for non-industrial disease	T5E03
52	NATSSCODPR	☐	PES_UI_NATSS	NUM10	NUMC	10	0	Employee's social insurance number
53	RESOL	☐	PES_RESOL	NUM5	NUMC	5	0	Legal regulation applicable	T5ES4
54	RESO2	☐	PES_UI_RESOL2	NUM5	NUMC	5	0	Second regulation applicable	T5ES4
55	NATSS	☐	NATSS	NUM12	NUMC	12	0	Employee's Social insurance number
56	MOCAT	☐	MOCAT	P04_MOCAT	NUMC	2	0	Categories modifier	*
57	COETP	☐	PES_COETP	DEC4	DEC	4	0	Part-time coefficient for contracts
58	CCCEE	☐	PES_CCCTR	NUM11	NUMC	11	0	Contribution Account Code(CAC) to which employee is assigned
59	CNAEC	☐	PES_CNAEC	CHAR5	CHAR	5	0	National classification of business activities
60	TPCCT	☐	PES_TPCCT	TEXT32	CHAR	32	0	Contribution Account Code type
61	CNAED	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
62	OCUPA	☐	PES_OCUPA	PES_OCUPA	CHAR	2	0	Employment (IA and ID contribution)	T5E4C
63	OCUPT	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
64	METO3	☐	PES_METO2	PES_METODO	CHAR	4	0	Contract processing method (other methods)
65	FERE3	☐	PES_FERE2	DATUM	DATS	8	0	Start date for reduction/allowance (other methods)
66	METO4	☐	PES_METO2	PES_METODO	CHAR	4	0	Contract processing method (other methods)
67	FERE4	☐	PES_FERE2	DATUM	DATS	8	0	Start date for reduction/allowance (other methods)
68	.INCLUDE	☐				0	0	Concurrent employment (Detail)
69	PLPOR	☐	PES_PLPOR	DEC3_2	DEC	5	2	FOGASA percentage multiple employment
70	PLPDE	☐	PES_PLPDE	DEC3_2	DEC	5	2	Percentage of Unemployment concurrent employees
71	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HCMT_BSP_PA_ES_R0061	BERKT	T5E48	CATEG
2	HCMT_BSP_PA_ES_R0061	CODPR	T005S	BLAND
3	HCMT_BSP_PA_ES_R0061	EPIGR	T5E6T	EPIGR
4	HCMT_BSP_PA_ES_R0061	GRCOT	T5E3T	GRCOT
5	HCMT_BSP_PA_ES_R0061	METO2	T5ES3	METOD
6	HCMT_BSP_PA_ES_R0061	OCUPA	T5E4C	OCUPA	KEY
7	HCMT_BSP_PA_ES_R0061	PLNSS	T5E34	CONSS
8	HCMT_BSP_PA_ES_R0061	RESO2	T5ES4	RESOL
9	HCMT_BSP_PA_ES_R0061	RESOL	T5ES4	RESOL
10	HCMT_BSP_PA_ES_R0061	SOASV	T5E03	COSOC
11	HCMT_BSP_PA_ES_R0061	SOILT	T5E03	COSOC

History

Last changed by/on	SAP	20130529
SAP Release Created in	100