Query For Raw material Consumption

[arpit_shah2]

Hi,

I am using SAP B1 9.00 PL 08.

Can any one provide the query raw material consumption for particular finish goods during the month.

We are using single level Bill of Material.

Regards,

Arpit

[Former Member]

Hi Arpit,

Try below Query.

Select  T0.ItemCode as Finished_Gooods_ItemCode, T2.ItemName as Finished_Gooods_ItemName,

SUM(T1.IssuedQty) as Total_Raw_Material_Issued_Quantity  from OWOR T0

INNER JOIN WOR1 T1 ON T1.DocEntry = T0.DocEntry

INNER JOIN OITM T2 ON T2.ItemCode = T0.ItemCode

INNER JOIN OITM T3 ON T3.ItemCode = T1.ItemCode

Where

T0.PostDate >=[%3] AND T0.PostDate <= [%4]

AND T0.ItemCode = [%0]

GROUP BY  T0.ItemCode , T2.ItemName

ORDER BY T0.ItemCode

Hope this helps

Thanks'

--

--

Regards::::

Atul Chakraborty

[arpit_shah2]

Thanks Atul for your prompt reply.

But query returns no output. Also please consider deassembly production order in the query.

Regards,

Arpit

[Former Member]

Hi Arpit,

My Mistake.. Check again

Select  T0.ItemCode as Finished_Gooods_ItemCode, T2.ItemName as Finished_Gooods_ItemName,

SUM(T1.IssuedQty) as Total_Raw_Material_Issued_Quantity  from OWOR T0

INNER JOIN WOR1 T1 ON T1.DocEntry = T0.DocEntry

INNER JOIN OITM T2 ON T2.ItemCode = T0.ItemCode

INNER JOIN OITM T3 ON T3.ItemCode = T1.ItemCode

Where T0.ItemCode = [%0] AND

T0.PostDate >=[%3] AND T0.PostDate <= [%4]

GROUP BY  T0.ItemCode , T2.ItemName

ORDER BY T0.ItemCode

Please also check Query is Returning Result.

Hope this helps

Thanks'

--

--

Regards::::

Atul Chakraborty

[arpit_shah2]

Thanks Atul,

Query result shows only qty consumed against finished goods. I need out put Raw Material   item ( ITW1.Itemcode) and qty consumed for finished goods.

Also in query it is not consumed Disassembly production order.

Regards,

Arpit

[Former Member]

Hi Arpit,

Guide me which which Fields you need so that i can Include in Query.

This Query will also show for Disassemble Production Order as there is no Condition for Production Order Type.

Thanks'

--

--

Regards::::

Atul Chakraborty