number of records in a standard table

[Former Member]

Hi,

How to find number of records, without fetching them into a internal table?

is there any command for that?

I want to know the number of records of a standard table in a report.

Thanks

[Former Member]

In the data browser (SE16) just press the 'number of entries' button.

Rob

[Former Member]

I want to know in my Report, the number of entries.

[Former Member]

SELECT COUNT ...

Rob

[former_member156446]

hmm

null

[Former Member]

DATA: l_count TYPE i.

SELECT COUNT(*) AS l_count
  INTO l_count
  FROM dd02l.

WRITE l_count.

[Former Member]

Hi,

If you want to know the number of records in your internal table after select statement.

You can use the below statement.

data : wa_lines like sy-tfill.

DESCRIBE TABLE itab LINES WS_LINES.

In wa_lines you will have the number of records.

If you want to know the number of records from standard itself.

You can use below :

select count(*) from table into variable
endselect.

Thanks,

Sriram Ponna.

[Former Member]

Hi,

If you want to know the number of records in your internal table after select statement.

You can use the below statement.

data : wa_lines like sy-tfill.

DESCRIBE TABLE itab LINES WS_LINES.

In wa_lines you will have the number of records.

If you want to know the number of records from standard itself.

You can use below :

select count(*) from table into variable
endselect.

Thanks,

Sriram Ponna.