Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Performace issue for a view like - Z_MARA_MVKE

Former Member
0 Kudos
106

Hi ,

I am facing an issue for the view - Z_MARA_MVKE which is collecting entry from Mara and MVKE table.

Now this view contains more than 36 lakhs entries for which this view is showing performance issue for us which is taking more than 10 mins time to execute . Can you please give me some suggestion how we can increase the performance of this view?

Moderator message: please use international units only, 36 lakhs = 3.6 million.

Edited by: Thomas Zloch on Sep 9, 2010 11:14 AM

4 REPLIES 4

Former Member
0 Kudos
53

Hi!

Are the MARA and MVKE table connected by primary key (MANDT+MATNR)? If not then change it to this.

If you try to restrict the values by a non-key and non-indexed field, like a Z- apppend field, it could be slow.

You might try to create an index for the field, you wanted to use for restricting the number of entries. You can use SE11 transaction for creating additinal indexes for tables (not for the views).

You can create additinal indexes even for SAP standard tables, like MARA and MVKE.

Regards

Tamás

Edited by: Tamás Nyisztor on Sep 7, 2010 4:14 PM

0 Kudos
53

secondary indices are rarely a good solution, IMHO. I try to always figure out a way to use the primary key on the tables if possible. Not sure what you really gain from a view of these two tables...are you able to supply a value for VKORG and VTWEG in MVKE?

Former Member
0 Kudos
53

Hi Sanjay,

You have created a view over MARA and MVKE tables which does not contains full primary key (matnr, vkorg and vtweg ) of table MVKE that's why it has been giving you lots of records.

My suggestion is to create a new view with three tables MARA, MSTA and MVKE (zmara_msta_mvke) so that it will get its full primary key. I have checked with the program as well as view and it has been giving the limited results.

I hope it will solve your technical problem.

Thanks.

Anurag

ThomasZloch
Active Contributor
0 Kudos
53

Please quote your entire join conditions and, if applicable, selection criteria of this view here to help the analysis.

Thomas