Views, Joins and For All Entries...
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?
i will suggest option 3, that will be faster.use for all entries. since view VIVEDA is also join.