This document aims at providing a basic understanding of how a wage type i.e.Transport allowance is paid to a specific employee group in payroll with peridodically change of Percentage on Basic Pay component.
Client is having Transport allowance for certain employee group in the organization and the allowance will some percentage on Basic pay and it will change periodically.
As we know there are so many ways to map this process into SAP, but I feel the simple way to map this process is using Table V_ T511K (Payroll Constants).
This Payroll Constant table is having a Start and End dates Validity set up , so the client can update new Percentage on an given date.
The customer in a way can also view the complete historical changes and without any development or customizing the changes can be easily transportable.
Let me explain in detail
Transport allowance is based employee group i.e. only for Contract employees and its percentage on Basic pay.
I have created Basic pay wage type 1001 by copying MB10
In the current scenario I have created Employee group; B Contract Employees
Created 1015 as Transport Allowance by copying Model Wage type M220
Please find below wage type characteristics of 1015
After creating required wage types, we need to maintain Transport allowance percentage in table T511K for employee group B Contract employees; I have given constant value as ZCNVP for TA Contract employees percentage.
We have to copy the main schema to Z schema I copied IN00 TO /N00.
For any WPBP related ( like DA / TA / Medical allowance will be included in XT00 sub schema , so need to change the XT00, As we know the best practice is not to touch the Standard Sub Schema please copy and do the changes, I copied into /T00. Please see below screen.
ZTRA rule for Transport Allowance Calculation.
Wage type 1015 should update with the percentage maintained in Constant table 511k.
Rule type D indicates that a decision operation, which more closely specifies the variable key, follows
Operation OUTWP — Load Work Center and Basic Pay Data (WPBP)
PERSG- –Employee Group RTE —- Current Rate Field K== Constant from T511K the system reads a constant from table T511K (Payroll Constants) and puts its value in the NUM, RTE, oder AMT field. Unlike table T511P, which is accessed using operand I, this table has no currency field and therefore contains in particular percentages, interest rates, and so on. Inserted the above rule in the Sub Schema /T00 line 140 for your ref.
ZCNVP which we have maintained in the table 511k
This is one of the approach which we can simply map this requirement.