ABAP-CDS采购订单收货数量

@AbapCatalog.sqlViewName: 'ZVMM_PO_GR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: '采购订单收货数量'
define view ZVMM_PO_GR_CDS as
select key A.mandt,
key A.ebeln,
key A.ebelp,
sum( case when A.shkzg = 'S'
then A.menge
else 0 - A.menge
end
) as menge
from ekbe as A
where vgabe = '1'
and ebeln != ''
and ebeln != '0000000000'
group by A.mandt,
A.ebeln,
A.ebelp