Inventory Management (SAP HANA-Optimized)
This documentation describes the SAP HANA-optimized Business Content objects that you can use to analyze data from SAP ERP Material Management component inventory management. The data model follows the requirements for the layered scalable architecture LSA++, which is optimized for BW running on SAP HANA.
For more information about general modelling patterns for SAP HANA-optimized Business Content, see SAP HANA-Optimized BI Content.
Prerequisites
See Prerequisites.
Features
The inventory management data is extracted from the ERP system to the Business Warehouse and made available there for further evaluation of different stock values, quantities and movements.
Possible analyzing scenarios are monitoring of current stock levels, analyzing inventory age and material range of coverage, and detecting stock obsolescence. You can run your analysis for different types of stocks, such as total or valuated stock, special stocks and consignment stock.
SAP delivers sample BEx queries on top of a CompositeProvider for the following areas:
Stock Overview
Material Range of Coverage
Obsolescence and Variance
Data Flow
More Information
In addition to this documentation, SAP offers you the following information.
Composite SAP Note Regarding ERP Inventory Management in SAP BW
Composite SAP Note 586163
contains information about the following topics:
Release Strategy
Information Sources
Extraction of Stock Data From ERP
Technical Information About Non-cumulative InfoCubes in SAP BW
Stock Analyses in SAP BW
Performance
Consulting SAP Note Regarding Interesting Facts about Inventory Cubes
SAP Note 1548125 contains information about the general handling of non-cumulative key figures in SAP BW with the following topics:
Definitions and Metadata
Process Flow with Example
Stock Initialization & DTP
Data Mart
Performance & Memory Consumption
Analysis of Problems
HANA Optimized Inventory Cubes and Advanced DataStore Objects
The SAP Note also references helpful SAP online documentation such as “Non-Cumulatives” and “Modeling Non-Cumulatives with Non-Cumulative Key Figures” and the following How To Papers:
“How to… Handle Inventory Management Scenarios in BW”
“First Guidance: SAP BW 7.40 / 7.50 powered by SAP HANA Inventory Handling and Non-Cumulative Key Figures”
Consulting SAP Note regarding Non-cumulative Data in SAP BW: Verifying and Correcting Data
SAP Note 745788 contains information about how to verify and correct data extracted from ERP Material Management component inventory management.
Possible Enhancement: Snapshot Scenario
The inventory scenarios delivered in Business Content are based on inventory key figures with associated movement key figures. A snapshot scenario can be advantageous, if there is a very high density of movements. Business Content does not contain such a scenario.
For more information, see the “How to…” document “How-to... Handle Inventory Management Scenarios in BW” mentioned above.
Possible Enhancement: Stock in Transit - Intercompany
The shipped stock reporting in BW does not offer the possibility to report on stock in transit that is created via purchase order / sales orders. To overcome this functional gap a separate extractor can be implemented to extract the intercompany stock in transit information.
For more information, search for “How to…” document “How-to... Report on Cross Company Stock in Transit”.
Further Possible Enhancements:
Depending on your specific requirements, the following SAP Notes might be useful to enhance the provided business content to suit your specific needs: