实际销量=销售订单标准 对应的交货数量 - 销售订单退货 对应的交货数量
select lips~matnr makt~maktx count( lips~lfimg )
from likp join lips on lips~vbeln = likp~vbeln
join mara on mara~matnr = lips~matnr
join makt on makt~matnr = mara~matnr and makt~spras = 1
join vbak on vbak~vbeln = lips~VGBEL
where likp~WADAT_IST >= '20210101' and likp~WADAT_IST < '20220101'
and mara~mtart in ('Z013','Z014','Z015','Z016','Z017') and vbak~AUART = 'ZTA' / ZRE ZQX
group by lips~matnr makt~maktx
order by lips~matnr makt~maktx