cancel
Showing results for 
Search instead for 
Did you mean: 

Analysis in inventory infocube 0IC_C03 adding Warehouse No., Stogare Bin and Storage type

0 Kudos

Hi gurus

I need to get the quantity and value of inventory by  Warehouse No (LGNUM), Stogare Bin  (LGPLA) and storage type (LGTYP), I found in datasource 2LIS_03_BF this fields but in 2LIS_03_BX and 2LIS_03_UM not, It´s posible get inventory by this fields using only the values of this datasource.

how would it be.


aditional information: BW 7.4


Regards,

Juan

Accepted Solutions (0)

Answers (2)

Answers (2)

bhavinvyas
Active Contributor
0 Kudos

You need to create generic data source based on LQUA also you can have HU related information from VEKP table,

Joining condition is as following for the view,

LQUAMANDT=VEKPMANDT
LQUALGNUM=VEKPLGNUM
LQUALENUM=VEKPEXIDV

Thanks,

Bhavin Vyas

Former Member
0 Kudos

Hi,

in that case you should get data from LQUA table which has storage bin/type and warehouse number.

if you have EWM module, you can find standard data source , if not , then you can create a custom data source by enabling direct access allowed and use a direct DTP to get the stock.