topic Re: Summarize Internal Table in Application Development and Automation Discussions

Summarize Internal Table

adeel_sarwar — Sat, 26 Dec 2009 07:13:51 GMT

Hi,

How can I summarize an internal table? Example being that using a SELECT statement I have obtained the Open Requisitions from table EBAN and moved it into an Internal table wa_itab.

DATA: BEGIN OF wa_itab OCCURS 0,
    matnr   LIKE marc-matnr,   "Material
    werks   LIKE marc-werks, "Plant
    banfn   LIKE eban-banfn,   "Purchase Requisition
    menge   LIKE eban-menge, "Quantity Requested
    meins   LIKE eban-meins,   "Unit of Measure
    bsmng   LIKE eban-bsmng, "Quantity Ordered
    opqty   LIKE eban-menge,   "Open Quantity
    lfdat   LIKE eban-lfdat,        "Delivery Date
    day     TYPE i,                     "Delivery Date Day
    month   TYPE i,                   "Delivery Date Month
    year(4) TYPE n,                 "Delivery Date Year
    qtyls  LIKE eban-menge,    "Quantity Less Than Current Month
    qty01  LIKE eban-menge,   "Quantity 1
    qty02  LIKE eban-menge,   "Quantity 2
 END OF wa_itab.

Now the aim is that I would like to summarize this by Material. At the moment this will be showing me 100s of lines or more for a material dependant on requisitions. So in a single line I would like to see the material, total order quantity, etc etc.

How can I achieve this?

Thanks

Adeel

Re: Summarize Internal Table

Former Member — Sat, 26 Dec 2009 07:19:15 GMT

Hi,

You can use AT NEW key word.

or take temp itab with only once char field MATNR and pass all data using MOVE-CORRESPONDING and append them to temp itab.

now use COLLECT key word.

for more info take F1 help on these key words.

Cheerz

Ram

Re: Summarize Internal Table

Former Member — Sat, 26 Dec 2009 07:43:34 GMT

hi,

Sort The internal table by MATNR.

If you want to get group by sum

then Use COLLECT key word.

if you want to fire begining of every line of a new MATNR.

then use AT NEW command.

Re: Summarize Internal Table

adeel_sarwar — Sat, 26 Dec 2009 07:53:42 GMT

hi,

can you please write a proper example using the table i have posted in the thread (Wa_itab) ? i have checked the keyword help and trying it but it doesn't seem to working.

thanks

Adeel

Re: Summarize Internal Table

Former Member — Sat, 26 Dec 2009 08:09:19 GMT

Create Another internal table

for example.

data : begin of it_summ ocurs 0,

matnr like marc-matnr,

qtyls LIKE eban-menge,

qty01 LIKE eban-menge,

qty02 LIKE eban-menge,

end of it_summ.

loop at wa_itab.

it_summ-matnr = wa_itab-matnr.

it_summ-qtyls = wa_itab-qtyls.

it_summ-qty01 = wa_itab-qty01.

it_summ-qty02 = wa_itab-qty02.

colect it_summ.

endloop.

you will get a single record for a material and sum of the quantity field u hav mentioned.

Try It.

Re: Summarize Internal Table

sreekanthgo — Sat, 26 Dec 2009 08:12:37 GMT

Hi,

As mentioned by others... For this you should know how to use Control break statements in a loop.

AT NEW... ENDAT.

AT END.... ENDAT.

AT LAST...ENDAT

AT FIRST..ENDAT

First try to read some help on the AT END, AT LAST.. and see how to use it.

Regards,

Sreekanth

Re: Summarize Internal Table

adeel_sarwar — Sat, 26 Dec 2009 08:21:24 GMT

thanks Amit that solved that.

Just another question on this, lets say for example i in eban i have requisitions for 2009 and 2010 and i want to put the quantitys in seperate columns how would i do this using the same analagy? As you have mentioned i have done the loop and collect that will give me a single record for MATNR. Now how would I put the quantitys in the right column lets say i have 2 more columsn 2009 and 2010?

LOOP at wa_itab.
itab-matnr = wa_itab-matnr.
itab-werks = wa_itab-werks.
itab-menge = wa_itab-menge.

COLLECT itab.

ENDLOOP.

Re: Summarize Internal Table

adeel_sarwar — Sat, 26 Dec 2009 08:24:56 GMT

actually got that using if statements etc thanks again for ure help Amit.