topic Re: How do I concatenate 2 fields in an Open SQL Select in Application Development and Automation Discussions

How do I concatenate 2 fields in an Open SQL Select

Former Member — Tue, 01 Sep 2009 14:33:25 GMT

Hi,

I have an internal table (simplified) that looks like this:

BEGIN OF t_konv,

kwert_vprs TYPE kwert,

knumv_kposn type char16,

END OF t_konv.

From an Open SQL Select statement I need to put kwert into kwert and I need to combine knumv and kposn into knumv_kposn.

Here is my select, but I do not know how to specify the last 2 fields as being concatenated into kmunv_kposn in my internal table.

SELECT h_{kwert h}knumv h~kposn

INTO TABLE it_konv

FROM konv AS h

FOR ALL ENTRIES IN it_bil_sal

WHERE h~knumv = it_bil_sal-knumv

AND h~kposn = it_bil_sal-posnr.

Any help is much appreciated!

Thx,

Andy

Re: How do I concatenate 2 fields in an Open SQL Select

Former Member — Tue, 01 Sep 2009 14:38:37 GMT

What happens if you execute the queery as written?

Rob

Re: How do I concatenate 2 fields in an Open SQL Select

Former Member — Tue, 01 Sep 2009 14:42:09 GMT

I get a short dump:

Error analysis

In a SELECT or FETCH command, the field string or internal table

specified in the INTO clause has 9 fields. It must have

at least as many fields as in the SELECT clause,

10 fields in this case.

Re: How do I concatenate 2 fields in an Open SQL Select

Former Member — Tue, 01 Sep 2009 14:57:12 GMT

Do you have to combine both fields into one?

I guess you could select the data into a table with the correct attributes and then copy the table into another table wit the attributes you want. (ITAB1[] = itab2[].)

Rob

Re: How do I concatenate 2 fields in an Open SQL Select

Former Member — Tue, 01 Sep 2009 15:05:49 GMT

Right now, concatenating them is my solution to some other issue, so yea, I'd like to make it work this way, if possible.

That's a thought...I could do as you try. It just sucks that I can't do it in the select...it's so simple in ANSI SQL:

Select fielda || fieldb from...

Thanks alot for your help, Rob.

Andy