Batch selection by sales order

[Former Member]

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

[Former Member]

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

[Former Member]

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.