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

How validate Total Stock ?

hi guys ....i´ve used the 2LIS_03_BF BX for calculate stocks in BW i've made an initialization and load historically material movements and activate the delta ...but i have a problem..i review my querys and the "in" stock movement and "out" stock movement are OK but the Total Stock Value are not OK i run the reports MMBE MB5B in R3 in order to validate the values but the Total Stock Value is not the same....

There`s any specific report in R3 for view that information ...........or maybe there another key figure for Total Stock ....i follow the "How to" pdf for inventory management and i have made complete loads....but i cant validate that value

Regards

Message was edited by: Oscar Diaz

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2006 at 07:03 AM

    Hi,

    Have you compressed BX init request with Marker updae?

    Have you compressed BF init request with out Marker updae?

    Have you compressed UM init request with out Marker updae?

    Have you compressed BF Delta load(if any) request with Marker updae?

    Have you compressed UM Delta load(if any) request with Marker updae?

    and also Restrict the Valuated Stock Kf with Stock category = # in BW side .

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2006 at 07:10 AM

    Thanks for your answer

    I have compressed BX init request with Marker update

    I have compressed BF init request(init delta with records) without Marker update

    I have not load UM but it only affects valuated stocks values and not quantities and i not used values ...noly quantities

    I load Deltas for BF but i have not compressed them yet,i supossed that not compressed deltas works the same that compressed ones

    I only want to see the stock value for a plant-material in a specific warehouse in a specific date.

    Message was edited by: Oscar Diaz

    Message was edited by: Oscar Diaz

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2006 at 07:23 AM

    Im not sure about the key figure to see the total stock quantity....i use 0TOTALSTCK

    Quantity Total Stock

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2006 at 08:29 AM

    Ok, the 0TOTALSTOCK value is the total number of peices of both valuated stock and non-valuated stock.

    For instance, if you run (in R/3) MB5L for the plant/valuation area/material in question, for either the current period, ending last period, or end of previous year, you get some values, of valuated stock.

    If you look in MMBE, you may see valuated and non-valuated stock, that is what your TOTALSTOCK should agree with.

    Compare this with BIW...are they the same for the same period? If so, the quantities almost have to be correct. But for TOTALSTOCK, it is a bit different, TOTALSTOCK includes all VALUATED STOCK, but with the addition of items that you don't valuate, maybe containers, project stock or other types of stock.

    First I would validate your valuated stock. Let me know how that number looks. If it is correct, you may want to search OSS, I remember some notes about the 0TOTALSTOCK value and how you may have to change (update rules) according to some specific requirements.

    Also, remember, you want to exclude Comsumption values (in the update rules you should be deleting these, unless you created KF's to keep these figures!).

    Cheers!

    /smw

    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.