2020-09-30 02:14发布
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
专家们,
我真的很想看到一个报告,该报告可以每月产生库存开始余额
像这样
项目代码| 项目自由裁量权| 期初余额日期| 数量| 期末余额日期| 数量
非常感谢。
嗨,
请尝试此操作并还原。.
选择不同的T0.ITEMCODE,T1.FrgnName作为'Part No',T1.ItemName,T2.ItmsGrpNam,T0.WhsCode,T0.ONHAND作为'Total Qty',T0.ONHAND * T0.AVGPRICE作为'TotalPrice' ,T1。[ManBtchNum],T1。[ManSerNum],当Datediff(day,T1.LASTPURDAT,GETDATE())> = 30 THEN T0.HANDEND END'> 30 Days(Qty)',时的情况 Datediff(day,T1.LASTPURDAT,GETDATE())> = 30THEN.THAN。* T0.AVGPRICE END'> 30 Days(Value)', Datediff(day,T1.LASTPURDAT,GETDATE() )> = 60 THEN T0.ONHAND END'> 60 Days(Qty)',当Datediff(day,T1.LASTPURDAT,GETDATE())> = 60THEN T0.ONHAND * T0.AVGPRICE END'> 60天 (值)', Datediff(day,T1.LASTPURDAT,GETDATE())> = 90 THEN T0.ONHAND END'> 90 Days(Qty)', Datediff(day,T1。 LASTPURDAT,GETDATE())> = 90THEN T0.ONHAND * T0.AVGPRICE END'> 90 Days(Value)',当Datediff(day,T1.LASTPURDAT,GETDATE())> = 180 THEN T0.ONHAND END'> 180 Days(Qty)',当Datediff(day,T1.LASTPURDAT,GETDATE())> = 180 THEN T0.ONHAND * T0.AVGPRICE时END'> 180 Days(Val ue)'从OITW T0在T0.ITEMCODE = T1.ITEMCODE =在T1.ITMSGRPCOD = T2.ITMSGRPCOD的内部联接OITM T1左联接在t3.itemcode = t0.itemcode和t3上联接ibt1 t3 .whscode = t0.whscode WHERE T0.ONHAND> 0 AND(T0.WhsCode ='[%0]'或'[%0]'='')和(T2.ItmsGrpNam ='[% 1]'或'[%1]'='')
最多设置5个标签!
嗨,
请尝试此操作并还原。.
选择不同的T0.ITEMCODE,T1.FrgnName作为'Part No',T1.ItemName,T2.ItmsGrpNam,T0.WhsCode,T0.ONHAND作为'Total Qty',T0.ONHAND * T0.AVGPRICE作为'TotalPrice' ,T1。[ManBtchNum],T1。[ManSerNum],当Datediff(day,T1.LASTPURDAT,GETDATE())> = 30 THEN T0.HANDEND END'> 30 Days(Qty)',
时的情况 Datediff(day,T1.LASTPURDAT,GETDATE())> = 30THEN.THAN。* T0.AVGPRICE END'> 30 Days(Value)',
Datediff(day,T1.LASTPURDAT,GETDATE() )> = 60 THEN T0.ONHAND END'> 60 Days(Qty)',
当Datediff(day,T1.LASTPURDAT,GETDATE())> = 60THEN T0.ONHAND * T0.AVGPRICE END'> 60天 (值)',
Datediff(day,T1.LASTPURDAT,GETDATE())> = 90 THEN T0.ONHAND END'> 90 Days(Qty)',
Datediff(day,T1。 LASTPURDAT,GETDATE())> = 90THEN T0.ONHAND * T0.AVGPRICE END'> 90 Days(Value)',
当Datediff(day,T1.LASTPURDAT,GETDATE())> = 180 THEN T0.ONHAND END'> 180 Days(Qty)',
当Datediff(day,T1.LASTPURDAT,GETDATE())> = 180 THEN T0.ONHAND * T0.AVGPRICE时END'> 180 Days(Val ue)'
从OITW T0在T0.ITEMCODE = T1.ITEMCODE =在T1.ITMSGRPCOD = T2.ITMSGRPCOD的内部联接OITM T1左联接在t3.itemcode = t0.itemcode和t3上联接ibt1 t3 .whscode = t0.whscode
WHERE
T0.ONHAND> 0 AND(T0.WhsCode ='[%0]'或'[%0]'='')和(T2.ItmsGrpNam ='[% 1]'或'[%1]'='')
一周热门 更多>