Description
This report compiles remuneration data that is relevant for the
for the metal industry employer's association.
The remuneration statistics in the metal industry are divided intothree
different surveys:
1. Salary statistics for the salaried employees
2. Wage group remuneration statistics for industrial workers (summary)
3. Work value remuneration statistics for industrial workers(analysis)
The survey data is printed on a form that matches the earnings survey
sheet.

Precondition
The following entries are always relevant and necessary:
- Survey year
- Survey month
- Issue individual statements
The following entries are only relevant for modifications (when setting
your own form indicators and features):
- Name of the feature that combines plant sections
(Standard feature: VEBZU)
- Form indicator from table T512E, where the wage types for
total gross calculation are stored.

Activities before creating the remuneration statistics:
You must maintain the following tables/features before you can
correctly create the remuneration statistics (metal):
Table T512E:
Maintain the wage types in table T512E that are used to
determine the gross salary and working hours from the payroll results.
You must assign these wage types to different form indicators,
according to their significance.
The following connection is set in the standard system:
'MEAL' = general valid wage types
applies to salaried employees and workers
'MEMA' = wage types valid for salaried employees
(for example, regular salary)
'MEMW' = wage types valid for hourly-paid workers
(for example, bonuses, hourly/monthly wages)
The entries (wage types) that you include in this form indicator,
must be maintained in the following fields:
Field name explanations
- Wtyp : Wage type names
- CumWT: Depending on the first letter in each field,
the following actions are carried out:
'G': The wage type is a standard basic
remuneration. The amount field for this
wage type is taken from the payroll results.
'Z': The wage type is for standard bonuses and
allowances. The amount field for this wage
type is taken from the payroll results.
The wage type keys that contain bonuses
are only used for salaried employees.
Determine the number of the paid working hours
to convert the wage to a 36 hour week.
If you enter '1' in the second place in this
field, the number of the paid hours is determined
from the wage type amount field from the
payroll results.
You must only take this into account for hourly
wage earners, for basic renumeration wage types.
The working hours are determined automatically
for monthly wage-earners and salaried employees.
The second and first places can also be entered
together. So, for example, when you enter the
cumulation wage type 'G100' the basic
remuneration wage type total is added up, and the
number field to determine the working hours is
processed.
- Rz: '+' = Number/amount of the wage type is added
'-' = Number/amount of the wage type is subtracted
Table T5D3M:
The salary statistics and the wage-group remuneration statistics list
employee remuneration under the respective salary/wage groups.
The assignment of different wage/salary groups to the employees is
controlled using the employee wage-level assignment.
The connection between the wage-level assignment and wage/salary
groups is stored in table T5D3M.
Note that you have generic assignment possibilities for the pay-scale
area and pay-scale level. For more detailed information, refer to theinstructions in the IMG.
The wage/salary groups are assigned automatically to individual
employees through specifications in the wage-level assignment ininfotype 8.
Include RPLEHED1/RPLEHBD2:
In the analytical remuneration statistics, industrial workers are
differentiated according to work values.
In contrast to the salary statistics and the summary remuneration
statistics, the analytical remuneration statistics for the working
values cannot be set depending on the wage level assignment.
In the standard system, the job key in the 'org.assignment' infotype
is evaluated to determine the work value of the employee.
An alternative to this is the evaluation of the DUEVO activity key
that is stored in the standard system, but deactivated.
The decision. as to which work value is assigned to the job key, is
taken in the Include RPLEHED1, in the metal industry survey program.
Modify this Include in the same way you assigned the job numbers
to the correct work values. This Include is called up at the end of the
main program RPLEHED0.
For the analytical remuneration statistics, you have the possibility
to assign the work value directly to the employee.
To do this, maintain the statistics infotype (infotype 33) under
the 'branch statistics' subtype (subtype 2). You can store the
employee's activity work-value under the statistic indicator '02'.
Place of work control feature:
Here, you control whether, and how, plant sections are combined into
plants. In the standard system, the feature to combine places of work
is used. This is also used to create the earnings survey (VEBZV, see
also the feature documentation).
When you have combined the plant sections into one plant, a survey
form is created for this combined plant only. The individual statements
(if you requested this output), are separated for each plant section
before output of the survey form.
Wage-level assignment control feature:
In this feature, you control whether, and how, wage-level
assignments, stored in table T510, are mapped on to new or different
wage-level assignments. These newly defined employee wage-level
assignments are only used to evaluate the wage-level assignment
with remuneration groups in table T5D3M.
You need only maintain this feature for the following constellations:
- The same wage-level assignments are used for both industrial
workers and salaried employees.
- There are wage level assignments with different pay scale groups
that are evaluated in the same way for remuneration groups.
In this case, the maintenance of table T5D3M can be considerably
reduced.
For more detailed information about maintaining the feature, see
the standard feature DVETR documentation.

