Valuated stock problem in inventory.

[Former Member]

Hi all BI gurus ,

Iam working on Inventory module , I have loaded the data for it .

1. For 2lis_03_bx i.e initial stock we have data from 1999 to 2006 on R/3 side .

2. And we are loading the data from 2005 to 2006 for BW .

But The valuated stock report is not matching with the R/3 data (MB5..) .

Also for 2lis_03_bf

1. We have data from 1999 to 2006 on R/3 and when Iam loading from 1999

to 2006 datas are not matching .

I have followed all necessary steps i.e.

First 2lis_03_bx with marker update and then 2lis_03_bf and um with no marker update .

Can anybody please tell me where Iam wrong . I don't know much of the functionality of inventory .

Thanks.

[Former Member]

Hi Akash,

On which day have you done your initialisation of 2lis_03_bx . this will bring in your opening balance to BW. and then the movement data for historical stock movements can be brought into BW using BF. Or you can do vice a versa as wel.

But check is in RSA3 for validity. If your historical data is not matching as you have mentioned then just check wherther that has been archived in R/3 (since the range you have given is 1999-2006, i doubt whether you will have all data for this period on your R/3 database )

if it is archived then you will have to etract it from your archive files

Do assign points if it helps

Regards,

Wrushali

[Former Member]

hi

For cumulative key figures....you hve to check wht is the settings used for exception aggregation in infoobject tab for all the infoobjects you calculate

and you have to check the aggregatin level in the key figure properties in BEx query designer........

For some calculations....in the query property.....exception aggreagation will be before aggregation and for some after aggregationl.......

Assign points is useful

Regards

N Ganesh