Skip to Content
0
Jul 02, 2020 at 07:17 AM

MB5B PERFORMANCE DEGRADED

134 Views

MB5B report is taking long time to display even single material for single date. what are the indexes should be on mkpf and mseg

the following query in mb5b is taking time.
SELECT (G_T_MSEG_FIELDS)
         INTO CORRESPONDING FIELDS OF TABLE G_T_MSEG_LEAN
         FROM MKPF AS MKPF  JOIN MSEG AS MSEG
                  ON MKPF~MANDT  =  MSEG~MANDT  AND
                     MKPF~MBLNR  =  MSEG~MBLNR  AND
                     MKPF~MJAHR  =  MSEG~MJAHR
         CONNECTION (DBCON)                                 
         WHERE MSEG~MATNR  IN  MATNR
           AND MSEG~WERKS  IN  G_RA_WERKS
           AND MSEG~LGORT  IN  G_RA_LGORT
           AND MSEG~CHARG  IN  CHARG
           AND MSEG~BWTAR  IN  BWTAR
           AND MSEG~BWART  IN  BWART
           AND MKPF~BUDAT  GE  DATUM-LOW
           AND MSEG~SOBKZ  IN  G_RA_SOBKZ
    %_HINTS  DB2    '&SUBSTITUTE VALUES&'
    ORACLE '&SUBSTITUTE VALUES&'.