In R/3 we have the report MC.9 where if your give a range of period like 01.2011 to 09.2011, the report can be seen as the trend of stock status i.e., the stock status month after month.
Currently we planned to build the same report in BI and during our exploration, we could not identify the exact data source which would help us meet our requirement. We identified the data source 2LIS_03_S198 and checked whether this could be used but we were not able to use it because the data flow is in date wise and moreover when the data is updated, the current stock is populated for previous dates also.
We raised this to SAP and found that the support for data sources 2LIS_ S* had been withdrawn because they are no more falling in the support portfolio.
We could not use our 2LIS_03_BF , BX as the volume of data is very high and report execution consumes very high time.
We plan to move only the month wise stock qty and value with the material group, valuation class, valuation type as a single entry to quicken the report output so that in Visual composer the report display will be fast.
Experts kindly help in providing details of which BI data source will help me in this regard or can a generic data source can be built ,which R/3 tables can be used to build generic data source.
Your help and guidance will be of very great help.