求指导！关于物料各价格明细表。

ferryfu · 发表于 2012-5-23 23:01

本帖最后由 ferryfu 于 2012-5-23 23:02 编辑

trigger_lau 发表于 2012-5-23 20:59
其实我一直想做个类似的程序卖给sap了，哈哈

你们谈的sap ecc6吧。这在B1系统是very easy的事情啊。如果ecc6装在Ms sql server上，用sql server 的report service也很容易啊。

trigger_lau · 发表于 2012-5-23 23:29

ferryfu 发表于 2012-5-23 23:01
你们谈的sap ecc6吧。这在B1系统是very easy的事情啊。如果ecc6装在Ms sql server上，用sql server 的rep ...

看到有人放出b1上有这样的功能

trigger_lau · 发表于 2012-5-23 23:29

我想这个应该是产品策略上的问题

kingiiouyang · 发表于 2012-8-25 10:01

如陈先生所言，用ＣＡＳＥ很好使，如果是ＳＱＬ　2008的话，可以转换的列完全够用

临窗飞飞 · 发表于 2013-6-19 16:04

这个其实很简单，ITM1上面有10个Pricelist，分别子查询在INNER JOIN 就可以了！

SELECT T0.[ItemCode],T0.[ItemName],T0.[OnHand],
T1.[Price] 价格1,T2.[Price] 价格2,T3.[Price] 价格3,T4.[Price] 价格4,T5.[Price] 价格5,
T6.[Price] 价格6,T7.[Price] 价格7,T8.[Price] 价格8,T9.[Price] 价格9,T10.[Price] 价格10
FROM OITM T0
INNER JOIN ITM1 T1 ON T0.ItemCode = T1.ItemCode
INNER JOIN (SELECT T0.[ItemCode],T0.[Price] FROM ITM1 T0 WHERE T0.[PriceList] =2 ) T2 ON T0.[ItemCode] =T2.[ItemCode]
INNER JOIN (SELECT T0.[ItemCode],T0.[Price] FROM ITM1 T0 WHERE T0.[PriceList] =3 ) T3 ON T0.[ItemCode] =T3.[ItemCode]
INNER JOIN (SELECT T0.[ItemCode],T0.[Price] FROM ITM1 T0 WHERE T0.[PriceList] =4 ) T4 ON T0.[ItemCode] =T4.[ItemCode]
INNER JOIN (SELECT T0.[ItemCode],T0.[Price] FROM ITM1 T0 WHERE T0.[PriceList] =5 ) T5 ON T0.[ItemCode] =T5.[ItemCode]
INNER JOIN (SELECT T0.[ItemCode],T0.[Price] FROM ITM1 T0 WHERE T0.[PriceList] =6 ) T6 ON T0.[ItemCode] =T6.[ItemCode]
INNER JOIN (SELECT T0.[ItemCode],T0.[Price] FROM ITM1 T0 WHERE T0.[PriceList] =7 ) T7 ON T0.[ItemCode] =T7.[ItemCode]
INNER JOIN (SELECT T0.[ItemCode],T0.[Price] FROM ITM1 T0 WHERE T0.[PriceList] =8 ) T8 ON T0.[ItemCode] =T8.[ItemCode]
INNER JOIN (SELECT T0.[ItemCode],T0.[Price] FROM ITM1 T0 WHERE T0.[PriceList] =9 ) T9 ON T0.[ItemCode] =T9.[ItemCode]
INNER JOIN (SELECT T0.[ItemCode],T0.[Price] FROM ITM1 T0 WHERE T0.[PriceList] =10 ) T10 ON T0.[ItemCode] =T10.[ItemCode]
WHERE T1.[PriceList]=1

复制代码