dynamic OpenSQL - SELECT FOR ALL ENTRIES ?

[Former Member]

Hi!

Is it possible to do a dynamic SELECT FOR ALL ENTRIES IN... command?

sg. like:

DATA:

select_text TYPE string,

from_text TYPE string,

where_text TYPE string.

SELECT FOR ALL ENTRIES IN <gt_table1> (select_text)

into corresponding fields of table <gt_table2>

FROM (from_text)

WHERE (where_text).

Thanks and Best Regards,

Tamas

[Former Member]

Hi

INSERT INTO (SELECT department_id, department_name, location_id

FROM departments WHERE location_id < 2000)

VALUES (9999, 'Entertainment', 2500);

Is this you are looking for ?

Regards

Vinod

[Former Member]

Hi Vinod!

No, I'm looking for the ABAP opensql command "SELECT FOR ALL ENRIES IN itab ..." with dynamic from, where etc. texts.

Best Regards,

Tamas