dynamic string concatenation in sql where clause

[T0bbes]

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]

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abensql_string_fun...

[T0bbes]

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

[retired_member]

Does not work as RHS but as LHS.

[T0bbes]

[...]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!