Concatenate two fields within select query

[former_member559754]

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?

[Sathya_Gunasekaran]

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

[former_member559754]

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

[retired_member]

As documented.

[RaymondGiuseppi]

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

[former_member559754]

Thank you.

[yashoratna]

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.