Solved: Concatenate 2 fields in SAP Query

Former Member · ‎08-03-2005

Hello,

We have a requirement where we have developed a report in SAP query, but we require a local field to basically give the concatenation of two fields detailed in the info set (EKPO-EBELP & EKET-ETENR)

Can you help me with how to learn to do this?

Many thanks

Steve

former_member214131 · ‎08-03-2005

Hello,

In your Infoset(SQ02), choose coding. In the 'Data' part of coding, you declare the new global variable. Depending on the requirement you concatenate the variables in appropriate part of coding ( Start-of-selection, Record processing etc.,)

Hope this helps you.

Regards, Murugesh AS

former_member214131 · ‎08-03-2005

Hello,

In your Infoset(SQ02), choose coding. In the 'Data' part of coding, you declare the new global variable. Depending on the requirement you concatenate the variables in appropriate part of coding ( Start-of-selection, Record processing etc.,)

Hope this helps you.

Regards, Murugesh AS

Former Member · ‎08-03-2005

Hi,

It hasnt really helped. I was under the impression I would need to create an additional field, and then apply some coding to have this field give the value of the concatenation. This field would then become avialable in the query for output.

Can you expand on this?

Steve

Former Member · ‎08-03-2005

Stephen, hi

You can only achieve this within the infoset, not in the query. Whoever creates/maintains your infosets will need to set this up and make it available in all queries using the infoset.

Kind regards

Mark

RichHeilman · ‎08-03-2005

Yes, in your infoset, you need to create an addtional field, add it to a field group. Also, add the coding, probably something like this.

Concatenate EKET-EBELP EKET-ETENR into NEW_FIELD.

Then, in your query, just pull the new field in.

Regards,

Rich Heilman

Former Member · ‎08-03-2005

Hi Rich,

Yes, I figured the code would be something like that, however, when I generate the infoset, I get the following:

Global syntax check
Additional Fields
Error in code for additional field ITSCH
The last statement is not complete (period missing)

I have placed the following code in the Additional fields/structure section

Concatenate EKET-EBELP EKET-ETENR into ITSCH

Can you help with what is probably a simple issue?

Many thanks

Steve

RichHeilman · ‎08-03-2005

Add a period at the end of that line of code.

Regards,

Rich Heilman

Former Member · ‎08-03-2005

Brilliant, yes, forgot the full stop!