Skip to Content
avatar image
Former Member

TOP N Rows in ABAP CDS

Hi,

Can someone help me to select TOP N rows in ABAP CDS select statement. I tried LIMIT and TOP but doesnt work.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 14, 2017 at 04:12 AM

    Hi Theerthan,

    TOP and LIMIT statements are not supported in ABAP CDS views. You could alternatively use CDS Table Function(which calls a Abap ManagedProcedure function ) where these statements are supported .However you should make sure that your DB is HANA..

    CDS Table Functions

    BR

    Arshad

    Add comment
    10|10000 characters needed characters exceeded

    • Doesn't it seem awful that your brand-new CDS promoted as hell, doesn't support such simple thing?

      Good old OpenSQL supports this from early releases, I do not understand the profit of CDS.

  • Mar 27 at 10:12 AM
    Add comment
    10|10000 characters needed characters exceeded