Use the SIS Data Warehouse for Management Reporting

  • by Mitresh Kundalia, Director — SAP Practice, Quality Systems & Software
  • November 15, 2002
Do you need custom ABAP programs to produce management reports that show sales bookings? You have an alternative in the Sales Information System data warehouse. By using it, not only will your management reports execute faster, but you'll have the ability to do exception reporting, too.

A common business requirement is to report monthly sales bookings for the organization. Sales bookings are one of the most important indicators to determine how you are doing. They are the yardstick most businesses use to monitor performance.

Although this information is predominantly related to the Sales and Distribution (SD) module, the finance department often drives this kind of request. As an FI person, you will want to know details such as how many orders are booked, the value of those orders, and the high-moving products.

Typically, most organizations write their own custom ABAP reports to gather this kind of bookings information. Developing custom ABAP programs is resource- consuming, and the programs often lack the functionality of exception reporting.

The Sales Information System (SIS) data warehouse may be a much better alternative for you. Part of the standard R/3 system, the SIS data warehouse provides a fast method for you to set up your own reports. One of the biggest advantages of SIS is that it stores data in a specific summarized form, providing rapid response time. Although not as robust, SIS has many of the same OLAP (online analytical processing) tools as SAP’s Business Information Warehouse (BW) application, including drill-down, drill-up, and slice-and-dice. Using SIS, you can gain in-depth knowledge of your company’s operations by exploiting data warehouse features in a standard R/3 system. This is especially important if your company is not yet ready for BW.

Mitresh Kundalia

Mitresh Kundalia heads the SAP practice at Quality Systems & Software (www.QSandS.com), a consulting firm specializing in SAP S/4HANA, SAP General Ledger, and complex System Landscape Optimization (SLO)-type reorganizations. Mitresh is widely acknowledged as a leading SAP expert, with multiple publications and an SAP-PRESS book to his credit. He has published more than 50 peer-reviewed articles and white papers, and he has given presentations at various SAP conferences and events. Mitresh is the chief solutions architect of General Ledger Migration Optimizer (GLMO), a leading product to accelerate and jump-start the SAP S/4HANA and SAP General Ledger initiatives; SAP Data Reorganization Optimizer (SDRO), an SLO-type product for managing complex system landscape reorganizations; and Group Currency Activation and Conversion (GCAC), a product suite to manage introduction of parallel currencies and conversion of data in a live SAP system.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.