Payslip Desing Addition

Hi Sap Experts!!

Hope you all are doing well!!

I have a doubt about adding a certain wage type with another wage type in the payslip form.

I have created a deduction wage type where the final value is multiplied with -1 it became positive it is legal company deduction must be shown in payslip with cumulation but it doesnt work for example.

as you can see above new wage type which i created got 7329,29 and loan repayment is 22,500, but i need Total company deductions should be shown as Total company deductions = 7329,29 + 22500,00 = 29829.29

Is this possible?

Thanks

Sriram

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Yes this is feasible through the configuration of Cumulation ids(check the corresponding radio button using tcode Pe51).

You can create a new cumulation id here & add both wage types. You also have the flexibility of instructing the system to add or subtract each wage type in the cumulation id by entering a suitable value in the MS column. Hit F1 in this column to understand how to do this.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Tania,

Could you please help me out?

I have seen the cumulation id here TCOM which got Total company Deductions, where i have added my new wage type in TCOM..

Hence my new wage type is appearing in payslip.. in order to add /LRP and 1431,, what must be done here?

Thanks

Sriram

Thanks

sriram

1431 is already added, as you can see in your second screenshot. In that screen, add a new entry for /LRP. In the MS column, enter the appropriate sign based on whether you want it to be added or subtracted.

Hi Tania.

That also is there,,, you can see below, But both are not cumulating!!1

Thanks

Sriram

Can you send the below screenshots:

1) Cumulation Id TCOM(do not crop, send the entire screen)

2) The single field on your payslip where this cumulation id is printed.

Hi Tania,

Here you go

Thanks

Sriram

Please attach a screenshot of the Single field where Tcom is assigned, Do this from the Single filed radio button.

Hi Tania,

Are you asking below?

No, this screenshot is the Windows radio button. In the Pe51 screen, click on the Single fields radio button. Then identify your single field based on that position where the TCOM should be displayed. Then double click on the single field and send a screenshot.

Hi Tania.

When i click on single field.. below is the screen i get!!

Thanks

Sriram

That's what I said, search for the single field corresponding to where that total should be displayed. Once you identify it , double click.

Hi Tania.

Could you please help me.. how to get that!! every where i click , it keeps says no data has been set up for this fixed position.

Thanks

Sriram

1. Scrolling to the col & line of single field'

1.1 Change 'Line 1 of'' to say 'Line 20' of. The from no. can be changed;

1.2 Similarly change 'from Col no' to say 60.

Alternatively - the screen provides horizontal scroll bar; scroll horizontally left to right; this will show the col's to the right

1.3 Then press enter. This will show the lines from 20 to 55; col 60 to 132.

1.4 See if you can see the total ded amt display col & line.

1.5 . Any single fields has the desc or its text followed by a underline; If you find the single field, then press F4 key (possible entries) the underline area - any col in that underline columns.

This will show the attributes of the single field - table from where the field is obtained, conversion rule, etc.

If not found, repeat step 1.1 to 1.4 changing the 'Line m' of and 'Col n of', till you find the single field.

2. Not adding/displaying similarly for all deductions

2.1 Reason: Conversion rule for display or the adding of deduction amts not being the same

3 Deriving grand total pay or dedns:

3,1 The cum id for grand total may include

3.1.1 w/t's from RT which are not included in any cum id total (e.g., tax dedn)

3.1.2 cum id's which need to be added together.

3.2 To find which id's or individual w/t's or which eval classes are included in a cum id:

3.2.1 In the single field screen, click F4 key for the identifier field, or press icon 'consists of'; then expand all nodes;

or in cum id screen, double clicking cum id.

4. Tot dedn showing twice:

4.1 This would be due to the splits being different in RT. As suggested above by others the split needs to be removed. Or the same split removal needs to be used;

Send a screenshot of your payslip output, highlighting the total field in question.

Hi Tania.

Thanks a lot for your help.. sorry for the trouble as i have never worked on payslip before!!

Under company deductions my new wage type value has appeared but it didnt add it with Loan repayment amount

again in summary column

Total company deduction appearing twice where amount 7.329,29 was not deducted from total earnings..

Ok, looks like these have been configured as Windows and not single fields. Can you click on the Windows radio button, identify the Company Deductions Window, double click on it & send a screenshot of all the contents.

Hi Tania.

I have chosen Company deductions!! and here you go,,

Thanks

Sriram

Double click on the entries and send a screenshot

Hi Tania.

I have double clicked on the 16 entries and pasted the screenshot.. please scroll right.. you can see .

Thanks

SRiram

In the cumulation id radio button, for TCOM, change the value in the DSplit column to * instead of A for both wage types. Try generating the payslip again. If the issue is still not resolved, make the same change in the Windows radio button for the TCOM entry.

Hi Tania,

Success , it is working now ,

so the total now is 29.829,29 which is correct.. but however in the summary of the my payslip still that 7.329 not got deducted, still payment amount as 145.364= but it should be 138034

Thanks

Sriram

The payment amount seems to be taking from wage type /560, so if this is wrong, it is not a payslip issue, it is a payroll issue. Which means that you have to identify why /560 gets generated wrongly. Are you adding your wage type to /110? Check if the cumulation class 10 is selected for you wage type.

Hi Tania,

you are correct then,, actually the deduction /110 has -22500 which is the exactly loan amount.. so if thats the case i must add the new wage type amount to /110,

Am i right ?

thanks

Sriram

Correct

Hi Tania,

Thanks a lot will do and let you know!!!

Thanks

Sriram

Hi Tania.

No words to express my thanks to you it is amazing.. it works perfectly.. now.. thanks a lot..

But please let me know how come in the company deductions after we changed A to *,, it got added.. will it have any issues in future..

Thanks

Sriram

You're welcome. With regards to your query, if you check the documentation of the Dsplit field, the purpose of the field is to define which split indicators should not be taken into account. Your earlier configuration A meant that only work center/basic pay splits will not be considered. However there are various other splits which could arise from splits in other infotypes. You can verify this by checking the RT for both your wage types. You will probably see two different split indicators for each. Which is why the TCOM got generated twice, once for each split indicator.

Replacing A by * simply means that no split indicators should be considered. This is what most clients require, and I suggest you make this change for all wage types in the Window & not just these two. Unless, of course, your client in fact requires that splits should be differentiated on the payslip, which (I guess), is unlikely.

Hi Tania.

Thanks a lot for the explanation.. as a last assitance on this issue.. could you please let me know where can i find the splits in RT,, i am in RT table. Could you please show some example.

Thanks

Sriram

The 01 alongside the wage type 1431 is the Split indicator. The /LRP may not have this indicator.

Hi Tania.

Thanks a lot always for your help and assistance on payroll.. every thread is a learning and experience.. thanks

Thanks

Sriram

My pleasure!

Ask a Question

Top Q&A Solution Author

User

Count