SAP ABAP Table PA0480 (HR master record for infotype 0480)
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 | TRANSP | Transparent table |
Transparent table | PA0480 | Table Relationship Diagram |
Short Description | HR master record for infotype 0480 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | .INCLUDE | 0 | 0 | Key for HR Master Data | |||||
3 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | PA0003 | |
4 | SUBTY | SUBTY | SUBTY | CHAR | 4 | 0 | Subtype | ||
5 | OBJPS | OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
6 | SPRPS | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
7 | ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
8 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
9 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
10 | .INCLUDE | 0 | 0 | HR Master Record: Control Field | |||||
11 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
12 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
13 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
14 | ITXEX | ITXEX | XFELD | CHAR | 1 | 0 | Text Exists for Infotype | ||
15 | REFEX | PRFEX | XFELD | CHAR | 1 | 0 | Reference Fields Exist (Primary/Secondary Costs) | ||
16 | ORDEX | ORDEX | XFELD | CHAR | 1 | 0 | Confirmation Fields Exist | ||
17 | ITBLD | ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
18 | PREAS | PREAS | PREAS | CHAR | 2 | 0 | Reason for Changing Master Data | T530E | |
19 | FLAG1 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
20 | FLAG2 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
21 | FLAG3 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
22 | FLAG4 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
23 | RESE1 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
24 | RESE2 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
25 | GRPVL | PCCE_GPVAL | PCCE_GPVAL | CHAR | 4 | 0 | Grouping Value for Personnel Assignments | ||
26 | .INCLUDE | 0 | 0 | Contract extensions (HRMS-ES) | |||||
27 | IDCON | PES_IDCONT | PES_IDCONT | CHAR | 5 | 0 | Contract identification by company | * | |
28 | WERKS | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
29 | BTRTL | BTRTL_001P | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
30 | TRFAR | TRFAR | TRFAR | CHAR | 2 | 0 | Pay scale type | * | |
31 | TRFGB | TRFGB | TRFGB | CHAR | 2 | 0 | Pay Scale Area | * | |
32 | ENDCO | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
33 | FERED | FERED | DATUM | DATS | 8 | 0 | Start date for reduction/allowance | ||
34 | REPRS | PES_REPRS | PERNR | NUMC | 8 | 0 | Person responsible for hiring | ||
35 | MOTIF | PES_MOTIVO | TEXT70 | CHAR | 70 | 0 | Contract reason and/or other comments | ||
36 | OFFIN | PES_OFFIN | PES_INEM | NUMC | 10 | 0 | Spanish Office of Employment (INEM): Enrollment code | T5E70 | |
37 | OFFRG | PES_OFFRG | PES_INEM | NUMC | 10 | 0 | Office where contract is filed | T5E70 | |
38 | REGNR | PES_REGNR | NUM10 | NUMC | 10 | 0 | Spanish Office of Employment (INEM) record number | ||
39 | FECRG | PES_FECRG | DATE | DATS | 8 | 0 | INEM: Date of registration | ||
40 | HORAS | PES_HORAS | DEC4_2 | DEC | 6 | 2 | Contracts: Working hours in part-time contracts | ||
41 | UNIHO | PES_UNIHO | PES_UNIHO | NUMC | 1 | 0 | Contracts: Unit for number of hours of part-time working day | ||
42 | DIAS | PES_DICON | DEC3 | DEC | 3 | 0 | Working days in part-time contracts | ||
43 | UNIDI | PES_UNIDI | PES_UNIDI | NUMC | 1 | 0 | Contracts: Time unit for number of part-time days | ||
44 | TURNO | PES_TURHAB | SCHKN | CHAR | 8 | 0 | Usual shift for full-time contracts | * | |
45 | NFORM | PES_NFORM | PES_NFORM | NUMC | 2 | 0 | Level of training according to INEM | ||
46 | CODOCU | PES_CODOCU | CHAR | 8 | 0 | Work center commitment code | T5E75 | ||
47 | ICDESP | PES_ICDESP | PES_ICDESP | CHAR | 1 | 0 | Dismissal costs indicator | ||
48 | CCDESP | PES_CCDESP | PES_CCDESP | NUMC | 2 | 0 | Dismissal collective code | ||
49 | ALTDIR | PES_ALTDIR | CHAR1 | CHAR | 1 | 0 | Senior management contract indicator | ||
50 | ICONTE | PES_ICONTE | CHAR1 | CHAR | 1 | 0 | Written contract indicator | ||
51 | CAUIN | PES_CAUIN | PES_CAUIN | CHAR | 1 | 0 | Temporary status object cause code | ||
52 | TIACA | PES_TIACA | CHAR12 | CHAR | 12 | 0 | Academic title code | ||
53 | HOFOR | PES_HOFOR | DEC4_2 | DEC | 6 | 2 | Training hours | ||
54 | COLEF | PES_COLEF | PES_COLEF | NUMC | 2 | 0 | Training age group | ||
55 | PJUPA | PES_PJUPA | PES_PJUPA | NUMC | 2 | 0 | Working time percentage, partial retirement contracts | ||
56 | COLBON | PES_COLBON_NC3 | PES_COLBON_NC3 | CHAR | 2 | 0 | Discount group (output with 3 characters) | T5E76 | |
57 | IDCONTR | PES_CODIDCONTR | CHAR | 14 | 0 | Employment office contract identifier | |||
58 | FECCOM | PES_FECCOM | DATS | DATS | 8 | 0 | Date of communication | ||
59 | USUCOM | PES_USACOM | CHAR10 | CHAR | 10 | 0 | User making the communication | ||
60 | FECABD | PES_FECABD | DATS | DATS | 8 | 0 | Entry date on employment office database | ||
61 | STACOM | PES_STACOM | PES_STACOM | CHAR | 1 | 0 | Status of contracts communication to employment office | ||
62 | OBLCB | PES_OBLCB | PES_OBLCB | CHAR | 1 | 0 | Obligatory to present basic copy to employment office | ||
63 | LEGBON | PES_LEGBON | NUM02 | NUMC | 2 | 0 | Legislation applying to the right to bonuses | ||
64 | LEGFOM | PES_LEGFOM | NUM02 | NUMC | 2 | 0 | Law promoting indefinate term contracts | ||
65 | STACOP | PES_STACOM | PES_STACOM | CHAR | 1 | 0 | Status of contracts communication to employment office | ||
66 | NUMPRO | PES_NUMPRO | NUM2 | NUMC | 2 | 0 | Extension sequential number | ||
67 | FECCOP | PES_FECCOM | DATS | DATS | 8 | 0 | Date of communication | ||
68 | USUCOP | PES_USACOM | CHAR10 | CHAR | 10 | 0 | User making the communication | ||
69 | FEABDP | PES_FECABD | DATS | DATS | 8 | 0 | Entry date on employment office database | ||
70 | STACOC | PES_STACOM | PES_STACOM | CHAR | 1 | 0 | Status of contracts communication to employment office | ||
71 | FECCOC | PES_FECCOM | DATS | DATS | 8 | 0 | Date of communication | ||
72 | USUCOC | PES_USACOM | CHAR10 | CHAR | 10 | 0 | User making the communication | ||
73 | TIPOFI | PES_TIPOF | PES_TIPOF | CHAR | 1 | 0 | Basic copy signature type. Notification of contracts to INEM | ||
74 | FEGENV | PES_FEGENV | DATS | DATS | 8 | 0 | Date the notification send was generated | ||
75 | HOGENV | PES_HOGENV | TIMS | 6 | 0 | Time (HHMMSS) the notification send was generated | |||
76 | CONCOL | PES_CONCOL | CHAR1 | CHAR | 1 | 0 | Collective agreement indicator | ||
77 | IDOFER | PES_IDOFER | CHAR17 | CHAR | 17 | 0 | Offer identifier | ||
78 | IDDISC | PES_IDDISC | CHAR1 | CHAR | 1 | 0 | Gap indicator | ||
79 | ACMAEX | PES_ACMAEX | CHAR1 | CHAR | 1 | 0 | Indicator of belonging to Maternity Leave allowance group | ||
80 | COD_LOC | PES_CODLOC | NUM5 | NUMC | 5 | 0 | Town code according to INEM | ||
81 | ERRC01 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
82 | ERRC02 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
83 | ERRC03 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
84 | ERRC04 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
85 | ERRC05 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
86 | ERRC06 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
87 | ERRC07 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
88 | ERRC08 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
89 | ERRC09 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
90 | ERRC10 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
91 | ERRC11 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
92 | ERRC12 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
93 | ERRC13 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
94 | ERRC14 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
95 | ERRC15 | PES_ERRCOM | CHAR07 | CHAR | 7 | 0 | Errors detected in communication | ||
96 | FOLNAME | HR99S_FORMLOGC | HR99S_FLNAME | CHAR | 30 | 0 | Logical form name | T5F99OMFG | |
97 | TPTRAB | PES_TPTRAB | PES_TPTRAB | CHAR | 1 | 0 | Relief worker type | ||
98 | PERCR | PES_PERCR | PERSNO | NUMC | 8 | 0 | Relief contract person | PA0003 | |
99 | STACOL | PES_STACOM | PES_STACOM | CHAR | 1 | 0 | Status of contracts communication to employment office | ||
100 | FECCOL | PES_FECCOM | DATS | DATS | 8 | 0 | Date of communication | ||
101 | USUCOL | PES_USACOM | CHAR10 | CHAR | 10 | 0 | User making the communication | ||
102 | MLLAM | PES_MLLAM | PES_MLLAM | CHAR | 2 | 0 | Call Up Type | ||
103 | TMMVB | PES_TMMVB | CHAR1 | CHAR | 1 | 0 | Temporal challenged person allowance | ||
104 | PJUPA_DEC | PES_PJUPA_DEC | PES_PJUPA_DEC | DEC | 5 | 2 | Decimal percent on working time (partial retirement) | ||
105 | IDLLAM | PES_IDLLAM | PES_IDLLAM | CHAR | 12 | 0 | Calling identifier | ||
106 | ICPRO | PES_ICPRO | XFELD | CHAR | 1 | 0 | Indicator of professional standard certificate | ||
107 | MODAEXCL | PES_MOD_ATT | PES_MODALIDAD | CHAR | 5 | 0 | Category of exclusion contracts | ||
108 | CCRED | PES_CCRED | PES_CCRED | CHAR | 2 | 0 | Reduction group code | ||
109 | PORRD | PES_PORRD | PES_PORRD | DEC | 5 | 2 | Contribution reduction percentage | ||
110 | PORJR | PES_PORJR | PES_PORJR | DEC | 5 | 2 | Percentage of contract work schedule with reduction | ||
111 | IEAPU | PES_IEAPU | XFELD | CHAR | 1 | 0 | Company ID | ||
112 | IPADU | PES_IPADU | XFELD | CHAR | 1 | 0 | Duration authorization indicator | ||
113 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PA0480 | CODOCU | T5E75 | COD_OCU | |||
2 | PA0480 | COLBON | T5E76 | COLBON | |||
3 | PA0480 | FOLNAME | T5F99OMFG | FOLNAME | KEY | ||
4 | PA0480 | OFFIN | T5E70 | COOFF | |||
5 | PA0480 | OFFRG | T5E70 | COOFF | |||
6 | PA0480 | PERCR | PA0003 | PERNR | REF | 1 | CN |
7 | PA0480 | PERNR | PA0003 | PERNR | |||
8 | PA0480 | PREAS | T530E | PREAS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |