Skip to Content

How to use * in a SELECT statement in CDS view?

Hello guys,

I have a requirement where, in the CDS view with parameters SELECT, I need to fetch all the values of a particular field .If I pass * in parameters, it should fetch all the data of the field.

How can I do this in CDS view?

Regards

Lavanya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 23, 2017 at 10:00 AM

    Hi Lavanya,

    I'm not sure whether you want to use CDS to achieve the select * in open sql.

    you could define a view like the following:

    @AbapCatalog.sqlViewName: 'Ztest_f'

    @AbapCatalog.compiler.compareFilter: true

    @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'test'

    define view ZTest_L as select * from spfli

    Best Regards,
    Sean

    Add comment
    10|10000 characters needed characters exceeded