MSKA table Data fetching

[Former Member]

Dear Experts,

I had one issue regarding data fetching from MSKA " Sales Order Stock".

I have 52+ lac records in MSKA table.

On MSKA table two indexes.

1 - for VBELN, POSNR fields

2 - for MATNR, WERKS, LGORT, CHARG, SOBKZ fields

Mainly while fetching data from MSKA table with where vbeln and posnr parameter data fetch easily.

When fetch using matnr, werks, lgort, charg parameter it's took long time, sometime time out for material ranges.

please anyone have idea regarding indexing priority or any alternative of table please suggest.

It may be performance tuning issue then please forgive but please reply.

Regards,

Nayan Lad

[JarosBaw]

Hi,

First check inSE11 if index is active and exist.

Try activate trace using transaction ST05 and check if index is used.

Regards,

Jarek

[Former Member]

Hi,

I had checked both index are activated.

Also trace with ST05 it showed both indexes there but not sure which index is use.

Thanks for reply.

[JarosBaw]

In ST05 You cen display explain and check which index (if any) is used in Your select statement.

[Former Member]

Hi,

If this is an ABAP question, then probably you can transfer first the contents of your MSKA table (of course, take care of you indices) into an internal table before making a selection.