Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How many entries in a Table??

Hi Experts,

Pls. let me know, How to to get it know that, each table does have so many entries? say, BKPF 10 million, like that, i need to display the entries in each table!!

I know, I can write a report prog. but, wuld like know that, Is there any way, to make it simple?? like using DD03T....some thing like that.......


TABLES: dd02l.

SELECT-OPTIONS: s_tabnam FOR dd02l-tabname.

DATA: BEGIN OF itab_tables OCCURS 0,
        tabname LIKE dd02l-tabname,
        count   TYPE i.
DATA: END OF itab_tables.


  SELECT tabname INTO TABLE itab_tables
                       FROM dd02l
                      WHERE tabname  IN s_tabnam
                        AND tabclass EQ 'TRANSP'.

  LOOP AT itab_tables.
    SELECT COUNT(*) FROM (itab_tables-tabname)
                    INTO itab_tables-count.
    MODIFY itab_tables.
    WRITE:/ itab_tables-tabname,

Sorry, I should have removed the extra data declarations.

Message was edited by:

Srinivas Adavi

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question