topic Re: Small Doubt with internal table in Application Development and Automation Discussions

Small Doubt with internal table

Former Member — Thu, 17 Jul 2008 14:57:13 GMT

Hi Guys,

I have an internal table like this :

1 a sdn

2 b sdn

3 c sdn

4 e sap

5 e sap

6 f sap

7 g sap

Now I want to get a count which will tell me that there are three lines with "sdn" and 4 lines with "sap".

Any idea how to do it?

Thanks

Kumar.

Re: Small Doubt with internal table

Former Member — Thu, 17 Jul 2008 14:59:59 GMT

itab { field1, field2}.

Sort itab by field 2.

count1, count2 type i.

Loop at itab,

at new field2.

if itab-field2 = 'sap'

count1 ++

else.

count2 ++

endif.

endat

endloop.

Re: Small Doubt with internal table

naimesh_patel — Thu, 17 Jul 2008 15:01:00 GMT

YOu can use the COLLECT to get the count.

Make an internal table, with 2 fields,

Count TYPE I

TEXT TYPE CHAR10.

Now,


LOOP AT ITAB.
  IT_SUM-COUNT = 1.
  IT_SUM-TEXT = ITAB-TEXT.
COLLECT IT_SUM.
CLEAR  IT_SUM.
ENDLOOP.

Regards,

Naimesh Patel

Re: Small Doubt with internal table

Former Member — Thu, 17 Jul 2008 15:01:16 GMT

HI,

LOOP AT ITAB TRANSPORTING NO FIELDS WHERE NAME CS 'SAP'.

ADD 1 TO COUNT.

ENDLOOP.

Regards,

Kiran.

Re: Small Doubt with internal table

Former Member — Thu, 17 Jul 2008 15:02:45 GMT

@Sekhar and Kiran

Here sap is just a value of the internal table and it may change to anything. So I cannot really hard-code the value into my programming.

Thanks

Kumar.

Re: Small Doubt with internal table

Former Member — Thu, 17 Jul 2008 16:22:46 GMT

That is not too difficult Kumar, if you paused to think for yourself how to implement the logic.

define itab2 similar to your itab.

copy contents of itab to itab2.

sort itab2 by field 2.

delete adjacent duplicates from itab2 comparing field 2.

sort itab1 by field2.

loop at itab2.

loop at itab1 where itab1-field2 = itab2-field2.

count++.

write count or store count in itab_count with one field- count & 2nd field value of itab2-field2 & append itab_count.

endloop.

refresh count.

endloop.