How to improve performance of vc01n_m transaction - view VBRP_VRPMA

[Former Member]

Hi experts,

I need to improve performance of vc01n_m transaction.

I run this transaction adding a selection on invoices creation date but it takes a very long time to give results.

In SM50 I see a Work process showing a sequential read on view VBRP_VRPMA.

If it was a database table I'm able to create an index for this kind of selection, but on a view how can I do? How can I get better performances (because I cannot create index on views)?

Thanks in advance

drag0

[Former Member · Accepted solution]

Hi,

Take an SQL trace with ST05 of your running transaction.

You will see which exécution plan is used to access your view and if an index creation would be a good thing to do.

Regards,

Olivier

[Former Member]

Create INDEX for tables, that will improve the performance.

Ignacio.

[Former Member]

Hello

VRPMA only contains invoice positions with coded materials, so it's possible you don't get all the billing documents accessing through this view. I'm not an expert in this transaction but perhaps the data selections can be reviewed.

Regards.