Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Views, Joins and For All Entries...

Hi Everyone

I understand that generally using the 'FOR ALL ENTRIES' option is more efficient than using JOINS within my code. However, even though they use inner joins, are Views inherently more efficient than using joins used in a program. If they are, are they also more efficient than using 'FOR ALL ENTRIES' too? My specific example involves joining VBAK and VBAP. I figure I have 3 options:

1. Write a selec statement joining the two tables on VBELN

2. Use the pre-defined view VIVEDA that does the same

3. Write a select with just VBAK into an int. table and then write another select using this table with a FOR ALL ENTRIES.

Which is the best option?

Kind regards

Andy

Tags:
Former Member
Former Member replied

Hi,

i will suggest option 3, that will be faster.use for all entries. since view VIVEDA is also join.

Regards

vijay

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question