ABAP – Avoid the View

Well, in a never ending quest to improve performance, I’ve stumbled upon yet another novice mistake I was making. I was doing select statements into views. In theory, views are great, everything is already there, I can do 1 extract and grab everything I need. I figured out, selecting data from a view is very EXPENSIVE.
So, my tip of the day, avoid views in your programming. If you only have a view, go to SE11, and see what tables comprise the views, and extract directly from the correct tables. Your users will thank you.
Thanks for reading,

As always, thanks for reading and don't forget to check out our SAP Service Management Products at my other company JaveLLin Solutions,
Mike