topic Re: How to fetch fields dynamically in Application Development and Automation Discussions

How to fetch fields dynamically

Former Member — Tue, 20 Nov 2007 05:33:44 GMT

Hi experts

I am using a report with following code , in which itemmaster is a workarea.

SELECT SINGLE * FROM zmartitemmaster CLIENT SPECIFIED INTO itemmaster

WHERE mandt = sy-mandt

AND prodid = prodid.

this work area has fields like itemdes1, itemdes2 and so on . Now problem is that i want to fetch its fields dynamically

so i collected dynamic fiels name inot a variable named <b>var</b> (ex concattenate 'itemdes' '1' to var)

then i am trying t fetch as

MOVE itemmaster-var to X.

but its giving a syntax error as itemmaster does not have a component called VAR.

can any body give any possible solution for getting dynamic fields contents.

Regards

Abhay

Re: How to fetch fields dynamically

Former Member — Tue, 20 Nov 2007 05:36:57 GMT

declare var of type itemmaster

Re: How to fetch fields dynamically

Former Member — Tue, 20 Nov 2007 05:42:24 GMT

thanks for reply but i want to fetch its fields dynamically ,

and i am storing fields name in <b>var</b> .

so i dont understand how to do it

can you plz explain it with piece of code .

Regards

Abhay

Re: How to fetch fields dynamically

Former Member — Tue, 20 Nov 2007 05:47:59 GMT

Hi,

You can use field symbols for it.

e.g. FIELD-SYMBOLS : <fs1>.

Using the function GET_COMPONENT_LIST you can get the fieldnames for the internal table being used in the program into another internal table.

Now, loop at the itab.

CONCATENATE 'zitemmaster-' itab-fieldname into str.

ASSIGN (str) to <fs1>.

ENDLOOP.

This will populate the value of zitemmaster-itemdes1, itemdes2 etc. one by one in the field symbol which we can use.

Hope it helps.

Regards,

Himanshu

Re: How to fetch fields dynamically

former_member195698 — Tue, 20 Nov 2007 05:48:10 GMT

Use field symbols to get the info

field-symbols: <fs> type any.

assign component Var of structure itemmaster to <fs>

Regards,

abhishek

Re: How to fetch fields dynamically

Former Member — Tue, 20 Nov 2007 06:57:02 GMT

Hi Himanshu and abhishek

Thanks a lot , problem solved

Regards

abhay

Re: How to fetch fields dynamically

Former Member — Tue, 20 Nov 2007 06:58:37 GMT

Thanks a lot problem solved

Regards

Abhay