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

Inventory Management: Valuated Stock Value

Hello Experts -

We're using inventory management. We're just bringing in 2lis_03_bf which is the material movements and the standard price datasource.

The plant valuated stock quantity and the valuated stock value are fine. The SLOC valuated stock quantity is fine. We're using the non-cumulative key figures for the valuated stock quantity and the valuated stock value. The SLOC valuated stock value isn't correct. So I just created a calculated key figure where I'm multiplying the quantity with the standard price.

This works fine but when I look at the plant level and use this CKF, the aggregation threw me off. So I changed the aggregation on CKF at the Bex level.

This works fine in dev and qa where I don't have too much of data. But as soon as I'm in in production, the query times out and gives me an error saying I reached the buffer limit.

I was thinking of calculating the valuated stock value at the ETL layer but now I'm thinking that if I do that and the price of a material changes, I'll again have the same problem. I can't re-load every time a material price changes.

Can someone please help me with this scenario?

Thanks!

Edited by: Siegfried Szameitat on Oct 29, 2008 9:30 AM

do not offer points, it is against the rules

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2008 at 02:25 PM

    Hi Syed,

    Deriving values by multipling with price also not correct. results will not match with R/3.

    Value Calculation

    In principle, values are updated with Plant, Material, and Stock Category only. Quantities are updated with these characteristics, as well as with Storage Location, Batch Number, and Stock Characteristic

    Check SAP Note 589024: Evaluations in BW with the Characteristics Storage Location and Stck Char.).

    Hope it Helps

    Srini

    Edited by: Siegfried Szameitat on Oct 28, 2008 4:17 PM

    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.