General Presentation
BW IM - Stocks application regroups all the reports that are based on the inventory data in SAP ERPs and more particularly:
- Inventory movements
- Stock situation
Stock vs. Inventory
| ||
| Products (in any form) sold to a customer | Definition | Value of a sum of finished products, work-in-progress products, and raw materials |
| Business | Context | Accounting |
| Market value (e.g. selling price to a customer) | Valuation | Cost incurred by the company (e.g. average costs, valuation methods - FIFO, LIFO, etc.) |
| Real-time (daily) | Frequency | End of financial reporting period (month/year) |
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. If you are interested in FI inventory values (Adjustments, Work in Progress, Transits) then check the Working Capital (WCAP) application.
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 are 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
Data update
Most data is updated several times per day based on the D4 loading schedule. With a few 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.
- 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
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