Skip to Content
0
Former Member
Jun 16, 2016 at 10:07 AM

How to give date ranges to check the sql query

15 Views

How to give date ranges (Start and ends date) to check the stocks under 2 specific bins

using sap 9.0 and sql 2012

This report i should be placed in query manager. Kindly give solution

SELECT

T1.Whscode 'WH No'

T1.ItemCode 'PartCode'

T1.OnHandQty 'Quantity',

T3.Price 'Value'

T0.BinCode 'Location',

FROM [OBIN] T0

LEFT JOIN [OIBQ] T1 ON T0.WhsCode = T1.WhsCode AND T0.AbsEntry = T1.BinAbs

LEFT JOIN [OITM] T2 ON T1.ItemCode = T2.ItemCode

INNER JOIN [ITM1] T3 ON T3.ItemCode = T2.Itemcode

where

T1.OnHandQty <> 0 AND

(t0.bincode

between '01SYSTEM' and '02SYSTEM')