Determine the result of MB5B using a program

oliver_ried · ‎2019 Mar 14

Hi,

is there a way to get the data from the MB5B through a program?

Is there a function module for this? I did not find any.

I need the non-hierarchical representation from the MB5B:

Material, date, initial stock, total receipt quantities, total issue quantities, final stock,

initial value, total access values, total exit values, end value

I would like to have this data collected regularly for the past week or the previous month via a program.

Is this possible without having to reprogram the MB5B?

Dominik_Tylczynski · ‎2019 Mar 14

Hi, depending on your exact requirements you have couple options:

If you care only about stock at the end of a month, you can write a FM by yourself and get the data from MARCH, MARDH, MBEWH tables
If you need exactly the same data as MB5B produces you have two options:

Build a FM wrapper around MB5B: call MB5B in background with SUBMIT ... EXPORTING LIST TO MEMORY AND RETURN; use FM LIST_FROM_MEMORY to read the MB5B output; parse the list and return in to your FM
Change MB5B slightly and grab the output data just before REUSE_ALV_LIST_DISPLAY is called.

Also take a look at:

HTH

Dominik Tylczyński

oliver_ried · ‎2019 Mar 20

@Dominik: Thank you for the answer. I have used the FM wrapper with SUBMIT and LIST_FROM_MEMORY. It works like a charm! Thank you very much!

holakac · ‎2019 Mar 14

Hello,

About your request - just schedule a job and collect it's results.