topic Re: Problem performance MIRO in the function MRM_DUPLICATE_INVOICE_CHECK in Application Development and Automation Discussions

Problem performance MIRO in the function MRM_DUPLICATE_INVOICE_CHECK

clayton_barbosa — Mon, 15 Oct 2012 19:50:12 GMT

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.

Re: Problem performance MIRO in the function MRM_DUPLICATE_INVOICE_CHECK

former_member182371 — Tue, 16 Oct 2012 07:36:19 GMT

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.

Re: Problem performance MIRO in the function MRM_DUPLICATE_INVOICE_CHECK

RaymondGiuseppi — Tue, 16 Oct 2012 07:54:07 GMT

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