union all data for different years in IDT
I am very new to SAP and I am struggling with using the UNION function in SAP IDT, I am trying to view data from different years using a UNION function but I am struggling in away to implement it correctly within IDT, but Its working fine in MS SQL server management studio.
Can you guys help me or point me in a way to be able to get it working correctly. I need the data to be displayed in one line, something like these:
comparing 2015 and 2016
The SQL code works well in MS SQL Management Studio, but not on SAP IDT.
Your help will be highly appreciated.