cancel
Showing results for 
Search instead for 
Did you mean: 

How could I add batch expiration date to the report I get from MB52 transaction?

0 Kudos

Hi everyone, I'm trying to do a VBA code that will pick raw materials based on their batch expiration date, to do this, I need to figure out how could I merge the information I get from MB52 report with the ones I get from running MMBE (or MSC3N) transactions.

I know we have some worksheets that get data from some tables using a RFC call, but I don't know how I can adapt the code in order to do this. I'm just a beginner with coding and I couldn't find a place where it explains the syntaxes, so I'm changing the variables from the code to see what happens, sometimes I get no data in others I get too much information that I don't really need.

Well, this isn't exactly a question, so if you have suggestions on what I could be searching, it would help a lot.

Accepted Solutions (0)

Answers (1)

Answers (1)

kusiel_camargo
Explorer
0 Kudos

Hi Junior,

Have you checked the Batch Information Cockpit, Tx: BMBC? It is a standard transaction that combines stock information with batch characteristics, including shelf-life. This transaction is very powerful, with several filtering options.

From there it is possible to export the results to an spreadsheet either.

Best regards,

Kusiel