topic Dynamic Selection in Application Development and Automation Discussions

Dynamic Selection

Former Member — Tue, 19 Jun 2007 13:53:16 GMT

Can anybody help how to do Dynamic selction from dynamic table to dynamic work area

example is

data p_name(12) type c.

p_name = 'MARA'.

select single* from (p_name) into (dynamic_work_area) where matnr = .....

i am able to do with dynamic table name but i am unable to code get the values into dynamic work area

Thanks

Uma

former_member378318 — Tue, 19 Jun 2007 14:56:50 GMT

Hi try the following:

DATA p_name(12) TYPE c.

DATA dref TYPE REF TO data.

FIELD-SYMBOLS: <wa> TYPE ANY.

p_name = 'MARA'.

CREATE DATA dref TYPE (p_name).

ASSIGN dref->* TO <wa>.

SELECT SINGLE * FROM (p_name) INTO <wa> WHERE matnr = ....

former_member196065 — Wed, 20 Jun 2007 00:23:57 GMT

Thanks Surbjeet Dhillon

This solved my problem

Uma