Skip to Content

Valuated stock value & Valuated stock quantity are not match with TCode MB51

When implemented inventory management we activate 3 datasources for it

(1) 2LIS_03_BF (2) 2LIS_03_BX (3) 2LIS_03_UM


In 2LIS_03_UM data source Valuated stock value and Valuated stock quantity are not match with MM TCode MB51 's Valuated stock value and Valuated stock quantity.

What I am missing please guide me.

Please also share the transformation mapping of all 3 datasources to 0IC_C03.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 28, 2015 at 05:50 AM

    Hi,

    Valuated stock value and Valuated stock quantity are non cumulative key figures, and you have compare these including BX, BF and UM with MB51.


    before that have you followed the below steps when loading the data?


    1. did you do the init data during the ECC  down time? does all users locked?
    2. after loading BX, have you compress the request with No marker update ->no tick
    3. after loading BF info package, while executing DTP(if you are in 7.X) have you choose "extraction mode -->non cumulative " ? and then compress the request with No marker update -->tick
    4. finally after loading UM, have you compress the request with No marker update -->tick
    5. if you did steps 1-4 correctly, then before releasing the system to users, did you comapare the BW report against MB51/MC.1?
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Imran Shafiq

      No, you can't compare Inventory data source wise.. the value stock and val qty are non-cumulative key figures, you dont see them in data source at all. these are available only in report.

      MC.1 is the current stock in source

      BX- just the stock intialization , BF- material movement

      when you do the compress of these two datasoruce request in cube (as I mentioned in first post), only then you can compare the BW values with MC.1

      for better understanding about inventory , please go through documents available on SCN. you will get a clear picture.

  • avatar image
    Former Member
    Oct 28, 2015 at 06:06 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 29, 2015 at 11:59 AM

    Hi Imran,

    Reconcile with MB52 t code. Check with MB5B Also.

    Regards,

    Naveen

    Add comment
    10|10000 characters needed characters exceeded