Ansicht
Dokumentation
HSKCTRX0_2017 - Statistical survey ISCP 1-04 2017
BAL Application Log Documentation 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).. This program was extended with the option to create also export files also for statistical survey of salaries (SALARIES) from 01.01.2007.
Current quarter is automatically preset in selection report mask according to system date. Annual processing is preset in month March.
According to statistical survey instructions, the code list KZAM has enhanced to 6 characters. This change is valid from 01.01.2002.
Report requires customer settings of wage types assignment.
Data export in DBF format.
Education level
is loaded from infotype 0022. System finds school type number 99 and completed school is loaded as the highest education.
School type number 99 settings with possible graduation according to TREXIMA code list is assumed.:
0 Elementary education not completed, (or no school)
1 Elementary education
2
Vocational secondary education, acquired in vocational secondary school - SOU (secondary education, apprenticeship)
3 Secondary education (less than four years - no graduation)
4 Completed vocational
secondary education (completed secondary education - study at vocational secondary school - with graduation)
5 Completed general secondary education (with graduation)
6 Completed secondary vocational
education in specialized secondary school or conservatory (completed secondary education with graduation)
7 Vocational higher education (years 5 and 6 of conservatory, post-secondary studies, education training colleges)
8 Bachelor study
9 Higher education
10 Scientific education
99 Unlisted education
Occupation
Firstly, it is searched in table T7SK13, if not found, value from infotype 0001 field Occupation is downloaded.
Residence
Instead of municipality code according to municipality code list, the postal code is loaded (consulted with Trexima).
Wage Types
are assigned v T512E with form TREX. Form must be allowed in table T514D (check by transaction SM30). Other settings are made by transaction SM30 View maintenance V_T512E.
By settings, the wage types are assigned directly to individual structure indicators according to quarterly report. It is also possible to assign to indicator with value of selected evaluation class EVCL of wage types.
If wage type is not being assigned but the class from selected evaluation class is, than **XX instead of wage type is added to T512E, where XX is that value. Used evaluation class is entered into selection report parameter
"Evaluation class". Standardly, class 7 is default, but also other class can be used, such as 02.
Also multiple use of one wage type into various columns is possible.
If wage type deduction is needed, sign (-) need to be entered into column AZ.
This assignment will be used also for annual processing.
Assigns to following indicators (curr. to 01.01.2007):
13,,Worked time
14,,Overtime
15,,Leaves
16,,Work incapacity
17,,Time off work with wage compensation
18,,Time off work without wage compensation
20,,Basic wage
21,,Supplements and arrears
22,,Premium and remunerations
23,,Wage compensations
24,,Other wage components
25,,Wage for overtime work
26,,Payments to a saving program
27,,Compensations for work standby
28,,Compensations during temporary work incapacity
29,,Cash payments from after-tax profits
30,,Net wage
33,,Wage for overtime work for the month October
34,,Selected wage benefits and supplements for the month October
35,,Paid hours for the month October
36,,Number of paid hours of overtime work for the month October
Extension:
The option to create files also for statistical survey of wages was added from 01.01.2007. Choose with the switch Data typethe wage survey and enter required half-year on the input screen. Statistical survey of wages is based goes from previous part (some data are collected from this part). For correct functionality, users for TREX form must be correctly defined and also users for new form TREP used for wage survey. Same rules are valid for the TREP form as for TREX form (described in section "Wage types").
Assign wage types to following indicators of TREP form (curr. to 01.01.2007):
12,,Worked time incl. overtime work
13,,Paid overtime
14,,Number of hours of leave used
15,,Number of hours of work incapacity
16,,Number of hours of time off work with wage compensation
17,,Number of hours of time off work without wage compensation
20,,Tariff pay
21,,Management supplement
22,,Substitution supplement
23,,Personal supplement
24,,Supplement for work in state service in difficult conditions and environments that are harmful to health
25,,Supplement for training a trainee
26,,Shift-work supplement
27,,Supplement for civil service work in a crisis area
28,,Special supplement
29,,Payment of arrears, other supplements and allowances
30,,Pay for overtime work in the civil service, or overtime work
31,,Remunerations
32,,Pay compensations
33,,Compensations for standby
34,,Net pay - enter
only components, that are deducted from total pay (18), such as taxes, contribution etc. Enter these components with a negative sign.
39,,Pay for overtime work in the civil service, or overtime work for October
40,,Selected supplements for October
41,,Paid hours in October
42,,Overtime hours in October
In order to process some data for
salary statistics, new values were added to the evaluation class 7. For example, there are a number
of supplements that have not yet been defined in the system. These values are mostly marked according
to indicator number, to which the number 50 is added (details in documentation) For example, for shift-work
supplement (indicator 26) it is 76. It should be emphasized that the new values in the evaluation class must be correctly assigned to the payroll types in order for statistics to show correct data.
Selection
Standard Variants
Output
Activities
Program contains user-exit, where it is possible to edit the value of job.
Job is downloaded from table T7SK13, from field KZAMP of record, that contains relevant value from employee infotype 0001 in key field STELL. If this value is unwanted, you can use own program. For its start, it is needed to enter a record with value 31TRXKZM in table T596F in field SNAME and program name in field PGMNA and own procedure (form) in field MODNA. Then, the program HSKCTRX0 will call external program on the assumption that record in T596F will timely match the period of processed quarter (of year). The user program must have the following parameters: TABLES P0001 USING ZAMEST, where P0001 is structure of current record of employee infotype 0001 (transferred to program) and ZAMEST (name can be adjusted) is the field with same type as the field KZAMP of table T7SK13 (CHAR6) - value, that was filled by main program and can be externally adjusted.
Program also contains user-exit, where it is possible to edit any data for one employee.
For its activation, it is needed to enter a record with value 31TRXCOM in table T596F in field SNAME and program name in field PGMNA and own procedure (form) in field MODNA. Then, the program HSKCTRX0 will call external program on the assumption that record in T596F will timely match the period of processed quarter (of year). The user program must have the following parameters: TABLES P0001 P0022 USING PRASTR, where P0001 and P0022 is the structure of current record of employee infotype 0001 and 0022 (transferred to program) and PRASTR (name can be adjusted) is the structure with type PSKFM_T_L_RES, defined in type-pool PSKFM - value, that was filled by main program and can be externally adjusted.
Program also contains user-exit for section SALARIES, where it is possible to edit any data for one employee.
For its activation, it is needed to enter a record with value 31TRXPLT in table T596F in field SNAME and program name in field PGMNA and own procedure (form) in field MODNA. Then, the program HSKCTRX0 will call external program on the assumption that record in T596F will timely match the period of processed half-year (of year). The user program must have the following parameters: TABLES P0001 P0016 P0022 USING PRASTR, where P0001, P0016 and P0022 is the structure of current record of employee infotype 0001, 0016 and 0022 (transferred to program) and PRASTR (name can be adjusted) is the structure with type PSKFM_T_L_RES, defined in type-pool PSKFM - value, that was filled by main program and can be externally adjusted.
Hints for programmers
Personnel number is a part of infotype structure (for example 0001). For job change we recommend to use first user-exit, which has simpler interface, although it is of course possible to transfer job change also in the 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 +/-
|
|-- indicator sequence number
|--- wage type or evaluation class
, where value 02 of selected evaluation class (chosen in form mask) in the first row is assigned to column 14, i.e. PREMIUM and REMUNERATIONS,
in the following rows, payroll types are directly assigned to the column, e.g. 11 - gross wage.
BAL Application Log Documentation CPI1466 during Backup
This documentation is copyright by SAP AG.
Length: 11358 Date: 20240520 Time: 091521 sap01-206 ( 187 ms )
