Ansicht
Dokumentation
HSKCTRX0_2013 - Report HSKCTRX0_2013
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by SAP AG.
Purpose
TREXIMA - statistical survey
Integration
Prerequisites
Features
With program HSKCTRX0 it is possible to create export files for annual and quarterly statistical survey of wages (ISCP - WAGES). From 1.1.2007 this program has been extended with the possibility to create also export files for statistical survey of salaries (SALARIES).
Current quarter will be default set in report selection mask according to system date. The annual processing will be default set in the month March.
According to the statistical survey instructions, the KZAM codes is extended to 6 characters. This change is valid from 01.01.2002.
The report requires wage types assignment customer settings.
Data export is in DBF format.
Education Level
is loaded from 0022. System searches school type 99 and graduation is loaded as the highest level of education.
School type setting no.99 with possible graduations according to TREXIMA code list is assumed.:
0 Unfinished basic education, (resp. without any school)
1 Basic education
2 Secondary technical education from secondary vocational schools - SOU (secondary education, apprenticeship)
3 Secondary education (shorter than 4 year - no graduation)
4 Complete secondary vocational education (complete secondary education - study at SOU - with graduation)
5 General secondary education (with graduation)
6 Secondary vocational education at secondary technical school and conservatory (complete secondary education with graduation)
7 Higher vocational education (5. and 6. year of conservatory, postgraduate study, higher pedagogic schools)
8 Bachelor degree
9 Academic education
10 Scientific education
99 Not specified education
Job
Firstly is searching in the table T7SK13, if not found, the value is transferred from Infotype 0001 job field.
Residence
Instead of town code according to code list, the postal code (consulted with Trexima) is loaded.
Wage types
are assigned in T512E by TREX form. This form must be permitted in table T514D (check using SM30 transaction). Additional settings is made using SM30 transaction View Maintaince V_T512E.
Wages types are directly assigned into individual key figures of structure according to quarterly report during the setup. The assignment into key figure using the value in selected wage type evaluation class EVCL is also possible.
If the wage type is not assigned but the value from selected evaluation class, then **XX instead of wage type is entered into T512E where XX is the value. Used evaluation class is entered into selection parameter of report
"Evaluation Class". Normally, the class 7 is default, but also other class could be used, for example 02.
Also a multiple use of one wage type into different columns is possible.
If the wage type subtraction is needed, the sign (-) must be entered in the column AZ.
This assignment will be used also for annual processing.
Assign to following key figures (currently to 1.1.2007):
13,,Worked hours
14,,Overtime
15,,Leavings
16,,Work incapacity
17,,Time off work with wage compensation
18,,Time off work w/o wage compensation
20,,Basic wage
21,,Supplements and arrears payments
22,,Incentives and bonuses
23,,Wage compensations
24,,Other wage components
25,,Wage for overtime work
26,,Payments to saving scheme
27,,Compensation for work standby
28,,Replacement income during temporary work incapacity
29,,Payment from profit after tax
30,,Net wage
33,,Overtime wage for October
34,,Selected wage benefits and supplements for October
35,,Paid hours for October
36,,Number of overtime paid hours for October
Extension:
There is an option to create files also for wage statistical survey from 01.01.2007. Select by the switch Data Type wage survey and enter required half-year on the initial screen. Statistical wage survey is based on the previous part (some data is collected from this part). For correct functionality, correct defined users for TREX form must be defined and also key figures for new form TREP for wage survey must be defined. For the form TREP the same rules are relevant as for form TREX (described in part Wage types").
Assing wage types to following key figures of form TREP (currently to 01.01.2007):
12,,Worked time incl. overtime work
13,,Paid overtime work
14,,Leave taken hours number
15,,Hours number of work incapability
16,,Hours number of time off work with wage compensation
17,,Hours number of time off work w/o wage compensation
20,,Tariff pay
21,,Management supplement
22,,Substitution supplement
23,,Personal supplement
24,,Supplement for state service in difficult and unhealthy working environment
25,,Supplement for training a trainee
26,,Shift-work supplement
27,,Supplement for state service in a crisis area
28,,Special supplement
29,,Payments of arrears, other supplements and contributions
30,,Pay for overtime in state service or for overtime work
31,,Remunerations
32,,Pay compensation
33,,Compensation for standby
34,,Net pay - enter
only items, that are subtracted form total pay (18) such as taxes, contributions etc. Enter these items with negative sign.
39,,Pay for overtime in state service or for overtime work for October
40,,Selected supplements for October
41,,Paid hours in October
42,,Overtime hours in October
New values were added to evaluation
class 7 to process some data for wage statistics. For example, various bonuses, that have not been defined
in the system yet. These values are mostly marked according to key fuger number, to which the number
50 is added (details in documentation). For example, for shift-work supplement (key figure 26) the value
is 76. It is necessary to highlight that new values in evalution class must be added to wage type correctly report correct data from statistics.
Selection
Standard Variants
Output
Activities
Program includes user-exit, where it is possible to adjust the job value.
Job is transfered from table T7SK13, from field of KZAMP entry, that includes relevant value in key field STELL from Infotype 0001 of employee. If this value is unwanted, it is possible to use own program. For its run, the entry with value 31TRXKZM in table T596F in in field SNAME and program name in field PGMNA and own procedure (form) in field MODNA must be entered. After it, the program HSKCTRX0 will call external program providing that entry in T596F will timely match the period of processed quarter (year). User program must contain following parameters: TABLES P0001 USING ZAMEST, where P0001 is the structure of current entry of employee Infotype 0001 (transfered to program) and ZAMEST (name can be changed) is field with the same type as the field KZAM of table T7SK13 (CHAR6) - the value, that was filled by main program and can be external adjusted.
Program also contains user-exit, where it is possible to adjust any data for one employee.
For its activation it is needed to create entry with value 31TRXCOM in table T596F in field SNAME with program name in field PGMNA and own procedure (form) in field MODNA. Then the program HSKCTRX0 will call external program assumpted that the entry in T596F will timely match the period of processed quarter (year). User program must contain following parameters: TABLES P0001 P0022 USING PRASTR, where P0001 and P0022 is structure of current entry of employee Infotype 0001 and 0022 (transfered to program) and PRASTR (name changeable) is structure with type PSKFM_T_L_RES, defined in type-pool PSKFM - so values, that were filled by main program and can be externaly adjusted.
Program contains also user-exit for part SALARIES, where it is possible to adjust any data for one employee.
For its activation it is neeeded to create entry with value 31TRXPLT in table in field SNAME and program name in field PGMNA and own procedure (form) in field MODNA. Then the program HSKCTRX0 will call external program assumpted that entry in T596F will timely match the period of processing half-year (year). User program must contain following parameters: TABLES P0001 P0016 P0022 USING PRASTR, where P0001, P0016 and P0022 is structure of current entry of employee infotype 0001, 0016 and 0022 (transfered to program) and PRASTR (name changeable) is structure with type PSKFM_T_P_RES, defined in type-pool PSKFM - values, that where filled by main program and can be externaly adjusted.
Tips for programmers
Personnel no. is a part of Infotype structure (f.e.0001). For job change we recommend to use the first user-exit, that has simplier interface, although the job change can be performed also in second general exit.
Example
WaTy
Sk
AZ
31
TREX
**02
14
. . .
31
TREX
/851
08
31
TREX
/852
10
31
TREX
/101
11
31
TREX
M610
11
-
31
TREX
M030
12
. . .
31
TREX
/43X
16
31
TREX
/43Y
16
. . .
31
TREX
M300
15
----
--
--
|
|
|-- arithmetic sign +/-
|
|-- key figure sequence no.
|--- wage type or evaluation class
, where the value 02 of selected evaluation class is in the first row selected in form mask) assigned to column 14, i.e. BONUSES AND REMUNERATIONS,
Wage types are directly assigned to column in following rows, for example. 11 - gross wage.
ABAP Short Reference Fill RESBD Structure from EBP Component Structure
This documentation is copyright by SAP AG.
Length: 11076 Date: 20240531 Time: 015722 sap01-206 ( 162 ms )
