Skip to Content

WIP calculation with wrong fiscal year

Hello everybody

I have a question regarding the above mentioned issue.

Problem description:

One of my (internal) customer wanted to start a WIP calculation (KKAO) for the current fiscal year. But instead of 2013, the customer entered the year 3110, which is her company code and then started the transaction...

Now the customer is not able to calculate the WIP again, so I have to do something to solve this situation.

Previous attempt:

I only have one approach which is delete the booked data for the fiscal year 3110 directly from SAP tables. In my opinion, the three relevant tables for this case are:

  1. COSB (CO Object: Total Variances/Results Analyses)
  2. COEPB (CO Object: Line Items Variance/Period-Based Results Analysis) and
  3. COSBD (CO Object: Total of variances/accruals, of which settled)

Question:

It is a pain everytime when I have to delete something directly from a SAP table. It is tricky and you have to ensure that only the right data is deleted from the system. Therefore, I would like to ask for your experience, whether is there any other possibility to solve this problem?

Thank you for your help and have a nice holliday!

Phuong.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Dec 27, 2013 at 03:24 PM

    Dear Duy

    You can reverse the WIP and rerun for 2013. However I hope you must have tried this. If this is not working please share what error the system is throwing. If possible with screens.

    Regards

    Rajneesh Saxena

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2013 at 11:36 PM

    Hi..

    I don’t understand that the customer is not able to calculate the WIP again.

    You can execute WIP Calculation job using t-code KKAO again if necessary.

    You shouldn’t delete standard table’s data.

    SAP accept no responsibility for the problem occurred by deletion of data.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 28, 2013 at 07:08 AM

    Phuong,

    Is your client already maintained version customization's settings for each fiscal year for year 3110?

    Regards

    Ajith

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 06, 2014 at 08:32 AM

    Hi Rajneesh

    Thank you for your quick response.

    It did work with your suggestion. But before you can reverse the WIP Calculation, you have to reverse the settelement of the production order first. After that you can reverse the WIP Calculation and then do the calculation for the right fiscal year again.

    Thank you again for your help and have a nice start to the new year.

    @ Big Choi: Without the reversal, the transaction breaks up with runtime error. I guest, the system tries to detect all WIP which has been calculated so far, which means it has to look up untill 3110. This is 1097 years into the future and so it broke up with runtime error.

    Phuong.

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Duy

      Wish you a very happy new year too.

      Happy to know that you are through. you are every right that first we have to reverse the settlement. Actually in your problem description you mentioned that "customer wanted to start a WIP calculation (KKAO)........." so I thought that you have not settled the orders hence I suggested only to reverse the WIP calculation.

      Any ways all is well if the end is well.

      Cheers

      Rajneesh Saxena

  • Posted on Jan 06, 2014 at 10:28 AM

    Hi Phuong,

    After you have cancelled the settlement in question you can delete RA data using TC KKA7 (for orders) rather than cancelling the WIP calculation. If you cannot do it per single order due to many orders involved try to play with SAPMKKAA.

    @Big Choi: you cannot calculate RA values in period preceding the period for which any RA values already exist.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.