Skip to Content
0
Former Member
Feb 17, 2009 at 03:30 PM

Listing Batch Number with transaction detail

165 Views

We use the Sales Order Usage Indicator to designate a Site location for order materials we supply to customers' building sites and I've written a report that lists component material details used in the Production orders created per sales order for each of those sites. What the user department would like is for the batch managed items detail to include the batch number associated with the material.

However, I'm finding it difficult to find which file this batch number data is actually in. I've found some batch numbers in RESB (which I use to get the component material number and configured data) but out of the millions of records in there only about 66 have the batch number included in the record. The other files I've checked that include the batch number field do not have any data in it. It is at component level that the batch field should have a batch number included.

Can anyone please advise as to where I can find the relevant data to complete my report.

FYI, I start with getting Sales Orders with selected Usage Ind in from VBAK, then pick up relevant sales order item data from VBAP with joins to MARA and MAKT for basic material data.

I get the Production order number from AUFK using the Sales order number and then I chain to RESB for the component material data using the Productioon order number. I pick up the batch field from RESB at this time but so far it has always been empty.

Thanks very much

Jim Jackson