Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Feb 27 at 05:52 PM

    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,


    Add comment
    10|10000 characters needed characters exceeded