How can i create a new table with duplicates summed?

[MarianVatafu]

Hello,

I am new to SAP ABAP and I would like to know if there is any way I can add a list of products with prices, compare it with an existing one, and if there are any duplicates sum the target values and create a final list with all the duplicates+non duplicates.

To be more specific, in the VA42 transaction, I would like to add a new "tab" like the Sales/Item overview ones.

In that Tab i want to put the new list and it will automatically sum it with the existing one from "Sales" Tab but keeping record of the duplicates.

[ArthurParisius · Accepted solution]

Try looking at the COLLECT statement.

[MarianVatafu · Accepted solution]

You'll have to be more specific, i'm a dummy when it comes to ABAP language. I requested access to ABAP Editor ( SE38). I'll try to open the va42 transaction. What should i do next ? I want to add another tab next to Sales/Item Overview etc. where i can paste my new items and the program will automatically add it to the existing list from the Sales tab.

Is it possible ?