Skip to Content
0

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

Feb 09, 2017 at 01:42 PM

73

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sean Zhang
Mar 23, 2017 at 10:00 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded