Skip to Content

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

union all data for different years in IDT

Hi All

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

MonthLastYearThisYear
January57
February25
March68

The SQL code works well in MS SQL Management Studio, but not on SAP IDT.

Your help will be highly appreciated.

Kind Regards

Marvin Butji

Former Member

Helpful Answer

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