SAP ABAP Table PES_FORM_RE_L3_R (ERE Company Certificate)
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_RE_L3_R   Table Relationship Diagram
Short Description ERE Company Certificate    
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 EMPRESA PES_SUFORM_ERE_EMPRESA   STRU 0   0    
2 NISSE_EMP NISS1 NUM11 NUMC 11   0   Company CA code  
3 NOMBRE     CHAR 40   0    
4 DIRE PES_SUFORM_ERE_DIRECCION   STRU 0   0    
5 .INCLUDE       0   0   Form: INEM address  
6 TIPO_VIA_PUBL STRDS STRDS CHAR 2   0   Street Abbreviation  
7 DOMICILIO     CHAR 32   0    
8 NUMERO_CASA PAD_HSNMR PAD_HSNMR CHAR 10   0   House Number  
9 ID_VIV_CASA     CHAR 12   0    
10 LOC     CHAR 32   0    
11 PROVINCIA     CHAR 32   0    
12 CODPOS     NUMC 5   0    
13 PAIS     CHAR 3   0    
14 TELEFONO TELNR TELNR CHAR 14   0   Telephone Number  
15 MOVIL TELNR TELNR CHAR 14   0   Telephone Number  
16 ACT_ECON     CHAR 40   0    
17 ACT_ECON_COD     CHAR 40   0    
18 REP_EMP PES_SUFORM_ERE_REP_EMP   STRU 0   0    
19 .INCLUDE       0   0   Form: ERE Person  
20 NIF CODIM CHAR9 CHAR 9   0   Tax payer's reference number (NIF)  
21 NATSS NATSS NUM12 NUMC 12   0   Employee's Social insurance number  
22 NOMBRE_PILA PAD_VORNA PAD_VORNM CHAR 40   0   First Name  
23 PRIMER_APELLIDO PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
24 SEGUNDO_APELLIDO PAD_NACH2 PAD_NACHN CHAR 40   0   Second Name  
25 NOMBRE     CHAR 122   0    
26 EDOCIVIL FAMST FAMST CHAR 1   0   Marital Status Key  
27 EDOCIVILDESC FATXT FATXT CHAR 6   0   Marital Status  
28 NUMHIJOS     INT4 10   0    
29 FECHNAC     DATS 8   0    
30 LUGAR_NAC GBLND LAND1 CHAR 3   0   Country of Birth  
31 NACIONALIDAD LAND1 LAND1 CHAR 3   0   Country Key  
32 TIPODOC     CHAR 1   0    
33 PROVINCIA     CHAR 2   0    
34 SEXO     CHAR 1   0    
35 CARGO     CHAR 40   0    
36 REPCOB PES_SUFORM_ERE_REP_EMP   STRU 0   0    
37 .INCLUDE       0   0   Form: ERE Person  
38 NIF CODIM CHAR9 CHAR 9   0   Tax payer's reference number (NIF)  
39 NATSS NATSS NUM12 NUMC 12   0   Employee's Social insurance number  
40 NOMBRE_PILA PAD_VORNA PAD_VORNM CHAR 40   0   First Name  
41 PRIMER_APELLIDO PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
42 SEGUNDO_APELLIDO PAD_NACH2 PAD_NACHN CHAR 40   0   Second Name  
43 NOMBRE     CHAR 122   0    
44 EDOCIVIL FAMST FAMST CHAR 1   0   Marital Status Key  
45 EDOCIVILDESC FATXT FATXT CHAR 6   0   Marital Status  
46 NUMHIJOS     INT4 10   0    
47 FECHNAC     DATS 8   0    
48 LUGAR_NAC GBLND LAND1 CHAR 3   0   Country of Birth  
49 NACIONALIDAD LAND1 LAND1 CHAR 3   0   Country Key  
50 TIPODOC     CHAR 1   0    
51 PROVINCIA     CHAR 2   0    
52 SEXO     CHAR 1   0    
53 CARGO     CHAR 40   0    
54 PAGOD PES_XFELD XFELD CHAR 1   0   Selection field (checkbox)  
55 PAGON PES_XFELD XFELD CHAR 1   0   Selection field (checkbox)  
56 CNAE PES_CNAEC CHAR5 CHAR 5   0   National classification of business activities  
57 CNAE_DESC     CHAR 60   0    
58 REG_SS_COD     CHAR 8   0    
59 REG_SS_DESC     CHAR 60   0    
60 TRABAJADOR PES_FORM_F0_TRABAJADOR   STRU 0   0    
61 PERNR P_PERNR PERNR NUMC 8   0   Personnel Number  
62 PERS PES_SUFORM_ERE_PERS   STRU 0   0    
63 NIF CODIM CHAR9 CHAR 9   0   Tax payer's reference number (NIF)  
64 NATSS NATSS NUM12 NUMC 12   0   Employee's Social insurance number  
65 NOMBRE_PILA PAD_VORNA PAD_VORNM CHAR 40   0   First Name  
66 PRIMER_APELLIDO PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
67 SEGUNDO_APELLIDO PAD_NACH2 PAD_NACHN CHAR 40   0   Second Name  
68 NOMBRE     CHAR 122   0    
69 EDOCIVIL FAMST FAMST CHAR 1   0   Marital Status Key  
70 EDOCIVILDESC FATXT FATXT CHAR 6   0   Marital Status  
71 NUMHIJOS     INT4 10   0    
72 FECHNAC     DATS 8   0    
73 LUGAR_NAC GBLND LAND1 CHAR 3   0   Country of Birth  
74 NACIONALIDAD LAND1 LAND1 CHAR 3   0   Country Key  
75 TIPODOC     CHAR 1   0    
76 PROVINCIA     CHAR 2   0    
77 SEXO     CHAR 1   0    
78 DIRE PES_SUFORM_INEM_DIRECCION   STRU 0   0    
79 TIPO_VIA_PUBL STRDS STRDS CHAR 2   0   Street Abbreviation  
80 DOMICILIO     CHAR 32   0    
81 NUMERO_CASA PAD_HSNMR PAD_HSNMR CHAR 10   0   House Number  
82 ID_VIV_CASA     CHAR 12   0    
83 LOC     CHAR 32   0    
84 PROVINCIA     CHAR 32   0    
85 CODPOS     NUMC 5   0    
86 PAIS     CHAR 3   0    
87 TELEFONO TELNR TELNR CHAR 14   0   Telephone Number  
88 MOVIL TELNR TELNR CHAR 14   0   Telephone Number  
89 GRUPOCOT GRCOT GRCOT NUMC 2   0   Key for the contribution group  
90 .INCLUDE       0   0   Work data  
91 DOMCENTTRAB CHAR40 CHAR40 CHAR 40   0   Character field of length 40  
92 TIPOCONTRA PES_CLCON PES_IDSEG CHAR 3   0   Contract Key for Social Insurance  
93 CONTR_TEXT TEXT32 TEXT32 CHAR 32   0   Text length 32  
94 PROFESION CHAR30 CHAR30 CHAR 30   0   30 Characters  
95 CATEGCODI NUMC04 NUMC4 NUMC 4   0   Count Parameters  
96 CATEGTEXT TEXT50 TEXT50 CHAR 50   0   Text Field  
97 FECHAEXIL DATS DATS DATS 8   0   Field of type DATS  
98 FECHAEFIN DATS DATS DATS 8   0   Field of type DATS  
99 FECHASUSP DATS DATS DATS 8   0   Field of type DATS  
100 CAUSACODI PES_CAUEXT PES_CAUEXT NUMC 2   0   Legal situation of unemployment  
101 CAUSATEXT PES_TXT150 PES_TXT150 CHAR 150   0   150 character text  
102 FECHALTSS DATS DATS DATS 8   0   Field of type DATS  
103 FECHBAJSS DATS DATS DATS 8   0   Field of type DATS  
104 FECHA_VND DATS DATS DATS 8   0   Field of type DATS  
105 NUEAN PES_NUEAN   NUMC 4   0   INEM no. - year  
106 NUENU PES_NUENU   NUMC 6   0   INEM no. - number  
107 TEXT_TYPEE CHAR12 CHAR12 CHAR 12   0   Character Field of Length 12  
108 DIAS_TRAB     CHAR 3   0    
109 DURACION PES_DURCT   CHAR 15   0   Duration of employment contract  
110 COD_OCUPA PES_CODOCU   CHAR 8   0   Work center commitment code  
111 COTZ PES_FORM_F0_COT_CC_TABLE   TTYP 0   0    
112 TOTAL_CC MAXBT PRBETRG CURR 15   2   HR Payroll: Amount  
113 TOTAL_CP MAXBT PRBETRG CURR 15   2   HR Payroll: Amount  
114 TOTAL_AC MAXBT PRBETRG CURR 15   2   HR Payroll: Amount  
115 TOTAL_VND MAXBT PRBETRG CURR 15   2   HR Payroll: Amount  
116 TOTAL_VND_CP MAXBT PRBETRG CURR 15   2   HR Payroll: Amount  
117 TOTAL_DIAS_CC INT4 INT4 INT4 10   0   Natural number  
118 TOTAL_DIAS_CP INT4 INT4 INT4 10   0   Natural number  
119 TOTAL_DIAS_AC INT4 INT4 INT4 10   0   Natural number  
120 TOTAL_DIAS_VND INT4 INT4 INT4 10   0   Natural number  
121 TOTAL_DIAS_VND_CP INT4 INT4 INT4 10   0   Natural number  
122 BASDIACC MAXBT PRBETRG CURR 15   2   HR Payroll: Amount  
123 BASDIACP MAXBT PRBETRG CURR 15   2   HR Payroll: Amount  
124 WAERS WAERS WAERS CUKY 5   0   Currency Key  
125 CPSIN PES_CPSIN PES_CPSIN CHAR 1   0   Public or labor union post  
126 CPSDU PES_CPSDC PES_PERC_DEC DEC 5   2   Time dedicated to public or labor union post  
127 TPARCIAL PES_SUFORM_ERE_TPARCIAL   STRU 0   0    
128 TIPO1     CHAR 1   0    
129 DIAS1     CHAR 3   0    
130 FEC_INI1     DATS 8   0    
131 FEC_FIN1     DATS 8   0    
132 TIPO2     CHAR 1   0    
133 DIAS2     CHAR 3   0    
134 FEC_INI2     DATS 8   0    
135 FEC_FIN2     DATS 8   0    
136 TIPO3     CHAR 1   0    
137 DIAS3     CHAR 3   0    
138 FEC_INI3     DATS 8   0    
139 FEC_FIN3     DATS 8   0    
140 TIPO4     CHAR 1   0    
141 DIAS4     CHAR 3   0    
142 FEC_INI4     DATS 8   0    
143 FEC_FIN4     DATS 8   0    
144 ERE PES_SUFORM_ERE_COMPL   STRU 0   0    
145 RED_ERE PES_REDERE PES_PERC_DEC DEC 5   2   Reduced working hours through ERE  
146 CUI_HIJ PES_REDHIJ PES_PERC_DEC DEC 5   2   Reduced working time for child care  
147 TRAMITACION PES_SUFORM_ERE_TRAMITACION   STRU 0   0    
148 DIAS     CHAR 3   0    
149 FEC_INI     DATS 8   0    
150 FEC_FIN     DATS 8   0    
151 TC2_DATA PES_SUFORM_ERE_TC2   STRU 0   0    
152 CLAVE_AUTOR PB04_AUTOR NUM08 NUMC 8   0   RED System authorization key  
153 FECHA_AUTOR PES_FECAUT SYDATS DATS 8   0   RED system authorization date  
154 PR_FLAG     CHAR 1   0    
155 FEC_EMI_DOCU DATS DATS DATS 8   0   Field of type DATS  
History
Last changed by/on SAP  20130529 
SAP Release Created in 600