Problem with inventory

[Former Member]

Hi Gurus,

We have loaded data into inventory cube with the following process:

In R/3 Initialized the stock Plantwise for 2LIS_03_BX and the same has been loaded into the infocube and compressed with NO marker update Chek box unchecked.

Next Initialised BF based on Posting Date from 28th feb to 14th nov 2006 and loaded the data into BW and again compressed with NO marker update Chek box checked.

Performed the above process too for UM.All the data got loaded successfully.

The stocks are matching with R/3 in MB5B.

My problem is, I am running a standard report "Stock Overview" where the report is coming calyear monthwise.The report is showing only November month because I have uploaded in the month of November.If I drill down by 0Calday it is showing the date on which I have Uploaded the data which in my case is today.

Ideally it should match with R/3 posting date which is not happening.In update rules 0calday is mapped to Posting date.

Please suggest me how to get the 0calyear/month or 0calday matching the posting date(BUDAT) in R/3.

Please respond immediately because the enduser needs the report.

Promise to assign points.

Thanks in advance

Regards,

Venkat

[Former Member]

Hi there just for reference another good R3 transaction for stocks is MB51, not sure if it will make a differenc but have you mapped a fiscal year variant indicator

[Former Member]

Hi Niten,

Fiscalyear variant is mapped.

Regards,

Venkat

[Former Member]

Have you tried the formula option DATE_FISCPER?

Sorry this is for the Fiscal Period from the date

Message was edited by:

Niten Shah

[Former Member]

Hi There,

I do not see the problem that you are having, I have checked the standard cube does map BUDAT to the InfoObject 0PSTNG_DATE and BUDAT is defined as "Posting date in the document" in R3, I am not clear on what the problem is have you reconciled say with an entry in MSEG just to check the values as well

BUDAT coming from MKPF or BKPF depending on extractor

Message was edited by:

Niten Shah