topic Re: Syntax problem in Application Development and Automation Discussions

Syntax problem

Former Member — Wed, 14 Nov 2007 15:50:55 GMT

DATA : BEGIN OF IT_TAB occurs 0,

INTERFACE(50) TYPE c,

COUNTER(10) TYPE n,

END OF IT_TAB.

DATA : IT_TAB1 LIKE IT_TAB OCCURS 0 WITH HEADER LINE.

SELECT interface counter

INTO it_tab

FROM /insfoo/cu_COUTBL.

append it_tab.

ENDSELECT.

COLLECT it_tab into it_tab1.

Collect statment is not working ..

Itab values are as follow..

<b>interface counter</b>

field1 12

field1 14

field1 13

I need the it_tab1 as field1 39

Any help would be appreciated..

thanks in advance..

Re: Syntax problem

Former Member — Wed, 14 Nov 2007 15:52:51 GMT

use COLLECT it_tab into it_tab1.inside select...endselect

reward if it helps,

Satish

Re: Syntax problem

Former Member — Wed, 14 Nov 2007 15:53:49 GMT

SELECT interface counter

INTO it_tab

FROM /insfoo/cu_COUTBL.

<b>COLLECT it_tab.</b>

ENDSELECT.

No need to use it_tab1.

Regards,

Atish

Re: Syntax problem

Former Member — Wed, 14 Nov 2007 16:41:59 GMT

I did try within select and end select..

it does not works..

Re: Syntax problem

Former Member — Wed, 14 Nov 2007 16:44:20 GMT

Have you commented Append Statement after keeping Collect inside select..endselect?

Regards,

Satish

Re: Syntax problem

Former Member — Wed, 14 Nov 2007 16:53:10 GMT

do not use append statement.

just use collect.

Regards

Re: Syntax problem

naimesh_patel — Wed, 14 Nov 2007 16:54:56 GMT

Do it like this:


DATA : BEGIN OF IT_TAB occurs 0,
INTERFACE(50) TYPE c,
COUNTER(10) TYPE n,
END OF IT_TAB.

DATA : begin of it_tab1 occurs 1,
INTERFACE(50) TYPE c,
COUNTER(10) TYPE i,   " <<< this should  be type i, p, f to collect
       end   of it_tab1.
SELECT interface counter
INTO table it_tab  "<< table
FROM /insfoo/cu_COUTBL.

LOOP AT ITAB
COLLECT it_tab into it_tab1.  "<<
ENDLOOP.

Regards,

Naimesh Patel

Message was edited by:

Naimesh Patel