Can I calculation values in a select statement ?

[Former Member]

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

[Former Member]

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

[b_deterd2]

No !

[JozsefSzikszai]

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

[Former Member]

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.

[Former Member]

Thanks for all answers ,

I must try filter.

[Former Member]

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