topic Re: Operation in Select Statement in Application Development and Automation Discussions

Operation in Select Statement

Former Member — Thu, 28 Feb 2008 11:41:30 GMT

Hi,

In an ABAP select statement, how to do operations on two columns of a dictionary transparent table(say division or multiplication on two column values) ?

Reward points will be awarded .

TIA

Regards,

Anindita

Re: Operation in Select Statement

Former Member — Thu, 28 Feb 2008 11:46:58 GMT

HI,

I don't think this can be achieved using OPEN SQL.

Regards,

Atish

Re: Operation in Select Statement

Former Member — Thu, 28 Feb 2008 11:47:07 GMT

I am not sure whether on a SELECT statement operations like subtraction, division or multiplication on DB columns can be performed.

You may have to select the columns into an internal table and then loop thru the internal table to perform the necessary division or multiplication operations.

Hope this helps.

Thanks,

Balaji

Re: Operation in Select Statement

Former Member — Thu, 28 Feb 2008 11:47:10 GMT

Hi,

There are some aggregate functions which can be used for columns in the database.

Those are: SUM, MAX, MIN, AVG and COUNT.

This above functions can be used accorddingly in the select queries like:

select vbeln posnr sum (netwr)

into gi_vbap

from vbap

where vbeln = ............

There is no operations fpor mulitply/divide.

Hope this helps.

Regards,

JLN

Re: Operation in Select Statement

Former Member — Thu, 28 Feb 2008 11:48:31 GMT

Hi Anindita

Can you please explain in detail what exactly you want to do so that i can help better.

Regards

Lakshmikanth

Re: Operation in Select Statement

Pramanan — Thu, 28 Feb 2008 11:51:57 GMT

Hi kumar,

Use this sample code..

Loop at internaltable

compute internaltable-total = internaltable-value1 + internaltable-value2.

modify internaltable.

endloop.

Regards,

Ramanan

Re: Operation in Select Statement

Former Member — Thu, 28 Feb 2008 12:11:40 GMT

hi,

see the below link

i hope it will useful for u .

http://help.sap.com/saphelp_nw04/helpdata/en/62/10a423384746e8bf5f15ccdd36e8b1/content.htm

SELECT AVG(salary) FROM employees

SELECT COUNT(*) FROM employees

SELECT COUNT(DISTINCT employee_name) FROM employees

SELECT employee_name, salary + benefit

FROM employees

WHERE salary < 0.8 *

( SELECT MAX( salary ) FROM employees )

Arithmetic Expressions. For all employees that have a salary not exceeding 80% of the salary of the maximum salary of all employees, this query returns the name of the employee and the sum of its salary and its benefit.

reward if its useful

Edited by: p541399 on Feb 28, 2008 5:49 PM

Re: Operation in Select Statement

Former Member — Thu, 28 Feb 2008 12:12:54 GMT

Hi,

Try doing ur operations outside select. Store it in a variable and use it in select. This will enhance ur performance.

Regards,

Ramya