topic Re: Pass class methods with returning parameter in Select query where condition. in Application Development and Automation Discussions

Pass class methods with returning parameter in Select query where condition.

Former Member — Sat, 25 Jan 2020 02:11:02 GMT

I am trying to directly call the method which has a returning parameter in the select query where condition . but this does't work. Gives an error. However this works for an IF condition.

if zclass->get_attribute( ) = 1. "this works

endif.

select a from ztable into table @data(lt_table)

where

b = zclass->get_attribute( ). "doesn't work

Does anyone have any idea about it? I am trying to avoid having local variables for all the getter methods and then passing them in the select query as there's quite a few of them and these values are required in multiple methods.

Thanks in advance.

Re: Pass class methods with returning parameter in Select query where condition.

former_member1716 — Sat, 25 Jan 2020 06:41:32 GMT

kaundinya,

Try the below Code and let us know if it works,

select a from ztable into table @data(lt_table)
where
b =  @( zclass->get_attribute( ) ) .

Regards!

Re: Pass class methods with returning parameter in Select query where condition.

Former Member — Sun, 26 Jan 2020 09:45:08 GMT

This works. Thanks!

Just a little change. The into table @data(lt_table) will come at the end like this.

select a from ztable where
b =@( zclass->get_attribute( ) )
into table @data(lt_table).

Re: Pass class methods with returning parameter in Select query where condition.

Sandra_Rossi — Sun, 26 Jan 2020 11:46:20 GMT

For information, the following part of the above code is named a host expression and exists since ABAP 7.50:

@( zclass->get_attribute( ) )

Re: Pass class methods with returning parameter in Select query where condition.

Clemenss — Wed, 17 Mar 2021 20:35:43 GMT

select a from ztable where
b = @( zclass->get_attribute())intotable@data(lt_table).