I have a requirement where I need restrict data(records) of HANA View based on below condition.
Out of above data, I need to delete ORDER and MATERIAL based on Max DATE.
Means, I need ORDER : 102. Need to sort Material based on Max DATE.
As 05032016 is Max Date for MAT1 , I need ORDER =102 and exclude Order-101 .
When I preview data of my CALCULATED VIE, I need only one record(ORDER -102,103,104) out of 4.
How can I achieve this at HANA Calculation View end.