topic Re: collect statement issue in Application Development and Automation Discussions

collect statement issue

Former Member — Tue, 22 Jul 2014 06:42:32 GMT

Hi all,

I have a requirement in which I am using Collect statement to club the numeric values.

TYPES: BEGIN OF ST_VBBE ,
                  MATNR TYPE VBBE-MATNR,
                  WERKS TYPE VBBE-WERKS,
                  OMENG TYPE VBBE-OMENG,
            END OF ST_VBBE.
data : IT_VBBE TYPE TABLE OF ST_VBBE,
          WA_VBBE TYPE ST_VBBE,
          it_vbbe_f TYPE TABLE OF st_vbbe,
          WA_VBBE_F TYPE ST_VBBE.
START-OF-SELECTION.
       SELECT MATNR WERKS OMENG
                    FROM VBBE INTO TABLE IT_VBBE UP TO 500 rows.
BREAK-POINT.
LOOP AT IT_VBBE INTO WA_VBBE.
   COLLECT WA_VBBE_f INTO IT_VBBE_f.
ENDLOOP.

This is my code.. But I am not getting a single value in the table in which I am collecting the data.

I am getting the data in IT_VBBE.

Re: collect statement issue

Former Member — Tue, 22 Jul 2014 06:47:34 GMT

Hi,

from where u are getting data into wa_vbbe_f , which you are collecting into it_vbbe_f. Check your Workarea and Table in Collect Statement

Re: collect statement issue

Former Member — Tue, 22 Jul 2014 06:47:43 GMT

use the following code.

loop at it_vbbe into wa_vbbe.

collect wa_vbbe into it_vbbe_f.

endloop.

you will find the collected data in it_vbbe_f.

Regards

Shaik

Re: collect statement issue

Mohamed_Mukhtar — Tue, 22 Jul 2014 06:48:44 GMT

Hello Yash

Change the collect statement to COLLECT WA_VBBE INTO IT_VBBE_f.

Re: collect statement issue

jarus — Tue, 22 Jul 2014 06:49:37 GMT

Hi Yash,

use your coding as

LOOP AT IT_VBBE INTO WA_VBBE.

COLLECT WA_VBBE INTO IT_VBBE_f.

ENDLOOP.

LOOP AT IT_VBBE INTO WA_VBBE.

move WA_VBBE to WA_VBBE_f.

COLLECT WA_VBBE_f INTO IT_VBBE_f.

ENDLOOP.

Thanks,

Sooraj Saini

Re: collect statement issue

SharathYaralkattimath — Tue, 22 Jul 2014 06:50:03 GMT

Add the highlighted code.

LOOP AT IT_VBBE INTO WA_VBBE.

MOVE: WA_VBBE TO WA_VBBE_f.

COLLECT WA_VBBE_f INTO IT_VBBE_f.

ENDLOOP.

Re: collect statement issue

Former Member — Tue, 22 Jul 2014 06:50:14 GMT

Hi Yash,

TYPES: BEGIN OF ST_VBBE ,

MATNR TYPE VBBE-MATNR,

WERKS TYPE VBBE-WERKS,

OMENG TYPE VBBE-OMENG,

END OF ST_VBBE.

data : IT_VBBE TYPE TABLE OF ST_VBBE,

WA_VBBE TYPE ST_VBBE,

it_vbbe_f TYPE TABLE OF st_vbbe,

WA_VBBE_F TYPE ST_VBBE.

START-OF-SELECTION.

SELECT MATNR WERKS OMENG

FROM VBBE INTO TABLE IT_VBBE UP TO 500 rows.

LOOP AT IT_VBBE INTO WA_VBBE_f.

COLLECT WA_VBBE_f INTO IT_VBBE_f.

ENDLOOP.

Regards

Ashwin.

Re: collect statement issue

former_member201275 — Tue, 22 Jul 2014 06:50:20 GMT

You are looping int WA_VBBE, but collecting from WA_VBBE_F? Thats not going to work. Change your collect to "COLLECT WA_VBBE INTO IT_VBBE_F".

Re: collect statement issue

Former Member — Tue, 22 Jul 2014 06:52:09 GMT

As per your code you doing worng,

TYPES: BEGIN OF ST_VBBE ,

MATNR TYPE VBBE-MATNR,

