Group Rerporting - Report of status information of data monitor incl. time stamp and user

[dmitrij_rempel]

Hello Community,

We have got a requirement to display in the report the list of consolidation units with the status of specific tasks from data monitor and the timestamp and name of the user, who achieved the status.

The goal is to have the overview for all cons. units of the group with the information if the tasks A, B and C are locked, when these are locked and by which user.

1. Is there any possibility to create a custom analytical querry for this purpose in Group Reporting?

If yes, what is the technical name of the cube we can use for the querry?

2. Is it possible to display such values in the AfO reports with formula like “SAPGetData”?

If yes, is there any link to the page with overview of such formulas?

3. What is the name of the table name, where this information is stored (to list it with SE16 over SAP GUI)?

Thank you very much in advance.

Kind regards,

Dmitrij

[MartinJul · Accepted solution]

Hi Dmitrij,

I have done this through API.

There is an API that has the information you need:

https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/44ec04bc8de24103b400d261fde99462/2a72362a8a994dfaa6f...

I have used this to connect to Workiva and make a dashboard that are in the direction you are looking at. You can properly add this as an source to Excel.

Br

Martin Jul

[dmitrij_rempel · Accepted solution]

Hello Martin,

thank you for the hint. We will check the possibility of the API.

As far as I understood you used the run task API just for getting the status information for Workvia. That might work for us if we can consume it in AFO.

Kind regards,

Dmitrij

[MartinJul · Accepted solution]

Hi,

If it don't work you can also look to create a view on table:

FINCS_LOG_HEADER

Together with:

FINCSTASKT

If you can join those and read the latest timestamp in a view you might have something.

I think this will give you the log that Arleigh Taylor mentions.

Br

Martin Jul