Question on Operation - "SETIN"

[Former Member]

Please help with this question on the operation- SETIN

According to entries on the on ZL table we are using operation SETIN to report shift differential pay on the RT table by sequence of occurrence

RT Table:-

E.g 1200 Eveg Shift -X01 (Sequence)

1200 Eve Shift - X02 (Sequence)

1200 Eve Shift - X03and so on.

We have also done some to report Regular earnings by the week using SETIN operation on the RT table.

E.g 1000 Regular work - W01 (week 01) Earning 400

1000 Regular work - W02 (Week 02) Earning 500

This was done by using two different rules SETIN X= NX and SETIN X= WW (per SAP documentation on the operation SETIN

Now ,We need to report *each occurrence of shift differential by work week as well. That is, all is combined

E.g below is how we want to combine it.

1000 Regular work - W01 (week 01) Earning 400

1200 Eveg Shift -X01 200

1200 Eve Shift - X02 200

1000 Regular work - W01 (week 02) Earning 400

1200 Eveg Shift -X01 200

This is my question.

Can we achive this using the operation SETIN??.What are the rules to do that, any suggestions??

Or is there a better operation we could use to get this combination on the RT table.

Thanks for all the help in advance.

Jay!!!

[Former Member · Accepted solution]

It is the right operation for your requirement for payroll processing and reporting. But this splits cannot be reported in the standard Payroll Reconciliation report or wagetype report.

> So you need to use the enhancement option in the recon report to write your custom logic to split these wagetype and report the week wise or shift wise splits. This might be complex.

> Best option is to configure the payroll journal summary report to show variable splits

> write custom reports

or

If you dont like option of creating custom report or configuring payroll journal report...then create new set of wagetypes for shift 1 / shift 2 / shift x... / week1 / week2...and store the amounts in these wagetypes. This can have explicit wagetype text as required and can be reported easily with any standard reports.

[Former Member · Accepted solution]

Thanks so much for the reply , when I meant report i was meaning reporting on the RT table in that combined format and finally on the remuneration statement. We were not intending to use a report to pull the data splits.

Would like to use this SETIN operation or some any other operation that would provide the splits on the RT table per my last combination.

to include shift differential by work week and earnings*. That is, all is combined

E.g below is how we want to combine it.

1000 Regular work - W01 (week 01) Earning 400

1200 Eveg Shift - X01 200

1200 Eve Shift - X 02 200

1000 Regular work - W01 (week 02) Earning 400

1200 Eveg Shift -X01 200

Can operation SETIN do this or is there any other operation that would do this .If SETIN does this how could we write that rule.

Thanks for all the help on this in advance

Jay!!

[Former Member · Accepted solution]

Yes.

To set the work week you need to have all applicable the employees with proper work week in IT0007. Based on that data and ZLIT you can set the work week example of the setin in the start UTRO schema

ZLIT UTR0 GEN NOAB *

You dont need to worry about the PC 85..it is for FLSA.

Just create custom ZTR0 similar to UTR0...with ZLIT

Where you ZTR0 is custom rule based on wagetypes you can SETIN X=WW

• **** ADDWT *

• 1000 SETIN X=WW --> will automatically set W to 01 or 02

• 1200 SETIN X=NX --> will automatically set X as variable split type with 01,02, 03,....

Edited by: Amosha on Nov 28, 2010 3:40 PM

[Former Member · Accepted solution]

Hey

Thanks so much for this wonderful tip !!!

This has got us closer to how we want the wagetype by week and in the sequence of its occurrence on the RT table.

Strangely they are not linked they are just getting groped in that sequence.??

Would you have any suggestion around how we truly link them like below. E.g below tells me that an employee worked 1000 Regular hrs in week 01 and earned 400$ by working 2 Eveg Shifts 01,02..

1000 Regular work - W01 (week 01) Earning 400$

1200 Eveg Shift - X 01 200$

1200 Eve Shift - X 02 200$

Can this be handled within the rules...how do we link the week ,earnings and the sequence

Thanks for all the great suggestions!!

Jay!!

[Former Member · Accepted solution]

1. How to link week and earnings --> already answered in the previous thread response. and also I have given how to write rule

2. Sequence : You cannot sort based on work week or earning X sequence. The RT gets sorted in the schema at end by wagetypes. the Sequence of wagetypes in RT should not matter... it is only for the Payroll team. If you are worried about the Rem statement...you can configure it as required in rem statement.

[Former Member · Accepted solution]

Thanks a lot Amosha !!!!