Skip to Content

Open SQL queries in SAP ABAP 7.4

Mar 08 at 10:24 AM


avatar image

Hi Experts,

I'm new to open SQL in ABAP HANA. We wish to get the entire data in a single select itself by using SQL queries. I have tried to get the total amount of a material for a particular movement type and subtract it with total amount of a different material for other movement type. I used SUM () and CASE to get the total amount for a movement type but i couldn't subtract both in the select statement.

Is it possible to do so in a select?

Note: It would be really helpful if any of you could share any blogs/documents which has complex SQL queries in ABAP HANA 7.4.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers