ABAP-CDS销售订单合计已交货数量

@AbapCatalog.sqlViewName: 'ZVSD_VBAP_DVR02'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: '销售订单合计已交货数量'
define view ZVSD_VBAP_DVR02_CDS as
select from zvsd_vbap_dvr01 as A
{

A.mandt,
A.vbeln,
A.posnr,
A.werks,
A.matnr,
A.kwmeng,
A.lsmeng,
A.vrkme,
A.uepos,
sum( A.ms_menge_sh ) as MENGE_YJH ,
A.ms_meins,
sum( A.ms_erfmg_sh ) as erfmg_YJH ,
A.ms_erfme
}
where A.ms_mblnr is not null
group by A.mandt,A.vbeln,A.posnr,A.matnr,A.kwmeng,A.lsmeng,A.vrkme,A.ms_meins,A.ms_erfme,A.uepos,A.werks

union

select from zvsd_vbap_dvr01 as A
{

A.mandt,
A.vbeln,
A.posnr,
A.werks,
A.matnr,
A.kwmeng,
A.lsmeng,
A.vrkme,
A.uepos,
A.ms_menge_sh as MENGE_YJH,
A.ms_meins,
sum( A.ms_erfmg_sh ) as erfmg_YJH ,
A.ms_erfme
}
where A.ms_mblnr is null
group by A.mandt, A.vbeln,A.posnr,A.werks,A.matnr,A.kwmeng,A.lsmeng,A.vrkme,A.uepos,A.ms_menge_sh,A.ms_meins,A.ms_erfme