SAP ABAP Table PS0480 (Contract extensions (HRMS-ES))
Hierarchy
☛
SAP_HRCES (Software Component) Sub component SAP_HRCES of SAP_HR
⤷ PA-PA-ES (Application Component) Spain
⤷ PB04 (Package) HR Master Data: Spain
⤷ PA-PA-ES (Application Component) Spain
⤷ PB04 (Package) HR Master Data: Spain
Basic Data
Table Category | INTTAB | Structure |
Structure | PS0480 | Table Relationship Diagram |
Short Description | Contract extensions (HRMS-ES) |
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 | IDCON | PES_IDCONT | PES_IDCONT | CHAR | 5 | 0 | Contract identification by company | * | |
2 | WERKS | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
3 | BTRTL | BTRTL_001P | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
4 | TRFAR | TRFAR | TRFAR | CHAR | 2 | 0 | Pay scale type | * | |
5 | TRFGB | TRFGB | TRFGB | CHAR | 2 | 0 | Pay Scale Area | * | |
6 | ENDCO | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
7 | FERED | FERED | DATUM | DATS | 8 | 0 | Start date for reduction/allowance | ||
8 | REPRS | PES_REPRS | PERNR | NUMC | 8 | 0 | Person responsible for hiring | ||
9 | MOTIF | PES_MOTIVO | TEXT70 | CHAR | 70 | 0 | Contract reason and/or other comments | ||
10 | OFFIN | PES_OFFIN | PES_INEM | NUMC | 10 | 0 | Spanish Office of Employment (INEM): Enrollment code | T5E70 | |
11 | OFFRG | PES_OFFRG | PES_INEM | NUMC | 10 | 0 | Office where contract is filed | T5E70 | |
12 | REGNR | PES_REGNR | NUM10 | NUMC | 10 | 0 | Spanish Office of Employment (INEM) record number | ||
13 | FECRG | PES_FECRG | DATE | DATS | 8 | 0 | INEM: Date of registration | ||
14 | HORAS | PES_HORAS | DEC4_2 | DEC | 6 | 2 | Contracts: Working hours in part-time contracts | ||
15 | UNIHO | PES_UNIHO | PES_UNIHO | NUMC | 1 | 0 | Contracts: Unit for number of hours of part-time working day | ||
16 | DIAS | PES_DICON | DEC3 | DEC | 3 | 0 | Working days in part-time contracts | ||
17 | UNIDI | PES_UNIDI | PES_UNIDI | NUMC | 1 | 0 | Contracts: Time unit for number of part-time days | ||
18 | TURNO | PES_TURHAB | SCHKN | CHAR | 8 | 0 | Usual shift for full-time contracts | * | |
19 | NFORM | PES_NFORM | PES_NFORM | NUMC | 2 | 0 | Level of training according to INEM | ||
20 | CODOCU | PES_CODOCU | CHAR | 8 | 0 | Work center commitment code | T5E75 | ||
21 | ICDESP | PES_ICDESP | PES_ICDESP | CHAR | 1 | 0 | Dismissal costs indicator | ||
22 | CCDESP | PES_CCDESP | PES_CCDESP | NUMC | 2 | 0 | Dismissal collective code | ||
23 | ALTDIR | PES_ALTDIR | CHAR1 | CHAR | 1 | 0 | Senior management contract indicator | ||
24 | ICONTE | PES_ICONTE | CHAR1 | CHAR | 1 | 0 | Written contract indicator | ||
25 | CAUIN | PES_CAUIN | PES_CAUIN | CHAR | 1 | 0 | Temporary status object cause code | ||
26 | TIACA | PES_TIACA | CHAR12 | CHAR | 12 | 0 | Academic title code | ||
27 | HOFOR | PES_HOFOR | DEC4_2 | DEC | 6 | 2 | Training hours | ||
28 | COLEF | PES_COLEF | PES_COLEF | NUMC | 2 | 0 | Training age group | ||
29 | PJUPA | PES_PJUPA | PES_PJUPA | NUMC | 2 | 0 | Working time percentage, partial retirement contracts | ||
30 | COLBON | PES_COLBON_NC3 | PES_COLBON_NC3 | CHAR | 2 | 0 | Discount group (output with 3 characters) | T5E76 | |
31 | IDCONTR | PES_CODIDCONTR | CHAR | 14 | 0 | Employment office contract identifier | |||
32 | FECCOM | PES_FECCOM | DATS | DATS | 8 | 0 | Date of communication | ||
33 | USUCOM | PES_USACOM | CHAR10 | CHAR | 10 | 0 | User making the communication | ||
34 | FECABD | PES_FECABD | DATS | DATS | 8 | 0 | Entry date on employment office database | ||
35 | STACOM | PES_STACOM | PES_STACOM | CHAR | 1 | 0 | Status of contracts communication to employment office | ||
36 | OBLCB | PES_OBLCB | PES_OBLCB | CHAR | 1 | 0 | Obligatory to present basic copy to employment office | ||
37 | LEGBON | PES_LEGBON | NUM02 | NUMC | 2 | 0 | Legislation applying to the right to bonuses | ||
38 | LEGFOM | PES_LEGFOM | NUM02 | NUMC | 2 | 0 | Law promoting indefinate term contracts | ||
39 | STACOP | PES_STACOM | PES_STACOM | CHAR | 1 | 0 | Status of contracts communication to employment office | ||
40 | NUMPRO | PES_NUMPRO | NUM2 | NUMC | 2 | 0 | Extension sequential number | ||
41 | FECCOP | PES_FECCOM | DATS | DATS | 8 | 0 | Date of communication | ||
42 | USUCOP | PES_USACOM | CHAR10 | CHAR | 10 | 0 | User making the communication | ||
43 | FEABDP | PES_FECABD | DATS | DATS | 8 | 0 | Entry date on employment office database | ||
44 | STACOC | PES_STACOM | PES_STACOM | CHAR | 1 | 0 | Status of contracts communication to employment office | ||
45 | FECCOC | PES_FECCOM | DATS | DATS | 8 | 0 | Date of communication | ||
46 | USUCOC | PES_USACOM | CHAR10 | CHAR | 10 | 0 | User making the communication | ||
47 | TIPOFI | PES_TIPOF | PES_TIPOF | CHAR | 1 | 0 | Basic copy signature type. Notification of contracts to INEM | ||
48 | FEGENV | PES_FEGENV | DATS | DATS | 8 | 0 | Date the notification send was generated | ||
49 | HOGENV | PES_HOGENV | TIMS | 6 | 0 | Time (HHMMSS) the notification send was generated | |||
50 | CONCOL | PES_CONCOL | CHAR1 | CHAR | 1 | 0 | Collective agreement indicator | ||
51 | IDOFER | PES_IDOFER | CHAR17 | CHAR | 17 | 0 | Offer identifier | ||
52 | IDDISC | PES_IDDISC | CHAR1 | CHAR | 1 | 0 | Gap indicator | ||
53 | ACMAEX | PES_ACMAEX | CHAR1 | CHAR | 1 | 0 | Indicator of belonging to Maternity Leave allowance group | ||
54 | COD_LOC | PES_CODLOC | NUM5 | NUMC | 5 | 0 | Town code according to INEM | ||
55 | ERRC01 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
56 | ERRC02 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
57 | ERRC03 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
58 | ERRC04 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
59 | ERRC05 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
60 | ERRC06 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
61 | ERRC07 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
62 | ERRC08 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
63 | ERRC09 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
64 | ERRC10 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
65 | ERRC11 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
66 | ERRC12 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
67 | ERRC13 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
68 | ERRC14 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
69 | ERRC15 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
70 | FOLNAME | HR99S_FORMLOGC | HR99S_FLNAME | CHAR | 30 | 0 | Logical form name | T5F99OMFG | |
71 | TPTRAB | PES_TPTRAB | PES_TPTRAB | CHAR | 1 | 0 | Relief worker type | ||
72 | PERCR | PES_PERCR | PERSNO | NUMC | 8 | 0 | Relief contract person | PA0003 | |
73 | STACOL | PES_STACOM | PES_STACOM | CHAR | 1 | 0 | Status of contracts communication to employment office | ||
74 | FECCOL | PES_FECCOM | DATS | DATS | 8 | 0 | Date of communication | ||
75 | USUCOL | PES_USACOM | CHAR10 | CHAR | 10 | 0 | User making the communication | ||
76 | MLLAM | PES_MLLAM | PES_MLLAM | CHAR | 2 | 0 | Call Up Type | ||
77 | TMMVB | PES_TMMVB | CHAR1 | CHAR | 1 | 0 | Temporal challenged person allowance | ||
78 | PJUPA_DEC | PES_PJUPA_DEC | PES_PJUPA_DEC | DEC | 5 | 2 | Decimal percent on working time (partial retirement) | ||
79 | IDLLAM | PES_IDLLAM | PES_IDLLAM | CHAR | 12 | 0 | Calling identifier | ||
80 | ICPRO | PES_ICPRO | XFELD | CHAR | 1 | 0 | Indicator of professional standard certificate | ||
81 | MODAEXCL | PES_MOD_ATT | PES_MODALIDAD | CHAR | 5 | 0 | Category of exclusion contracts | ||
82 | CCRED | PES_CCRED | PES_CCRED | CHAR | 2 | 0 | Reduction group code | ||
83 | PORRD | PES_PORRD | PES_PORRD | DEC | 5 | 2 | Contribution reduction percentage | ||
84 | PORJR | PES_PORJR | PES_PORJR | DEC | 5 | 2 | Percentage of contract work schedule with reduction | ||
85 | IEAPU | PES_IEAPU | XFELD | CHAR | 1 | 0 | Company ID | ||
86 | IPADU | PES_IPADU | XFELD | CHAR | 1 | 0 | Duration authorization indicator | ||
87 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PS0480 | CODOCU | T5E75 | COD_OCU | |||
2 | PS0480 | COLBON | T5E76 | COLBON | |||
3 | PS0480 | FOLNAME | T5F99OMFG | FOLNAME | KEY | ||
4 | PS0480 | OFFIN | T5E70 | COOFF | |||
5 | PS0480 | OFFRG | T5E70 | COOFF | |||
6 | PS0480 | PERCR | PA0003 | PERNR | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |