select count( * ) command at internal tables

[Former Member]

Hi,

it is not possible to use a select quiry at internal tables.

I would like determine the number of person with a where

condition at an internal table. How does it work ?

I cant say :

select count( * ) from xxx into xxxxxxx

where xx= xx.

What else can I do ?

Regards

ertas

[Former Member]

hi check this..

PARAMETERS: p_carrid TYPE sbook-carrid,

p_connid TYPE sbook-connid.

TYPES: BEGIN OF sbook_type,

fldate TYPE sbook-fldate,

smoker TYPE sbook-smoker,

smk_cnt TYPE i,

END OF sbook_type.

DATA sbook_tab TYPE TABLE OF sbook_type.

SELECT fldate smoker COUNT( * ) AS smk_cnt

FROM sbook

INTO CORRESPONDING FIELDS OF TABLE sbook_tab

WHERE connid = p_connid

GROUP BY carrid fldate smoker

HAVING carrid = p_carrid

ORDER BY fldate smoker

regards,

venkat

[RichHeilman]

If the data is in an internal table you would have to count it manually.

data: lv_count type i.

clear lv_count.
loop at itab where some_field = 'ABC'.
  lv_count = lv_count + 1.
endloop.

Regards,

Rich Heilman

[Former Member]

Hi,

Use a normal select.

The system variable sy-dbcnt has the number of records from last select statement.

Regards,

Fernando

[valter_oliveira]

Hello.

Make queries to internal tables it's not possible.

In your specific case, to know the number of rows with a specific WHERE condition, you can do it this way:

- LOOP at itab WHERE condition ...

- after the loop check variable sy-tabix: it return how many lines where found.

Best regards.

Valter Oliveira.

[matt]

Rather than loop through the table you could try this.

Your table is itab1. Define a temporary table, itab2, of the same type. NOTE: neither table with header lines. cond is the condition you want the records to meet.

itab2 = itab1.
DELETE itab2 WHERE NOT cond.
no_of_recs_meeting_cond = lines( itab2 ).

Not terribly memory efficient, but it could be a little quicker than looping.

matt

[former_member194669]

I think LINES() is available as of release 6.10,

a®