MSKA table Data fetching

[nayanlad]

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

[Jarosław]

Hi,

First check inSE11 if index is active and exist.

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

Regards,

Jarek

[nayanlad]

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.

[Jarosław]

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.