Hello,
I have a problem with this query. If the Lagerplatz for the item is empty in warehouse 02 then it should take from warehouse 01
but it doesn't work. What should i do?
Thanks
SELECT T0.[ItemCode] ,T1.[ItemName], CASE WHEN T0.U_appBinLocation IS NULL THEN (SELECT A.U_appBinLocation FROM OITW A WHERE A.WhsCode = '01' AND A.ItemCode = T1.ItemCode) ELSE T0.U_appBinLocation END, T0.[OnHand], T1.[IsCommited] 'Bestätigt', T1.[CodeBars], T2.[ItmsGrpNam], T3.[PriceList], T3.[Price] FROM DBO.OITW T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode INNER JOIN ITM1 T3 ON T1.[ItemCode] = T3.[ItemCode] INNER JOIN OITB T2 ON T1.ItmsGrpCod = T2.ItmsGrpCod WHERE T0.[U_appBinLocation] LIKE '%[%test%]%'AND T0.[WhsCode] = [%0] AND T2.[ItmsGrpNam] NOT LIKE '%%INAKTIV%%' AND T1.[frozenFor] = 'N' AND T3.[PriceList] = 1 ORDER BY T0.[U_appBinLocation]