topic Re: Dynamic field Select from table in Application Development and Automation Discussions

Dynamic field Select from table

Former Member — Mon, 11 Jan 2010 05:09:56 GMT

Hi,

I have to select certain field from table. The field which I have to select I do not know.

It will come dynamically from program.

Plz help me what is correct statement to execute.

Thanks.

S Sahoo

Former Member — Mon, 11 Jan 2010 05:17:25 GMT

SELECT (FIELD_NAME) FROM <dbtab>

INTO CORRESPONDING FIELDS OF TABLE itab.

REGARDS,

SUMIT NENE

Former Member — Mon, 11 Jan 2010 05:20:46 GMT

Hi Sahoo,

Pllease follow below steps.

1, Create internal table with field Fieldname TYPE FIELDNAME (Say ITAB)

2. Append Fields (thats you want to select) to internal table [at run time]

3. Use

SELECT (ITAB)

into table <table>

from <DB>

where <cond>

Hope this helps,

Nag

kesavadas_thekkillath — Mon, 11 Jan 2010 05:24:37 GMT

You can use fm FREE_SELECTIONS_DIALOG,RKD_SEL_BUILD_WHERE_CLAUSE,RH_DYNAMIC_WHERE_BUILD , for more details search in SCN.

Refer link:[http://www.sap-img.com/abap/how-can-we-give-dynamic-table-name-in-select-statement.htm]

Former Member — Mon, 11 Jan 2010 05:26:56 GMT

Hi sunil,

Warm regards,

Pravin