WIP Balance for Materials

[Former Member]

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

[ajaycwa1981 · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[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.

[Former Member]

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.

[Former Member]

Question:  When you say "splitting WIP balance according to material"   I thought you meant according to material that is being produced.   Do you mean by material issued to order?

regards

althea

[Former Member]

Hi Althea;

It is like this. At the end of the year 2011, there is a significant balance in WIP account. I would like to see this balance based on materials. How much does each material have from this WIP balance.

When I run KKAO transaction; I only see the part of this balance for production orders but I want to see the balance which comes up from raw materials and activities.

Thanks a lot.

[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

[Former Member]

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