Skip to Content
avatar image
Former Member

Batch selection by sales order

I need to write a query to extract matnr werks charg from mcha based on sales order number entered

also write a query to extract matnr werks charg from mcha based on delivery note entered

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2007 at 02:12 PM

    Hi Megan,

    Get the batch number from VBAP table VBAP-CHARG

    Pass this batch number to MCHA table MCHA-CHARG and get the information you need. hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 01:58 PM

    Hi,

    for first user VBAK, VBAP, MCHA with VBELN on VBAK and VBAP and MATNR for VBAP ans MCHA,

    For delivery use LIKP, LIPS, MCHA,

    regards, Dieter

    Add comment
    10|10000 characters needed characters exceeded