Previous post Next post
Currently Being Moderated


Duet Enterprise is a new product developed jointly by SAP & Microsoft to expose the SAP services/screens into Share Point 2010.

Duet Enterprise provides SSO functionality and out of box scenarios like: Workflow, Reporting, Starter Services etc. It enhances the end user expereince and provide a seemless interface. I will explain in this blog about the Reporting feature and how to schedule a report to run periodically from Share Point


Reporting is one of the Ready to Use capability which lets the end users schedule the back end system report from Share Point 2010. The report gets sent to the Duet SAP System, called as SCL system. Roles are checked in SCL system and then request is sent back to the backend system. The report is executed and the output is sent back to SCL system and then to Share Point in Excel format. Sounds easy and interesting for Ad-Hoc execution of reports, but ever wondered, how an end user can schedule a report to run periodically.

System Time Points

SYSTEM TIME POINTS is a feature provided to schedule a report periodically. Think of this as similar to scheduling a job from SM37 and choosing periodic. I will explain in this blog, the procedure to create, edit, use of system time points for Reporting scenario in Duet Enterprise. I will show how to make use of them from Share Point 2010. This blog assumes that Reporting scenario is already configured and working end to end in Duet Enterprise 1.0 environment.


Installed, Configured Duet enterprise for Reporting scenario. Sample reports or any other reports must be configured in the SCL system and able to execute them from SharePoint 2010

Backend system is ERP 6.0 EHP 4

SCL system is NW 7.02 with Duet Add-Ons Installed

SharePoint 2010 with Duet Enterprise Add-Ons Installed


Log in to backend system (ex: ERP) in working client and go to SM36

Schedule the Time Point Job with the following:

Job Name: TP_BROADCASTING_DAILY (Job name should be in format TP_BROADCASTING_XXXXX)

Job Step Name: /OSP/IW_TIMEPOINT_PROCESS (for ERP System)

Job Frequency: Choose your frequency. If the report needs to be executed every day, then choose daily.

Choose Periodic

Do not change the default values for Job class, Status, and Exec. Target


If Backend system is ERP, step should be:


If Backend system is BW, you need to add additional step RSRD_BROADCAST_FOR_TIMEPOINT:



We need to create additional time point jobs if we need to execute the Reports with different frequency in Share Point. Here we assume that we only need Reports to be executed daily; hence we have created only one job.

The job should at least run once successfully, to see the System Time Point in the SCL system.

In SCL system

Login to SCL system,

Tcode -> SIMGH

IMG Structure -> Service Consumption Layer Reporting Administration

Choose -> Manage System Time Points and Data Change Events

You should now see the system time point job.


Check the “Active” checkbox and the time point should be ready for use.


Status should be “Active” now.


In my system, I have created 4 time points that run every 15mins, Daily, Weekly, and Monthly.


Now go to “Manage reports and their properties”
Open the report for which you want to configure time points. Make sure “Based on Time Points” is checked.


Now in Share Point Duet Reporting Site, go to Report settings and edit the properties:


Select “Schedule Report” and click on Edit.


Now choose the Time point “Daily” that we created earlier


Save the report with a new name.


The report is saved as “ Inquiries List – Daily Run”


Now once the Time Point job is executed in backend (daily), the report output is seen in Share Point.


In this way, end user can use the system time points defined by Duet Administrator to schedule his jobs periodically.



Filter Blog

By date: