Arrear Report

[former_member792858]

Dear Experts,

I want to generate one report which will show individual wage type head wise Arrear amont. I got to know, for that I need to create some wage types for that.

My question is

1)what are the standart wage types from which I can copy ( Ex. Basic, HRA, Conv., Professional persuit, Child all. etc).

2) How to maintain those wage types?

3) What PCRs to be modified and how.?

4) How can I fetch those wage types for reporting?

Can anyone guide me please?

Regards

Nasim

[sikindar_a · Accepted solution]

if it is for India the wage types are two types

/A wage types which are Carry Farword wage types

/Z wage types which are Brought farword wage types Check in table V_512w_D

Check the PCRS IN42 43 44

Use the wage types reporter to

[former_member792858 · Accepted solution]

Thank You very much sikinder. I have seen the wage types. How can use them? If I copy the wage types accordingly, need I to maintain them in any Infotypes or system will automatically populate them. what modification do I need to do in the PCRs.

Regards

Nasim

[sikindar_a · Accepted solution]

Just Copy Two wage types for Each wage type that is C/F and B/F

Just take an example of MB10 (Basic Pay) in the above said PCRs and follow the same for ur wage types

in case of any issue please do let me know please assign symbolic accounts for these wage types too

[Former Member · Accepted solution]

As Sikinder said this is control by the PCRs IN42, IN43 & IN44.

IN42 - here you have to substract the wage type and store into DT table.

IN42 Formation of differences, transfer of non-revisable wage type

*

****

WGTYP? Query wage type

****

9999

ELIMI * Elim.time period ID

SUBWTD/A99 DT Difference tab.

So its basically you are picking the ORT value (old value) of wage type and storing into outflow wage type with negative sign.

IN43 Store the differences in DT (India)

Here you have to add the RT value(latest value) of the wage type to /A** series.

By this way you will get the delta of the wage type which is stored in DT.

Now IN44 will be processed in the current period from where retro was triggered.

Here /A** ( Outflow wage type) will be added to /Z** (inflow wage type).

Edited by: praveen.hcm on May 17, 2011 4:21 PM

[former_member792858 · Accepted solution]

Dear Praveen,

Thanks for your explanation. But I need some more clarity.

WT 1000 is copied from /A*** for Basic

WT 1001 is copied from /Z*** for the same

Now can you please show me what should I write in the PCRs-

IN42 , IN43 and IN44 respectively

Thanks

Nasim

[sikindar_a · Accepted solution]

Assumeing XXXX is ur basic Pay

XXXX

ELIMI *

SUBTD1000 in IN42

XXXX

ELIMI *

ADDWTD1000 IN43

1000

WLIMI *

ADDWT10001 IN44

C/F wage type that is /A* will get subract and adds with Basic Pay Wage type and /z* wage types the amount will get stored from /A* wage types

Note include 1001 in the Payslip for display of arrear amount

[Former Member · Accepted solution]

I have already mentioned IN42 in the last reply. Check it again -

IN42

*

****

WGTYP? Query wage type

****

9999

ELIMI * Elim.time period ID

SUBWTD1000 DT Difference tab.

IN43

*

****

WGTYP? Query wage type

****

9999

ELIMI * Elim.time period ID

ADDWTD1000 DT Difference tab.

IN44

*

****

WGTYP? Query wage type

****

1000

ELIMI * Elim.time period ID

ADDWTI1001 IT Input table

Here, i have considered 9999 as Basic payment wage type for which you need to get the delta.

1000 is for /A**

1001 is for /Z**.

[former_member792858 · Accepted solution]

Thanks Praveen & Siki,

It is working. One more thing... How can I display the details of arrear month wise? I mean to say from the date data is fetched and month wise break up also I want to display. Please guide me.

Thanks

Nasim Haider

[Former Member · Accepted solution]

You can try using Wage type reporter (PC00_M99_CWTR) for the month wise and wage type wise break-up.

[former_member792858 · Accepted solution]

Thanks Praveen,

I know the data I can get from wage type reporter. But can we put that data in this format:

Ex. Arrear on Basic is 3000 on June 2011. and it is generating from April 2011.

so

Data will be like

Basic Arr on April-Basic Arr on May-Basic Arr on Jun- Total arrear

1000- 1000- 1000- 3000

Regards

Nasim

[sikindar_a · Accepted solution]

Where do you want to see this break ups in Payslip or a consolidated report please do let us know

[former_member792858 · Accepted solution]

Hi Sikinder,

I want to diplay in aconsolidated Report.

Thanks

Nasim

[sikindar_a · Accepted solution]

In case of Repot you have to go with Custom Report (wait for other expert views also)

[Sujith_EM · Accepted solution]

Adding some more

you can create a Zreport , one that will query in DT table to get the break up

[Former Member · Accepted solution]

I don't feel that there is any such report for consolidation.

What you can do, take the data from wage type reporter into an excel. Then write a macro to set up the data in the format you want for the same.

Edited by: Praveen Tiwari on May 26, 2011 2:28 PM

Edited by: Praveen Tiwari on May 26, 2011 2:28 PM

[former_member792858 · Accepted solution]

Thanks Sujit,

Ofcourse we are going to create one ZReport. You mean to say I need to fetch data from DT instead of RT. Can I get the wage type amounts from DT also?

Nasim

Edited by: nasim.haider on May 26, 2011 11:02 AM

[Sujith_EM · Accepted solution]

_________

Removed because I came to know the input provided by me is wrong one

_________

Edited by: self

[Former Member · Accepted solution]

DT only exist during the payroll run. Once you break the SAP session in which you are executing payroll, DT will lost. Also, it is not being stored into Payroll cluster. Hence you can not use it outside payroll after execution. Anyway all the values of /551, /553 & /552 will come into RT table in corresponding period payroll results.

Edited by: Praveen Tiwari on May 26, 2011 2:45 PM

[former_member792858 · Accepted solution]

wage types /551, /552 and /553 comes in corresponding periods, but it stores arrear amount as a whole. No headwise break will be there. For break up I am creating seperate wage types. I think if payroll is running in retro, as Arrear comes in that condition only, then I can get head wise break up in corresponding preiods also against my Wage types..

Am I correct.... ?If yes then I will sit with my ABAPer for creating the report.

Can I develop the logic like this... If payroll is running for multiple periods then we capture data against each Wage type and for each payroll period for that Payroll run.

Please comment.

Thanks

Nasim

[Former Member · Accepted solution]

What you can do is import the RGDIR table, now get the latest RTs for the retro periods, you will get the /551 & /553 from here. Now from the currect period you can get the /552.

Now you can use as you want.

[Former Member · Accepted solution]

Well /551 and/552 concept is same as for other outflow and inflow wage types... so you can use in the same . Hence i feel what you are sayign should work.

[former_member792858]

Hi all,

The issue is resloved. We have created the report successfully. But we need some improvement here. Suppose arrear is coming in negative form for Previous month's LOP. Now how can we show the number of days for which salary is being deducted. we want to show number of days also in the report.

any guidance please.

Nasim