Performance issue in mb51

[krishna_k19]

Dear All ,

         i'm executing the T.Code--MB51 (Program--RM07DOCS , Include RM07DOCS_GENERATED ) one table(MKPF) is taking too much time . here i'm presenting the query pls help me.

select (g_t_fields)
     into corresponding fields of table itab
     from mkpf inner join mseg
     on    mkpf~mandt = mseg~mandt
       and mkpf~mblnr = mseg~mblnr
       and mkpf~mjahr = mseg~mjahr
        WHERE MKPF~BUDAT in BUDAT
          and MSEG~BWART in BWART
          and MSEG~CHARG in CHARG
          and MSEG~KUNNR in KUNNR
          and MSEG~LGORT in LGORT
          and MSEG~LIFNR in LIFNR
          and MSEG~MATNR in MATNR
          and MSEG~SOBKZ in SOBKZ
          and MKPF~USNAM in USNAM
          and MKPF~VGART in VGART
          and MSEG~WERKS in WERKS
          and MKPF~XBLNR in XBLNR
%_HINTS
ORACLE '&SUBSTITUTE VALUES&' .

Please find and suggest me.

Thanks & Regards,

Krishna

[former_member16553]

Hi

    Pass value in maxium selection in selction-screen as u can.

[krishna_k19]

Thanks for your reply..

   but here i'm giving(Selection Screen) Material , Plant , Storage Location , Movement type , Posting Date ,User Name then also it is taking time .

  I Created Secondary Index for MKPF (For fields MANDT, BUDAT ,USNAM , VGART ,XBLNR) with these fields then also no use.

Please Suggest.

Thanks ,

Krishna

[raymond_giuseppi]

Did you check for OSS performance notes like Note 1550000 - MB51: Redesign of selection for performance optimization and 1516684 - MKPF fields added to MSEG - Performance optimization ?

Regards,

Raymond

[krishna_k19]

Thanks Raymond..

  i checked those notes so i got solution..

Thanks

Krishna