https://blog.csdn.net/weixin_43675474/article/details/119758574
如何汇总数量呢
并且要在汇总数量时根据类型来做到加减
例如S类型的就是相加,H类型的就是减
SELECT aebeln,aebelp,SUM( CASE shkzg WHEN ‘S’ THEN a~menge
WHEN ‘H’ THEN a~menge * -1 END ) AS zkpsl,
SUM( CASE shkzg WHEN ‘S’ THEN wrbtr
WHEN ‘H’ THEN wrbtr * -1 END ) AS zkpje
FROM rseg AS a
INNER JOIN @lt_ekpo AS b ON a~ebeln = b~ebeln AND a~ebelp = b~ebelp
GROUP BY aebeln,aebelp
INTO TABLE @DATA(lt_resg).