General Presentation
BW IM - Stocks application regroups all the reports that are based on the inventory data in SAP ERPs and more particularly:
- Inventory status
- Stock situation
Master data
Wide range of Material Master data is available in all reports.
Material-Plant combination is a basic reporting unit. Some figures provide detailed view on Batch level.
Selection by Company Code(s) and Calendar Year/Month(s) enables to access high amount of data in one report.
Transaction data
Both values and quantities of material (and its movements) are calculated for selected time period.
Historical data (previous years) is available for analysis.
All inventory figures are based on Material Movements.
Reports are used mainly by supply chain and controllers.
Access
Access to BW IM - Stocks application in the WBP Server is provided by Company Code. Users could be authorized to one, several or all company codes (depending their profile).
Reporting catalog is accessible via:
Sap Business Object Analysis → Select Data Source → WBP (Single Sign On) → Role → IM - Stock
Perimeter
BW IM Stock application reports USED TO BE DIVIDED into 2 separate categories with different reporting logic:
WP1 Application retrieving data of all companies maintained in Rhodia Core System
PF1 Application using company data in PF1 (Solvay-legacy) as a source
Since Q4 2020, a new BW model is available, merging both PF1 and WP1 into ONE SINGLE GLOBAL SOLUTION.
Data update
Most data is updated several times per day based on the D4 loading schedule. With following exceptions:
| Application | Data | Frequency |
|---|---|---|
| WP1 & PF1 | Material Prices (Moving Average Price / Standard Price) | Daily - Monday to Friday |
| WP1 | Material Prices for Physical Inventory | Yearly (January) |
| PF1 | "End of month status" reports | From 3rd to 7th working day of following month |
Reports (Queries/Workbooks)
Core queries are listed by Application and divided into sub-categories by their reporting purpose. Choose the respective source system for complete list of Core Queries.
*NEW* Global reporting Solution
- Stock Analysis
- SMOG Analysis
- Day-to-day tracking - stock indicators, material movements and inventory status point
- End of month status - valuated stock at the end of each accounting period
- Evolution follow-up - stock turnover and value development in selected time period
- Inventory tracking - current inventory status and identification of expiring materials
- Price evolution - material prices and their changes in between 2 periods
- Stock analysis - stock values and quantities by different selection criteria
- Stock movements - stock changes identified by material movement types
- Zone/GBU specific - miscellaneous, customized by request
Related topics
Working Capital (WCAP) application - Inventory values (Adjustments, Work in Progress, Transits) from finance perspective.
Inventory Visibility Tool - Aggregation and graphic presentation of inventory data from both (WP1, PF1) applications. This Dashboard uses BW Core Queries as its source. ***DECOMISSIONED IN NOVEMBER 2020***
Contacts
SAP Business Objects Analysis tool: Follow User Guide and in case of additional doubts, open a FreshDesk ticket
Access and authorization problems: open a FreshDesk ticket to IS Authorization Team
Report a problem/clarify an issue: open a FreshDesk ticket to IS Reporting Team
Questions on scope/functionalities/evolution:
Solvay Business Services
Digital & Information Technologies
IS Supply Chain M&S Data & Reporting Support