BW Scenario: Scheduling Agreements Analysis

This scenario enables you to analyze scheduling agreements from SAP R/3.

As this scenario is meant as example for scheduling agreements analysis, it  evaluates  forecast delivery schedules only. Neither JIT nor planning delivery schedules are evaluated. However, the scenario can easily be adapted  to evaluate JIT or planning delivery schedules.

Key Points

  • Creation of a table view and data source for scheduling agreements data in SAP R/3
  • Data modelling: Creation of transfer rules, update rules and ODS-Objects in SAP BW
  • Procedures for loading data

    Caution: As in R/3 data is stored only for the current forecast delivery schedule (per scheduling agreement) it must be ensured that data is loaded into BW before a new forecast delivery schedule is inserted into the database. Otherwise the data is lost.

  • Creation of queries for evaluation forecast delivery schedule:

    Display of forecast delivery schedule quantities by the following characteristics: Material, customer (sold-to party), scheduling agreement (order number), schedule line date and delivery schedule date

    Display of forecast delivery schedule quantities according to scheduling horizon by scheduling agreement number and delivery schedule date

 

Scenario Documentation
Scenario Overview
Business Process Procedure


Scenario Installation
Scenario Installation Guide
Building Blocks
I00: Essential Information for SAP Best Practices BI
B84: BW Connectivity
B03: General Settings BW Integration