Skip to Content
0
Jan 30, 2014 at 11:48 AM

MSKA table Data fetching

281 Views

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