How to get latest records from I_GOODSMOVEMENTCUBE CDS View based on Posting Date

[ManuKumar]

Dear community,

We need a report of material aging, for that we need some material documents with latest posting dates for each material, Can I know how to do this in Custom CDS View?

how to sort in descending order and take top 1 in custom cds view app?

[GeovanaLettnin]

Dear Manu Kumar, We helped you to accept the answer, since there were no further updates under the topic. You can unaccept it anytime if the answer provided was not helpful enough and you have further questions. Best regards, Geovana

[MariusSiegel · Accepted solution]

Dear @ManuKumar,

have you tried to use one of the standard reports instead, like the following?

Slow or Non-Moving Materials

Dead Stock Analysis

best regards,

Marius

[Eric_Yu]

Dear @ManuKumar,

Would you please further find the option below to select the data

Select one of the following aggregations for each numeric field in your selection: Max.Min or Sum

https://help.sap.com/docs/SAP_S4HANA_CLOUD/0f69f8fb28ac4bf48d2b57b9637e81fa/fe9b4b4587a84611b94c844c...