Questions tagged [hana-cds]

I am working in SAP HANA Native CDS, where i want to convert a sql query into CDS format. The current SQL Query looks like this FIRST_VALUE(STAT) OVER(PARTITION BY OBJNR ORDER BY UDATE desc, UTIME desc) as STAT, FIRST_VALUE(UDATE) OVER(PARTITION BY…

I am trying to use a STRING_AGG function in my SAP HANA CDS file, but the system does not seem to recognize this function. Standard aggregation functions like sum or count seems to work but this one - doesn't: view MY_VIEW as select from A_TABLE…