Canteen Deduction

[former_member216910]

Dear Experts, How to write the PCR for the below-mentioned canteen deduction. Canteen deduction rate - Rs.13 per Token If they utilized more than 30 token Rs.45 per token Canteen Deduction Rates are differ from Personnel area wise. Kindly help me to achieve this . Regards, P.Lakshmanaperumal

[Former Member · Accepted solution]

Hi Lakshman,

Create 2 constants for each personnel area and 1 constant for fixed 30 canteen tokens

PA-1:

Zcor1 with rupees 13

Zcor2 with rupees 45

Zcnft with no. 30

PA-2:

ZAAA1 with rupees 20

ZAAA2 with rupees 50

PA-3:

ZBBB1 with rupees 16

ZBBB2 with rupees 48

Like this you have to create constants for all the PA’s with the respective amounts.

Maintain no. of canteen token’s with wage type (ex. 2040) through IT 0015.

Create another wage type to pass final amount for deduction (ex. 2005).

Here wt 2040 is number unit & 2005 is amount unit maintain these in WT characteristics table (V_T511)

Add the wt 2005 in the payslip in deduction side.

ZQ77 Personnel Calculation Rule  ZQ76

    3

      ****

        ADDWT *    OT   Output table

      2040 CTokens

        OUTWPPLANT P.area in v.key

PSG1

NUM?30     Comparison

*

RTE=KZCOR1 Set

MULTI NRA  Multipl.amt/no/rate

ADDWT 2005 OT   Output table

>

NUM=  2040 Set

NUM-KZCNFT Subtraction

RTE=KZCOR2 Set

MULTI NRA  Multipl.amt/no/rate

AMT*-1     Multiplication

ADDWT 2005 OT   Output table

NUM=KZCNFT Set

RTE=KZCOR1 Set

MULTI NRA  Multipl.amt/no/rate

AMT*-1     Multiplication

ADDWT 2005 OT   Output table

Best Regards

[former_member216910 · Accepted solution]

Dear Praneeth, Above mentioned PCR is working fine. Thanks.

[venkateshorusu]

How we are coming to know X employee has used Y tokens, if we are maintaining manually then we can query number of days and accordingly we can calculate amount with different rates.

Suhas has already shared the logic it works we can use constants as well maintain V_T511K and same can be queried here.

Eg

OUTWPPLANT

XXXX

NUM?30

*

  RTE=KZZZZZ

  MULTI NRA

  ADD WT *

>

RTE=KXXXXX

MULTI NRA

ADDWT *

Regards

Venkatesh

[former_member216910]

Dear Suhas,

Our client having 15 plants, each plants have different canteen rates. So, how i can maintain the rate in 511p table.

Example if i utilized 30 token means Rs.13 . If more than 30 tokens utilized in a month means each token has Rs.30. Help me how to solve it.

Regards,

P.Lakshman

[former_member216910]

Dear Venkat,

Our client having 15 plants, each plants have different canteen rates. So, how i can maintain the rate in 511p table.

Example if i utilized 30 token means Rs.13 . If more than 30 tokens utilized in a month means each token has Rs.30. Help me how to solve it.

Regards,

P.Lakshman

Canteen Deduction

[venkateshorusu]

If plants are identified as PA/PSA we have operation to query OUTWPPLANT based on plant we can write our own logic, i hope you understand this depends on ERP structure in the system.

you can refer earlier post Instead XXXX we can place YYYy, ZZZZ and according to master data it works.

Regards

Venkatesh

[former_member216910]

Dear Venkat,

We have 15 Personnel Subarea each PSA have minimum amount and maximum amount i have to maintain in V_T511P table.

Please explain the process.

Regards,

P.Lakshman

[venkateshorusu]

Yes you can either maintain V_T511P or V_T511K and then query the same in the rule.

Regards

Venkatesh

[suhas_lembarkar]

Hi,

please refer to below pc,if it is works.

you have to maintain constant table-v_t511p for rate 13  and 45.

ZN12 Personnel Calculation Rule  ZN12

    *

      8CAN Canteen Deducation

        OUTWPPLANT P.area in v.key

          MH01

            NUM?30     Comparison

              <

                RTE=IRTE30 Set

                MULTI NRA  Multipl.amt/no/rate

                ADDWT *    OT   Output table

              >

                RTE=IRTE31 Set

                MULTI NRA  Multipl.amt/no/rate

                ADDWT *    OT   Output table

              =

                RTE=IRTE30 Set

                MULTI NRA  Multipl.amt/no/rate

                ADDWT *    OT   Output table

[former_member216910]

Dear Suhas, Our client having 15 plants, each plants have different canteen rates. So, how i can maintain the rate in 511p table. Example if i utilized 30 token means Rs.13             if more than 30 tokens utilized in a month means each token has Rs.30. Help me how to solve it. Regards, P.Lakshman

[raghu_c]

How are you recording number of tokens utilized? How many Personal areas are there?

Raghu