Hi, I need a query to show inventory movement by item both in and out. This should include all documents that affect inventory which I believe would be AR invoices, goods issues, receipts from production (all outs) and then goods returns, issues for production, and AP invoices (all ins). I'd like it to show the item no, item description, beginning balance, "In" column, "Out" column, and ending balance for a specific time period. A view of a 30, 60, 90 day time period would be best if possible. Please help when you can, thank you!@
This is a very complex query....are you running SQL or HANA?
Have you looked at the standard SAP inventory analysis options?
How do you use plan to use the data in this query - maybe theres an alternative to get you what you need...