Skip to Content
author's profile photo Former Member
Former Member

Month on Month stock status report in SAP

Dear Friends,

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.

Regards,

M.M

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 26, 2011 at 07:21 AM

    Hi,

    you may use MBEWH table which stores monthly values of valuated stock.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2011 at 08:13 AM

    Dear shailesh patil,

    Thank you for your guidance. I already checked this table and could not use this because, this table gets updated only if the material movement takes place. For example there is stock for current month but no material movements takes place then the table will not have any entry so this did not suit us. Can you provide some other table details.

    We tried the following and could not use because of the reason mentioned.

    Table - Reason for not selecting this table.

    CKMLPP - Number of records very huge

    S031,S032 - System arrives at the previous month stock using the current months stock and reducing the issue and adding the receipts.

    Regards,

    M.M

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.