SAP B1查询-库存账龄

2020-09-18 03:39发布

         点击此处--->   EasySAP.com群内免费提供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]'
 

         点击此处--->   EasySAP.com群内免费提供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]'
 
付费偷看设置
发送
2条回答
shere_lin
1楼-- · 2020-09-18 04:25

我知道了。 太糟糕了,旧网站不见了。 这将在5分钟内得到答复。

compass1988
2楼-- · 2020-09-18 04:23

嗨,

尝试一下

选择不同的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

一周热门 更多>