on 05-27-2016 2:02 PM
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
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,
LQUA | MANDT | = | VEKP | MANDT |
LQUA | LGNUM | = | VEKP | LGNUM |
LQUA | LENUM | = | VEKP | EXIDV |
Thanks,
Bhavin Vyas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.