BW Scenario: Cross-Functional Analysis: Financial and Sales Data

The scenario Cross-Functional Analysis: Financial and Sales Data describes all the necessary activities to built up a report that analyzes data from financial accounting and sales and distribution. With the detailed description easy enhancement of the report according to individual customer requierements is possible, for example: include more or other characteristics, other key figures, break down in other intervals, and so on.

Function List

The following functions are provided to support the Cross-Functional Analysis: Financial and Sales Data scenario:

  • Connecting SAP BW to SAP R/3
  • General settings for BW-Integration
  • Modelling of the data structure for cross-functional analysis SD-FI in BW
  • Building up a web report for analyzing financials and sales data

Key Points

  • Analyzing financials key figures
  • Drilling down key figures from sales to the level of the followig characteristics: Sales Organization, Distribution Channel, Division, Sold-to Party, Bill-to Party, Billing Document Number, Sales Group, Sales Employee, Sales District., Sales Office
  • Analyzing the structure of receivables
  • Revenue for the current year broken down by due date for net payment in intervals: already paid items, total balance of open items, already overdue items, intervals 16 - 30 days, 31 - 45 days, 46 - 60 days, 61 - 90 days, 91 -120 days, > 120 days
 

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
BS3: Basic Configuration - Sales Analytics
BS1: Basic Configuration - Financial Accounting Analytics
B34: Accounts Receivable Analysis