topic Re: MSKA table Data fetching in Application Development and Automation Discussions

MSKA table Data fetching

Former Member — Thu, 30 Jan 2014 11:48:17 GMT

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

Re: MSKA table Data fetching

JarosBaw — Thu, 30 Jan 2014 12:01:44 GMT

Hi,

First check inSE11 if index is active and exist.

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

Regards,

Jarek

Re: MSKA table Data fetching

Former Member — Thu, 30 Jan 2014 12:08:26 GMT

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.

Re: MSKA table Data fetching

JarosBaw — Thu, 30 Jan 2014 12:49:39 GMT

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

Re: MSKA table Data fetching

Former Member — Thu, 30 Jan 2014 13:00:59 GMT

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.