topic Re: Count matnr in Application Development and Automation Discussions

Count matnr

Former Member — Thu, 11 Dec 2008 11:57:41 GMT

Moderator message: please use a more informative subject in future

Dear Experts;

I am fetch values And stored in IT_EKPO. this itab available record in below format.

ebeln matnr count

10 lo45 0

10 l045 0

10 o77 0

13 li12. 0

my case is count matnr comparing ebeln.that is my output is stored it_ekpo1.for this way.

ebeln matnr count

10 lo45 2

10 lo77 1

13 li12 1

I am trying this code.is not working .

 it_ekpo1[] = it_ekpo[].
sort it_ekpo1 by matnr comparing ebeln.
sort it_ekpo by matnr comparing  ebeln.

loop at it_ekpo.
  clear count1.
 loop at it_ekpo1 where matnr = it_ekpo-matnr.
    read table it_ekpo1 with key ebeln = it_ekko-ebeln.
      loop at it_ekpo1 where matnr = it_ekpo-matnr.

    count1 = count1 + 1.
  endloop.
  it_count-matnr = it_ekpo-matnr.
  it_count-count1 = count1.
  append it_count.
  clear it_count.
endloop.

<<text removed>>

regards,

raj

Edited by: Matt on Dec 11, 2008 2:40 PM - Please use tags around your ABAP. Do not say "ASAP".

Re: Count matnr

Former Member — Thu, 11 Dec 2008 11:59:58 GMT

Hi Sai,

Just use COLLECT key word within the loop

loop at itab.

collect itab.

and check the value of count in the debug mode

endloop

Regardss

Ramchander Rao.K

Re: Count matnr

Former Member — Thu, 11 Dec 2008 12:01:27 GMT

sort it_ekpo by ebeln matnr .

loop at it_ekpo.

count1 = count1 + 1.

it_ekpo1 = it_ekpo.

at end of matnr.

it_ekpo1 = count1.

append it_ekpo1.

clear count1.

endat.

Endloop.

or other way..

it_ekpo-count = 1.

modify it_ekpo where count eq 0 transporting count.

loop at it_ekpo.

collect it_ekpo1 from it_ekpo..

Endloop.

Edited by: avinash kodarapu on Dec 11, 2008 5:32 PM

Re: Count matnr

Former Member — Thu, 11 Dec 2008 12:04:44 GMT

Hi,

Use the following code.

Take counter as numeric value

Sort the internal table by matnr, ebeln.

Loop at it_ekko wa_ekko.

at end of ebeln.

sum.

move wa_ekko fields to wa_ekko1

then append wa_ekko1 to it_ekko1

endat.

endloop.

regards

Pavan

Re: Count matnr

kesavadas_thekkillath — Thu, 11 Dec 2008 12:09:21 GMT

sort it_ekpo by ebeln matnr ascending.

loop at it_ekpo.

cnt = cn + 1.

at end of matnr.

read table it_ekpo index sy-tabix.

it_ekpo1-ebeln = it_ekpo-ebeln.

it_ekpo1-matnr = it_ekpo-matnr.

it_ekpo1-count = cnt.

append it_ekpo1.

cnt = 0.

endat.

endloop.

Re: Count matnr

Former Member — Thu, 11 Dec 2008 12:14:14 GMT

Hi Soosai,

The following code will work for you.

int_tab - Source table:

ebeln    matnr                                            count
10         lo45                                              0
10         lo45                                              0
10         o77                                               0
13         li12                                               0

int_tab1 - Target table:

ebeln    matnr                                            count
10         lo45                                              2
10         o77                                               1
13         li12                                               1

SORT int_tab BY ebeln matnr.

LOOP AT int_tab INTO wa_tab.
  w_count = w_count + 1.
  wa_tab1 = wa_tab.
  AT END OF matnr.

    wa_tab1-count = w_count.
    CLEAR w_count.
    APPEND wa_tab1 TO int_tab1.

  ENDAT.
ENDLOOP.

Hope this will help you.

Regards,

Manoj Kumar P

Re: Count matnr

matt — Thu, 11 Dec 2008 13:41:43 GMT

Please use a more informative subject in future

Also - don't use ASAP. And do use tags around your ABAP