Skip to Content

Stock Value Wrong

Hello All,

I have a problem concerning stock (quantity and values).

In our Source System, one material is displayed by quantity and value (transaction MM03 or CKM3), both are correct.

When we're consulting this same material through a query, the quantity and value are wrong. For same cases the quantity is correct.

Please, take a look (the quantity is correct, but the stock value doesn't):

Another important detail is that the movement type "Output" (negative/red) is recorded in the values, but the movement type "Entry" (positive/blue) doesn't:

Here's the technical fields/names in SAP for each one in the way that refers to the query:

Quantity = AABCK0074

Value = AABCK0075

Plant/Center = 0PLANT

Storage Location = 0STOR_LOC

Someone could help?

Thanks in advance,

Flávio

pastedImage_0.png (332.5 kB)
pastedImage_1.png (11.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2014 at 04:25 PM

    Hi,

    Assuming you are using standard flow:

    Are below steps executed in your system:

    1) Initialization of Stock through 2LIS_03_BX & compression with Marker update

    2) Historical load of movements with 2LIS_03_BF / UM & compression without market update

    3) Daily delta of 2LIS_03_BF/UM & (compression with marker update) --> Optional

    If yes, then can you check if some deltas were missed. I would suggest doing a repair full load for one of the example to confirm the same.

    Regards,

    Viraj Dhopavkar.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello,

      Yes, we use this standard structure, but with some particularities:

      There's a MultiCube: "X"

      MultiCube "X" has three InfoCubes: "A", "B", "C":

      - "A" works with 2 InfoSources: (Goods in transit - inbound / Goods in transit - outbound) and 1 DSO (Goods in transit);

      - "B" works with 3 transfer rules:

      2LIS_03_BX (InfoSource: Material Stockw)

      2LIS_03_UM (InfoSource: Revaluations)

      2LIS_03_BF (InfoSource: Material movements)

      - "C" works with 2 transfer rules:

      2LIS_03_UM (InfoSource: Revaluations)

      2LIS_03_BF (InfoSource: Material movements)

      No deltas missing.

      I'll keep you updated.

      Thanks,

  • Posted on Dec 05, 2014 at 02:12 PM

    Hi,

    pelase check the MB51 report with bex query results.

    quantity should be match with the issue total stock with - values and receipt total stock with + vauels

    amount in LC match with the issued value with - vaues and receipt values +values .

    Thanks,

    Phani.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2014 at 10:24 AM

    Is your market update set up correctly?

    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.