topic Re: select statement in Application Development and Automation Discussions

select statement

former_member196517 — Fri, 25 Jan 2008 10:52:26 GMT

Hi All,

I have one internal table where i have stored transparent table names.. now i want to loop thru this internal table and want to count number of rows in all transparent tables so i will use select count (*) from transparent table name.. but as this is a string or name which is generated dynamically.. code gives a syntax error.. how to overcome this problem

my code is something like this

loop at itab into wa

select count (*) from wa-tablename

endloop

Regards

Anuj

Re: select statement

ThomasZloch — Fri, 25 Jan 2008 10:53:49 GMT

try

select count (*) from (wa-tablename)

Greetings

Thomas

Re: select statement

former_member156446 — Fri, 25 Jan 2008 11:00:58 GMT

Hi Anuj

else check this way


data: lv_tb type DD02D-DBTABNAME.

loop at itab into wa

lv_tb = wa-tablename.

select count (*) from lv_tb.

endloop.

Re: select statement

former_member196517 — Fri, 25 Jan 2008 12:37:37 GMT

doesnt work.. says syntax error lv_tb doesnt exist in ddic.

Re: select statement

ThomasZloch — Fri, 25 Jan 2008 12:39:19 GMT

see my post above, that should work for you.

Re: select statement

Former Member — Fri, 25 Jan 2008 12:56:15 GMT

Hi,

Try this

Data: l_cnt type i.

parameters: p_tname type char30 default 'MARA'.

select Count(*) from (p_tname) into l_cnt.

Regards,

Satish

Re: select statement

former_member156446 — Fri, 25 Jan 2008 12:58:14 GMT

Hi this works, I tested it... just fill the itab during debugging..


TABLES: vbak , vbap.

DATA: BEGIN OF itab OCCURS 0,
       lv_tb TYPE dd02d-dbtabname,
      END OF itab,
    l_count TYPE i.
DATA: lv_tb TYPE dd02d-dbtabname.

LOOP AT itab.
  lv_tb = itab-lv_tb.

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

  WRITE l_count.

ENDLOOP.

Re: select statement

Clemenss — Fri, 25 Jan 2008 13:32:26 GMT


loop at itab into wa
select count (*) from (wa-tablename).
write: \ wa-tablename, sy-dbcnt.
endloop.

In most cases, ABAP requires the field in (brackets) if you want it's value to be interpreted.

Regards,

Clemens