Skip to Content
0
Jan 24, 2017 at 09:14 AM

Hana CDS View Field Name

6082 Views Last edit Jan 25, 2017 at 07:25 AM 2 rev

Hi,

i created cds view dll and i add new 'CHARK' fields when .. case but field name is empty ?

my dll source code below and se16n screen shoot.

@AbapCatalog.sqlViewName: 'ZHV_QM_001'
@ClientDependent: true
@AbapCatalog.compiler.CompareFilter: true
@EndUserText.label: 'Release QM Karakteristik'
/* Mustafa Hamit - 14.01.2017 */

define view Zhv_Qm_0001 as

select distinct from zpp_v_0004 as p
left outer join qals as q on p.aufnr = q.aufnr
left outer join qamv as b on q.prueflos = b.prueflos

{
key q.prueflos,
( 
case when b.verwmerkm <> '' then 'X'
else ''
end
) 
as chark @<EndUserText
@<EndUserText.label: 'CHARK'
@<EndUserText.quickInfo: 'Kayıt Var Göstergesi',
p.aufnr,
p.patid,
p.satid,
p.uaaop,
p.aufnr_temp,
p.patid_79,
p.dalan,
p.kokda,
p.paren,
p.par_satid,
p.seviy,
p.bmsch,
p.satid_65,
p.paren_65,
p.seviy_65,
p.kestp,
p.gblok,
p.sattp,
p.vornr,
p.arbpl,
p.ktsch,
p.steus,
p.umren,
p.umrez,
p.genis_65,
p.coils,
p.meins,
p.weight,
p.urtmk,
p.vbeln,
p.posnr,
p.birsip,
p.birmat,
p.charg,
p.sipma,
p.werks,
p.lgort,
p.plnnr,
p.plnal,
p.sipkl,
p.kalge,
p.kalcs,
p.hurda,
p.serit,
p.segtp,
p.tip,
p.x0,
p.x1,
p.y0,
p.y1,
p.erdat,
p.erzet,
p.ernam,
p.aedat,
p.aezet,
p.aenam,
p.vge01,
p.vgw01,
p.optrh,
p.ebeln,
p.ebelp,
p.islem,
p.baslik,
p.operasyon,
p.bilesen,
p.baslik_rslt,
p.operasyon_rslt,
p.bilesen_rslt,
p.message,
p.vge02,
p.vgw02,
p.slwid,
p.usr00,
p.usr11,
p.huk,
p.relok
}
where p.aufnr is not null
/*group by q.prueflos*/

Attachments

capture.png (23.3 kB)