Posting Date in PSA for 2LIS_03_BX

[manna_das]

Hi,

When I am executing 2LIS_03_BX for Stock Init, Posting Date in PSA is showing todays date. Why this is happening?

I run the IP on 9/12/2011, in PSA the posting dates are 9/12/2011 but in R/3 Side the dates are different.

Basically I want the old stock also. When I am loading this to 0IC_C03, opening stock is showing only for 9/12/2011 before that there is not stock in BW Dev.

How to overcome this issue?

Pls. suggest me.

Regards

Manna Das

[manna_das]

issue solved with the help of Note - 0001548125

[former_member209032]

Hi ,

The BX datasource gives the stock value at the date in which u initialized. If u do initialization in MCNB on 12th of december the posting data will be 12th for all the record. If u want stocks for older dates fill the setup tables for BF without any restriction then do init load it to cube and do a compression without any marker update.

Regards,

Raghavendra.

[manna_das]

Hi Raghavendra,

thanks for the reply.

Your are right that BX datasource gives the stock value at the date in which initialize will happen in MCNB, for all records i am getting the same date and I want old stock also, but I am not giving any restriction in MCNB then why it's fetching the same date for all records. The only resctriction i am giving is Termination Date and Time.

can you help me

Regards

Manna Das

[former_member209032]

Hi,

The initialization is done based on MBEW table and not on MSEG and MKPF table. MBEW gives the current stock for taking into consideration all the historic postings. So the BX datasource has all the transaction but it is in a aggregated form( Not literally). If u want to see the stock for older data plz load the BF datasource and see.

Regards,

Raghavendra.

[manna_das]

BF Datasource is ok, old posting dates are coming. But in that case how i will get the opening stock if i don't load the BX?

Regards

Manna Das

[former_member209032]

hi,

Inventory load is different to other loads because of non-cumulative keyfigures. There is something called marker update. Please read how to inventory doc or other docs in SDN regarding non cumulative keyfigures. It will help u to get a better understanding. For ur case load BX to cube. DO compression with marker update. The load initial load for BF and compress without marker update and then resume daily delta load for BF and compress this with marker update.

Regards,

Raghavendra.

[Former Member]

Hi,

You have to make sure that by restrictions for posting date or the material document number you only select those material documents that have created the opening stock.Also Please consider that material movements that have been posted into the future for a date (field BUDAT) after the initial stock date are not getting selected if the upper restriction bound is exactly this date. In this case you have to choose an appropriate upper bound like 31st December 2099 and to keep the posting block. Also if you post new documents to a date (field BUDAT) earlier than the initial stock date you have to keep the posting block as time restrictions wonu2019t help to determine the right documents (maybe restrictions by document number help).

Following link will guide you further :-

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e...

Navesh

[manna_das]

Hi Navesh,

Thanks for the reply,

I am not restricting any mat doc no. or posting date, without any restriction i m running that IP. Can you pls elaborate in steps.

and I have followed that doc which you have sent me to see but i m still in same place.

Regards

Manna Das

[Former Member]

Hi,

Don't give any selection in the IP for Posting Date as it will extract the stock for that particular date only. Also when you are initializing the stock its better not to give any selections while extraction.

Navesh

[manna_das]

There is only three fields in 2LIS_03_BX and there is no restriction but still the posting date in psa is same

BSTTYP Stock categories in the Logistics Information System

MATNR Material Number

WERKS Plant

and in Update Tab there is only One Option " Generate Initial Status"

Regards

Manna Das

[Former Member]

Hi,

If you are doing stock initialization for the first time only then you will get back dated stocks otherwise all the BX data changes to BF that is movement data and you get only the latest dated stocks through BX data source. This is how Inventory Mgmt works.

However if you are facing this issue in during the first time stock initialization then you should raise a OSS message for SAP as this should not happen during first time stock initialization.

Navesh

[manna_das]

Navesh,

thanx for the suggestion, I have raised a message to SAP.

Regards

Manna Das

[Former Member]

Hi,

Please check following document as well for better understanding of the inventory management in BW :-

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e...

http://wiki.sdn.sap.com/wiki/display/BI/InventoryManagement-MarkerUpdate,NoMarker+Update

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/906b837a-0d54-2c10-08b8-bde703375...

Navesh

[manna_das]

Thanks for the Docs Navesh