topic Re: Concatenate two fields within select query in Application Development and Automation Discussions

Concatenate two fields within select query

former_member559754 — Tue, 10 Jul 2018 12:05:35 GMT

I have to Concatenate BELNR and GJAHR field of RSEG table into another field. Is it possible in inline coding concatenate these two field within the select query of RSEG table?

Re: Concatenate two fields within select query

Sathya_Gunasekaran — Tue, 10 Jul 2018 12:20:42 GMT

https://blogs.sap.com/2015/10/28/abap-news-for-release-750-host-and-other-expressions-in-open-sql/

Re: Concatenate two fields within select query

RaymondGiuseppi — Tue, 10 Jul 2018 12:21:19 GMT

In recent versions Open SQL allows some functions in an SQL expression such as CONCAT( arg1, arg2 )

Re: Concatenate two fields within select query

former_member559754 — Tue, 10 Jul 2018 13:35:31 GMT

Thanks. It is worked. But it is worked only in Inner Join not worked in For all entries.

Re: Concatenate two fields within select query

former_member559754 — Tue, 10 Jul 2018 13:35:59 GMT

Thank you.

Re: Concatenate two fields within select query

retired_member — Tue, 10 Jul 2018 13:40:09 GMT

As documented.

Re: Concatenate two fields within select query

yashoratna — Fri, 30 Dec 2022 21:29:44 GMT

Hi Amit,

We can use CONCAT syntax in select query as per below.

SELECT concat( belnr , gjahr ) 
FROM rseg 
INTO  @DATA(lv_accdoc_year) 
UP TO 1 ROWS.
ENDSELECT.