Skip to Content
Author's profile photo Former Member

Best Practice: Business Process Monitoring for Order to Cash

Further blogs

You can find an introduction to Business Process Monitoring in SAP Solution Manager in the SAP Business Process Monitoring within SAP Solution Manager of this blog. There, all further blogs dealing with various aspects of Business Process Monitoring are linked. The blog will be updated regularly. 

Business Process Monitoring for Order to Cash 

Business Process Monitoring (BPMon), as part of Solution Monitoring in SAP Solution Manager means the proactive and process oriented monitoring of the most important or critical business processes including the observation of all technical and business application specific functions that are required for a steady and stable flow of the business processes.

You can learn more on this topic overall in sessions at TechEd 2009 in Phoenix, Vienna and Bangalore. Please find some corresponding session abstracts at the end of this blog.

One of the most critical business processes in the SAP ERP environment is often a sales process (especially Order to Cash) which looks more or less like the process below.

 

 BP model for OTCBP model for OTC

 

The most typical sales process the Order to Cash starts with the creation of a Sales Order. This might happen directly via a dialog transaction within the SAP ERP system or via various replication interfaces (e.g EDI) where the original Sales Order was created in legacy systems or WEB-Shops or in a SAP CRM system. Within the Sales Order you find a required delivery date where the customer expects a delivery at the latest. It is of utmost importance that this required delivery date is met in order to achieve a high customer satisfaction. For meeting the required delivery date the goods should leave the warehouse at the planned Goods Issue date at the latest.

The subsequent document created is the Outbound Delivery, which is the basis for all Logistic Execution functionality (e.g. picking, packing, handling units). For ensuring a delivery on time the Goods Issue posting on this delivery document should take place on the planned Goods Issue date at the latest and definitely before the required delivery date is reached.

The next document to create within an Order to Cash process is the Sales Invoice or Billing Document which can be sent to the customer and lists the amount of money to pay for the goods or services delivered. In order to receive money from the customer it is hence very important to create a corresponding invoice after the Goods Issue posting at latest. If the process of invoice creation fails that could directly lead to lost revenue.

In a next step the invoice needs to be transferred to accounting so that a corresponding accounting document is created in FI that is needed to receive and settle the incoming payments. So once the payment is received the respective Accounts Receivable item would be cleared. If no corresponding accounting document has been created then it is hardly possible to track outstanding payments. 

Many of the activities mentioned above can also be executed as mass activities in background (e.g. delivery or invoice creation) and hence could be monitored by the job monitoring functionality from Business Process Monitoring. For more information you could have a look into the Best Practice document “Best Practice – Background Job Monitoring“.   

Within such an Order to Cash process there are of course many things that could be monitored and Business Process Monitoring provides many technical and business application specific monitors for this purpose which come out-of-the-box and can be adjusted to the customer needs, e.g. by entering data for sales organizations, shipping points and sales/delivery/billing types. Probably the most important key figures are the following:

  • # Sales Orders (GI date in the past but not delivered)
    Business Risk: This key figure represents real sales backlog where the expected delivery date was not met or will probably not meet as the goods did not leave the warehouse soon enough. The planned goods issue date lies already in the past but the schedule line item was not or only partially delivered. This is lost revenue and might lead to bad customer satisfaction.
  • # Overdue Outbound Deliveries
    Business Risk: This key figure represents the number of open and overdue outbound deliveries where the goods issue was not posted yet and the planned delivery data lies already in the past. This will lead to a delay in the delivery process and to bad customer satisfaction.
  • # Goods Delivered not Invoiced
    Business Risk: This key figure represents the number of open outbound deliveries where the goods issue was posted but the invoice was not created yet. This will lead to a delay for the incoming payment from the customer or might even lead to lost revenue.
  • # Invoices not transferred to Accounting
    Business Risk: This key figure represents the number of sales invoices which are not posted to FI. Therefore no open customer item in accounts receivable will be created which will lead to a delay in the incoming payment process.
  • # Overdue Customer Items FI-AR
    Business Risk: This key figure represents the number of outstanding customer payments, which were not yet settled in FI. This will result in delayed or even lost revenue.

