topic Re: Count in internal table in Application Development and Automation Discussions

Count in internal table

Former Member — Thu, 26 May 2005 08:21:00 GMT

Hi,

How can i get the number of records(count) in an Internal table based on some condition.

Re: Count in internal table

jayanthi_jayaraman — Thu, 26 May 2005 08:27:49 GMT

Hi,

data cnt type i.

i = 0.

Loop at internaltable into workarea where condition.

i = i + 1.

endloop.

write : 'Count:',i.

Re: Count in internal table

Former Member — Thu, 26 May 2005 08:30:05 GMT

Hi,

Loop at itab where <cond>.

<b>add 1 to counter</b>.

endloop.

Also,If u r doing a looping alone then, After looping at the internal table (after endloop) u can also get the value of <b>sy-index</b>. This will hold the count in that internal table.

http://www.sapdevelopment.co.uk/reporting/ind/ind_count.htm

Thanks & Regards,

Judith.

Message was edited by: Judith Jessie Selvi

Re: Count in internal table

Former Member — Thu, 26 May 2005 08:30:28 GMT

Hi Suzane,

You cannot find the count in one direct statement. You will have to use the count() in your select, or if that is not possible, then:

Easy option:

loop at itab where field1 = condition1.

counter = counter + 1.

endloop.

A lesser easy way, and not always feasible:

itab_copy[] = itab[].

delete itab_copy where field1 NE condition1.

describe table itab_copy lines lv_lines.

Cheers, Rahul

Re: Count in internal table

Former Member — Thu, 26 May 2005 08:46:07 GMT

I think the only possible way is by looping over the table:

Counter = 0.

LOOP AT itab WHERE cond1 AND cond2.

Counter = counter + 1.

Endloop.

You might gain some speed if it is a large table by

using field symbols or references, this avoids the cost of copying the table record to the work area.

Loop at itab assigning <FS> where cond1 AND cond2.

counter = counter + 1.

endloop.

Loop at itab reference into dref where cond1 AND cond2.

counter = counter + 1.

endloop.

Hope this helps.

Joris.

Re: Count in internal table

Former Member — Thu, 26 May 2005 12:05:37 GMT

Hi Judith,

I am not sure that is correct. SY-INDEX will hold the index of the last record that was looped at, but this may not necessarily be equal to the number of records matching the condition. (By the way, possibly you mean SY-TABIX).

Consider the following example. After looping through the table, SY-TABIX = 3. There are, however, only 2 records matching the condition.

data: begin of itab occurs 0,

val1 type c,

val2 type c,

end of itab.

itab-val1 = 'A'.

itab-val2 = 'C'.

append itab.

itab-val1 = 'A'.

itab-val2 = 'B'.

append itab.

itab-val1 = 'A'.

itab-val2 = 'C'.

append itab.

loop at itab where val2 = 'C'.

endloop.

write: sy-tabix.

Re: Count in internal table

Former Member — Thu, 26 May 2005 17:06:40 GMT

Data: v_line type i.

Describe table itab lines v_line. (for all records)

Write: v_line.

loop at itab.

if (condition)

add 1 to v_line.

endif.

endloop.