topic Re: Adding columns in a open sql select query in Application Development and Automation Discussions

Adding columns in a open sql select query

Former Member — Sun, 26 Jun 2005 06:32:01 GMT

Hi Everyone,

I would like to add the values of n columns of a table and place them in one column, how can i achieve this in open sql.

In oracle native sql the query will look like this:

Select col1 + col2 + col3 AS col

from tab1;

On a similar grounds, i would like to concatenate the contents of n columns into one column. The oracle native sql will look like this:

select col1 || col2 || col3

from tab1;

How can I do this in Open SQL.

Thanks in advance.

Prabhu.

Re: Adding columns in a open sql select query

Former Member — Sun, 26 Jun 2005 07:54:56 GMT

Hi Prabhu,

I'm afraid what you're trying to do is not possible using the Open SQL. You will have to get the data from all the three columns into an internal table and then write your own logic to accomplish the same.

data : begin of itab occurs 0,
         col1 type i,
         col2 type i,
         col3 type i,
         col4 type i,
       end of itab.
field-symbols: <fs_itab> like line of itab.

SELECT COL1
       COL2
       COL3
  INTO TABLE ITAB.

LOOP AT ITAB assigning <fs_itab>.
  <fs_itab>-col4 = <fs_itab>-col1 + <fs_itab>-col2 + <fs_itab>-col3.
ENDLOOP.

Regards,

Anand Mandalika.

Re: Adding columns in a open sql select query

Former Member — Sun, 26 Jun 2005 07:57:29 GMT

I don't think it's possible in open sql..

you should use the ABAP processing to achieve this after selecting all the fileds in relevant varibles ( or itabs)..

Cheers,

Ram

Re: Adding columns in a open sql select query

Former Member — Sun, 26 Jun 2005 08:01:07 GMT

Thanks you so much.