There are of course also additional key figures that might be important for an Order to Cash scenario which are also shipped out-of-the-box, e.g. key figures where you can check the number of sales orders which contain a delivery block, billing block or credit block respectively. Besides these application key figures you could also monitor other things like interface processing or output message processing via table NAST, where you can check for erroneous output messages no matter if they are related to fax, print or IDoc generation. See also previous blogs about New Business Process Monitoring functionalities in SAP Solution Manager – ALE / IDoc Monitoring and New Business Process Monitoring functionalities in SAP Solution Manager – qRFC Monitoring. All monitoring data can be extracted to BI in order to perform some trend analysis. This was also described in a previous New Business Process Monitoring functionalities in SAP Solution Manager – BPMon Trend Analysis Reporting

We take the key figure # Goods Delivered not Invoiced as an example for showing what information the Business Process Monitoring provides and what drill-down capabilities are provided.  

First step in setting up monitoring for this key figure will be to model the Order to Cash process in the system. How to model business processes in SAP Solution Manager is out of the scope here. Having modeled the business process, you can assign key figures to every business process step. In this example, we select the business process Order to Cash, choose process step Post Goods Issue, select the Monitoring Type Application Monitor, then select the Monitoring Object Outbound Deliveries and finally select Key Figure # of Outbound Deliveries with GI posted but no invoice occurred from the list of available key figures. 

Monitoring Object 

On the next level, “customizing” (i.e. select-options in order to identify the “right” documents) for the key figure has to be maintained, as well as threshold values which will later on define the rating of the alerts. 

Key Figure

Roughly spoken, this is all what needs to be done for setting up the monitoring. You can then use the monitoring in the operative part of the monitoring session.

As an entry point, the system provides a general overview of the status of all alerts assigned to your business process steps.  

Alert Overview

Navigating into the details of this process step, you will find a list with all recent alerts thrown for our key figure. In this case, 244 Outbound Deliveries were found where the GI was posted but no invoice was created. These Outbound Deliveries documents can be viewed directly in the monitored system using the Detail Info button.  

Alert Details

After clicking the button in the SAP Solution Manager system, you will be asked to log on to monitored backend system. Having done this, a list with all entries causing the alert will be displayed. So all transactional data remains in the backend system and is not transferred to the SAP Solution Manager.  

Document Numbers

If you like to see the details of a specific Outbound Delivery document, just click on it and you will be directly led to standard transaction VL03N (if your backend user has the appropriate authorization) where you can process the issue further.

 

VL03N

 

 

Corresponding session abstracts for TechEd 2009 in Phoenix, Vienna and Bangalore:

Business Process Analysis & Monitoring

During this session you will learn how Business Process Analysis & Monitoring within Enterprise Support helps to optimize the return on your investment in SAP ERP software, by identifying optimization potential for your core business processes. You will learn what kind of errors/problems could be identified by analyzing customer systems. The benefits of this service are the following and should all help lowering your Total Cost Of Ownership (TCO): 

  • Allows internal benchmarking of different organizational units, e.g. sales organizations or manufacturing plants
  • Learn in which organizational areas you

          – Could speed-up and streamline your most critical business processes

          – Could improve service levels

          – Might need to train your end-users to better follow intended procedures

          – Could improve your daily operations

You will also learn how the Business Process Analysis can be a good starting point for setting up Business Process Monitoring in SAP Solution Manager. 

Business Process Monitoring setup for a typical Order to Cash process

