net pay calculation
I am developing one report that. calculates the difference between current months pay and previous months pay. to generate a one report monthly basis
can any one tell me how to find current months net pay and previous months pay. for that i have to check.. /559 (i dont know what it is) please help me any help will be appreciated.
my report look
emo id name curent month previous month Difference percent
991 Mr. XYZ 25000 24100 900 ??%
I am supposed to fine current month pay and previous month pay.. please help me to determind this...
Pranitha Chaitanya replied
You need to match the cluster tables.
All the payroll records are stored in the RT Table which can be viewed from transaction PC00_M40_CLSTR or PC_PAYRESULT.
As per my understanding your client required a report to show the difference in net pay for the current month and the previous month.
If im right then, i guess you should develop a report with conditions to evalute current RT ( From the above Tcode) for wagetype /559 and the immediate previous month RT with Wagetype /559. and find the difference.
/559 is the standard wagetype for Net bank transfer i.e. actual amount the employee gets in hand.
Hope this helps.
Dont forget to reward me with points if this helps.