Number of records from each table

[Former Member]

Hi All,

I am extracting the data from VBAK table and am keeping this data in one text file using GUI_Download function module, and also am extracting the data from vbap and vbkd tables and filling the data of these two tables in to one internal table and keeping this data in one text file using GUI_Download function module.

my question is i want to show the number of records extracted from each table.

How can i , anyone plz send me the code ASAP.

BALU.

[Former Member]

You could check the field SY_DBCNT or use the command describe line t_table lines w_lines to check the interanal table size.

[former_member181962]

Once you have the data in internal tables, you can use the describe statement.

describe table itab lines v_lines.

v_lines will now have the number of records in itab.

Regards,

Ravi

[Former Member]

Hi bala,

1. Simple

2. After selecting/extracting data from VBAK table,

in ITAB for eg.

3. describe table itab.

write sy-tfill.

(sy-tfill will contain the number of records)

regards,

amit m.

[Former Member]

hi bala,

use describe stmt.

data: v_lines type i.

describe table itab line v_lines.

write:/ v_lines.

regards,

priya.

[Former Member]

Hi Bala,

After selecting data into the internal table,use

describe table itab lines v_lines.

u wil get the no. of records selected frm the table.

regards,

keerthi.

[Former Member]

Hi Bala ,

If your internal table is IT_VBAK (after extracting records)

then DESCRIBE IT_VBAK LINES V_LINES.

You will get no of records in v_lines.

Define v_lines as -

Data v_lines type I

Regards

Narayan.

[Former Member]

Hi,

try doing like this...

data: v_count like sy-tabix..

describe table it_vbak line v_count.

at end-of -selection

give.....

write:/ 'No of records dounloaded from table VBAK : ' , v_count.

similarly do for other two tables..

Madhavi

[Former Member]

Bala,

If u want to get from IT : describe table t_tab lines v_shipline.

after select if u want : sy-dbcnt.

-Anu