Dynamic field Select from table

[Former Member]

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]

SELECT (FIELD_NAME) FROM <dbtab>

INTO CORRESPONDING FIELDS OF TABLE itab.

REGARDS,

SUMIT NENE

[Former Member]

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]

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]

Hi sunil,

Please folow this link http://help.sap.com/search/highlightContent.jsp

Warm regards,

Pravin