Understanding Inventory Cube for SAP BW 7.3 on HANA

Author: 
Tengran Liu

INTRODUCTION:

As we all know it is difficult to work with Inventory Management in SAP BI. We need to take a lot care while extracting data from ECC to BI system.This blog will explain all the extractors and workflows in inventory for BW 7.3 on HANA.

First of all, we need to get familiar with our performers:

2LIS_03_BX --> This structure is used to extract the stock data from MM Inventory Management for initialization to a BW system.

2LIS_03_BF --> This structure is used to extract the material movement data from MM Inventory Management (MM-IM) consistently to a BW system

2LIS_03_UM --> This structure is used to extract the revaluation data from MM Inventory Management (MM-IM) consistently to a BW system. Contains only value changes, no quantity changes.

Before you can extract data for revaluations to a Business Warehouse system, you must ensure that the transaction/event key is active.
For this, see the following SAP Notes:
353042: How To: Activate transaction key (PROCESSKEY)
315880: Missing event control after PI-A installation

Usage of BX datasource depends on business requirement for SAP Bw on HANA

Want to find out more details? Please, just click the button below.

Visitors who read this blog also read these two blogs for further information

    http://www.ameri100.com/blog/big-data-what-it-and-how-does-it-apply-your...

    ATCG Solutions specializes in consolidation of data from social media, enterprise databases and other rudimentary databases and apply business logic.

    SMAC(Social, Mobile, Analytics and Cloud) + Enterprise Data

    Consolidate + Analyze = Decision Driver

    Want to learn more about the world of Big Data and Social media. One very common use is to extract Twitter data into a Big Data solution such as Hadoop. You can learn how simple this really is in our eBook, "Learn How To Stream Twitter Data Into Hadoop" by clicking the button below.