Connecting to SAP Business Information Warehouse

Use

The interface between Agency Business and the SAP Business Information Warehouse (SAP BW) enables you to use SAP BW technology to run statistical analyses of agency business data. This leads to an improvement in mass data handling and the performance of your system when updating data.

Prerequisites

Before implementation, it is important that you install the Plug-Ins detailed below and implement the SAP Notes detailed in the SAP Service Marketplace:

• To update actual data, Plug-In 2001.2 is a minimum requirement.
  SAP Note 448600 is a prerequisite for using Plug-In 2001.2.
• Before you can use Business Content in SAP BW, you require at least Plug-In 2002.1.
  Before you can use Plug-In 2002.1, it is essential that you implement SAP Note 507357 in your system.

You can active the extractors in Customizing for the Plug-In systems by selection Customizing for SAP Business Information Warehouse ® Settings for Application-Specific Data Sources ® Logistics ® Managing Extract Structures ® Logistics: Extract Structures in Customizing Cockpit.

Features

1. Updates

Three extractors are available for updating data in OLTP systems:

• Use extractor MC45W_0HDR if you want to update single settlement requests and vendor billing documents at header level.
• Use extractor MC45W_0LST if you also want to update the key figures for the remuneration list.
• If you want to update individual documents at item level, the system can determine all the important key figures using the subtotals in the calculation schema. These subtotals must first be created in the calculation schema. Extractor MC45W_0ITM must also be activated before you can run updates.

2. Business Content in the SAP Business Information Warehouse

Business Content is available for Agency Business as of SAP BW 3.0B and contains all the key figures for the document types vendor billing document and single settlement request. This means that data can be analyzed at header and item level for both document types.

Activities

If you decide to use the Business Content for Agency Business in SAP BW, the preconfigured objects (for example, InfoObjects, InfoCubes, Queries and Roles) can all be implemented relatively quickly.

For more information, see the SAP Library documentation for the SAP Business Information Warehouse under Business Content ® Industry Solutions ® Retail ® Agency Business.