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

History

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