Make your own free website on Tripod.com

SAP PM & ABAP Code Niraj Visnoi

SAP ABAP Performance Issues - Coding Guidelines

Home
What is SAP ?
SAP LSMW Explained with example
SAP PM T-Codes
PM BRD/COR Maintenance
Add Your URL
User Exits & Enhancements
Best Of SAP Links
BDC Code
My Resume
SAP SmartForms Step by Step
SAP ABAP ALV Grid Explained with Example
Useful Tips
Contact Information Guest Book and Consultants List
ABAP Code
ABAP System Fields
SAPScript
SAPScript Graphics
SAPScript Print Program
ABAP ListViewer
Dialog Programming
SAP Tables
SAP ALE and IDOC
Recommended SAP ABAP Coding guidelines
SAP General ABAP
Submit Your Code
SAP Books For consultants
Free Website Submission and ROR Sitemap generator
Free Domain Search
Free HoroScope

Performance issues with SELECT statement -SAP ABAP Coding Guidelines.

NESTED SELECT STATEMENTS
 Instead of nested SELECT statements the joins INNER or OUTER should be used or VIEWS should be created in ABAP DICTIONARY if possibel another
alternative is to use
FOR ALL ENTRIES IN itab
 
If we use FOR ALL ENTRIES IN itab , care should be taken that it is not
empty otherwise DBMS will return all the rows from the table specified
in the FROM clause of SELECT statement .

USE SELECT SINGLE
 Use SELECT SINGLE if the key is completely known instead of SELECT ENDSELECT statement .
 
USE FIELD LIST
Instead of using SELECT * we should use SELECT with fields specified individually as less data will be retrieved from the databse.
SELECT f1 f2 f3
              f4 f5 f6
   FROM tab
 

http://sap.niraj.tripod.com

http://sap.niraj.tripod.com

Search http://sap.niraj.tripod.com Search www

 http://sap.niraj.tripod.com      Niraj Visnoi *INDIA * niraj_visnoi@consultant.com      
 CELL No. 91 9911413767       Copyright 2006 all rights reserved