@AbapCatalog.sqlViewName: 'ZV_ZXK3'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'ZDDL_ZXK3'
@OData.publish: true
define view ZDDL_ZXK3
as select from ekpo
join ekko
on ekpo.ebeln = ekko.ebeln
{
@UI.selectionField: [{position: 10}] //選擇屏幕
@UI.lineItem: [{position:10 }] //報(bào)表行項(xiàng)目
key ekpo.ebeln,
@UI.selectionField: [{position: 20}] //選擇屏幕
@UI.lineItem: [{position:20 }] //報(bào)表行項(xiàng)目
key ekpo.ebelp,
@UI.selectionField: [{position: 30}] //選擇屏幕
@UI.lineItem: [{position:30 }] //報(bào)表行項(xiàng)目
ekpo.matnr,
@UI.lineItem: [{position:40 }] //報(bào)表行項(xiàng)目
ekpo.bukrs,
@UI.lineItem: [{position:50 }] //報(bào)表行項(xiàng)目
@DefaultAggregation: #SUM //默認(rèn)聚合函數(shù):求和
@Semantics.amount.currencyCode: 'waers' //金額貨幣代碼
ekpo.netwr,
@UI.identification: [{position:10 }] //行項(xiàng)目的一般信息
ekpo.menge,
@UI.identification: [{position:20 }] //行項(xiàng)目的一般信息
ekpo.meins,
@UI.identification: [{position:30 }] //行項(xiàng)目的一般信息
@Semantics.amount.currencyCode: 'waers' //金額貨幣代碼
ekpo.netpr,
@Semantics.currencyCode: true //貨幣代碼
ekko.waers
}
where ekko.ebeln = '4500000002'
image.png
image.png
image.png
