topic Batch selection by sales order in Application Development and Automation Discussions

Batch selection by sales order

Former Member — Wed, 22 Aug 2007 13:48:07 GMT

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 — Wed, 22 Aug 2007 13:58:17 GMT

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 — Wed, 22 Aug 2007 14:12:25 GMT

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.