topic Re: count values in Application Development and Automation Discussions

count values

Former Member — Thu, 17 Jun 2010 11:55:31 GMT

i have three tables

1.ZDOCP contains fields zzmatnr,zzmatkl

2.PRST matnr,pspnr

3.KNA1 name1

i have populted fields

in internal table i_final

i want to count zzmatkl with respective to PSPNR

or else i want to count values in internal table,,

please help experts

syed_ibrahim5 — Thu, 17 Jun 2010 12:27:04 GMT

hi,

do you mean , you want to count the number of records in the final internal table with respect to distinct pspnr.

regards,

syed

Former Member — Fri, 18 Jun 2010 09:23:04 GMT

Hi!

you can loop at your internal table and put a counter somethink like this:



data: aux type i.
aux = 0.

loop at itab.
aux = aux +1.
endloop.

Former Member — Fri, 18 Jun 2010 10:01:13 GMT

Hi,

u can use DESCRIBE statement if u want to count the records of internal table,

or if u want to count no of zzmatkl on the basis of zpspnr then use

loop at itab.

at new zpspnr.

if zmatkl is not initial.

count = count + 1.

endif.

endat.

endloop.

hope ur query will get resolved by this,

if yes then please give rewards and if not then let us know where u r getting problem

Cheerz

Neha

Edited by: neha1.gpta on Jun 18, 2010 2:42 PM