topic Re: A Loop count in Application Development and Automation Discussions

A Loop count

Former Member — Thu, 27 Sep 2007 09:10:30 GMT

How to do a loop for a table to get the total count of the rows?

And write out the total number of rows.

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:12:25 GMT

i am sending you a smaple code from my program

plz see this you can understand very easyly

LV_COUNT = 0.

LOOP AT IT_OUTPUT INTO WA_OUTPUT.

LV_COUNT = LV_COUNT + 1.

WA_OUTPUT-COUNT = LV_COUNT.

APPEND WA_OUTPUT TO IT_OUTPUT_1.

ENDLOOP.

REFRESH IT_OUTPUT.

IT_OUTPUT = IT_OUTPUT_1.

output is my final internal table and output1 is also type of that output structure

<b>Reward if usefull</b>

Re: A Loop count

former_member188827 — Thu, 27 Sep 2007 09:12:51 GMT

loop at itab.

write:/sy-tabix.

endloop.

Message was edited by:

abapuser

Re: A Loop count

sailaja_vadlamudi — Thu, 27 Sep 2007 09:13:50 GMT

Check the thread

Sail

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:15:57 GMT

Hi ,

If i understand correctly you want to get the number of rows in an internal table ,

if that is the case use the DESCRIBE command.

with the addition LINES.

Regards

Arun

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:18:07 GMT

DATA : MY_TABIX TYPE SY-TABIX.

LOOP AT ITAB.

AT LAST .

MY-TABIX = SY-TABIX.

ENDAT.

ENDLOOP.

IN MY_TABIX YOU HAVE NUMBER OF RECORDS.

REWARD IF USEFUL

AMIT SINGLA

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:22:47 GMT

Instead of looping into the table you can use a direct ABAP command:

DESCRIBE TABLE itab LINES gv_record.

WRITE: gv_lines.

gv_line should be type 'i' and will give you number of records in an internal table.

PS: Please mark this question answered since this solves your query.

Regards.

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:26:12 GMT

I'm looping my database table. I want to know how many records i have in my database table.

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:26:29 GMT

describe table itab.

now it wil fil the system field SY-TFILL wid number of lines in internal table

use like this

describe table itab.

write : sy-tfill.

reward if useful

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:29:30 GMT

I'm looping my database table not internal table.

Re: A Loop count

former_member188827 — Thu, 27 Sep 2007 09:31:08 GMT

den use

syst-dbcnt

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:33:44 GMT

Thanks everybody. My question is solved.

I just use SQL statement to loop my table. 😃

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:35:30 GMT

How can you loop at your DB table thats not intelligent.

You can transfer them into an internal table and find the entry count.

Re: A Loop count

Former Member — Thu, 27 Sep 2007 09:39:00 GMT

use sy-dbcnt for the number of record fetched from database table

Re: A Loop count

anupam_srivastava2 — Thu, 27 Sep 2007 09:40:15 GMT

your need to select records which you want from your table into an internal table and then you can loop it and count the number of records.

hope this would be help ful.

cheers