Open SQL queries in SAP ABAP 7.4

[former_member563509]

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.

[former_member563509]

Hi Experts,

Could any1 pls help me out?

Thanks in advance!

[Sandra_Rossi]

It looks like you are new to SQL too, no? So you need a SQL training first. Then, it's not a SAP topic. Or read the ABAP documentation, there are lots of simple and complex examples.

[matt]

Are you new SQL, or are you coming from an SQL background? If the former, this isn't really the place to get training - but if you search, you'll find some really useful blogs and documents, and even some tutorials to work through - not just on sap.com, but everywhere all over the net.

If the latter, I think you need to share what you've tried. Describing a query in general terms isn't specific enough.

[tom_wan]

Hello

Please be more specific so that we can help.