Exclude duplicate records at Calculation View

Hi All,

I have a requirement where I need restrict data(records) of HANA View based on below condition.

ORDER

MATERIAL

DATE

QTY

101

MAT1

02032016

100

102

MAT1

05032016

200

103

MAT2

06032016

300

104

MAT3

06032016

400

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.

Thanks.