on 10-29-2015 2:34 PM
Hi Experts,
Does anyone know what table should i use if i want to create a query of batch numbers with onhand quantity?
Thanks in advance,
Malu
Hi Malu,
Refer OIBT for Batch info and OITW for Onhand Qty with respect to warehouse.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Batch related tables MCHA, MCHB, MCH1.
Thanks With Regards,
Dinesh Kumar V.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dinesh,
As suggested by you i am not able to find any batch information in your provided table name
But as Suggested by Wongso Soekamto we can fetch the details, but needed join to combine both the table.
Regards,
Bhushan Verma
Hi Malu,
How about OBTQ and OIBT?
Regards,
Wongso
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.