topic Re: dynamic string concatenation in sql where clause in Application Development and Automation Discussions

dynamic string concatenation in sql where clause

T0bbes — Fri, 15 Dec 2017 10:22:29 GMT

Is it possible to combine two variables from a select in a subselect?

Example:

select tplnr from table1 as a where ( exists ( select * from table2 where key = @sy-mandt+a~tplnr)).

Focus:

@sy-mandt+a~tplnr

Thanks!

retired_member — Fri, 15 Dec 2017 10:32:48 GMT

T0bbes — Fri, 15 Dec 2017 10:48:29 GMT

This function does not working wihtin the "where" expression. I can't compile it.

retired_member — Fri, 15 Dec 2017 10:51:22 GMT

Does not work as RHS but as LHS.

T0bbes — Fri, 15 Dec 2017 11:29:43 GMT

[...]select addrnumber from adrv where concat( 'test1', 'test2' ) = p~appl_key [....]<br>

This leads to the following error message: ( is gramatically not allowed here...

Okay.. we are using 7.4 not 7.5... sorry. Thanks!