Get the Latest Item record using ABAP CDS

[former_member632762]

Hello Experts,

I need to Build a CDS view which should fetch the latest record [green color highlighted record ] , as shown in the attachment. Is it possible without using Table Functions. Please suggest.

Thanks,

Vijay

[junwu · Accepted solution]

create cds1: select from yourtable{ticket, max(ticketupdatdtime) } group by ticket

then cds 2 select from your table join the cds 1{column you want}

[former_member632762 · Accepted solution]

Hello Jun Wu,

Thanks for the response. Able to solve. That was not possible with single CDS views.

Thanks

Vijay

[Ramjee_korada]

hi Vijay,

It's possible on ABAP layer.

Please see below blogpost.

https://blogs.sap.com/2021/11/30/new-window-functions-in-abap-sql/

BW,

Ramjee