topic Re: Can I calculation values in a select statement ? in Application Development and Automation Discussions

Can I calculation values in a select statement ?

Former Member — Fri, 05 Sep 2008 08:00:02 GMT

Hi friends,

Can I want do calculation in the select statement ? sample

SELECT * FROM VBRP INTO CORRESPONDING FIELDS OF TABLE TEMPTABLE 
   WHERE VBELN = LS_VBRP-VBELN AND 
         MVGR2 = LS_VBRP-MVGR2 AND
        *( KZWI5 / FKIMG )* = BFIYAT.

I want to calculatution process be in a select statement. How its possible ? or not

Regards

İrfan

Re: Can I calculation values in a select statement ?

b_deterd2 — Fri, 05 Sep 2008 08:03:10 GMT

No !

Re: Can I calculation values in a select statement ?

JozsefSzikszai — Fri, 05 Sep 2008 08:04:02 GMT

I don't think this is possible. Just select everything into an internal table and do the calculation there.

Re: Can I calculation values in a select statement ?

Former Member — Fri, 05 Sep 2008 08:04:49 GMT

Hi Irfan,

Calculation is not possible in the select statement.

You may avoid the calculation part and do the filtering after selecting the data.


SELECT * FROM VBRP INTO CORRESPONDING FIELDS OF TABLE TEMPTABLE 
   WHERE VBELN = LS_VBRP-VBELN AND 
         MVGR2 = LS_VBRP-MVGR2.

Re: Can I calculation values in a select statement ?

Former Member — Fri, 05 Sep 2008 08:13:59 GMT

Thanks for all answers ,

I must try filter.

Re: Can I calculation values in a select statement ?

Former Member — Fri, 05 Sep 2008 08:15:16 GMT

Hi,

Select query written is not possible.....

We can add the numeric values using COLLECT keyword..........

Other calculations are to be done only after the selection of data into an internal table.....'

Regards,

Kunjal