SAP BLOG Exploring Analysis Office with S/4HANA Out of the Box Queries

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,367
Tepki puanı
7
Puanları
6
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”

1raaoe.png


I selected the Asset History Sheet query

2raaoeprompts.png


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

3datareturnedfromdev.png


This is what is returned by default

4pauserefresh.png


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

5dragaccountdetermtobg.png


Move account determination to the background filter

6moveasset.png


Move asset number to rows

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




7walkacross.png


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


8searchasset.png


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?

Okumaya devam et...
 
Üst