03-08-2018 10:24 AM
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.
03-19-2018 4:26 AM
03-19-2018 8:11 AM
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.
03-19-2018 8:49 AM
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.
03-21-2018 2:30 AM