09-05-2008 9:00 AM
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
09-05-2008 9:03 AM
09-05-2008 9:04 AM
I don't think this is possible. Just select everything into an internal table and do the calculation there.
09-05-2008 9:04 AM
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.
09-05-2008 9:13 AM
09-05-2008 9:15 AM
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