Problem to make a CDS view. ( Max keyword is not working )
I want to make a CDS VIEW about system status ( From TJ02T, JEST )
But. CDS view doesn't work Max aggregation comparing STAT field. I want to get only one max line but the result It has two line.
STAT field is CHAR5 . But MAX aggregation it works characteristc domain. isn't it?
Here is my source.
|CDS Define Source|
select from proj as proj
But the result has two line like this
Sorrry. I was idiot.
I have to use only key fields on GROUP BY statement, Like this
GROUP BY proj.pspid, jsto.objnr