CONCATENATE

[MaDo]

Hello

I want to combine the field MARA-MATNR and statement 'Q01_' in one field named AQ.

How to build this statement with CONCATENATE?

[MaDo]

Hi a.shaaban,

check for the string function concat

https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/abensql_string_func.htm

select concat( 'Q01_' , MARA-MATNR ) as AQ from table

Regards

Thorsten

[KonradZaleski]

Which programming language is you question referring to?

[ThorstenHoefer]

Hi a.shaaban,

check for the string function concat

https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/abensql_string_func.htm

select concat( 'Q01_' , MARA-MATNR ) as AQ from table

Regards

Thorsten

[Sandra_Rossi]

little typo 😉

[ThorstenHoefer]

Thanks Sandra,

I have fixed it, concat instead of cancate.

Greetings

Thorsten

[RaymondGiuseppi]

• You don't require any conversion-exit attached to domain MATNR?
• Look at ABAP SQL - SQL Expressions sql_exp