WBS consumption Table

[former_member218144]

Hi All,

I have a small issue with regards to the consumption against WBS element.

I want to track the consumption of all materials against a WBS element for a reporting requirement.

Currently I tracking the same through "MSEG" table.But I am having performance issue .

It takes a long time to retrieve all the data since we are handling large volume of data.

Please suggest a better way to do the same.

Regards

Richie

[former_member195427 · Accepted solution]

Hi Richie,

Have you tried available std. reports for material consumption in projects?

CJI3,CJI5, ME2J,ME5J,MB5B,MB52 etc.

Or the SQVI query using tables BSEG,MSEG. Use only that data in this query which you actually require in the output (to save memory space during execution).

OR

I assume that you have developed a complex report as per your requirement successfully and now you are facing performance issue. For that you need to check with Abaper on ABAP performance using SQL trace (ST05). Check the following link:

ABAP Performance and Tuning - ABAP Development - SCN Wiki

You need to removed unwanted SQL statements which are consuming more space in your custom program.

Ley us know if you have havy doubt in it.

Regards

Saurabh