how to get the num of records from a table?

Question

SELECT COUNT(*) AS NumberOfRecords FROM tableX; how do I convert this to sap ABAP

...without bothering to even use Google to search for an answer? — vwegert, Dec 28 '16 at 19:04

maillard · Accepted Answer · 2016-12-24T10:34:37.210

5

For database tables you can do SELECT COUNTlike this:

SELECT COUNT( * )
    INTO numberOfRecords
    FROM tableX.

To get the line count of an internal table you need the DESCRIBE statement:

DESCRIBE TABLE tableX LINES numberOfRecords.

edited Dec 24 '16 at 10:34

answered Dec 24 '16 at 07:00

maillard

680
1
14
27

Don't you have to add `SINGLE` to use this `SELECT` without `ENDSELECT`? – Dec 24 '16 at 10:02
It works both with and without `SINGLE` on our system. The F1 help doesn't show `SINGLE` for aggregate functions – maillard Dec 24 '16 at 10:33

score 1 · Answer 2 · answered Dec 27 '16 at 00:15

1

For internal tables you can use this build in function as well:

numberOfRecords = lines( tableX)

answered Dec 27 '16 at 00:15

Togo

172
8

score 0 · Answer 3 · answered Jan 14 '21 at 07:43

I had a similar issue, and a colleague gave me to following. I needed the counts of entries in a db table for a key, and didn'enter code heret want to do a select count(*) in a loop. So, we created a sorted table with the unique key, did a select... endselect into that table with the condition BEFORE the loop, and in the loop simply read this new sorted table:

types:
            begin of ts_tab
                        f1 type 1
                        f2 type 2
                        f3 type i
            end of ts_tab
            tt_tab type sorted table of ts_tab
            with unigue key f1 f2
 
select f1 f2 into coorresponding fields of ls_tab
            read table lt_tab assigning <ls_tab>
                        with table key f1 = f1 etc.
            if sy-subrc = 0.
                        add 1 to <ls_tab>-f3
            else.
                        ls_tab-f3 = 1.
                        insert ls_tab into lt_tab.
            endif.
endselect 
loop etc.

   read lt_tab into ls_tab with key f1 = f1 f2 = f2.
   if sy-subrc eq 0.
      my_count = ls_tabl-f3.
   endif

endloop

score -1 · Answer 4 · edited Jul 24 '17 at 13:01

-1

You may use ABAP Statement:

DESCRIBE TABLE itab[] lines lv_no.

edited Jul 24 '17 at 13:01

Russia Must Remove Putin

374,368
89
403
331

answered Jul 24 '17 at 12:08

Ethic Coder Pavan Golesar

1
2

score -2 · Answer 5 · edited Aug 14 '19 at 14:08

-2

1) If you just want the count of the records in database table, use the following syntax.

SELECT COUNT( * ) INTO RecordCount FROM tableX.

2) But, if you need the records for processing, as well as the count then use following.

SELECT * INTO TABLE itab FROM tableX.
DESCRIBE TABLE itab[] lines RecordCount.

edited Aug 14 '19 at 14:08

Dharman

30,962
25
85
135

answered Aug 14 '19 at 14:03

M Shaik

1
1

There is a difference in the syntax of the Case 2. – M Shaik Aug 15 '19 at 15:41
Hardly any. I believe the question was about SQL table, not the internal tables. If it was about internal tables then `lines( )` is more suitable. – Dharman Aug 15 '19 at 16:01
The difference i am pointing to is in this line. SELECT * INTO TABLE itab FROM tableX. Anyway, i later realized it was an old post. So not much use in arguing among us. – M Shaik Aug 16 '19 at 11:35

how to get the num of records from a table?

5 Answers5