Skip to Content
Former Member
Jan 04, 2011 at 11:19 AM

Re:Query for items having Stock for a particular warehouse ..!!!


Dear SAP Members,

I need a query to display a list of items having stock by considering all the marketing documents,goods receipt,BOM,Production Order,etc.

I have written query like this:

SELECT T0.[ItemCode], T0.[ItemName], T1.[ItmsGrpNam],T0.[OnHand], 
T0.[IsCommited], T0.[OnOrder] FROM OITM T0  INNER JOIN OITB T1 ON T0.ItmsGrpCod = T1.ItmsGrpCod 
WHERE T1.[ItmsGrpNam] ='[%0]' or  T0.[DfltWH] ='[%1]'

The issue is

The InStock shows the total by calculating all warehouses stock but i need the total for the default warehouse.

Plz suggest or modify my query if i have missed out any fields.

With Regards,