Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

CONCATENATE

MaDo
Explorer
0 Likes
1,690

Hello

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

How to build this statement with CONCATENATE?

1 ACCEPTED SOLUTION
Read only

ThorstenHoefer
Active Contributor
1,576

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

Hello

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

How to build this statement with CONCATENATE?

5 REPLIES 5
Read only

KonradZaleski
Active Contributor
0 Likes
1,576

Which programming language is you question referring to?

Read only

ThorstenHoefer
Active Contributor
1,577

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

Read only

0 Likes
1,576

little typo 😉

Read only

1,576

Thanks Sandra,

I have fixed it, concat instead of cancate.

Greetings

Thorsten

Read only

RaymondGiuseppi
Active Contributor
0 Likes
1,576