Functions in CDS VIEW

[jasper_nan]

select mandt,werks,matnr,zltno,vcode,zmsta,ersda,row_number() over(partition by mandt,werks,matnr,zltno order by ersda desc)rid from ytest002

The result is:

Can I make a cds view like this?

what function can i use in cds view?

i can use substring function, but any other functions i can't use in the cds view.

it tell me there is an error,and i can't active it

[pfefferf]

Hello Jasper,

window functions  (like ROW_NUMBER) are not supported in CDS up to now (even not in SPS10).

Check the statement of Tom Jung in chapter "SQL functions" of post regarding this.

Best Regards,

Florian