topic Re: collect statement not adding and mergeing in Application Development and Automation Discussions

collect statement not adding and mergeing

pritam_baboo49 — Mon, 04 Jul 2022 10:20:29 GMT

Hi All,

I have an Internal table with fields that I want to add and merge. For ex:

plant bomID matnr idnrk menge vornr plnnr

1100 1028-02 111222 11122205 100 31 5555-1

1100 1028-02 111222 11122205 200 33 5555-2

1100 1028-01 111222 11122203 200 34 5555-2

1100 1028-01 111222 11122203 200 33 5555-2

1100 1028-02 111222 11122201 100 33 5555-2

Now I want to add the MENGE field(it is type p) according to idnrk and result should be

plant bomID matnr idnrk menge vornr plnnr

1100 1028-02 111222 11122205 300 31 5555-1

1100 1028-02 111222 11122203 400 33 5555-2

1100 1028-01 111222 11122201 100 33 5555-2

I am using collect statement but it is not working. Kindly suggest

Re: collect statement not adding and mergeing

FredericGirod — Mon, 04 Jul 2022 10:41:50 GMT

Why do you say it didn't work?

what is the result ? what is the code used ?

Re: collect statement not adding and mergeing

Sandra_Rossi — Mon, 04 Jul 2022 11:21:57 GMT

COLLECT statement "adds and merges" very well in the conditions explained in the ABAP documentation.

Re: collect statement not adding and mergeing

former_member640214 — Mon, 04 Jul 2022 12:21:15 GMT

1. Collect statement could not collect the data according to a specific field( Ex: In you case menge could not be collected for IDNRK only)

2. In your structure collect statement collect the menge according to below highlighted fields.

plant bomID matnr idnrk menge vornr plnnr

Hence collect statement won't fulfill your requirement

3. Solution :Try to use the structure with less no.of fields if possible and use collect. Or use loop statement and add menge.

Re: collect statement not adding and mergeing

pritam_baboo49 — Wed, 06 Jul 2022 06:08:48 GMT

The Collect statement is just adding up but line items are not merging. As stated by Rama Chittimadi, Thanks for the inputs. I am using loop statement.

Re: collect statement not adding and mergeing

venkateswaran_k — Wed, 06 Jul 2022 06:14:54 GMT

Hi Preetham

Collect statement is like a Group by Clause in SQL.

So for each combination of

Plant + BomID + Material + Maerial(idnrk) + vornr + plnnr == sum(menge).

So if you want on any specific one , then you need to handle other also not chaning.