SAP ABAP Table Q0061 (Screen Fields 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	Q0061	Table Relationship Diagram
Short Description	Screen Fields 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	PFHMI	☐	PFHMI	NUM5	NUMC	5	0	Child allowance amount for challenged children
2	PFAMI	☐	PFAMI	NUM5	NUMC	5	0	Child allowance amount
3	TEXT1	☐	TEXT32	TEXT32	CHAR	32	0	Text length 32
4	TEXT2	☐	TEXT32	TEXT32	CHAR	32	0	Text length 32
5	CODPR	☐	PES_CODPR	REGIO	CHAR	3	0	Province code	T005S
6	NRAFI	☐	PES_NRAFI	NUM8	NUMC	8	0	Affiliation number
7	NACON	☐	PES_NACON	CHAR2	CHAR	2	0	Social Insurance check digit
8	NISSE	☐	NISS1	NUM11	NUMC	11	0	Company CA code
9	NISS2	☐	NISS2	NUM11	NUMC	11	0	CA code for training contracts
10	NISS3	☐	NISS3	NUM11	NUMC	11	0	CA Code for Foreigners
11	NISS4	☐	PES_NISS4	NUM11	NUMC	11	0	CA code for consultants and administrators
12	IDSEG	☐	PES_IDSEG	PES_IDSEG	CHAR	3	0	Main contract key
13	ARR	☐	PES_ARR	PES_ARR	CHAR	1	0	Indicator of allowances and reductions carried forward
14	COETP	☐	PES_COETP	DEC4	DEC	4	0	Part-time coefficient for contracts
15	CLCON	☐	PES_CLCON	PES_IDSEG	CHAR	3	0	Contract Key for Social Insurance
16	CODES	☐	PES_CODES	PES_CODES	CHAR	1	0	Unemployed
17	FEINI	☐	PES_FECH_I	DATUM	DATS	8	0	Contracts start date
18	INDSU	☐	PES_INDSUB	CHAR1	CHAR	1	0	Partial subrogation indicator
19	RELAB	☐	PES_RELLAB	PES_RELLAB	CHAR	4	0	Special work relationship
20	NUSST	☐	PES_NUSS	NUM12	NUMC	12	0	Replaced employee Social Insurance number
21	CAUSU	☐	PES_CAUSAS	PES_CAUSAS	CHAR	2	0	Reason for substitution
22	DISP	☐	PES_DISP	CHAR3	CHAR	3	0	Display field
23	PLPOR	☐	PES_PLPOR	DEC3_2	DEC	5	2	FOGASA percentage multiple employment
24	RACIN	☐	PES_RACIN	XFELD	CHAR	1	0	Active Insertion Income
25	ALUMB	☐	PES_ALUMB	XFELD	CHAR	1	0	Contract after giving birth
26	REDJB	☐	PES_REDJB	NUMC2	NUMC	2	0	Retirement age reduction coefficient
27	RELEV	☐	PES_RELEV	CAT_FLAG	CHAR	1	0	Relief contract
28	RESOL	☐	PES_RESOL	NUM5	NUMC	5	0	Legal regulation applicable
29	PLPDE	☐	PES_PLPDE	DEC3_2	DEC	5	2	Percentage of Unemployment concurrent employees
30	COLTR	☐	PES_COLTR	PES_COLTR	NUMC	3	0	Worker group
31	MREIN	☐	PES_MREIN	PES_MREIN	CHAR	1	0	Rehired female employee
32	AUTTR	☐	PES_AUTTR1	CHAR3	CHAR	3	0	Authorization to work (foreigners)
33	AUTVI	☐	PES_AUTVI	DATS	DATS	8	0	Validity of authorization to work (foreigners)
34	TPCCT	☐	PES_TPCCT	TEXT32	CHAR	32	0	Contribution Account Code type
35	CCCEE	☐	PES_CCCTR	NUM11	NUMC	11	0	Contribution Account Code(CAC) to which employee is assigned	T5E08
36	NISS1	☐	NISS1	NUM11	NUMC	11	0	Company CA code
37	OCUPT	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
38	CNAET	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
39	CNAEC	☐	PES_CNAEC	CHAR5	CHAR	5	0	National classification of business activities
40	CNAED	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
41	DTRTP	☐	PES_DTRTP	NUMC2	NUMC	2	0	Days worked part-time
42	PLNS2	☐	PES_CON20	PES_CON20	NUMC	20	0	Pay scale code	*
43	CONTX	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
44	CPTRA	☐	PES_CPTRA	PES_CPTRA	NUMC	2	0	Change of work center

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	Q0061	CCCEE	T5E08	NISSE
2	Q0061	CODPR	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in