Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
TammyPowlas
Active Contributor
11,178
I sort of "stumbled" into this feature of using Analysis Office with S/4HANA on premise (in this case, 1909).  I think it is a great feature, especially for finance users

Start by using transaction RAAOE inside S/4HANA, "Launch Analysis Workbook"



I selected the Asset History Sheet query



At the selection screen, most of the prompt values are already populated.



This is what is returned by default



Turn on pause refresh to save trips to and from the S/4HANA server



Move account determination to the background filter



Move asset number to rows


Click the Pause/Refresh from the ribbon again to refresh the query


 


Result is the asset history sheet in Excel by asset; a possible audit schedule.



For fun, search on "asset" as shown above and review the results


So what is is nice is these queries are all "out of the box".  You just need Analysis Office and authorizations of course.

 

What do you think?

12 Comments
Labels in this area