on 10-28-2015 5:25 AM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
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.
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?
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
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 .
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.
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?
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.
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.
Hi Imran,
Reconcile with MB52 t code. Check with MB5B Also.
Regards,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Imran...
Non cumulative Key figure...
Check out this links plz.....
http://help.sap.com/saphelp_bw32/helpdata/en/80/1a62dee07211d2acb80000e829fbfe/frameset.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.