topic Dynamice field in the Select statement ? in Application Development and Automation Discussions

Dynamice field in the Select statement ?

Former Member — Thu, 14 Dec 2006 23:05:11 GMT

I want to query a table and get the SUM ( fieldx) without any where clause. However, the fieldx should be dynamic.

Select SUM ( Gross_Wt ) from table. I want the Gross_Wt field to be dynamic.

Any sugestions.

Former Member — Thu, 14 Dec 2006 23:09:17 GMT

Try using Field symbols.

Select SUM ( <FS_Gross_Wt> ) from table.

- guru

Former Member — Thu, 14 Dec 2006 23:13:55 GMT

I tried field symbol its not working. Thanks.

Former Member — Thu, 14 Dec 2006 23:14:12 GMT

Welcome to SDN,

You can try like this


DATA : v_field(40) like c VALUE 'SUM(<FIELD NAME>)',
       v_var TYPE p.
 
SELECT v_field FROM <TABLE> INTO v_var.

Just this blog you will get more idea

/people/alvaro.tejadagalindo/blog/2006/12/13/dynamic-inner-join-function-module

Regards

Kathirvel

Former Member — Thu, 14 Dec 2006 23:21:23 GMT

Karthir, I tried your code, its not working either. Thanks & Regards.

Former Member — Thu, 14 Dec 2006 23:27:31 GMT

Plz try this


DATA : v_field(40) like c VALUE 'SUM( <FIELD NAME> )',
       v_var TYPE p.
 
SELECT v_field FROM <TABLE> INTO v_var GROUP BY <key Field>.

Regards

Kathirvel

Former Member — Thu, 14 Dec 2006 23:57:15 GMT

Solved the problem

strtemp1 = 'SUM( '.

strtemp2 = ' )'.

CONCATENATE strtemp1 l_kfname strtemp2

INTO strsumfld SEPARATED BY space.

SELECT SINGLE ( strsumfld )

FROM (l_etblname)

INTO l_ecubetotal.