thespot4sap.com independent sap information
 

New - get SAP Access - pay monthly

SAP Tutorials    Online SAP Training    SAP CBT's    Forums    SAP Articles    SAP Jobs    Resumes
  SAP Access    SAP Blogs    SAP Books     Links     Vendor Directory     Submit Content    Search

New Page 1

Previous Page

Next Page

SAP ABAP Performance Tuning
Tips & Tricks
Using Views instead of Base Tables

Page 4 of 15

Use of Views instead of base tables

Many times ABAP programmers deal with base tables and nested selects. Instead it is always advisable to see whether there is any view provided by SAP on those base tables, so that the data can be filtered out directly, rather than specially coding for it.

Not recommended

            Select * from zcntry where cntry like ‘IN%’.

             Select single * from zflight where cntry = zcntry-cntry and airln = ‘LF’.

            Endselect.

 

Recommended

            Select * from zcnfl where cntry like ‘IN%’ and airln = ‘LF’.

            Endselect.

===================================================================================

This tutorial contains a number of pages, each one explaining a tip or trick. You can either browse them one by one (click on the NEXT button, or jump straight to a tip or trick which interests you:

Next Page

Previous Page

 

New Page 1

 

 


About Us   Contact Us   Privacy   Disclaimer   Feedback   Email Discussion   Newsletter  

Copyright © - Independent SAP Information
Partners: Learn XML, SAPdox, Worldwide Guesthouses and B&B's