Skip to Content
0
Former Member
Oct 19, 2007 at 05:37 AM

mseg table read taking much time (ALTERNATIVE ??)

42 Views

hi experts,

<b>SELECT mblnr mjahr

zeile

bwart

kdauf

kdpos

werks

erfmg

xauto

FROM mseg

INTO TABLE gt_mseg

FOR ALL ENTRIES IN gt_vbap

WHERE bwart IN (641, 101, 102)

AND kdauf = gt_vbap-vbeln

AND kdpos = gt_vbap-posnr

AND werks = gt_vbap-werks.</b>

Here in in my case mseg has 7 lakh records and vbap has 5000 record..

report is taking hell of a time to give an output..

is there any way to fine tune it

pls help me on this.

i want only erfmg field from mseg so is there any other table from where i can get the same..

points will be rewarded

Thnx,

Rajan Mehta