Problem performance MIRO in the function MRM_DUPLICATE_INVOICE_CHECK

[clayton_barbosa]

Hi!

  I am a problem with perfomance in transaction MIRO.

    The problem is in the select of table rbkp in the function MRM_DUPLICATE_INVOICE_CHECK.

The select

* As there can be several hits, store the result of the database
* selection into an internal table.
  IF NOT t169p-xxblnr IS INITIAL AND i_xblnr CS string.
    SELECT * FROM rbkp INTO TABLE t_rbkp
             WHERE xblnr = i_xblnr AND lifnr = i_lifnr AND (code).
  ELSE.
    SELECT * FROM rbkp INTO TABLE t_rbkp
             WHERE lifnr = i_lifnr AND (code).
  ENDIF.

    In the table rbkp is with all index ative.

Can you suggest what could be the possible reasons behind the slow performance of MIRO??

Any suggestions for remedy??

Thanks.

[former_member182371]

Hi,

the only thing i´ve found is this OSS Note:

Note 790680 - MM IV: Performance during check for duplicated invoices

https://service.sap.com/sap/support/notes/790680

Best regards.

[RaymondGiuseppi]

Also look for (old) Note 134660 - Logistics Invoice Verification: Performance (RBKP) which suggest  to create some indexes (like LIFNR, BUKRS, XBLNR, if you create this one, then deactivate RBKP~1 in database).

Regards

Raymond