SAP ABAP Table PES_FORM_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
Basic Data
Table Category INTTAB    Structure 
Structure PES_FORM_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_SUFORM_INEM_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_SUFORM_INEM_TRABAJADOR   STRU 0   0    
57 PERNR P_PERNR PERNR NUMC 8   0   Personnel Number  
58 PERS PES_SUFORM_INEM_IDENT   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 VORNA VORNM CHAR 25   0   First Name  
62 PRIMER_APELLIDO NACHN NACHN CHAR 25   0   Last Name  
63 SEGUNDO_APELLIDO NACH2 NACHN CHAR 25   0   Second Name / Name at Birth  
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 INT4 INT4 10   0   Natural number  
68 FECHNAC DATS DATS DATS 8   0   Field of type DATS  
69 LUGAR_NAC GBLND LAND1 CHAR 3   0   Country of Birth  
70 NACIONALIDAD LAND1 LAND1 CHAR 3   0   Country Key  
71 TIPODOC CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
72 PROVINCIA CHAR2 CHAR2 CHAR 2   0   Version Number Component  
73 SEXO CHAR3 CHAR3 CHAR 3   0   3-Byte field  
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_DIAS_CC INT4 INT4 INT4 10   0   Natural number  
113 TOTAL_DIAS_CP INT4 INT4 INT4 10   0   Natural number  
114 TOTAL_DIAS_AC INT4 INT4 INT4 10   0   Natural number  
115 TOTAL_DIAS_VND INT4 INT4 INT4 10   0   Natural number  
116 BASDIACC MAXBT PRBETRG CURR 15   2   HR Payroll: Amount  
117 BASDIACP MAXBT PRBETRG CURR 15   2   HR Payroll: Amount  
118 FEC_EMI_DOCU DATUM DATUM DATS 8   0   Date  
History
Last changed by/on SAP  20130529 
SAP Release Created in 600