cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member198905
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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?
former_member198905
Participant
0 Kudos

Hi

Here is the difference b/w TCode & DS

139,067   1,395,501.49    MB51    dn01
216   2,960.38          MB51    tn02
QTYVALUE             TCOD   PLNT

103,460   101,357.98      UM    dn01
48,504   1,496,413.71    BX    dn01
210   2,960.38          BX    tn02
661,014   6,057,029.93    BF    dn01
250   5,064.62          BF    tn02
QTYVALUE             DS    PLNT
Former Member
0 Kudos

Hi Imran,

you cannot compare the stock qty and value data source wise.

hope you know purpose of each data source

BX - stock initialization

BF- stok movements

UM- revaluations

again I am referring to my previous post, if you did the init of these three data sources in the same above as I mentioned , then just create a sample bex query on 0IC_C03, with store and calmonth/years in rows and stock qty and stock value --> this report should match with MB51/MC.1

also, please clarify, you are reconciling data right after you done the inti load ?

former_member198905
Participant
0 Kudos

Hi Jyothi

Please clarify following ambiguities more:

1) Please share the transformation mapping for all DS to Cube. I need to check it with mine

after loading BF info package, while executing DTP(if you are in 7.X) have you choose "extraction mode -->non cumulative " 

2) I have "extraction mode -->non cumulative "  in BX but you mentioned in BF?

3) In LBWE I use Unserialized V3 Update in update mode but someone said use Delta Queued (if you are in 7.X) so which one I use?

Waiting for your reply.

Former Member
0 Kudos

Hi,

you are right, non-cumulative option is available for BX DTP ( not for BF, sorry for the typo)

you can use either one of them Queued Delta/Unserialized V3 update. only thing you need to keep in mind is, when using unserialized , data should be updated to infocube.

Regarding transformations, if you migrate the flow as it it, then you shouldn't have any issue with data mismatch. have you done any changes to the standard mappings?

former_member198905
Participant
0 Kudos

Kindly share the transformation mapping for all DS to Cube. I don't know the person who is working on this project previously change the standard mapping or not that why I need it.

Former Member
0 Kudos

Hi Imran,

In my current assignment, we got no need to implement this . I am giving you inputs from past experience .

but i have a question for you, have you ran a query on cube to compare the stock value and stock qty against MB51/Mc.1? If you have done the intial data loading correctly during the non-business hours and compare the data, it should match. please confirm have you done these correctly?

in which environment are you working ? Dev/Qa/Prd ? if you are working in dev and not sure about mappings then you can always compare it with QA/PRD if your business already gone live.  alternatively, you can post your current mapping here to get more help. Thank you

former_member198905
Participant
0 Kudos

Hi Jyothi

I am working on Dev environment and Data loading in is progress.

One more think to clarify is when I check the TCode SMQ1 and LBWQ for MCEX03 entry but the entry I found is MCEX02 why?

Former Member
0 Kudos

Hi Imran,

SMQ1 is an outbound rfc queue which pushes to LBWQ and then to RSA7.

For unserialized v3 -->you can check SM13

for queued delta --> you can check LBWQ

if the V3 job for  MCEX03 (which pushes the data from SMQ1\LBWQ\SM13 to RSA7) sucessfully finished, then you there wont be any entries .

former_member198905
Participant
0 Kudos

Hi Jyothi

After successful load according to your steps here is the result:

MB51

Val Stock Val    Val Stock Qty      Plant

1,395,501.49    139,067 EA          DN01

2,960.38                 216 EA          TN02

MC.1

1,495,982.20     48,490 EA           DN01

2,672.88                205 EA           TN02

BEx

0                      48,504 EA           DN01

0                           210 EA          TN02

All of them giving different results so where is the problem?

I need the mapping also.

Former Member
0 Kudos

Imran,

MB51 and MC.1 are not matching, are there any postings happening in source when you are doing this activity? are you choosing the correct posting date range ? you should take the day where the inventory gone live until the day you did the inti in BW.

and the stock value is 0 ? are you sure you check the correct key figure 0VALSTCKVAL?

former_member198905
Participant
0 Kudos

Hi Jyothi

Is there any procedure, If I want to verify Stock Value & Stock Qty on ECC level?

There are no postings happening in source when we are doing this activity.

We are using Selection by materiel doc. instead of posting date range.

Former Member
0 Kudos

for MB51- use the posting date range for each store

ex: DN01 --> 01.01.2015 - 30.10.2015

here 01.01.2015 is the day your business went live with inventory, this date range is must in order to reconcile.

similarly for MC.1 --> month

ex: DN01 -->01.2015 - 10.2015

MB51 is per variant/article wise, you need to sum up all (GR and GI) to see the totals (you should not exclude any movement types when computing).

better choose MC.1 , this will just give the snapshot of current stock.

alternatively, you can check the MC.1 current stock (snapshot) with your functional team. they can help you to confirm the values.

later can dig into BW step by step.

former_member198905
Participant
0 Kudos

But how to compare with DS extraction i.e. RSA3 how I know that all DS extract correct values?

MC.1 values are near to BX values but not exact.

Former Member
0 Kudos

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.

Answers (2)

Answers (2)

former_member223861
Participant
0 Kudos

Hi Imran,

Reconcile with MB52 t code. Check with MB5B Also.

Regards,

Naveen

former_member198905
Participant
0 Kudos

Hi Naveen

MB52 and MB5B also show different values.

former_member223861
Participant
0 Kudos

Ideally it should Match with MB5B. As Postings are going on ECC it may Not reconcile with ECC  and BI as on date. check for Previous Month. it would get reconcile. If it was not reconciling Definitely you are missing Some thing.

former_member198905
Participant
0 Kudos

Hi Naveen

Can you shared the mapping?

Former Member