点击此处---> 群内免费提供SAP练习系统(在群公告中)
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
Hello SAP Gurus,
有人可以帮助更新以下查询,以便默认情况下选择所有仓库吗? 现在,当您运行查询时,将弹出"查询-选择标准"窗口,询问您选择哪个仓库代码。 我只希望它默认查询所有仓库。
这是查询:
选择不同的T0.ITEMCODE,T0.ONHAND作为"总数量",T1.AvgPrice"平均价格",T1。[ManSerNum], Datediff(day,T1.LASTPURDAT,GETDATE())<45然后T0.ONHAND END'<45 Days(Qty)'的情况, Datediff(day,T1.LASTPURDAT,GETDATE())<45然后T0.ONHAND * T1.AVGPRICE END'<45 Days(Value)'的情况 当DateDiff(day,T1.LASTPURDAT,GETDATE())> = 45并且DateDiff(day,T1.LASTPURDAT,GETDATE())<90然后T0.ONHAND END '45 to 90 Days(Qty)', 当DateDiff(day,T1.LASTPURDAT,GETDATE())> = 45并且DateDiff(day,T1.LASTPURDAT,GETDATE())<90 THEN T0.ONHAND * T1.AVGPRICE END '45 to 90 Days(Value)'的情况 , 当DateDiff(day,T1.LASTPURDAT,GETDATE())> = 90并且DateDiff(day,T1.LASTPURDAT,GETDATE())<180然后T0.ONHAND END '90 to 180 Days(Qty)', 当DateDiff(day,T1.LASTPURDAT,GETDATE())> = 90并且DateDiff(day,T1.LASTPURDAT,GETDATE())<180 THEN T0.ONHAND * T1.AVGPRICE END '90 to 180 Days(Value)'的情况 , 当Datediff(day,T1.LASTPURDAT,GETDATE())> = 180 THEN T0.ONHAND END'> 180 Days(Qty)'时, Datediff(day,T1.LASTPURDAT,GETDATE())> = 180 THEN T0.ONHAND * T1.AVGPRICE END'> 180 Days(Value)'的情况 从OITW T0内连接OITM T1到T0.ITEMCODE = T1.ITEMCODE T1上的INNER JOIN OITB T2.ITMSGRPCOD = T2.ITMSGRPCOD在t3.itemcode = t0.itemcode和t3.whscode = t0.whscode上左移ibt1 t3 哪里 T0.WhsCode ='[%0]'
我知道了。 太糟糕了,旧网站不见了。 这将在5分钟内得到答复。
嗨,
尝试一下
选择不同的T0.ITEMCODE,T0.ONHAND作为"总数量",T1.AvgPrice"平均价格",T1。[ManSerNum],当Datediff(day,T1.LASTPURDAT,GETDATE())<45 THEN T0时 .ONHAND END'<45天(数量)',当Datediff(day,T1.LASTPURDAT,GETDATE())<45 THEN T0.ONHAND * T1.AVGPRICE END'<45天(值)',案例,当DateDiff( day,T1.LASTPURDAT,GETDATE())> = 45并且DateDiff(day,T1.LASTPURDAT,GETDATE())<90然后T0.ONHAND END '45 to 90 Days(Qty)',当DateDiff(day,T1 .LASTPURDAT,GETDATE())> = 45 AND DateDiff(day,T1.LASTPURDAT,GETDATE())<90 THEN T0.ONHAND * T1.AVGPRICE END '45 to 90 Days(Value)',Case when DateDiff(day, T1.LASTPURDAT,GETDATE())> = 90并且DateDiff(day,T1.LASTPURDAT,GETDATE())<180然后T0.ONHAND END '90 to 180 Days(Qty)',当DateDiff(day,T1.LASTPURDAT) ,GETDATE())> = 90并且DateDiff(day,T1.LASTPURDAT,GETDATE())<180 THEN T0.ONHAND * T1.AVGPRICE END '90 to 180 Days(Value)'(当Datediff(day,T1。 LASTPURDAT,GETDATE())> = 180然后T0.ONHAND END'> 180 Days(Qty)',CAS E当Datediff(day,T1.LASTPURDAT,GETDATE())> = 180 THEN T0.ONHAND * T1.AVGPRICE END'> 180 Days(Value)'from OITW T0 INNER JOIN OITM T1 on T0.ITEMCODE = T1.ITEMCODE INNER 在T1上连接OITB T2.ITMSGRPCOD = T2.ITMSGRPCOD在t3.itemcode = t0.itemcode和t3.whscode = t0.whscode WHERE(T0.WhsCode ='[%0]'或'[%0]' ='')
此致
Nagarajan
一周热门 更多>