Shared Top Border

Enterprise Resource
Planning Portal

 

Advertise | Founder BLOG

ERPGenie.COM ABAP Tips and Tricks Database

THE ultimate
ERP website

 

Forums | Vote for us |

Google    Other Search Options

Home arrow Tips and Tricks arrow ABAP Reports arrow Select vs. Select *
Select vs. Select * PDF Print E-mail
User Rating: / 1
PoorBest 
Written by Anon.   
Saturday, 10 March 2007
Using Select field1 field2 ….. instead of Select * is significantly faster if the table contains a large number of fields

Example:
 
SELECT MATNR WERKS DISMM FROM MARC
       INTO TABLE T_MARC
       WHERE MATNR IN O_MATNR.

SELECT * FROM MARC
       INTO TABLE T_MARC
       WHERE MATNR IN O_MATNR.

Recommendation:
  • Use Select <field>:
  • Table consists of a large number of fields
  • Data retrieval is limited to a relatively small number of fields compared to overall number of fields. Hence, less memory usage and network load.
  • Use of Select * should be used on an exception basis ONLY.

ALSO

Example:
 
DO

SELECT MATNR WERKS DISMM FROM MARC
       INTO TABLE T_MARC
       WHERE MATNR IN O_MATNR.

DON'T

SELECT MATNR WERKS DISMM FROM MARC
       INTO CORRESPONDING FIELD OF TABLE T_MARC
       WHERE MATNR IN O_MATNR.
 

 


Related Items:
Last Updated ( Friday, 09 March 2007 )
 
< Prev   Next >
[ Back ]

Google Search

WEB
ERPGenie.COM
EDIGenie.COM
WorkflowGenie.COM

Google Ads

Shared Bottom Border

Contact Us | Polls | Add URL | Contribute | Privacy | Terms | Feedback

Discussion Forum | BLOG | Consultants: Post your resume | Companies: Advertise on ERPGenie.COM | Post Job
Financials Consultant | Consultant Review | Gallia Consulting | Supply Chain Project | SAP Financials Forum
GenieHoldings.COM, Inc. | Genie Press | WorkflowGenie | ESAGenie | ERPTopSites | ABAP Tips and Tricks | SAP Solutions Database
EDIGenie | Searching Survivor

©2001-2008 Genieholdings.COM, Inc. All rights reserved. ERPGenie.COM, EDIGenie.COM, WorkflowGenie.COM and ESAGenie.COM are Trademarks of Genieholdings.COM, Inc.

All product names are trademarks of their respective companies. GenieHoldings.COM, Inc. and it's websites are in no way affiliated with SAP AG.
 SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps, SAP NetWeaver, and and any other SAP trademarks are registered trademarks of SAP AG in Germany and in several other countries.
 Every effort is made to ensure content integrity. Use information on this site at your own risk.