ABAP-CDS取数销售订单行项目各条件类型值
@AbapCatalog.sqlViewName: 'ZVSD_VBAP_PRICE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: '销售订单单价'
define view ZVSD_VBAP_PRICE_CDS as
select from vbap as A
join vbak as B
on A.mandt = B.mandt
and A.vbeln = B.vbeln
join prcd_elements as C
on B.knumv = C.knumv
and A.posnr = C.kposn
--and C.kschl = 'ZPR2'
and C.kinak = ''
{
A.mandt,
A.vbeln,
A.posnr,
C.kschl,
C.kbetr,
C.kpein,
C.kmein,
C.kwert
}