Dynamice field in the Select statement ?

[Former Member]

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]

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]

Try using Field symbols.

Select SUM ( <FS_Gross_Wt> ) from table.

- guru

[Former Member]

I tried field symbol its not working. Thanks.

[Former Member]

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]

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

[Former Member]

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]

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.