Performance MCHB & MSKA

[Former Member]

Dear friends,

Here the volume of data in the subject tables is very huge and performance of reports are badly affected.

But, on observing the data in these tables, most of material batches for previous year is already disposed and showing zero quantity. So, most part of the table data is occupied by zero quantity batches.

Is there any way that i can eliminate these batches from table, or any other way i can improve the performance (other than archive).

Kindly suggest,

Praveen Lobo

[Former Member]

Hi,

Table MCHB has the latest data related the key combination of MATERIAL, PLANT, STORAGE LOCATION and BATCH. The data reside with this table is the latest entry of the above said key combination. Even it it is last year data, because there was no transaction done related to stock for the key combination. All the batch stocks history details are stored MCHBH, there you can find the history of the batch stock details. Same as for the table MSKA, there is a history table MSKAH which is having history of sales order stock. Then do one thing lets get the data from these tables into internal table then calculate total, which is total of all stocks available in the table, if it is zero (TOTAL = 0) then delete the corresponding rows from internal table.

Rgds,

Bujji

[Former Member]

Hello,

Even though MCHB has the latest data, it remains in MCHB with zero stock for the period. So how can get rid of this zero stock latest data with zero stock.

Regards,

Praveen Lobo