topic Re: Problem with Collect statement in Application Development and Automation Discussions

Problem with Collect statement

Former Member — Wed, 19 Dec 2007 07:49:51 GMT

Hi Experts,

I am facing a peculiar problem. Please go through the code below and it is not giving the aggregate of it_ekbe_642_pgi-menge for the same it_ekbe_642_pgi-ebeln and it_ekbe_642_pgi-ebelp.

LOOP AT it_ekbe_642_pgi.

it_ekbe_642_pgi_tot-ebeln = it_ekbe_642_pgi-ebeln.

it_ekbe_642_pgi_tot-ebelp = it_ekbe_642_pgi-ebelp.

it_ekbe_642_pgi_tot-budat = it_ekbe_642_pgi-budat.

it_ekbe_642_pgi_tot-xblnr = it_ekbe_642_pgi-xblnr.

it_ekbe_642_pgi_tot-menge = it_ekbe_642_pgi-menge.

COLLECT it_ekbe_642_pgi_tot.

ENDLOOP.

Please suggest.

Thanks....

Shibaji.

Re: Problem with Collect statement

JackGraus — Wed, 19 Dec 2007 08:04:02 GMT

Table EKBE holds the receipt documents for a purchase order. When you have several receipts on a purchase order item but with a different posting date (BUDAT) or reference (XBLNR) the collect statement will create a new record in yoy internal table. Only numeric fields are aggregated.

regards Jack

Re: Problem with Collect statement

Former Member — Wed, 19 Dec 2007 08:37:24 GMT

Hi Jack,

I wanted to aggregate the numeric field (menge) with same ebeln, ebelp, budat and with different xblnr. But, it is overwriting on the previous record.

Please tell me the problem in the code..

Regards,

Shibaji.

Re: Problem with Collect statement

JackGraus — Wed, 19 Dec 2007 08:41:33 GMT

Then XBLNR should be left blank otherwise different references (XBLNR) will result in different records in your internal table.

Regards Jack

Re: Problem with Collect statement

Former Member — Wed, 19 Dec 2007 08:43:01 GMT

Hi Jack,

I wanted to aggregate the numeric field (menge) with same ebeln, ebelp, budat and with different xblnr. But, it is overwriting on the previous record.

Please tell me the problem in the code..

Regards,

Shibaji.

Re: Problem with Collect statement

JackGraus — Wed, 19 Dec 2007 08:47:48 GMT

Your internal table definition of it_ekbe_642_pgi_tot-menge might not be numeric ?

Regards Jack

Re: Problem with Collect statement

Former Member — Wed, 19 Dec 2007 08:57:11 GMT

hi,

Declare internal table fields datatyps should be same as database fields which you are referring.

one more point is if you are not considering xblnr for cumulation of quantites dont put that in loop while using collect stmt.

afterwards you move xblnr with modify stmt into 2nd internal table.

when budat is also same only (not only ebeln ebelp ) qty will be cumulated.

Regds

Sivaparvathi

Please reward points if helpful.

Re: Problem with Collect statement

former_member402443 — Wed, 19 Dec 2007 08:59:18 GMT

Hi Shibaji Maitra ,

Since you are aggregating the it_ekbe_642_pgi-menge for the same it_ekbe_642_pgi-ebeln and it_ekbe_642_pgi-ebelp.

For using the Collect statement the order of the fields should be

in proper order i.e. all the char fields come up & then after that

all the numeric fields.Please check the sequence in your internal

table and also the fields type of menge field.

LOOP AT it_ekbe_642_pgi.

it_ekbe_642_pgi_tot-ebeln = it_ekbe_642_pgi-ebeln.

it_ekbe_642_pgi_tot-ebelp = it_ekbe_642_pgi-ebelp.

it_ekbe_642_pgi_tot-xblnr = it_ekbe_642_pgi-xblnr.

it_ekbe_642_pgi_tot-budat = it_ekbe_642_pgi-budat.

it_ekbe_642_pgi_tot-menge = it_ekbe_642_pgi-menge.

COLLECT it_ekbe_642_pgi_tot.

ENDLOOP.

Rewards points if helpful.

Regards

Manoj Kumar

Re: Problem with Collect statement

Former Member — Wed, 19 Dec 2007 09:09:27 GMT

hai Shibaji Maitra,

i think ur problem is to collect the fields only when xblnr is changed.if it is right u must use on change of bcz the collect statement collects the field when a single value of left of ur field (it_ekbe_642_pgi_tot) which u are going to collect(it_ekbe_642_pgi_tot) changes.

i think this might be usefull for u.....

Re: Problem with Collect statement

Former Member — Thu, 20 Dec 2007 05:43:26 GMT

Thank you all ... my problem got resolved.

Regards,

Shibaji