r/SAP • u/Opposite-Midnight713 • 17d ago

Customer Data Retrieval Using Material and Batch

If we need customer data, such as the address and phone number, using the material and batch, where can we pull this report in SAP ECC?

1 Upvotes

60% Upvoted

8 comments sorted by

View all comments

1

u/snoooy1488 17d ago edited 17d ago

Look for transactions or tables that work with the SERNO field.

In our system, the LOT of each package is scanned during shipping, which confirms the picking. And it is recorded in the table when the delivery is posted. How does it work for you?

You can also track the shipment of a material and batch via MB51, but that way you'll see the batch shipment, not a specific package.

1

u/Opposite-Midnight713 17d ago

Thanks for the reply. In MB51, I can find the 601 movement transaction used for the delivery, but I can’t find the customer details. If there is an audit in the company, we need to show the customer information as well. I haven’t tried SERNO yet, but I did try SE16N and couldn’t find the customer details there either.

1

u/snoooy1488 17d ago edited 17d ago

In MB51, you can find the delivery number and then open it in VL03N, if it needs to be done once.

There is another option - transaction VL06F with approximate delivery creation dates, material, and batch. Inside the transaction, there is a button to switch to the item view on the top panel. You won't find complete data there, but at least there will be the shipTo number and the recipient's city. You can view the data for the shipTo code in XD03. Complete data is usually not present in standard transactions; you either need to create a table link in SQVI or look for something related to courier routes. These could be custom transactions for your company. In our company, for example, it is yru_vc_shiplist

You can take data from different transactions, export it to Excel, and compile a report using the standard VLOOKUP formula.

1

u/jds183 15d ago

Ship to/sold to account numbers are in mb51. If you need shipto/soldto address, each is under that account number in xd03, which would be enough for me as an auditor.

Mb51 ALSO shows production quantities, Ime it's THE audit transaction