WERKS TYPE VBBE-WERKS,

OMENG TYPE VBBE-OMENG,

END OF ST_VBBE.

data : IT_VBBE TYPE TABLE OF ST_VBBE,

WA_VBBE TYPE ST_VBBE,

it_vbbe_f TYPE TABLE OF st_vbbe,

WA_VBBE_F TYPE ST_VBBE.

START-OF-SELECTION.

SELECT MATNR WERKS OMENG

FROM VBBE INTO TABLE IT_VBBE UP TO 500 rows.

BREAK-POINT.

LOOP AT IT_VBBE INTO WA_VBBE.

COLLECT WA_VBBE_f INTO IT_VBBE_f. " wrong here you taking data in WA_VBBE, so need to pass in WA_VBBE_F and then collect.

ENDLOOP.

"Refer this code

TYPES: BEGIN OF ST_VBBE ,

MATNR TYPE VBBE-MATNR,

WERKS TYPE VBBE-WERKS,

OMENG TYPE VBBE-OMENG,

END OF ST_VBBE.

data : IT_VBBE TYPE TABLE OF ST_VBBE,

WA_VBBE TYPE ST_VBBE,

it_vbbe_f TYPE TABLE OF st_vbbe,

WA_VBBE_F TYPE ST_VBBE.

START-OF-SELECTION.

SELECT MATNR WERKS OMENG

FROM VBBE INTO TABLE IT_VBBE UP TO 500 rows.

BREAK-POINT.

LOOP AT IT_VBBE INTO WA_VBBE.

WA_VBBE_f = WA_VBBE.

COLLECT WA_VBBE_f INTO IT_VBBE_f.

ENDLOOP.

Regards,

Sandeep

Re: collect statement issue

Former Member — Tue, 22 Jul 2014 06:52:52 GMT

Hello ,

Try the below code. Only chnage required is the collect statement will use the same looping table. Inorder to see the other entries in your it_vbbe_f table you need to use append statement also as well.

TYPES: BEGIN OF ST_VBBE ,

MATNR TYPE VBBE-MATNR,

WERKS TYPE VBBE-WERKS,

OMENG TYPE VBBE-OMENG,

END OF ST_VBBE.

data : IT_VBBE TYPE TABLE OF ST_VBBE,

WA_VBBE TYPE ST_VBBE.

START-OF-SELECTION.

SELECT MATNR WERKS OMENGE

FROM VBBE INTO TABLE IT_VBBE.

LOOP AT IT_VBBE INTO WA_VBBE.

COLLECT WA_VBBE INTO IT_VBBE.

ENDLOOP.

COLLECT allows you to create unique or summarized datasets.

The system first tries to find a table entry corresponding to

the table key (see Key definition for internal tables). The

key values are taken either from the header line of the

internal table itab, or from the explicitly-specified work

area wa. itab must have a flat structure, that is, it may not

contain other internal tables. All components that are not

part of the key must be have numeric types (see ABAP numeric

types).

If the system finds an entry, the numeric fields that are not

part of the table key (see ABAP number types) are added to the

sum total of the existing entries. If it does not find an

entry, the system creates a new entry instead.

The way in which the system finds the entries depends on the

type of the internal table:

Thanks,

Re: collect statement issue

Former Member — Tue, 22 Jul 2014 09:28:27 GMT

Siva,

WA_VBBE_f doesn't have any values. You can check the following loop:

LOOP AT IT_VBBE INTO WA_VBBE.

wa_vbbe_f-matnr = wa_vbbe-matnr.

wa_vbbe_f-werks = wa_vbbe-werks.

wa_vbbe_f-omeng = wa_vbbe-omeng.

COLLECT WA_VBBE_f INTO IT_VBBE_f.

ENDLOOP.

Regards

Purnand

Re: collect statement issue

former_member201275 — Thu, 31 Jul 2014 14:46:36 GMT

Is your issue resolved? Did any of the replies help or answer your question? Please mark accordingly and close.

Re: collect statement issue

Pavan_Golesar — Fri, 01 Aug 2014 05:41:36 GMT

hi, yash you have made a slight mistake in my sense, which is why you are unable to get the data through collect statemant.

Here is the recorrect code, kindly like if you are satisfied.

i hope this solves your query.

thanks.