Sales by item query

[wojciech_domanski]

Hi,

I need help with folowing query:

Item Code | Item Desc | Sum of Sold qty in stock UoM | Stock Uom

based on invoices, deliveries, credit notes and returns filter by dates.

Thanks in advance

Wojtek

[former_member227598 · Accepted solution]

Hi,

Please find the below link for your reference get idea and change accordingly......

https://scn.sap.com/thread/3583628

Rgds,

Kamlesh Naware

[wojciech_domanski · Accepted solution]

Thank You for your respond.

It is nice query but I'm afraid that I will not be able to adjust it for my needs.

I need just list of products and sum of sold qty in certain period covering

qty from delivery (not invoiced yet) + qty from invoices - qty from returns (not credit note yet) - qty from Credit Notes

Wojtek

[frank_wang6 · Accepted solution]

you should use OIMN view to get ur result, it is purely based on inventory transaction, so u dont need to consider many different situation like u mentioned.

Frank

[wojciech_domanski · Accepted solution]

How can I get this view? Its not Query Manager table.

[kothandaraman_nagarajan]

Hi,

Please check this thread Query to get sales order, Delivery, Invoice | SCN

Hope from above query you can required quantity.

Thanks.

[wojciech_domanski]

Thanks for your help. I finally got data from OINM Table.

Wojtek

[Former Member]

Hi Wojeciech! Maybe try this one...

SELECT T0.[ItemCode], T1.[ItemName], T0.[Price], T2.[Quantity], T3.[DocDate] FROM ITM1 T0  INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode INNER JOIN INV1 T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OINV T3 ON T2.DocEntry = T3.DocEntry WHERE T0.[PriceList] =[%0] AND  T3.[DocDate] BETWEEN [%1] AND [%2]

Good luck