Skip to Content
avatar image
Former Member

How to fix "Negative inventory quantity issue in BW"

Sep 07, 2017 at 10:32 PM | 94 Views

Hello,

We are facing negative inventory quantity issue in BW production due to missing records (moments) for one posting period. In ECC MB5B Transaction for one material there are 2 movements (+90 and -90) but in BW +90 is missing and we got negative quantities.

The challenge what I am facing is:

If I do full load based on posting period, I don't have posting period available in selective deletion screen of cube

if I go with material document number, material document number is not available in cube.

Please provide steps to resolve this issues.

Thanks / Ram

BW (SAP Business Warehouse)
BW Data Staging (WHM) | BW Content and Extractors | bw 7.4
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Sushil Kumar Goel
    Sep 09, 2017 at 09:50 AM

    Hi Ram

    Could you please share the available selection fields of cube and infopackage of datasource.

    Probably, you can fetch data on basis of posting date

    Thanks

    Sushil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Frédéric Cincet
    Sep 08, 2017 at 03:10 PM

    Hello Ram,

    Why can't you just do a full load on the missing material documents ? You won't have any selective deletion to do at the cube level.

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded