Skip to Content
0
Former Member
Jun 09, 2008 at 05:25 AM

performance issue with joins on table VBAK, VBEP, VBKD and VBAP

412 Views

hi all,

i have a report where there is a join on all 4 tables VBAK, VBEP, VBKD and VBAP.

the report is giving performance issues because of this join.

all the key fields are used for the joining of tables. but some of the non-key fields like vbap-vstel, vbap-abgru and vbep-wadat are also part of select query and are getting filled.

because of these there is a performance issue.

is there any way i can improve the performance of the join select query?

i am trying "for all entries" clause...

kindly provide any alternative if possible.

thanks.