Master data queries for the earnings survey report
a) Work-time and DUEVO infotypes
If the person is entered as part-time in the work-time
infotype, or if the person has an employment percentage of
less than 100,00, this person is seen as a part-time employee,
and, as such, is not included in the statistics.
If a person is entered as part-time in the DUEVO infotype, the
entry is rejected. The work-time and DUEVO infotypes are
checked against each other.
b) Entry/Leaving
If an employee leaves or joins the company during the survey
period,
they are not included in the statistics.
c) Membership of a wage/salary group
You determine wage/salary group membership using the employee's
pay-scale.
The assignment of wage/salary groups to pay-scales takes place
in table T5D3M.
If a person is assigned to a wage/salary group that differs from
their corresponding wage/salary-group pay-scale, you can maintain
this person-specific wage/salary group in the 'statistics'
infotype, subtype '2' under the statistic '03',
(metal-industry survey)
d) Type - salaried employee/industrial worker
The metal-industry survey distinguishes between employees
(Time wage earners, piecework wage earners, premium wage earners),
office employees, and technical employees.
The report is used to determine these features as follows:
1. First, the work contract is checked.
This can be maintained as for each employee
in the 'org. assignment' infotype. Only make
entries in this field if you want to change specific employee
data in the WrkCnt (work contract) field,
This is defined for an employee group and subgroup in
table T5D03.
2. If a review is not possible using the work contract, the
entry is examined according to table T5D03, to which
every employee group/subgroup is assigned.
If a review is also not possible here, the entry will be rejected
with an error message.

Output:
You usually have a form that matches the survey form.
Print the company address using table T536A
If you have selected the 'issue individual statements' parameter,
you receive the personal data for every person included
in the survey form. The individual statement lists helps you
to check the settings for the metal-industry survey (wage types in
T512E, evaluation of the wage-level assignments in T5D3M).
The individual statements have the following form when printed:
- The heading contains the month when the metal-industry survey was
created.
- Directly under this is the type of survey that you chose
from the three possibilities.
- This is followed by the name of the company for which the
metal industry survey was created.
Example:
Plant : 0001 Heidelberg Head Office Goethestraße 8
PltSect: 0001 Administration 22085 Hamburg
- The individual statements follow the name of the company.
This list is divided into two units. First, the information you
use to decide where the employee should appear in the survey form.
The information that is issued is dependent on the type of survey
that you have chosen from the three possibilities.
1. Salary statistics
Example:
Off/Tech Empl Rem
PersNr. Sal.Emp. Mstr m/f Age Year Gr Line
00000352 X f 44 1 1 14
! ! ! ! ! ! !
Person is <- ! ! ! ! ! ! !
office/tech. ! ! ! ! ! !
salaried employee ! ! ! ! ! !
! ! ! ! ! !
Person is <-------------! ! ! ! ! !
foreman ! ! ! ! !
Gender <---------------------! ! ! ! !
of the employee ! ! ! !
Age of the employee <--------------! ! ! !
Number of employment years <-------------! ! !
Remuneration grp according <-----------------! !
to T5D3M/ IT0001 !
Line number that results from these <--------------!
specifications
In the above example the employee is a technical, salaried
employee, and is assigned to remuneration group '1'.
Since the employee has been employed for 1 year within this
wage-level assignment, and is older than 21, they appear in the
date entry form in line 14, and in the column for technical,
salaried employees.
The second part of the list shows you which salary and, if
necessary, how many hours the employee works.
Example:
Actual. Remun for
PersNr. .. Remun Hrs/Wk 36hr week Bonus
00000352 .. 1.976,00 38,00 1.872,00 197,60
Through these entries you can check if the determination of
these amounts from the wage types in the form table T512E is
correct. The first displayed remuneration is the salary that the
employee actually earns.
In addition, a salary conversion is shown, based on a 36 hour
week.
The employee bonuses are also listed.
2. Summary remuneration for industrial workers
Example:
Time/Wg Premium Piece Gender Wage Line
PersNr. wkrs wkrs wkr m/w Grp.
00000350 X ! m 2 26
! ! ! !
Type of <----------! ! ! !
activity ! ! !
of the ! ! !
industrial employee ! ! !
Employee's gender <------------------! ! !
Employee's wage group <---------------------! !
Line number that results from <---------------------!
this output.
In the above example the employee is an hourly-paid worker,
and is assigned to wage type '1', according to table T5D3M
or according to the 'org. assignment' infotype.
Therefore, the employee appears in line 26, and in
the column for the hourly-paid workers.
The second part of the list shows the employee's salary and the
hours worked.
Example:
Actual Remun. for
PersNr. .. Rumun. Hrs/Wk 36 Hr. Week
00000350 .. 2.108,00 35,40 2.143,73
Use these entries to check the accuracy of these amounts from
the wage types in the form table T512E.
The first displayed remuneration is the salary that the employee
actually earns.
In addition, the conversion of the salary, based on a 36-hour
week, is displayed.
3. Analytical remuneration statistics for industrial employees
Example:
TIme-Wg Piece-wkr Premium Gender Work. Line
PersNr. wkr wkr m/f value
00000350 X ! m 30 26
! ! ! !
Type of <----------! ! ! !
Activity ! ! !
of the ! ! !
Industrial employee ! ! !
Employee's gender <----------------------! ! !
Work value of the activity <-----------------------! !
of the employee !
Line number that results from this <---------------------!
output.
In the above example, the employee is a time wage earner.
The employee's job is classified with the work value '30'.
Consequently, the employee is displayed in line 26
of the survey form and in the time wage-earner line.
The second part of the list shows the employee's wage and
the number of hours worked.
Example:
Actual Remun. for
PersNr. .. Remun Hrs/Wk 36 hr. week
00000350 .. 2.108,00 35,40 2.143,73
Use these entries to check the accuracy of
these amounts from wage types in form table T512E.
The first displayed remuneration is the salary that the employee
actually earns.
In addition, the salary conversion is shown, based on a
36 hour week.
- After the individual statements, you may see notes, which
tell you why employees have not been included in the survey.
Finally, you receive a list, which you can use to check
employee data for accuracy and consistency.