SAP ABAP Table PES_SUFORM_INEM_TRABAJADOR (Employee data)

Hierarchy

☛ SAP_HRCES (Software Component) Sub component SAP_HRCES of SAP_HR
   ⤷ PY-ES (Application Component) Spain
     ⤷ PC04 (Package) HR Payroll: Spain

Basic Data

Table Category	INTTAB	Structure
Structure	PES_SUFORM_INEM_TRABAJADOR	Table Relationship Diagram
Short Description	Employee data

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	PERNR	☐	P_PERNR	PERNR	NUMC	8	0	Personnel Number
2	PERS	☐	PES_SUFORM_INEM_IDENT		STRU	0	0
3	NIF	☐	CODIM	CHAR9	CHAR	9	0	Tax payer's reference number (NIF)
4	NATSS	☐	NATSS	NUM12	NUMC	12	0	Employee's Social insurance number
5	NOMBRE_PILA	☐	VORNA	VORNM	CHAR	25	0	First Name
6	PRIMER_APELLIDO	☐	NACHN	NACHN	CHAR	25	0	Last Name
7	SEGUNDO_APELLIDO	☐	NACH2	NACHN	CHAR	25	0	Second Name / Name at Birth
8	NOMBRE	☐			CHAR	122	0
9	EDOCIVIL	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key
10	EDOCIVILDESC	☐	FATXT	FATXT	CHAR	6	0	Marital Status
11	NUMHIJOS	☐	INT4	INT4	INT4	10	0	Natural number
12	FECHNAC	☐	DATS	DATS	DATS	8	0	Field of type DATS
13	LUGAR_NAC	☐	GBLND	LAND1	CHAR	3	0	Country of Birth
14	NACIONALIDAD	☐	LAND1	LAND1	CHAR	3	0	Country Key
15	TIPODOC	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
16	PROVINCIA	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
17	SEXO	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
18	DIRE	☐	PES_SUFORM_INEM_DIRECCION		STRU	0	0
19	TIPO_VIA_PUBL	☐	STRDS	STRDS	CHAR	2	0	Street Abbreviation
20	DOMICILIO	☐			CHAR	32	0
21	NUMERO_CASA	☐	PAD_HSNMR	PAD_HSNMR	CHAR	10	0	House Number
22	ID_VIV_CASA	☐			CHAR	12	0
23	LOC	☐			CHAR	32	0
24	PROVINCIA	☐			CHAR	32	0
25	CODPOS	☐			NUMC	5	0
26	PAIS	☐			CHAR	3	0
27	TELEFONO	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
28	MOVIL	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
29	GRUPOCOT	☐	GRCOT	GRCOT	NUMC	2	0	Key for the contribution group	*
30	.INCLUDE	☐				0	0	Work data
31	DOMCENTTRAB	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
32	TIPOCONTRA	☐	PES_CLCON	PES_IDSEG	CHAR	3	0	Contract Key for Social Insurance
33	CONTR_TEXT	☐	TEXT32	TEXT32	CHAR	32	0	Text length 32
34	PROFESION	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
35	CATEGCODI	☐	NUMC04	NUMC4	NUMC	4	0	Count Parameters
36	CATEGTEXT	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
37	FECHAEXIL	☐	DATS	DATS	DATS	8	0	Field of type DATS
38	FECHAEFIN	☐	DATS	DATS	DATS	8	0	Field of type DATS
39	FECHASUSP	☐	DATS	DATS	DATS	8	0	Field of type DATS
40	CAUSACODI	☐	PES_CAUEXT	PES_CAUEXT	NUMC	2	0	Legal situation of unemployment	*
41	CAUSATEXT	☐	PES_TXT150	PES_TXT150	CHAR	150	0	150 character text
42	FECHALTSS	☐	DATS	DATS	DATS	8	0	Field of type DATS
43	FECHBAJSS	☐	DATS	DATS	DATS	8	0	Field of type DATS
44	FECHA_VND	☐	DATS	DATS	DATS	8	0	Field of type DATS
45	NUEAN	☐	PES_NUEAN		NUMC	4	0	INEM no. - year
46	NUENU	☐	PES_NUENU		NUMC	6	0	INEM no. - number
47	TEXT_TYPEE	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
48	DIAS_TRAB	☐			CHAR	3	0
49	DURACION	☐	PES_DURCT		CHAR	15	0	Duration of employment contract
50	COD_OCUPA	☐	PES_CODOCU		CHAR	8	0	Work center commitment code
51	COTZ	☐	PES_FORM_F0_COT_CC_TABLE		TTYP	0	0
52	TOTAL_CC	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
53	TOTAL_CP	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
54	TOTAL_AC	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
55	TOTAL_VND	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
56	TOTAL_DIAS_CC	☐	INT4	INT4	INT4	10	0	Natural number
57	TOTAL_DIAS_CP	☐	INT4	INT4	INT4	10	0	Natural number
58	TOTAL_DIAS_AC	☐	INT4	INT4	INT4	10	0	Natural number
59	TOTAL_DIAS_VND	☐	INT4	INT4	INT4	10	0	Natural number
60	BASDIACC	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
61	BASDIACP	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount

History

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