topic Re: query concatenate text in Application Development and Automation Discussions

query concatenate text

Former Member — Mon, 10 Jan 2011 23:25:35 GMT

Dear Experts,

is there any way to concatenate 2 text fields into a new local one using the formula option within an sq01 query?

Really great thanks in advance for your help.!!!

Kind Regards

George

Edited by: SapPU87ly on Jan 11, 2011 12:31 AM

Re: query concatenate text

Former Member — Tue, 11 Jan 2011 05:52:31 GMT

hiii,

you can go through the following link to go through infosets and query

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10eab7af-0e54-2c10-28a5-87b47adbe1a5?QuickLink=index&overridelayout=true

HOPE THE LINK HELPS YOU.

regards,

akshay ruia

Re: query concatenate text

Former Member — Tue, 11 Jan 2011 07:14:35 GMT

Hello my friend akshay ruia,

thank you very much for your concern, but I already know all these.

My question is a part of this knowledge in this article which is not mentioned there.

By using all this knowledge I have come to the point to create a local field in which I want to concatenate 2 other text fields.

Is this possible to do this & how exactly?

Great thanks in advance.!

Kind Regards

George

Re: query concatenate text

Former Member — Thu, 20 Jan 2011 08:15:11 GMT

i am also facing this question.

i know that abap can help to slove this problem be slecting both field and combine.

but how do it in GUI window by creating Local Field?

thanks.

Re: query concatenate text

Former Member — Tue, 08 Nov 2011 02:44:28 GMT

Hi There,

I have also been searching for a solution to this problem. I cannot find it documented anywhere where Local fields support a concatenation operator like "&" in Excel. A common usage would be to create a local field Full Name from Last Name, Name Prefix and Full Name.