Skip to end of metadata
Go to start of metadata

BW Scenario: Purchasing Analysis

This scenario enables you to analyze purchasing data from SAP R/3.

Info Cubes

  • Purchasing Data (technical name*: 0PUR _C01*)
  • Vendor Evaluation (technical name: 0PUR_C02)
  • Purchasing Groups (technical name: 0PUR_C04)
  • Analysis of material groups,   vendors, and materials. This data enables you to find answers to the following questions, for example:
     - Which materials and how much of each material have been ordered from a certain vendor?
     - How many PO items are there for a certain material group?
  • Display of scores from the vendor evaluation facility within Purchasing. On the basis of this data, you can compare your vendors with each other and also check whether a certain vendor delivers a material punctually and in the desired quantity for example. Since the scores from the previous period are available in addition to the current score, you can also check whether your vendors' performance is improving or deteriorating.
  • Analysis of the purchasing activities of your purchasing (buyer) groups. Data on effective order values, invoiced amounts, and number of deliveries is available to you for this purpose. Furthermore, you can obtain an overview of how many documents, document items, and (if applicable) document schedule lines have been created by the purchasing group

Building Block: Essential Information for SAP Best Practices for BI

The document Essential Information for SAP Best Practices for BI  is intended for SAP Channel Partners, consultants and system administrators who are involved in an SAP Best Practices for BI installation. The information in this document enables you to use the documentation delivered with SAP Best Practices for BI. This document describes installation activities that you need to conduct to successfully install SAP Best Practices for BI. To ensure a successful installation and to prevent possible mistakes, read Essential Information for SAP Best Practices for BI before you start with any installation activities.

Content List

The main sections of this document:

  • Introduce the concept of SAP Best Practices for BI installations and provide an overview of the building block approach and a general idea of the installation process using building blocks
  • Show you how to use the documentation delivered with SAP Best Practices for BI
  • Highlight which SAP Notes you need to install. The activities described in this section are a prerequisite of any installation procedure.
  • Provide explanations and support for the most common errors and mistakes that can occur during the installation

Key Points

  • Offers a good base for anyone who wants to start an SAP Best Practices for BI installation
  • Provides a comprehensible pragmatic introduction to the building block concept
  • Includes detailed instructions on how to work with SAP Best Practices for BI

Building Block: BW Connectivity

Connectivity refers to the interface, transfer of data, and configuration settings between the SAP BW system and the source systems. This building block describes the activities that are necessary to connect the source systems to SAP BW. This building block is the prerequisite for the installation of all SAP BW business scenarios delivered by SAP Best Practices.

Function List

This building block contains the following activities for the connection of the different components:

  • Local Settings
    This section describes all local settings that are necessary for components such as SAP R/3, SAP SCM, SAP BW, or SAP CRM.
  • Cross Connectivity
    This section describes all settings that are necessary to connect the components of the system landscape with each other. The settings for each combination of two components to be connected are described in a separate structure node. Separate structure nodes make it possible to identify the required activities needed to connect certain components with each other. The structure nodes for components that are not part of the installation can be skipped

Key Points

  • This building block contains all settings that are necessary to connect all the relevant source systems with SAP BW.
  • If only some source systems are relevant for the installation, the building block activities can be reduced without any effect on other source systems.
  • An installation role for each component is provided to access all transactions relevant for the installation.

Building Block: Basic Configuration - Purchasing Analytics

This building block contains the basic configuration settings required for this scenario. The steps described in the configuration guide are essential for the successful installation of this scenario and need to be carried out completely before you proceed with the installation of further Building Blocks.

Function List

The following functions are provided:

  • Source System Configuration
  • Activation of Business Content Data Sources
  • Replication of Data Sources
  • Loading Master Data

Building Block: Purchasing Group

The Building Block Purchasing Group contains the configuration that is required if you want to use the Info Cube Purchasing Group (Technical Name: 0PUR_C04) for reporting.

Function List

The following functions are provided:

  • Source system configuration
  • Installation of Business Content
  • Data upload

Key Points

  • With the data from the Info Cube Purchasing Group, you can analyze the purchasing activities of your purchasing (buyer) groups.
  • Data on effective order values, invoiced amounts, and number of deliveries is available to you for this purpose.
  • Furthermore, you can obtain an overview of how many documents, document items, and (if applicable) document schedule lines have been created by the purchasing group

Building Block: Purchasing Data

The Building Block Purchasing Data contains the configuration that is required if you want to use the Info Cube Purchasing Data (Technical Name: 0PUR_C01) for reporting

Function List

The following functions are provided:

  • Source system configuration
  • Installation of Business Content
  • Data upload

Key Points

With the data of the Info Cube Purchasing Data you can carry out analyses of material groups, vendors, and materials. This data enables you to find answers to the following questions, for example:

  • Which materials and how much of each have been ordered from a certain vendor?
  • How many PO items are there for a certain material group?

Building Block: Vendor Evaluation

The Building Block Vendor Evaluation contains the configuration that is required if you want to use the Info Cube Vendor Evaluation (Technical Name: 0PUR_C02) for reporting.

Function List

The following functions are provided:

  • Source system configuration
  • Installation of Business Content
  • Data upload

Key Points

  • With the Info Cube Vendor Evaluation, you can display the scores from the vendor evaluation facility within Purchasing.
  • On the basis of this data, you can compare your vendors with each other and also check whether a certain vendor delivers a material punctually and in the desired quantity for example.
  • Since the scores from the previous period are available in addition to the current score, you can also check whether your vendors' performance is improving or deteriorating.

BW Scenario: Inventory Analysis

This scenario enables you to analyze stock data from SAP R/3 and to evaluate materials for which no movement has occurred.

Info Cubes

  • Material Movements (technical name 0IC_C03)
  • Slow-Moving Items (technical name 0IC_MC01)

Key Points

  • Stock overview
  • Valuated Stock Analysis
  • Blocked Stock Analysis
  • Slow Moving items Analysis

Building Block: Material Movements

The Material Movements building block contains the configuration that is required if you want to use the InfoCube Material Movements (technical name: 0IC_C03) for reporting.

Function List

The following functions are provided:

  • Source system configuration
  • Installation of  Business Content
  • Data upload

Key Points

This InfoCube enables you to view information about Stock data from R/3 such as

  • Stock overview
  • Blocked stock
  • Valuated stock

Building Block: Slow-Moving Items

This scenario enables you to analyze stock data from SAP R/3 and to evaluate materials for which no movement has occured.

InfoCubes

  • Material Movements (technical name 0IC_C03)
  • Slow-Moving Items (technical name 0IC_MC01)

Key Points

  • Stock overview
  • Valuated Stock Analysis
  • Blocked Stock Analysis
  • Slow Moving items Analysis

Technical name: 2LIS_03_BF

Use

This structure is used to extract the material movement data from MM Inventory Management (MM-IM) consistently to a BW system.

Features of Extractor

A data record belonging to extractor 2LIS_03_BF is defined in a unique way using the key fields Material Document Number (MBLNR), Material Document Year (MJAHR), Item in Material Document (ZEILE), and Unique Identification of Document Line (BWCOUNTER). Technical name: 2LIS_03_UM

Use

This structure is used to extract the revaluation data from MM Inventory Management (MM-IM) consistently to a BW system.

Delta Update

A Delta update is supported. Delta procedure: ABR - Complete Delta with deletion flag using Delta queue (RemoteCube compatible). Stock Initialization for Inventory Management 
Technical name: 2LIS_03_BX

Use

This structure is used to extract the stock data from MM Inventory Management for initialization to a BW system.

  1. This content was originally posted by krish in the SAP DemoContent section of this wiki.