performance issue

[Former Member]

My code below is taking too much time around 13,369,415

I need to improve the performance of the code. any ideas!!!

  SELECT SINGLE aufnr
        FROM mseg
        INTO v_aufnr
        WHERE charg IN charg
        AND   bwart = v_move.

[rodrigo_paisante3]

Hi.

The use of IN kill performance. Try to select without IN.

Regards.

[Former Member]

I tried without

IN

and its the same performace. It has to do with

MSEG

table, I think the table has a lot of data and too many fields.

[Former Member]

Use AUFM table