Multi Level BOM Quantity - Calculation ?

[#1]

Hi Everyone,

I've very new to SAP PP and dont know too much about it. I have a question related to retrieving the BOM Quantity in a Multi Level BOM and I could really use some help.

I am creating a report to show things like Material Variance and Cost Variances. In order to do this I need to get the lowest level in the BOM. I can do this but I am having trouble understanding the quantity figures.

My client say the BOM Qty being picked up is not correct and therefore it produces an incorrect Material Variance which is out by millions. The BOM QTY I'm picking up is 6.540 kg (base quantity 89.8) - however my client suggest that for a quantity of 400400 the correct BOM Qty is 11.99 kg. I can replicate this in transaction CS11 but not in my report. So that would mean the BOM QTY for a required Quantity of 1 would be 0.00002995.

My question is how do I retrieve a BOM Qty for a required Quantity of 1 or even 1000. I cant see how to get the correct figure from 6.540kg. It seems SAP might do some funny logic to store BOM Quantities.

Any help or input is greatly appreciated as I'm pretty stuck on this. Thanks for your time and patience.

Kind Regards

G

[Former Member · Accepted solution]

Hi,

You can use the function module CS_BOM_EXPL_MAT_V2 to get the Exact bIll of material.

the Parameters you need to Pass are as follows.

CAPID: BOM application

DATUV: Valid From

EHNDL as 1

MKTLS as X

MEHRS as X

MTNRV as Material Number of parent material

STLAN and STLAL as BOM usage and alternative

STPST as 0

SVWVO as X

VRSVO as X

WERKS as plant

and EMENG as the required quantity

it will explode the BOm of PArent to the Lowest level.

Thanks!

[Former Member · Accepted solution]

Hi Mandar N,

Thank you for your reply. I've tried this but it doesnt seem to bring back the component quantity like in the transaction CS11. Is this function module supposed to bring back the component quantity ? If I can get component quantity I can solve my problem

Thanks for your help so far.

G

Edited by: gearoido on Jun 17, 2011 6:07 PM

[Former Member · Accepted solution]

Hi Mandar N,

I made a mistake in the paramaters. This function module is doing exactly what I need. It's bringing back component quantity for a required quantity of 100,000 over the base quantity of 1,000. So this allows me to calculate the componenet quantity 400400 which is 11.99,

Thank you very much for taking the time. I really appreciate it.

Best Regards

G