Skip to Content
avatar image
Former Member

Using Inventory Management in BI

We are trying to make use of inventory data in BI. Weu2019ve installed business content for the cube 0IC_C03 and followed the steps in u2018How tou2026 Handle Inventory Management Scenarios in BWu2019 to get the data to the cube. The best I can understand I've loaded and compressed in the right order.

When we run a report it only seems to be reporting on the opening balance as defined in the 2LIS_03_BX load. It does not appear to be looking at the material movements as loaded in 2LIS_03_BF to calculate balances in the past. We installed from business content the Stock Overview report. Here is a sample of what Iu2019m seeing when drilled into a specific material that I know had inventory movements in 07 & 08 of 2008:

06/2008 1,002 EA

07/2008 1,002 EA

08/2008 1,002 EA

09/2008 1,002 EA

10/2008 1,002 EA

Anybody have any suggestions on what I need to look at? My understanding was that the query would used the material movements to calculate the balances for those months.

Thanks,

Chris

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 15, 2008 at 02:11 PM

    Hi,

    Check my thread..

    report-for-actual-gr-posted

    Thanks

    Reddy

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      If you followed the steps correctly you must get the correct values in BW report and it will match with MB5B in ECC.

      Do like this...

      If you have any opening stock problem, please run the report

      SAP_REFPOINT_COMPLETE and select Insert of Missing Records

      and then check the data in the cube.

      While checking data in MB5B, you need to give proper selections i.e. date and check valuated stock radio button.

      Note: check what are date ranges that are you are giving in BW report and in ECC

      Thanks

      Reddy

  • avatar image
    Former Member
    Oct 16, 2008 at 07:32 PM

    I think we found the issue. In thread [0icc03-data-mismatch-from-2lis03bf] Sayed referenced note 353042. I'm not getting the process key into BI. So my transformation rules are not loading the correct values. I'm pretty certain that this is the issue though I still can't make sence of the solution steps noted in 353042.

    Chris

    (FYI - Sayed if you repost that to this thread I'll reward you points.)

    Edited by: Chris Robertson on Oct 16, 2008 9:36 PM

    Add comment
    10|10000 characters needed characters exceeded