SAP ABAP Table PES_FORM_I190_0003 (Forms: Deductions 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_I190_0003   Table Relationship Diagram
Short Description Forms: Deductions 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 CABECERA PES_SUFORM_I190_CERET_CABECERA   STRU 0   0    
2 EJER PES_190EJR CHAR4 CHAR 4   0   Fiscal year of declaration  
3 NIF_PER PES_190NPE CHAR9 CHAR 9   0   Payee or declared party NIF  
4 NAME PES_190NOM CHAR40 CHAR 40   0   Surnames and name or registered company name  
5 NAME_EMPR PES_190NOM CHAR40 CHAR 40   0   Surnames and name or registered company name  
6 NIF_PRES PES_190NIP CHAR9 CHAR 9   0   DME 190 model: NIF of presenting party  
7 SG PES_190SIG CHAR2 CHAR 2   0   DME 190 model: Initials of fiscal residence  
8 VIA PES_190VIA CHAR40 CHAR 40   0   DME 190 model: Street  
9 NUMO PES_190NUM CHAR5 CHAR 5   0   DME model 190: Number  
10 ESCALERA PES_190ESC CHAR2 CHAR 2   0   DME model 190: Sequence  
11 PISO PES_190PIS CHAR2 CHAR 2   0   DME 190 model: Floor  
12 PUERTA PES_190PTA CHAR2 CHAR 2   0   DME 190 model: Apartment no.  
13 CPOS PES_190CPS NUM5 NUMC 5   0   DME model 190: Zip code  
14 MUNIC PES_190MUN CHAR40 CHAR 40   0   DME model 190: Municipality  
15 PROVINCIA PES_190CPR CHAR2 CHAR 2   0   Province code  
16 TELN PES_190TLN CHAR9 CHAR 9   0   Telephone number of contact person  
17 PROV_TRA     CHAR 20   0    
18 PROV_EMP     CHAR 20   0    
19 REPRESENT PES_SUFORM_I190_CERET_REPRESEN   STRU 0   0    
20 NIF     CHAR 9   0    
21 NOMBRE     CHAR 40   0    
22 TITULO     CHAR 30   0    
23 ACTIV_ECONOM EACTI EACTI CHAR 4   0   Company business activity  
24 ACTIV_ECONOM_TEXT TEXT50 TEXT50 CHAR 50   0   Text Field  
25 A_NAC PES_190ANA CHAR4 CHAR 4   0   Year born  
26 DISCA PES_190DIS CHAR1 CHAR 1   0   DME template 190: Disability  
27 SIT_FAM PES_190SIF CHAR1 CHAR 1   0   DME model 190: Family situation  
28 NIF_CONY PES_190NIC CHAR9 CHAR 9   0   DME template 190: Spouse NIF  
29 PECOM PECOM WERTV5 CURR 9   2   Compensatory payments  
30 ALIME PES_ALIME WERTV5 CURR 9   2   Annuities for child maintenance  
31 PROLACTLAB PES_190PAL CHAR1 CHAR 1   0   Extension of work activity  
32 MOV_GEOG PES_190MGE CHAR1 CHAR 1   0   Geographic mobility  
33 HIJOS_0_2 PES_190MN3 CHAR1 CHAR 1   0   Children less than 3 years old  
34 HIJOS_0_2_E PES_190M3E CHAR1 CHAR 1   0   Children younger than 3 years old integral  
35 HIJOS_3_24 PES_190RES CHAR2 CHAR 2   0   Remaining children (between 3 and 24 years old)  
36 HIJOS_3_24_E PES_190REE CHAR2 CHAR 2   0   Remaining children calculated as integer  
37 DESC_33_65 PES_190DM3 CHAR2 CHAR 2   0   Descendants with disability between 33 and 65%  
38 DESC_33_65_E PES_190D3E CHAR2 CHAR 2   0   Descendants disabled between 33 and 65% integrall  
39 DESC_65 PES_190DMA CHAR2 CHAR 2   0   Disabled descendants with reduced mobility  
40 DESC_65_E PES_190DAE CHAR2 CHAR 2   0   Disabled descendants with reduced mobility integral  
41 DESC_ASIST PES_190DM6 CHAR2 CHAR 2   0   Descendants with degree of disability 65%  
42 DESC_ASIST_E PES_190D6E CHAR2 CHAR 2   0   Descendants disabled 65% integral  
43 ASC_75 PES_190A65 CHAR1 CHAR 1   0   Ancestors between 65 and 75 years of age  
44 ASC_75_E PES_19065E CHAR1 CHAR 1   0   Ancestors less than 75 years old integral  
45 ASC_65 PES_190A75 CHAR1 CHAR 1   0   Ancestors more than 75 years old  
46 ASC_65_E PES_19075E CHAR1 CHAR 1   0   Ancestors more than 75 years old integral  
47 ASCM_33_65 PES_190AM3 CHAR1 CHAR 1   0   Ancestors with disability between 33 and 65%  
48 ASCM_33_65_E PES_190A3E CHAR1 CHAR 1   0   Ancestors with disability between 33 and 65& integral  
49 ASCM_65 PES_190AMA CHAR1 CHAR 1   0   Disabled ancestors with reduced mobility  
50 ASCM_65_E PES_190AAE CHAR1 CHAR 1   0   Disabled ancestors with reduced mobility integral  
51 ASCM_ASIST PES_190AM6 CHAR1 CHAR 1   0   Ancestors with disability 65%  
52 ASCM_ASIST_E PES_190A6E CHAR1 CHAR 1   0   Ancestors with a disability of 65% integral  
53 NOHIJ PES_190RES CHAR2 CHAR 2   0   Remaining children (between 3 and 24 years old)  
54 .INCLUDE       0   0   Form: Deductions certificate - Monetary and in kind amount  
55 DINER_PER     CHAR 15   0    
56 DINER_RET     CHAR 15   0    
57 ESPEC_PER     CHAR 15   0    
58 ESPEC_RET     CHAR 15   0    
59 ESPEC_REP     CHAR 15   0    
60 ESPEC_NOREP     CHAR 15   0    
61 REDUC     CHAR 15   0    
62 CINTG     CHAR 15   0    
63 REDU1 PES_SUFORM_I190_CERET_INTGR   STRU 0   0    
64 BASIR     CHAR 15   0    
65 BAITG     CHAR 15   0    
66 REDUC     CHAR 15   0    
67 RETEN     CHAR 15   0    
68 PITGR     CHAR 3   0    
69 REDU2 PES_SUFORM_I190_CERET_INTGR   STRU 0   0    
70 BASIR     CHAR 15   0    
71 BAITG     CHAR 15   0    
72 REDUC     CHAR 15   0    
73 RETEN     CHAR 15   0    
74 PITGR     CHAR 3   0    
75 REDU3 PES_SUFORM_I190_CERET_INTGR   STRU 0   0    
76 BASIR     CHAR 15   0    
77 BAITG     CHAR 15   0    
78 REDUC     CHAR 15   0    
79 RETEN     CHAR 15   0    
80 PITGR     CHAR 3   0    
81 MUTUAS     CHAR 15   0    
82 GASTOS     CHAR 15   0    
83 COOPE     CHAR 15   0    
84 ZIMCLI     CHAR 15   0    
85 EJDEV1     CHAR 4   0    
86 EJDEV2     CHAR 4   0    
87 EJDEV3     CHAR 4   0    
88 EJDEV4     CHAR 4   0    
89 RETEN1     CHAR 15   0    
90 RETEN2     CHAR 15   0    
91 RETEN3     CHAR 15   0    
92 RETEN4     CHAR 15   0    
93 PERCE1     CHAR 15   0    
94 PERCE2     CHAR 15   0    
95 PERCE3     CHAR 15   0    
96 PERCE4     CHAR 15   0    
97 NJDEV1     CHAR 4   0    
98 NJDEV2     CHAR 4   0    
99 NJDEV3     CHAR 4   0    
100 NERCE1     CHAR 15   0    
101 NERCE2     CHAR 15   0    
102 NERCE3     CHAR 15   0    
103 SJDEV1     CHAR 4   0    
104 SJDEV2     CHAR 4   0    
105 SJDEV3     CHAR 4   0    
106 SJDEV4     CHAR 4   0    
107 SETEN1     CHAR 15   0    
108 SETEN2     CHAR 15   0    
109 SETEN3     CHAR 15   0    
110 SETEN4     CHAR 15   0    
111 SERCE1     CHAR 15   0    
112 SERCE2     CHAR 15   0    
113 SERCE3     CHAR 15   0    
114 SERCE4     CHAR 15   0    
115 DIETAS     CHAR 15   0    
116 DESPID     CHAR 15   0    
117 EXENTO     CHAR 15   0    
118 O_EXEN     CHAR 15   0    
119 PREMIO PES_SUFORM_I190_CERET_DINESP   STRU 0   0    
120 DINER_PER     CHAR 15   0    
121 DINER_RET     CHAR 15   0    
122 ESPEC_PER     CHAR 15   0    
123 ESPEC_RET     CHAR 15   0    
124 ESPEC_REP     CHAR 15   0    
125 ESPEC_NOREP     CHAR 15   0    
126 DATOS_ADICIONALES PES_SUFORM_I190_CERET_ADD_DATA   STRU 0   0    
127 PERNR P_PERNR PERNR NUMC 8   0   Personnel Number  
128 NIF     CHAR 9   0    
129 TRAT_EMPL ANREX ANREX CHAR 5   0   Form of address text  
130 APELLIDO PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
131 SIGLA_DOM STRDS STRDS CHAR 2   0   Street Abbreviation  
132 CP PSTLZ_HR PSTLZ CHAR 10   0   Postal Code  
133 PROVINCIA BEZEI20 TEXT20 CHAR 20   0   Description  
134 POBLACION PAD_ORT01 PAD_ORT01 CHAR 40   0   City  
135 DIRECCION PAD_STRAS PAD_STRAS CHAR 60   0   Street and House Number  
136 PAIS LANDX TEXT15 CHAR 15   0   Country Name  
137 FECHA_ACTUAL     DATS 8   0    
138 FECHA_FIN_EJ     DATS 8   0    
139 EDIFICIO AD_BLD_10 TEXT10 CHAR 10   0   Building (number or code)  
140 NUMERO PAD_HSNMR PAD_HSNMR CHAR 10   0   House Number  
141 ID_CASA PAD_POSTA PAD_HSNMR CHAR 10   0   Identification of an apartment in a building  
142 PLANTA AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
143 CPO_ADD PAD_LOCAT PAD_LOCAT CHAR 40   0   2nd address line  
144 ADR03 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
145 ADR04 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
146 ACTUAL PES_SUFORM_I190_CERET_ORG_DATA   STRU 0   0    
147 DIV_PERS PERSA PERSA CHAR 4   0   Personnel Area  
148 SUBDIVISION BTRTL BTRTL CHAR 4   0   Personnel Subarea  
149 DIVISION GSBER GSBER CHAR 4   0   Business Area  
150 C_COSTE KOSTL KOSTL CHAR 10   0   Cost Center  
151 POBL_DIV ORT01 TEXT25 CHAR 25   0   City  
152 SOCIEDAD BUKRS BUKRS CHAR 4   0   Company Code  
153 FINEJER PES_SUFORM_I190_CERET_ORG_DATA   STRU 0   0    
154 DIV_PERS PERSA PERSA CHAR 4   0   Personnel Area  
155 SUBDIVISION BTRTL BTRTL CHAR 4   0   Personnel Subarea  
156 DIVISION GSBER GSBER CHAR 4   0   Business Area  
157 C_COSTE KOSTL KOSTL CHAR 10   0   Cost Center  
158 POBL_DIV ORT01 TEXT25 CHAR 25   0   City  
159 SOCIEDAD BUKRS BUKRS CHAR 4   0   Company Code  
160 S_0004 PES_SUFORM_I190_0004   STRU 0   0    
161 CABECERA PES_SUFORM_I190_CERET_CABECERA   STRU 0   0    
162 EJER PES_190EJR CHAR4 CHAR 4   0   Fiscal year of declaration  
163 NIF_PER PES_190NPE CHAR9 CHAR 9   0   Payee or declared party NIF  
164 NAME PES_190NOM CHAR40 CHAR 40   0   Surnames and name or registered company name  
165 NAME_EMPR PES_190NOM CHAR40 CHAR 40   0   Surnames and name or registered company name  
166 NIF_PRES PES_190NIP CHAR9 CHAR 9   0   DME 190 model: NIF of presenting party  
167 SG PES_190SIG CHAR2 CHAR 2   0   DME 190 model: Initials of fiscal residence  
168 VIA PES_190VIA CHAR40 CHAR 40   0   DME 190 model: Street  
169 NUMO PES_190NUM CHAR5 CHAR 5   0   DME model 190: Number  
170 ESCALERA PES_190ESC CHAR2 CHAR 2   0   DME model 190: Sequence  
171 PISO PES_190PIS CHAR2 CHAR 2   0   DME 190 model: Floor  
172 PUERTA PES_190PTA CHAR2 CHAR 2   0   DME 190 model: Apartment no.  
173 CPOS PES_190CPS NUM5 NUMC 5   0   DME model 190: Zip code  
174 MUNIC PES_190MUN CHAR40 CHAR 40   0   DME model 190: Municipality  
175 PROVINCIA PES_190CPR CHAR2 CHAR 2   0   Province code  
176 TELN PES_190TLN CHAR9 CHAR 9   0   Telephone number of contact person  
177 PROV_TRA     CHAR 20   0    
178 PROV_EMP     CHAR 20   0    
179 REPRESENT PES_SUFORM_I190_CERET_REPRESEN   STRU 0   0    
180 NIF     CHAR 9   0    
181 NOMBRE     CHAR 40   0    
182 TITULO     CHAR 30   0    
183 ACTIV_ECONOM EACTI EACTI CHAR 4   0   Company business activity  
184 ACTIV_ECONOM_TEXT TEXT50 TEXT50 CHAR 50   0   Text Field  
185 PROFES PES_SUFORM_I190_CERET_DINESP   STRU 0   0    
186 DINER_PER     CHAR 15   0    
187 DINER_RET     CHAR 15   0    
188 ESPEC_PER     CHAR 15   0    
189 ESPEC_RET     CHAR 15   0    
190 ESPEC_REP     CHAR 15   0    
191 ESPEC_NOREP     CHAR 15   0    
192 AGRICO PES_SUFORM_I190_CERET_DINESP   STRU 0   0    
193 DINER_PER     CHAR 15   0    
194 DINER_RET     CHAR 15   0    
195 ESPEC_PER     CHAR 15   0    
196 ESPEC_RET     CHAR 15   0    
197 ESPEC_REP     CHAR 15   0    
198 ESPEC_NOREP     CHAR 15   0    
199 PROPIN PES_SUFORM_I190_CERET_DINESP   STRU 0   0    
200 DINER_PER     CHAR 15   0    
201 DINER_RET     CHAR 15   0    
202 ESPEC_PER     CHAR 15   0    
203 ESPEC_RET     CHAR 15   0    
204 ESPEC_REP     CHAR 15   0    
205 ESPEC_NOREP     CHAR 15   0    
206 DATOS_ADICIONALES PES_SUFORM_I190_CERET_ADD_DATA   STRU 0   0    
207 PERNR P_PERNR PERNR NUMC 8   0   Personnel Number  
208 NIF     CHAR 9   0    
209 TRAT_EMPL ANREX ANREX CHAR 5   0   Form of address text  
210 APELLIDO PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
211 SIGLA_DOM STRDS STRDS CHAR 2   0   Street Abbreviation  
212 CP PSTLZ_HR PSTLZ CHAR 10   0   Postal Code  
213 PROVINCIA BEZEI20 TEXT20 CHAR 20   0   Description  
214 POBLACION PAD_ORT01 PAD_ORT01 CHAR 40   0   City  
215 DIRECCION PAD_STRAS PAD_STRAS CHAR 60   0   Street and House Number  
216 PAIS LANDX TEXT15 CHAR 15   0   Country Name  
217 FECHA_ACTUAL     DATS 8   0    
218 FECHA_FIN_EJ     DATS 8   0    
219 EDIFICIO AD_BLD_10 TEXT10 CHAR 10   0   Building (number or code)  
220 NUMERO PAD_HSNMR PAD_HSNMR CHAR 10   0   House Number  
221 ID_CASA PAD_POSTA PAD_HSNMR CHAR 10   0   Identification of an apartment in a building  
222 PLANTA AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
223 CPO_ADD PAD_LOCAT PAD_LOCAT CHAR 40   0   2nd address line  
224 ADR03 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
225 ADR04 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
226 ACTUAL PES_SUFORM_I190_CERET_ORG_DATA   STRU 0   0    
227 DIV_PERS PERSA PERSA CHAR 4   0   Personnel Area  
228 SUBDIVISION BTRTL BTRTL CHAR 4   0   Personnel Subarea  
229 DIVISION GSBER GSBER CHAR 4   0   Business Area  
230 C_COSTE KOSTL KOSTL CHAR 10   0   Cost Center  
231 POBL_DIV ORT01 TEXT25 CHAR 25   0   City  
232 SOCIEDAD BUKRS BUKRS CHAR 4   0   Company Code  
233 FINEJER PES_SUFORM_I190_CERET_ORG_DATA   STRU 0   0    
234 DIV_PERS PERSA PERSA CHAR 4   0   Personnel Area  
235 SUBDIVISION BTRTL BTRTL CHAR 4   0   Personnel Subarea  
236 DIVISION GSBER GSBER CHAR 4   0   Business Area  
237 C_COSTE KOSTL KOSTL CHAR 10   0   Cost Center  
238 POBL_DIV ORT01 TEXT25 CHAR 25   0   City  
239 SOCIEDAD BUKRS BUKRS CHAR 4   0   Company Code  
240 DESCRIP_SY_DATUM     CHAR 30   0    
History
Last changed by/on SAP  20130529 
SAP Release Created in 600