SAP ABAP - CDS View Batch Characteristic Value
@AbapCatalog.sqlViewName: 'ZVBATCHCHAR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS View Batch Characteristic Value'
define view ZCDS_BATCH_CHAR_VALUE as select from inob as a inner join ausp as b
on a.cuobj = b.objek left outer join cabnt as c on c.atinn = b.atinn
left outer join cawnt as d on b.atinn = d.atinn and b.atzhl = right(d.atzhl, 3) {
b.objek as auspObjek,
a.objek as obj,
a.obtab,
b.klart,
substring(a.objek, 1, 40) as Material,
substring(a.objek, 41, 50) as Batch,
b.atinn,
c.atbez,
b.atzhl,
b.atwrt,
d.atwtb,
b.atflv,
b.date_from,
b.dec_value_from
} where a.obtab = 'MCH1' and a.klart = '023' and c.spras = 'E'
Comments
Post a Comment