cancel
Showing results for 
Search instead for 
Did you mean: 

What is the use of 2LIS_03_BX data source

Former Member
0 Kudos

Hi Experts,

I designed the query on top of Inventory Cube , it has 5 years of inventory moments, so query is taking 45 mins to execute it, for this cube data is not loaded through 2LIS_03_BX data source, data is loaded through 2LIS_03_BF Data source only, now i have to reduce the Quey time

Please correct me if i am wrong

1. If i initialize the stock now(say on 06.01.2012) through 2LIS_03_BX data source and load historical data through 2LIS_03_BF Data source

Say if user want to see the Stock on 07.01.2012 of Material

system calculates like as below

Stock of the Material on 07.01.2012 = Opening stock of the material on 06.01.2012(using 2LIS_03_BX data source) + Stock Received on 07.01.2012(Moments from 2LIS_03_BF Data source) - Stock issued on 07.01.2012(Moments from 2LIS_03_BF Data source)

Stock of the Material on 08.01.2012 = Opening stock of the material on 06.01.2012(using 2LIS_03_BX data source) + Stock Received on 07.01.2012((Moments from 2LIS_03_BF Data source) + Stock Received on 08.01.2012(Moments from 2LIS_03_BF Data source) - Stock issued on 07.01.2012 - Stock issued on 08.01.2012(Moments from 2LIS_03_BF Data source)

2. If user want to see the stock before stock inialization date(say 05.01.2012),

how this value gets calculated

Stock of the Material on 05.01.2012 = all Received Qty since 5 years(<= 05.01.2012,(Moments from 2LIS_03_BF Data source)) - all Issued Qty since 5 years(<= 05.01.2012, (Moments from 2LIS_03_BF Data source)) ?

or

it uses Initialization stock value to calculate the Stock on 05.01.2012?(using 2LIS_03_BX data source and Moments from 2LIS_03_BF Data source)

Regards

Chandra

Accepted Solutions (1)

Accepted Solutions (1)

abhishek_rajan3
Contributor
0 Kudos

Hi Chandra,

You can refer to the How to document through the below link which explains inventory calculation in each scenario. What you have mentioned is mostly right for the stock calculation for future postings. However, for historical posting, you might want to determine if you're using the non- cumulative approach or the snapshot approach.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e328

Hope it helps.

Thanks,

Abhsihek.

Answers (0)