query concatenate text

[Former Member]

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

[Former Member]

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-87b47adbe...

HOPE THE LINK HELPS YOU.

regards,

akshay ruia

[Former Member]

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

[Former Member]

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.

[Former Member]

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.