program to select material inventory

[Former Member]

Hi,

I have written a program, that should select the material inventory, increase, outflow in a specific month and show it in an ALV. there should be an option to export the results as a csv file.

I have finished the ALV and the csv-file stuff, but I have problems to get the right data-field for the material inventory for the specific month....

It should show the same result, as You would use the transaction "MCBC" and select for the specific month.

Now, I have selected all entries from Mara to get all materials. After that I have selected the fields mzubb, wzubb, magbb, wagbb from s032 for the specific month/year (spmon). The third selection, I have made, was the fields lbkum and salk3 from mbewh for the specific month (lfmon) and the year (lfja).

After all I have merged the results together in one table....

But the fields salk3 and lbkum from mbewh aren´t the right fields.... In the mcbc I get different values.

Can anybody help me?

Cheers Arne

[Former Member]

Hello Arne,

The field u have chose has different meaning in S032 it is running total. in mbewh it is the actual transaction.

e.g u have received 100 in May 05 & 200 Jan 06 then ur mbewh would show...

one entry as 100 in May period and 200 in Jan period whereas in MCBC trx it would show for the selected period (11.2005 - 02.2006) as

11.2005 --- 100

12.2005 --- 100 as there has been no trx

01.2006 --- 300 as receipt in January

02.2006 --- 300

where as the s032 would have 300 in valuated stock field.

So u need to decide which one u want to display.