22,206
社区成员
发帖
与我相关
我的任务
分享
CREATE VIEW V_FZR_CL AS
select DISTINCT a.PSPID,a.POST1,a.VERNR,b.POSID,b.PSPNR,b.OBJNR,c.BANFN,c.BNFPO,d.EBELN,d.EBELP
from PROJ a
join PRPS b on b.PSPHI in (a.PSPNR) and b.MANDT='800' and b.IZWEK='05'
join EBKN c on c.PS_PSP_PNR in (b.PSPNR) and c.MANDT='800'
left join EKKN d on d.PS_PSP_PNR in (b.PSPNR) and d.MANDT='800'
where a.MANDT='800' and a.WERKS='NC01' and (a.PSPID like 'T%' or a.PSPID like 'M%') and a.PSPID like '__N%'
select (sum(b.WKGBTR)+sum(c.SALK3)) as FKBY,a.PSPID
from V_FZR_CL a
left join COEP b on b.OBJNR =a.OBJNR and b.MANDT='800' and b.KOKRS='1000' and b.WERKS='NC01'
and (b.VRGNG='COIE' or b.VRGNG='COIN') and b.WRTTP='04'
left join QBEW c on c.PSPNR =a.PSPNR and c.MANDT='800' and c.BWKEY='NC01' and c.SOBKZ='Q'
group by a.PSPID
select (sum(isnull(b.WKGBTR,0))+sum(isnull(c.SALK3,0))) as FKBY,a.PSPID
from V_FZR_CL a
left join COEP b on b.OBJNR in (a.OBJNR) and b.MANDT='800' and b.KOKRS='1000' and b.WERKS='NC01'
and (b.VRGNG='COIE' or b.VRGNG='COIN') and b.WRTTP='04'
left join QBEW c on c.PSPNR in (a.PSPNR) and c.MANDT='800' and c.BWKEY='NC01' and c.SOBKZ='Q'
group by a.PSPID
select * from
(
select sum(b.WKGBTR) as FKBY,a.PSPID
from V_FZR_CL a
left join COEP b on b.OBJNR in (a.OBJNR) and b.MANDT='800' and b.KOKRS='1000' and b.WERKS='NC01'
and (b.VRGNG='COIE' or b.VRGNG='COIN') and b.WRTTP='04'
group by a.PSPID
)t