Report Navigation in C4C – Example
This blog shows a simple example how report navigation works and the configuration.
1. Short description of use case
2. Example
3. Configuration for this example
1. Short description of use case
In this example we have 2 reports.
1 report with 1 view
1 report with 2 views
We navigate from one report to the other and pass the parameter ‘sales unit’
Then we navigate within the second report to another view and pass the parameter ‘month’
2. Example
In this report we see the opportunity pipeline summed up on Sales unit level. From here you can drill down to the next level ‘by month’ for a selected sales unit
The parameter ‚sales unit‘ is passed based on your selection bevore and the result shows the details for this sales unit by month
The next level are the single opportunities for a certain month within this sales unit
Again the parameters are passed and you see the results – in this example the drill down shows all previous selections in the result list as columns…
But you can also hide these columns- which will lead to a better performance if you have large size reports with many columns & lines in the result list
3. Configuration for this example
Create two reports – 2nd report has 2 views defined
Mark the report you want to navigate to and define a new report navigation- here we want to navigate from the 1st to the second report in the list.
Choose the view you want to navigate to and maintain a meaningfull description.
Choose the source report – system will also inform you about mandatory fields you have to consider in the next steps.
Do the field mapping. I want the parameters to be passed into the selection fields of the target report- so I maintain the mapping in the 2nd section ‘variables’
In this example the sales unit is a characteristic & variable so I can fill either column 1 or 2- the currency fields are only variables so I have to maintain them in column 2. Since they are mandatory I have to maintain them. In this case I pass the actual variables – in the next case below I derive the default of the report.
Once the data is saved you will see your navigation target for the source report
next step in our example- configure navigation from one view to another of the same report.
Again mark the report that has the views defined you want to navigate to and create a new navigation target.
choose the view you want to navigate to and maintain a meaningful description
Choose same report as source report
Do the mapping.- in this case I want to take over the sales unit & the Month from my previous selections. The currency fields will be derived from the report configuration default itself
As a result you see the assigned navigation target for your report
Is it possible to navigate to a particular object from a Report? For example go to the particular opportunity?
Hi Julija Skapova, yes that's possible as in the standard SAP report it is pre-delivered.
If you use the standard data sources and click on a specific cell in the report table that identifies the e.g. opportunity exactely - there is out of the box a navigation to the business object. If you use custom data sources, make sure that the UUID for the respective business object is available...
Regards, Deborah
Hi Deborah,
In our business case, we need to show all the activities for the account, so built a report on "ALL Activities " data source.
So, in this report we are using Activity type and Activity name. As per standard navigation to Object is available only from specific object ex: I need to select the Appointment as the column then from Appointment name the navigation is available, But not from the Activity name column.
In our report if we enable appointment, then for the activity if type Task, it is showing as # for the column Appointment (standard behavior).
Please suggest if I am missing some thing to get the navigation from Activity Name column in the Report.
Thank you in advance...!
Best Regards,
Vignesh Karuppasamy
Hi Vignesh Karuppasamy
I think thats Standard behaviour your describe. You need to click on a certain cell so that the system knows which specific activity should be opened.
If you click on the whole column, it's not defined which activity should be opened.
All navigations I created til now are working when clicking on a cell - not the column ( I don't get the navigation targets display after clicking on a column).
If you want to accumulate certain activities you can e.g. add another characteristic like actitiy type and create a report navigation for this for example.
Best regards, Deborah