Skip to Content
avatar image
Former Member

Batch Numbers with Onhand Quantity

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 30, 2015 at 04:40 AM

    Hi Malu,

    How about OBTQ and OIBT?

    Regards,

    Wongso

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2015 at 05:34 AM

    Hi,

    Batch related tables MCHA, MCHB, MCH1.

    Thanks With Regards,

    Dinesh Kumar V.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

      Former Member you can go for OBTN

      Regards,

      Bhushan Verma

  • avatar image
    Former Member
    Oct 30, 2015 at 05:54 PM

    Hi Malu,

    Refer OIBT for Batch info and OITW for Onhand Qty with respect to warehouse.

    Add comment
    10|10000 characters needed characters exceeded