Skip to Content

Using Template Allocation for actual activity posting

Hi,

The scenario is that there are (lets say) 3 FG produced for which 3 Production Orders will be created. But we cannot enter actual labor (activity) hours used per material at the time of confirmation. We will know the total actual hours consumed at the end of the month only. We want to distribute the actual hours to all the 3 Production Orders in the ratio of the quantity of FG produced by each Production Order.

Example: PP Order 1 - 2 qty, PP Order 2 - 3 qty, PP Order 3 - 5 qty.

               Total hours consumed = 50 hours.

               Then PP Order 1 should get debited with 10 hours, PP Order 2 with 15 hours and PP Order 3 with 25 hours at month end.

               i.e  Actual Hours on and Order = Total Hours posted in the Cost Center * (GR quantity of that Order/Total GR quantity of all orders)

I have considered using CKMDUVACT but I could not find any way to create distribution with above logic.

So I am planning to use template allocation. The environment will be 001 - Cost Estimate/Production Order.

Can anyone suggest if there is any default function that can be used for above logic?

If not, can I create a function without ABAP help?

BR

Abhinav

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 26, 2015 at 11:58 AM

    Hi Abhinav,

    There is no standard function is available to meet your requirement but you can you mix approach of Template allocation & CKMDUVACT.

    1) Use Template allocation- with standard function of template allocation you can transfer actual quantity based on quantity confirm on production order. for example order 1 has 10 confirmation and order 2 has 20 confirmation then labour activity confirmed on order 1 & 2 will be 10 & 20 respectivity

    2) Use CKMDUVREC- use transaction to book actual labour hours at cost center level.

    3) CKMDUVACT- this will distribute total books hours on cost center to respective order based on quantity confirmed. If total hours is 90 then order 1 will have additional differential booking of 20 hrs and order 2 will have 40 hrs

    Regards,
    Malay

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Abhinav,

      Logically it should work but it is world of SAP so may be your observation is correct.

      In this scenario you have two option..

      1) Raise message to SAP and hopefully they can provide some solution. (DUV functionality has many notes)

      2) As you told earlier..DEVELOPMENT

      Malay

  • Oct 23, 2015 at 12:54 PM

    Hi Abhinav,

    Please use SKF for your requirement.

    Thanking you

    Vengaiah

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 04:52 AM

    Hi,

    Any suggestions by experts?

    BR

    Abhi

    Add comment
    10|10000 characters needed characters exceeded

    • Abhinav Sinha Vengaiah Chowdary Pachava Chinna

      Hi Vengaiah,

      The basis of allocation in my case should be either GR qty or total credits on an order.

      Hours consumed per order = Total Hours posted in the Cost Center * (GR quantity of that Order/Total GR quantity of all orders)

      OR

      Hours consumed per order = Total Hours posted in the Cost Center * (total credits on the order / Total credits in all the orders)

      This basis for allocation doesn't change every month. Of course the total hours posted in the cost center will change every month. Any pointers?

      BR
      Abhi

  • Nov 02, 2015 at 04:35 AM

    Hi,

    My current idea is to do the below for the above scenario:

    1. Use template allocation for plan activity values. This is possible because there is no distribution required for plan values. So we're simply replacing the activities from work center master data to template allocation method.

    This will be used in both std cost estimate and preliminary cost estimate.

    2. Use indirect activity allocation cycle for distributing actual activity values - This will be done by creating order sets (similar to order group) and placing them in the receiver side of the allocation cycle and marking the COGM cost element (total credits on the order) as the tracing factor. Total activity value will be entered in the cost center using KB51n before executing this cycle.

    Is there any problem with this method? Is there any better way to do this?

    Dear Former Member and Former Member SIr,

    Your expert suggestion pls.

    BR

    Abhinav

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Santosh Sir,

      Thanks for the inputs.

      1. We have more than 6 activities so cant depend on routing for plan values. We dont want to use multiple work centers for one operation. This was the reason I was using template allocation for booking of quantities rather than relying on PP confirmations. This was the most ideal solution otherwise.

      2. CKM* works without ML, I tested that part. The only trouble is that if I use template allocation then CKMDUVACT does not recognize activities booked on production hours. (perhaps because business transaction is RKLT)

      3. I had considered link to LIS, but unfortunately it appears that we cannot assign SKF to Production order from LIS the way we can assign them to cost center.

      4. The reason I felt COGM value as tracing factor is because FG qty is not available as tracing factor. Also, there are co-products too, so the tracing factor will consider the co-product receipts too, which I feel is right for the distribution. Why do you think "it may not work as same as production quantity ratio".


      BR

      Abhi