topic Re: Dynamic select statement in Application Development and Automation Discussions

Dynamic select statement

RKSK — Wed, 29 Jun 2011 09:37:29 GMT

Hi Friends,

could we have dynamic internal table in for all entries of select statement

i.e.

i am looking for select like

here gt_table is vbak and it could be any

select vbeln

from vbap

into gt_vbap

for all entries in * (gt_table)*

where ( string clause).

hope every thing is clear .

Thank you

kat

Former Member — Wed, 29 Jun 2011 09:50:21 GMT

Hi,

if you imply gt_table is a table whoose structure is dynamic. then yes you can pass teh table in for all entries.

You can cretae a dynamic internal table using field symbols.

If you are saying can you pass a variable in for all entries <variable table>. Then i doubt if that is possible.

Venkat_Sesha — Wed, 29 Jun 2011 09:50:36 GMT

Just Use this in the declaration part. lv_table TYPE ddobjname,

ref_table_des ?=

cl_abap_typedescr=>describe_by_name( lv_table ).

Assign the structure at runtime

Select will be as follows.

SELECT SINGLE *

FROM (lv_table)

INTO CORRESPONDING FIELDS OF <dy_wa2>

WHERE (tb_where).

Everything here is Dynamic. Hope this helps

RKSK — Wed, 29 Jun 2011 12:06:57 GMT

HI Friends,

Is there any one who could answer my query??

SuhaSaha — Wed, 29 Jun 2011 12:49:25 GMT

Hello Rachit,

Similar question has been discussed in the forum:

BR,

Suhas