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