Showing posts with label BI Inventory Management. Show all posts
Showing posts with label BI Inventory Management. Show all posts
Tuesday, 27 March 2012
Non-Cumulatives
Use
A non-cumulative is
a non-aggregating key figure on the level of one or more objects, which is
always displayed in relation to time. Examples of non-cumulatives include
headcount, account balance and material inventory.
How you model the
folder for non-cumulatives in the BI system depends on your scenario.
Depending on how often non-cumulatives change, and the total number of objects
for which you want to calculate non-cumulatives, you should choose one of the
following two options:
Non-Cumulative Management with Non-Cumulative Key Figures:
10 Important Points to Consider while working with Inventory Management
1. There are 3 SAP delivered transactional data sources for stock management.
2LIS_03_BX : Always needed to carry the initialization of the stocks.
2LIS_03_BF
: Initialize this in source if you need historical data else an empty
init can be done for this to load only future delta records. If the
Source system is new then no need to do an initialization.
2LIS_03_UM : Only needed if revaluations are carried out in Source. This data source is helpful if adjustment in material prices is done time to time otherwise it won’t extract any data.
2. Check list for source system. Needs to be carried out before initialization of the above 3 data sources .
Inventory Management - Marker Update, No Marker Update
Marker Update is used to reduce the time of fetching the non-cumulative key figures while reporting. It helps to easily get the values of previous stock quantities while reporting. The marker is a point in time which marks an opening stock balance. Data up to the marker is compressed.
The No Marker Update concept arises if the target InfoCube contains a non-cumulative key figure. For example, take the Material Movements InfoCube 0IC_C03 where stock quantity is a non-cumulative key figure. The process of loading the data into the cube involves in two steps:
Wednesday, 7 March 2012
Subscribe to:
Posts (Atom)