SAP ABAP Table PES_FORM_F0_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_FORM_F0_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_ERE_PERS		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	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
6	PRIMER_APELLIDO	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
7	SEGUNDO_APELLIDO	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
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	10	0
12	FECHNAC	☐			DATS	8	0
13	LUGAR_NAC	☐	GBLND	LAND1	CHAR	3	0	Country of Birth
14	NACIONALIDAD	☐	LAND1	LAND1	CHAR	3	0	Country Key
15	TIPODOC	☐			CHAR	1	0
16	PROVINCIA	☐			CHAR	2	0
17	SEXO	☐			CHAR	1	0
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_VND_CP	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
57	TOTAL_DIAS_CC	☐	INT4	INT4	INT4	10	0	Natural number
58	TOTAL_DIAS_CP	☐	INT4	INT4	INT4	10	0	Natural number
59	TOTAL_DIAS_AC	☐	INT4	INT4	INT4	10	0	Natural number
60	TOTAL_DIAS_VND	☐	INT4	INT4	INT4	10	0	Natural number
61	TOTAL_DIAS_VND_CP	☐	INT4	INT4	INT4	10	0	Natural number
62	BASDIACC	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
63	BASDIACP	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
64	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
65	CPSIN	☐	PES_CPSIN	PES_CPSIN	CHAR	1	0	Public or labor union post
66	CPSDU	☐	PES_CPSDC	PES_PERC_DEC	DEC	5	2	Time dedicated to public or labor union post
67	TPARCIAL	☐	PES_SUFORM_ERE_TPARCIAL		STRU	0	0
68	TIPO1	☐			CHAR	1	0
69	DIAS1	☐			CHAR	3	0
70	FEC_INI1	☐			DATS	8	0
71	FEC_FIN1	☐			DATS	8	0
72	TIPO2	☐			CHAR	1	0
73	DIAS2	☐			CHAR	3	0
74	FEC_INI2	☐			DATS	8	0
75	FEC_FIN2	☐			DATS	8	0
76	TIPO3	☐			CHAR	1	0
77	DIAS3	☐			CHAR	3	0
78	FEC_INI3	☐			DATS	8	0
79	FEC_FIN3	☐			DATS	8	0
80	TIPO4	☐			CHAR	1	0
81	DIAS4	☐			CHAR	3	0
82	FEC_INI4	☐			DATS	8	0
83	FEC_FIN4	☐			DATS	8	0
84	ERE	☐	PES_SUFORM_ERE_COMPL		STRU	0	0
85	RED_ERE	☐	PES_REDERE	PES_PERC_DEC	DEC	5	2	Reduced working hours through ERE
86	CUI_HIJ	☐	PES_REDHIJ	PES_PERC_DEC	DEC	5	2	Reduced working time for child care
87	TRAMITACION	☐	PES_SUFORM_ERE_TRAMITACION		STRU	0	0
88	DIAS	☐			CHAR	3	0
89	FEC_INI	☐			DATS	8	0
90	FEC_FIN	☐			DATS	8	0

History

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