Reports have been developed in BW in order to provide KPIs to the GBUs in a user friendly manner.
If you wish to access them, you need to request access to the IS Applications support team (see Contacts in the Welcome page), and indicate the GBU(s) you want access to.
There are 2 reports currently: the first one focused on generation and the second one on SDS automatic distribution in SAP.
Refer to the dedicated training item (invalid link) for more explanations and screenshots.
Contents
SDS Generation
This report lists all the EHS documents with a released status: SDSs but also labels, transport documents, composition report and certificates.
The status of the product (obsolete or not) is also displayed, which is a good tool to check that we don't keep active documents for obsolete products.
The first tab is a dashboard that gives a summary and the second one provides the details of each document published: which language, created by whom and when. So it is also a good tool to check that there are no SDSs that were created more than 3 years ago.
Note that this KPI can be easily followed via the Qlikview dashboard (invalid link).See dedicated training item (invalid link) for all the details.
SDS Shipping
- This report will be useful for all the GBUs that are using the SDS automatic distribution in SAP. It is based on data coming from the "CVD1" transaction in SAP, which is the standard SAP transaction to monitor the SDS Distribution.
The CVD1 is not a very practical reporting tool because it does not allow searching by GBU. Moreover it is not very easy to export the results to excel.
That is why we decided to create a report in BW. It can be run by GBUs but also using criteria such as the sales organization, sales office etc. - This report lists all the orders that triggered a successful SDS sending or an error. In case of error, the reason is clearly explained: "SDS missing", "Technical error", "Occasional customer".
- Another advantage of having the report in BW is that we included directly some data from the order: especially the order number and customer information. It therefore becomes very easy to check how many SDSs were sent to a particular customer in a given period of time for example.
- For this report also there is a dashboard (overview page) in the first tab and then a tab for the detailed view, where each line corresponds to one sales order.
- Note that the status of the orders in BW is refreshed based on CVD1 only for the previous rolling year. So it means you should not run the report for a period greater than 1 year.