Project Stock report using QBEW and QBEWH tables

[Former Member]

Dear All,

First of all Happy New Year to all of you.

Here is my question: I want to build a ABAP report for stock situation for project stock. The report demands the stock by closing month. Suppose I run the report for month 11/2010, it should show the closing stock at the end of the month 11/2010.

Now I am using the values from table QBEW for this purpose.But QBEW table shows only current entries. If a material stock is changed or value is changed, it goes into history table QBEWH.

Now problem is that if I try to make sum of QBEW and QBEWH, the stock value is excessive. Now I am not sure which entries I should consider from QBEWH table for this purpose.

Has anybody worked on similar requirement?

Thanks in advance!

Regards,

Mahendra Dighe

[former_member230675]

Hi,

Please try the report S_P00_07000140 - Inventory and Raw material for special stock report.

Thanks.

abdul