This hands-on workshop describes a use case for business process monitoring for a typical order to cash scenario. In this session you will use the SAP Solution Manager in order to set up the continuous alert & trend monitoring of important application specific key figures in SAP ERP. Typical examples are overdue sales orders, overdue deliveries, goods delivered not invoiced, incorrect billing print-outs. You will also learn about integrated reporting capabilities using the trend analysis SAP NetWeaver Business Warehouse dashboard.

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Firstly I should appriciate the way the process is been explained preety good.

      I have a requirement where i may need to add custom parameters(text watcher) for example delivery material, Qty or document Type, Plant etc then how to do it.

      kindly advice.

      Author's profile photo Volker von Gloeden
      Volker von Gloeden
      All key figures provide different Select-Options. Under
      https://service.sap.com/bpm --> Media Library --> Customer Information --> Business Process & Interface Monitoring Part 2.ppt

      you find a kind of catalog showing all available key figures with respective Select-Options. If you need something different, more customized you could utilize the Customer Exit framework.

      A Setup Guide for the Customer Exit can be found in the same Media Library under Technical Information.

      Regards
      Volker

      Author's profile photo Former Member
      Former Member
      Thanks Volker I have gone through that guide it completly states how create our own monitoring object, key figues and parameters it is excellent and exiting too.
      is it possible to copy the existing (Standard) data collectors into cusomer exit and add few parameters in it.(need to enhance existing monitoring objects)

      Regards,
      AL

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Yes, that's possible. Be aware that the number of parameters is restricted to 10 each on monitoring object level and on key figure level. So altogether you can define 20 parameters for a certain key figure.

      Regards,
      Johannes

      Author's profile photo Former Member
      Former Member
      Thanks Johannes,
      I will keep the limitation in mind.
      Can you tell me from where i can get those standard monitors. and how to copy them into a cusomer development.
      Author's profile photo Barry Jesse J.
      Barry Jesse J.
      Good post, clearly written and helps me to understand what SolMan can do with regard to process monitoring.

      However, I'm curious if there is a transaction-wise view of the process, showing where a given transaction flow is in the process.  For example, consider an eCommerce scenario where the web-store is on a non-SAP platform, R/3 is used for order management, and a non-SAP system is used for warehouse management.  At each step, R/3 and the web-store update each other with status and information (e.g. order from web-store into R/3, R/3 sending status to web-store, etc.). 

      From what I understand from this post, I could model this process and see counts of documents at given steps and have alerts based on certain parameters.  But what if I wish to start with a given web-store order number and get a graphical view of where that order is in the process (i.e. what is the current process step of that order, if there are any problems with that order, etc.). 

      Such a use would be common in any scenario which is high-volume (in this case, high order volume) and where multiple systems are involved making tracking the progress of an order across systems challenging for a given end-user.  

      Is this functionality provided through SolMan?  From this post and others that I have read, it seems not.  But this sort of functionality is provided through other, 3rd party, packages.

      Author's profile photo Volker von Gloeden
      Volker von Gloeden
      The answer is yes and no, but rather no. The main BPMon functionality is not tracking single documents as this task is far too performance intensive (especially for high-volume scenarios that you mention) and the added value is little. If you look at other tools that perform this kind of tracking it is often amazing to see that the analysis engine is larger than many SAP ERP systems of smaller or medium size SAP customers.

      The question is still why you want to track the single document. In most cases customers are asking for this because at some point of time the support organization gets the single request "Some document was not created, so please tell me where my document is" and then the search for the needle in the haystack begins.
      With our approach of providing crucial key figures for important watch points this question is obsolete. You get to see the complete entirety of documents causing problems. So if you work on this problematic documents in a timely manner then you won't get the support calls for missed documents any longer.
      The big advantage with our approach is that you can identify systematic errors as you see all problematic documents, so you can resolve the root cause of problems (e.g. customizing errors, process design gaps, process deviations from defined template) instead of just working on a single incident (one document lost).
      Basically every customer asking for document tracking before the Business Process Monitoring implemtation forgot about it after the BPMon implementation.

      The only valid reason to track documents would be cycle-times for efficiency analysis. For this reason we might provide some further document tracking capabilities with the help of the "Process Monitoring Infrastructure". This is already possible now but not really rolled-out yet. Nevertheless even if you find out that a process is faster in Germany than in the US or Japan you still need to find out what the reason is. And the reason is mostly given already by the key figures we already shipped.

      Best Regards
      Volker

      Author's profile photo Kevin Wilson
      Kevin Wilson
      Jesse,

      SAP provides a standard tool called SAP Event Management that tracks a business object through the process life cycle giving you and up to date status as it flows through the system. For more details see the SCN wiki at http://wiki.sdn.sap.com/wiki/display/SCM/SAP+Event+Management

      Author's profile photo Sudha Surendran
      Sudha Surendran
      Excellent explanation. Thanks for sharing
      Author's profile photo Sai Sridhar K
      Sai Sridhar K

      Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      Hi Johannes,

      Thank you for such a detailed blog. Really helps me understand the usage of the functionality better.

      However, one specific question - you have provided Business Risk for five KPIs. Did you write that description or is that available in some document. Currently, I am trying to activate KPIs but the document I have lists the 700+ KPIs. It would be very helpful in selecting which KPIs to select if there is a brief description available.

      Your help would be appreciated.

      Regards,

      -Anshul

      Author's profile photo Volker von Gloeden
      Volker von Gloeden

      Hi Anshul,

      no such document exists. You have more technical information in the "Key figure help" directly within the Setup environment.

      Further key figures with further business risks are only listed in the Service Report of a CQC Business Process Analysis service that can be order as part of an SAP Enterprise Support agrrement.

      Kind Regards

      Volker

      Author's profile photo Former Member
      Former Member

      Thank you for your response Volker. I will look into the Service you have pointed to.