Skip to Content
author's profile photo Former Member
Former Member

WIP Balance for Materials

Hello SAP Gurus;

I have to determine 151 WIP account balance according to materials as the date of 2011.(Splitting wip balance according to materials) As far as I know; there is no an exact table for this in the system. How could I manage to do this; which tables I can use and what do you suggest.

Best Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Nov 09, 2012 at 12:04 PM

    Hi

    I used to execute FBL3N and plug in the field MATERIAL (BSEG-MATNR) into the report.. It is populated with the MAT No..

    If you dont see it there, you need to add it as a Special field

    br, Ajay M

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ajay;

      Thank you for your interest first. I'll have a question. When I execute FBL3N; there is no material column as you know. I can only see both account and material column in BSEG report as you mention. Now; as your solution, it could really help me but how could I plug Material field in FBL3N report. Can you help me about that.

      Best Regards

      Sadullah

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2012 at 06:31 PM

    Hello,

    Two thoughts:

    1 - run the collective WIP job (transacton KKAO) in test mode; down load the report that shows the order number with WIP and use a Production order report to add the materials.

    2 - COSB is the table that holds WIP/RA data, Variance Category WIPR; business transaction: KABG Automat. WIP/results analysis (these can vary depending you your processes)

    This table keys on "oject number" you would need to still determine the material number and net out values in the monthly bucket.

    Opt 1 should be the easiest.

    regards

    Althea

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2012 at 11:06 AM

    When I run KKAO; it will only include the balance of production orders.

    I have to add this with ml document types, price differences which arise from raw materials and activities.

    Could you help about this?

    Best regards.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The problem I see with this is that while material documents and accounting documents will show material issued into an order (debit), the Credit to the order is the Goods receipt of the product being made. I don't see that these documents would net to the details of WIP.

      You can try KOC4, a cost analysis of orders report. you can copy and paste in the order numbers that have WIP and you will get a detail list of planned cost, actual costs, etc. There are a lot of hidden fields for the report that may be useful, including WIP. The "plus" that I see to this report is that you can call all the orders up, sort by WIP value and then drill into the Order's cost report which will show details of material and labor issued and the value of GR.

      this may help your analysis.

      Regards

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2012 at 01:53 PM

    Hello,

    Well, simply I am looking for an answer for activities' total price which were consumed during wip.

    I need to trace which activity were consumed for which material in wip. How could I reach this data?

    Thanks a lot

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      We have a custom report written against GLPCA. - it shows us all materials, and activities charged to an order. All of our Goods issues and Goods reciepts post through profit center accounting. (this could depend on your processes, but it worth a look.

      there is a field for Order Number.

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.