Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Multiply within Select Query

Hi,

I have a two tables, say ZTAB1 and ZTAB2. ZTAB1 has fields node1 and node2. ZTAB2 has fields node3.

By using simple select query we can fetch the data from the DB tables. But the complexity is that I want another field in second table say node4 and the value in it should be ( Node2 * 10 ).

I know that we can do it by looping the internal tables and performing arithmetic operations and modifying.

As the table ZTAB1 and ZTAB2 has a bulk amount of records, it would be a performance issue for the code I loop and modify. Can we achieve it within select query itself.

Like,

Select a~node1

          a~node2

           b~node3

          ( a~node2 * 10) as b~node4 into ITAB

          from ZTAB1 AS a

          INNER JOIN ZTAB2 AS b

          where <condition>.

Regards

Raghu

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question