Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

inventory data loading issue

Hi All,

Can we skip the initial stock loading (2LIS_03_BX) and perform the 2LIS_03_BF -material movement?

With Regards,

Swaroop Kumar

Former Member
Former Member replied

Hi Swaroop,

Just to add one thing with the answers of other experts:

Can you skip 2LIS_03_BX datasource (I will call it as BX in further reply)? - Ideally yes, but this is specific to how you plan to load 2LIS_03_BF datasource (I will call it as BF in further reply).

So when can you skip BX? - Well, ONLY if you are loading all the historical data from your source system. BX datasource is used to extract the current stock at the time of initialization and BF datasource is used to extract all (in many cases not all historical data) the historical data up to the point when you are initializing.

For example, lets say you are extracting on 5/22/2015 and your material M1 was created in year 2010 with initial value of 5000. And on 5/22/2015 your stock value of material M1 is 10.

So

Case 1: BX is used in extraction:

If you extract BX datasource on 5/22/2015 your stock value for M1 will be 10. And for BF there are two cases now:

i) You load data from 2012 till 2015 (today) - lets say on 01/01/2012 your stock value of M1 was 2000. so BF will pick data from M1 stock = 2000. So ideally you are missing the initial stock value of M1 as 5000 that was in 2010. Now when you will load the delta data system will know that on 5/22 the stock of M1 was 10 (because you load BX) and it can easily calculate the next day wise stocks in delta run.

But when you look at the historical data for M1 prior to 2012 you will get incorrect results because you have loaded data only from 2012.

So, future data will be correct but not all historical data will be correct in this case.

ii) You load data from 2010 till 2015 (today): So in this case your all historical plus future data for M1 will be correct as system will have all the initial stocks from the time the material was created.

Case 2: BX is not used in extraction:

If you DO NOT extract BX datasource on 5/22/2015. For BF there are two cases now:

i) You load data from 2012 till 2015 (today) - lets say on 01/01/2012 your stock value of M1 was 2000. so BF will pick data from M1 stock = 2000. So ideally you are missing the initial stock value of M1 as 5000 that was in 2010. Now when you will load the delta data system will NOT have any information about the initial stock so it cannot calculate the correct delta values plus the historical data will also be incorrect.

So, future and historical data will be incorrect. Ideally this is not what you want

ii) You load data from 2010 till 2015 (today): So in this case your all historical plus future data for M1 will be correct as system will have all the initial stocks from the time the material was created.

So conclusion is:

Use BX datasource is you are not loading all the historical data from your source system else you can skip it ONLY IF you are loading all historical data.

I hope it helps to make clear choice.

Let me know if you have any questions.

Thanks

Amit


2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question