topic Re: Selecting data dynamically in Application Development and Automation Discussions

Selecting data dynamically

Former Member — Wed, 23 Sep 2009 10:52:35 GMT

Hi all,

I have a table ZADDRESS which has fields like MOLGA,FIELD1, FIELD2, FILED3, FIELD4, FIELD5---FIELD8. Based on MOLGA, the values stored in the table would be names of the fields of infotype 6. Say STRAS is sotred in FIELD1, LOCAT in FIELD2. For every different MOLGA i would get different values of the field in the table ZADDRESS. I need to get the data from infotype 6 for only those fields mentioned for that MOLGA in ZADDRESS. Can any one help how this can be done?

Thanks in advance.

Warm regards,

Harshad.

Re: Selecting data dynamically

Former Member — Wed, 23 Sep 2009 11:00:38 GMT

Hi,

You can programatically concatenate the fields you want to be selected into a variable say - lv_select_clause.

Then use that variable in the select clause:

SELECT (lv_select_clause) from ....

Hope this helps,

Wenonah

Re: Selecting data dynamically

Former Member — Wed, 23 Sep 2009 11:16:14 GMT

http://help.sap.com/saphelp_nw04/helpdata/en/66/f9545ed3654bd4b55bf7a5b9953a53/frameset.htm

please go through this link. and search sdn, you will get a lot of wikis and blogs on this

Re: Selecting data dynamically

Former Member — Thu, 22 Oct 2009 11:42:30 GMT

solved