Wage type Calculation

[Former Member]

Hi

I have a requirement like below

Calculation of wage type 1174/1178:

• Create constant with value 5.5%
• Cumulate wage types 1603 and 1706 (may add other wage types at a later date) into technical wage type /142
• Multiple constant x /142 = either 1174 and/or 1178 (whichever is entered in infotype 0008 for the employee).

Example

WT 1603 $4,795.07 + WT 1706 $599.38 = WT /142 $5,394.45

WT /142 $5,394.45 x constant 5.5% = WT 1174 and/or 1178 = $296.70

Please let me know how can i write a pcr for this?

[Former Member]

Dear Lakshmi,

Instead of querying /142 please pass that value into some dummy wage type 1234 and then write your logic on querying wage type 1234 X constant 5.5 and pass it to 1174 or 1178 as you like.

Regards,

Dora

[Former Member]

Hi Dora

I am new to PCR so please let me know how to write the logic in this scenario.

please let me know the process i should follow for this requirement.That will be great help for me.

Thanks for your help.

Lakshmi

[Former Member]

Dear Lakshmi,

Please fine the sample pcr as below for your logic.

*

****

amt= /142

amt*Kabcd (constant in t511k which is 5.5)

amt/100

addwt 1174

Regards,

Dora

[Former Member]

Hi Dora

i am trying write in the same way but it gives some message in the first line

amt= /142 its not a valid operation

i also tried amt=& /142 but same error is coming.any idea why?

[Former Member]

Dear Lakshmi,

Please share your pcr, you can read the amount in /142 the place where you are placing the wage type is the issue I believe, find my replay on below thread where I read the amount from technical wage type for your reference.

http://scn.sap.com/thread/3467544

Regards,

Dora

[Former Member]

Hi Dora

Please find the attached doc for the PCR which i started to write.But it gives me error in the first line it self.

Thanks

Lakshmi

[Former Member]

Hi Dora

i had gone through the link you have given and that requirement is different from mine.

my case client will give some amount for 1174 and 1178 wagetype in IT0008.If it is normal payroll run the amount enetered in IT0008 will be paid as it is.

when mid month pay increased the /142 will be changed as per the pay period salary increased.Then the 1174 and 1178 should be prorated and should multiply by 5.5%*/142 then input amount into 1174 or 1178 wagetype.

[Former Member]

Dear Lakshmi,

I know both the requirements are differnt just i asked you to check the amount query in pcr for an technical wage type. Now coming to your issue any case in mid month proration both 1174 and 1178 will be prorated because you are processing these wage type in IT0008 so to prorate these wage type you should make sure to maintain processing class 10 with specification 1 then system will prorated as you excepted. if you want to multiply the /142 with percentage 5.5% that can be achieved through pcr and you can update in some other wage type during process but you can't update IT0008 through this process.

Please let me know your business process to handle this issue.

Regards,

Dora

PS - If you want to override the wage type 1174 and 1178 with 5.5% of /142 can also possible in RT.

[Former Member]

Hi Dora

yes your are correct and i have maintained the PC10 with specification 1 for both wagetypes.

i need the override amount which is 5.5%8/142 should be update in 1174,1178 in RT table.No need to update in IT0008.

i have written the PCR as u mentioned above.But still in payresult the 1174 is not prorated.please check the below logic and let me know if i need to do any changes?

ZSUP Prorate 1178 & 1174

    *

      /142

        AMT= /142  Set

        AMT*KLAKS  Multiplication

        AMT/100    Division

        ADDWT 1174 OT   Output table

[Former Member]

Dear Lakshmi,

Please change the logic as below.

*

****

wgtyp?

****

addwt *

1174

amt=  /142

amt/Kabcde (which is 100)

amt*Klaks1 (constant should be 5 digits or letters)

multi ana

addwt *

addwt 1178

Regards,

Dora

[Former Member]

HI Dora

i have written the rule like below.

ZSUP Prorate 1178 & 1174

    *

      ****

        WGTYP?     Query wage type

          ****

            ADDWT *    OT   Output table

          /142

            ADDWT *    OT   Output table

            AMT*KZLAKS Multiplication

            AMT/100    Division

            ADDWT 1174 OT   Output table

but now the wagetype 1174 is appearing twice in payresult which is one amount is caluculated on /142 and another amount is entered in IT0008.

So please let me know how can i restrict the IT0008 amount not to show in pay result?

[Former Member]

Dear Lakshmi,

Instead of querying /142 try to query with 1174 and build same logic then it will override the original amount in RT.

Regards,

Dora

[Former Member]

Hi Dora

i have changed the rule as u said above.But now 1174 is coming as it is entered in IT0008.No caluculation happend on /142.please check and let me know is any other changes required on below rule.

ZSUP Prorate 1178 & 1174

    *

      ****

        WGTYP?     Query wage type

          ****

            ADDWT *    OT   Output table

          1174

            ADDWT *    OT   Output table

            AMT*KZLAKS Multiplication

            AMT/100    Division

            ADDWT 1174 OT   Output table

[Former Member]

Dear Lakshmi,

Above rule you are processing with 1174 (entered in IT0008)amount only. Should read the amount from /142, Please change the logic as below.

ZSUP Prorate 1178 & 1174

    *

      ****

        WGTYP?     Query wage type

          ****

            ADDWT *    OT   Output table

          1174

            AMT=  /142    Set

            AMT*KZLAKS Multiplication

            AMT/100    Division

            ADDWT *  OT   Output table

Regards,

Dora

[Former Member]

Dear Dora

sorry to bother you again & again.But still no luck.1174 is coming the value same as entered in IT0008.Not caluculating on /142.

[Former Member]

Dear Lakshmi,

Please share your pcr.

Regards,

Dora