SAP ABAP Table PES_SUFORM_I190_CERET_FORM0003 (Form: Garnishment certificate - Form 0003)
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_I190_CERET_FORM0003   Table Relationship Diagram
Short Description Form: Garnishment certificate - Form 0003    
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 DESC_ASC PES_SUFORM_I190_CERET_DESC_ASC   STRU 0   0    
26 A_NAC PES_190ANA CHAR4 CHAR 4   0   Year born  
27 DISCA PES_190DIS CHAR1 CHAR 1   0   DME template 190: Disability  
28 SIT_FAM PES_190SIF CHAR1 CHAR 1   0   DME model 190: Family situation  
29 NIF_CONY PES_190NIC CHAR9 CHAR 9   0   DME template 190: Spouse NIF  
30 PECOM PECOM WERTV5 CURR 9   2   Compensatory payments  
31 ALIME PES_ALIME WERTV5 CURR 9   2   Annuities for child maintenance  
32 PROLACTLAB PES_190PAL CHAR1 CHAR 1   0   Extension of work activity  
33 MOV_GEOG PES_190MGE CHAR1 CHAR 1   0   Geographic mobility  
34 HIJOS_0_2 PES_190MN3 CHAR1 CHAR 1   0   Children less than 3 years old  
35 HIJOS_0_2_E PES_190M3E CHAR1 CHAR 1   0   Children younger than 3 years old integral  
36 HIJOS_3_24 PES_190RES CHAR2 CHAR 2   0   Remaining children (between 3 and 24 years old)  
37 HIJOS_3_24_E PES_190REE CHAR2 CHAR 2   0   Remaining children calculated as integer  
38 DESC_33_65 PES_190DM3 CHAR2 CHAR 2   0   Descendants with disability between 33 and 65%  
39 DESC_33_65_E PES_190D3E CHAR2 CHAR 2   0   Descendants disabled between 33 and 65% integrall  
40 DESC_65 PES_190DM6 CHAR2 CHAR 2   0   Descendants with degree of disability 65%  
41 DESC_65_E PES_190D6E CHAR2 CHAR 2   0   Descendants disabled 65% integral  
42 DESC_ASIST PES_190DMA CHAR2 CHAR 2   0   Disabled descendants with reduced mobility  
43 DESC_ASIST_E PES_190DAE CHAR2 CHAR 2   0   Disabled descendants with reduced mobility integral  
44 ASC_75 PES_190A75 CHAR1 CHAR 1   0   Ancestors more than 75 years old  
45 ASC_75_E PES_19075E CHAR1 CHAR 1   0   Ancestors more than 75 years old integral  
46 ASC_65 PES_190A65 CHAR1 CHAR 1   0   Ancestors between 65 and 75 years of age  
47 ASC_65_E PES_19065E CHAR1 CHAR 1   0   Ancestors less than 75 years old integral  
48 ASCM_33_65 PES_190AM3 CHAR1 CHAR 1   0   Ancestors with disability between 33 and 65%  
49 ASCM_33_65_E PES_190A3E CHAR1 CHAR 1   0   Ancestors with disability between 33 and 65& integral  
50 ASCM_65 PES_190AM6 CHAR1 CHAR 1   0   Ancestors with disability 65%  
51 ASCM_65_E PES_190A6E CHAR1 CHAR 1   0   Ancestors with a disability of 65% integral  
52 ASCM_ASIST PES_190AMA CHAR1 CHAR 1   0   Disabled ancestors with reduced mobility  
53 ASCM_ASIST_E PES_190AAE CHAR1 CHAR 1   0   Disabled ancestors with reduced mobility integral  
54 NOHIJ PES_190RES CHAR2 CHAR 2   0   Remaining children (between 3 and 24 years old)  
55 .INCLUDE       0   0   Form: Deductions certificate - Monetary and in kind amount  
56 DINER_PER     CHAR 15   0    
57 DINER_RET     CHAR 15   0    
58 ESPEC_PER     CHAR 15   0    
59 ESPEC_RET     CHAR 15   0    
60 ESPEC_REP     CHAR 15   0    
61 ESPEC_NOREP     CHAR 15   0    
62 REDUC     CHAR 15   0    
63 CINTG     CHAR 15   0    
64 REDU1 PES_SUFORM_I190_CERET_INTGR   STRU 0   0    
65 BASIR     CHAR 15   0    
66 BAITG     CHAR 15   0    
67 REDUC     CHAR 15   0    
68 RETEN     CHAR 15   0    
69 PITGR     CHAR 3   0    
70 REDU2 PES_SUFORM_I190_CERET_INTGR   STRU 0   0    
71 BASIR     CHAR 15   0    
72 BAITG     CHAR 15   0    
73 REDUC     CHAR 15   0    
74 RETEN     CHAR 15   0    
75 PITGR     CHAR 3   0    
76 REDU3 PES_SUFORM_I190_CERET_INTGR   STRU 0   0    
77 BASIR     CHAR 15   0    
78 BAITG     CHAR 15   0    
79 REDUC     CHAR 15   0    
80 RETEN     CHAR 15   0    
81 PITGR     CHAR 3   0    
82 MUTUAS     CHAR 15   0    
83 GASTOS     CHAR 15   0    
84 COOPE     CHAR 15   0    
85 ZIMCLI     CHAR 15   0    
86 EJDEV1     NUMC 4   0    
87 EJDEV2     NUMC 4   0    
88 EJDEV3     NUMC 4   0    
89 EJDEV4     NUMC 4   0    
90 RETEN1     CHAR 15   0    
91 RETEN2     CHAR 15   0    
92 RETEN3     CHAR 15   0    
93 RETEN4     CHAR 15   0    
94 PERCE1     CHAR 15   0    
95 PERCE2     CHAR 15   0    
96 PERCE3     CHAR 15   0    
97 PERCE4     CHAR 15   0    
98 NJDEV1     NUMC 4   0    
99 NJDEV2     NUMC 4   0    
100 NJDEV3     NUMC 4   0    
101 NERCE1     CHAR 15   0    
102 NERCE2     CHAR 15   0    
103 NERCE3     CHAR 15   0    
104 NREDU1     CHAR 15   0    
105 NREDU2     CHAR 15   0    
106 NREDU3     CHAR 15   0    
107 SJDEV1     CHAR 4   0    
108 SJDEV2     CHAR 4   0    
109 SJDEV3     CHAR 4   0    
110 SJDEV4     CHAR 4   0    
111 SETEN1     CHAR 15   0    
112 SETEN2     CHAR 15   0    
113 SETEN3     CHAR 15   0    
114 SETEN4     CHAR 15   0    
115 SERCE1     CHAR 15   0    
116 SERCE2     CHAR 15   0    
117 SERCE3     CHAR 15   0    
118 SERCE4     CHAR 15   0    
119 DIETAS     CHAR 15   0    
120 DESPID     CHAR 15   0    
121 EXENTO     CHAR 15   0    
122 O_EXEN     CHAR 15   0    
123 DATOS_ADICIONALES PES_SUFORM_I190_CERET_ADD_DATA   STRU 0   0    
124 PERNR P_PERNR PERNR NUMC 8   0   Personnel Number  
125 NIF     CHAR 9   0    
126 TRAT_EMPL ANREX ANREX CHAR 5   0   Form of address text  
127 APELLIDO PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
128 SIGLA_DOM STRDS STRDS CHAR 2   0   Street Abbreviation  
129 CP PSTLZ_HR PSTLZ CHAR 10   0   Postal Code  
130 PROVINCIA BEZEI20 TEXT20 CHAR 20   0   Description  
131 POBLACION PAD_ORT01 PAD_ORT01 CHAR 40   0   City  
132 DIRECCION PAD_STRAS PAD_STRAS CHAR 60   0   Street and House Number  
133 PAIS LANDX TEXT15 CHAR 15   0   Country Name  
134 FECHA_ACTUAL     DATS 8   0    
135 FECHA_FIN_EJ     DATS 8   0    
136 EDIFICIO AD_BLD_10 TEXT10 CHAR 10   0   Building (number or code)  
137 NUMERO PAD_HSNMR PAD_HSNMR CHAR 10   0   House Number  
138 ID_CASA PAD_POSTA PAD_HSNMR CHAR 10   0   Identification of an apartment in a building  
139 PLANTA AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
140 CPO_ADD PAD_LOCAT PAD_LOCAT CHAR 40   0   2nd address line  
141 ADR03 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
142 ADR04 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
143 ACTUAL PES_SUFORM_I190_CERET_ORG_DATA   STRU 0   0    
144 DIV_PERS PERSA PERSA CHAR 4   0   Personnel Area  
145 SUBDIVISION BTRTL BTRTL CHAR 4   0   Personnel Subarea  
146 DIVISION GSBER GSBER CHAR 4   0   Business Area  
147 C_COSTE KOSTL KOSTL CHAR 10   0   Cost Center  
148 POBL_DIV ORT01 TEXT25 CHAR 25   0   City  
149 SOCIEDAD BUKRS BUKRS CHAR 4   0   Company Code  
150 FINEJER PES_SUFORM_I190_CERET_ORG_DATA   STRU 0   0    
151 DIV_PERS PERSA PERSA CHAR 4   0   Personnel Area  
152 SUBDIVISION BTRTL BTRTL CHAR 4   0   Personnel Subarea  
153 DIVISION GSBER GSBER CHAR 4   0   Business Area  
154 C_COSTE KOSTL KOSTL CHAR 10   0   Cost Center  
155 POBL_DIV ORT01 TEXT25 CHAR 25   0   City  
156 SOCIEDAD BUKRS BUKRS CHAR 4   0   Company Code  
157 MESEXT     CHAR 10   0    
History
Last changed by/on SAP  20130529 
SAP Release Created in 600