2020-09-09 09:48发布
点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)尊敬的专家 我想编写查询以从... 显示全部
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
尊敬的专家
我想编写查询以从带有序列号的垃圾箱位置获取物品库存。
谢谢
Santosh Dhere。
嗨桑托什,
尝试一下:
选择T0。[ItemCode],T5。[DistNumber],T5。[MnfSerial],T5。[LotNumber],T3。[OnHandQty] ,T1。[BinCode],T1。[WhsCode] 来自[dbo]。[OIBQ] T0 内部联接[dbo]。[OBIN] T1在T0上。[BinAbs] = T1。[AbsEntry]和T0。[OnHandQty] <> 0 左外连接[dbo]。[OBBQ] T2在T0上。[BinAbs] = T2。[BinAbs] AND T0。[ItemCode] = T2。[ItemCode] AND T2。[OnHandQty] <> 0 左外部联接[dbo]。[OSBQ] T3在T0上。[BinAbs] = T3。[BinAbs] AND T0。[ItemCode] = T3。[ItemCode] AND T3。[OnHandQty] <> 0 左外部联接[dbo]。[OBTN] T2上的T4。[SnBMDAbs] = T4。[AbsEntry]和T2。[ItemCode] = T4。[ItemCode] 左外连接[dbo]。[OSRN] T5在T3上。[SnBMDAbs] = T5。[AbsEntry]和T3。[ItemCode] = T5。[ItemCode] T1。[AbsEntry]> =(0)和(T3。[AbsEntry]不为空) 全联盟 选择T0。[ItemCode],T5。[DistNumber],T5。[MnfSerial],T5。[LotNumber],T0。[OnHandQty] ,T1。[BinCode],T1。[WhsCode] 来自[dbo]。[OIBQ] T0 内部联接[dbo]。[OBIN] T1在T0上。[BinAbs] = T1。[AbsEntry]和T0。[OnHandQty] <> 0 左外连接[dbo]。[OBBQ] T2在T0上。[BinAbs] = T2。[BinAbs] AND T0。[ItemCode] = T2。[ItemCode] AND T2。[OnHandQty] <> 0 左外部联接[dbo]。[OSBQ] T3在T0上。[BinAbs] = T3。[BinAbs] AND T0。[ItemCode] = T3。[ItemCode] AND T3。[OnHandQty] <> 0 左外部联接[dbo]。[OBTN] T2上的T4。[SnBMDAbs] = T4。[AbsEntry]和T2。[ItemCode] = T4。[ItemCode] 左外连接[dbo]。[OSRN] T5在T3上。[SnBMDAbs] = T5。[AbsEntry]和T3。[ItemCode] = T5。[ItemCode] T1。[AbsEntry]> =(0)并且(T2。[AbsEntry]为NULL和T3。[AbsEntry]为NULL) 全联盟 选择T0。[ItemCode],T0。[SRNDistNumber],T0。[SRNMnfSerial],T0。[SRNLotNumber],T0。[IBQOnhandQty]-T0。[OnHandQty] ,T0。[BinCode],T0。[WhsCode] 来自( 选择T0。[BinAbs],T0。[ItemCode],MAX(T0。[OnHandQty])AS'IBQOnhandQty',SUM(T2。[OnHandQty])AS'OnHandQty',N''AS'BTNDistNumber',N'' AS'BTNMnfSerial' ,N''AS'BTNLotNumber',N''AS'SRNDistNumber',N''AS'SRNMnfSerial',N''AS'SRNLotNumber',MIN(T5。[AbsEntry])AS'AbsEntry',MIN(T1。 [BinCode])AS'BinCode' ,10000044 AS'SnbType',MIN(T5。[AbsEntry])AS'BTNAbsEntry',MIN(T5。[AbsEntry])AS'SRNAbsEntry',MIN(T1。[WhsCode])AS'WhsCode',MIN(T1。 [SL1Code])AS'SL1Code' ,MIN(T1。[SL2Code])AS'SL2Code',MIN(T1。[SL3Code])AS'SL3Code',MIN(T1。[SL4Code])AS'SL4Code',MIN(T1。[SL1Abs])AS' SL1Ab' ,MIN(T1。[SL2Abs])AS'SL2Abs,MIN(T1。[SL3Abs])AS'SL3Abs,MIN(T1。[SL4Abs])AS'SL4Abs 来自[dbo]。[OIBQ] T0 内部联接[dbo]。[OBIN] T1在T0上。[BinAbs] = T1。[AbsEntry]和T0。[OnHandQty] <> 0 左外连接[dbo]。[OBBQ] T2在T0上。[BinAbs] = T2。[BinAbs] AND T0。[ItemCode] = T2。[ItemCode] AND T2。[OnHandQty] <> 0 左外部联接[dbo]。[OSBQ] T3在T0上。[BinAbs] = T3。[BinAbs] AND T0。[ItemCode] = T3。[ItemCode] AND T3。[OnHandQty] <> 0 左外部联接[dbo]。[OBTN] T2上的T4。[SnBMDAbs] = T4。[AbsEntry]和T2。[ItemCode] = T4。[ItemCode] 左外连接[dbo]。[OSRN] T5在T3上。[SnBMDAbs] = T5。[AbsEntry]和T3。[ItemCode] = T5。[ItemCode] T1。[AbsEntry]> =(0)AND(T2。[AbsEntry]不为空) T0。[BinAbs],T0。[ItemCode]的分组 全联盟 选择T0。[BinAbs],T0。[ItemCode],MAX(T0。[OnHandQty])AS'IBQOnhandQty',SUM(T3。[OnHandQty])AS'OnHandQty',N''AS'BTNDistNumber',N'' AS'BTNMnfSerial' ,N''AS'BTNLotNumber',N''AS'SRNDistNumber',N''AS'SRNMnfSerial',N''AS'SRNLotNumber',MIN(T4。[AbsEntry])AS'AbsEntry',MIN(T1。 [BinCode])AS'BinCode' ,10000045 AS'SnbType',MIN(T4。[AbsEntry])AS'BTNAbsEntry',MIN(T4。[AbsEntry])AS'SRNAbsEntry',MIN(T1。[WhsCode])AS'WhsCode',MIN(T1。 [SL1Code])AS'SL1Code' ,MIN(T1。[SL2Code])AS'SL2Code',MIN(T1。[SL3Code])AS'SL3Code',MIN(T1。[SL4Code])AS'SL4Code',MIN(T1。[SL1Abs])AS' SL1Ab' ,MIN(T1。[SL2Abs])AS'SL2Abs,MIN(T1。[SL3Abs])AS'SL3Abs,MIN(T1。[SL4Abs])AS'SL4Abs 来自[dbo]。[OIBQ] T0 内部联接[dbo]。[OBIN] T1在T0上。[BinAbs] = T1。[AbsEntry]和T0。[OnHandQty] <> 0 左外连接[dbo]。[OBBQ] T2在T0上。[BinAbs] = T2。[BinAbs] AND T0。[ItemCode] = T2。[ItemCode] AND T2。[OnHandQty] <> 0 左外部联接[dbo]。[OSBQ] T3在T0上。[BinAbs] = T3。[BinAbs] AND T0。[ItemCode] = T3。[ItemCode] AND T3。[OnHandQty] <> 0 左外部联接[dbo]。[OBTN] T2上的T4。[SnBMDAbs] = T4。[AbsEntry]和T2。[ItemCode] = T4。[ItemCode] 左外连接[dbo]。[OSRN] T5在T3上。[SnBMDAbs] = T5。[AbsEntry]和T3。[ItemCode] = T5。[ItemCode] T1。[AbsEntry]> =(0)AND(T3。[AbsEntry]不为空) T0。[BinAbs],T0。[ItemCode]的分组 T0 T0。[IBQOnhandQty]> T0。[OnHandQty]
此致
JC。
最多设置5个标签!
嗨桑托什,
尝试一下:
此致
JC。
一周热门 更多>