|
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:
- 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.
|
|
Last Updated ( Friday, 09 March 2007 )
|
|
Read more...
|
|
|
Written by Anon.
|
|
Saturday, 10 March 2007 |
|
|
|
Read more...
|
|
|
Written by Anon.
|
|
Friday, 09 March 2007 |
|
Custom reports often require large amounts of processing of internal tables. The following techniques have worked well for large volume internal table processing. |
|
Read more...
|
|
|
Written by Anon.
|
|
Friday, 09 March 2007 |
|
During calculation, the performance depends on the data type used. Integer is the fastest, followed by Floating point and then Packed, which is the most resource intensive. |
|
|
Written by Anon.
|
|
Friday, 09 March 2007 |
Native SQL is to be avoided! Read on to see why....
|
|
Read more...
|
|
|
Written by Anon.
|
|
Friday, 09 March 2007 |
|
The DISTINCT addition to the SELECT statement allows you to remove duplicates from a set of results during a SELECT. |
|
Read more...
|
|
|
Written by Anon.
|
|
Friday, 09 March 2007 |
|
ABAP provides 2 methods of sorting. One is executing the sort on the database server and the other is executing the sort on the application server.
DON'T
Example: Sorting data within select statement
SELECT MATNR WERKS DISPO
FROM MARC
INTO TABLE T_MARC
WHERE DISMM = 'ND'
ORDER BY DISPO MATNR.
-> Sort is executed on database server DO
Example: Sorting data within ABAP
SELECT MATNR WERKS DISPO
FROM MARC
INTO TABLE T_MARC
WHERE DISMM = 'ND'.
SORT T_MARC BY DISPO MATNR.
-> Sort is executed on application server |
|
Last Updated ( Friday, 09 March 2007 )
|
|
Read more...
|
|
|
Written by Anon.
|
|
Friday, 09 March 2007 |
Assume an internal table TAB1 with the following definition. TAB1 is built from the database table DBTAB and contains many possible values for the table column FLAG (except the initial value). The functionality covered in this example is the case where all the internal table values with the value of FLAG not equal to ‘D’ have to be deleted. The table contains 100,000 rows.
LOOP AT TAB1
IF TAB1-FLAG <> ‘D’.
TAB1-FLAG = SPACE.
MODIFY TAB1 INDEX SY-TABIX
TRANSPORTING FLAG.
ENDIF.
ENDLOOP.
DELETE TAB1 WHERE FLAG = SPACE
|
|
|
Written by Anon.
|
|
Friday, 09 March 2007 |
|
Regardless of the various options associated with the SELECT statement the following guidelines--and some are restatements of coding/DDIC standards--must be kept in mind when coding a SELECT in an ABAP custom report program: |
|
Read more...
|
|
|
Written by Anon.
|
|
Friday, 09 March 2007 |
|
There are a couple of alternatives when using an OR-operator on a field that is relevant for an index. The below example will illustrate how the Rule based optimizer changes the access path for the query |
|
Read more...
|
|
|
Written by Anon.
|
|
Friday, 09 March 2007 |
|
Example: A database table dbtable1 has an index on field1, field2, and field3. |
|
Read more...
|
|
|
Written by Anon.
|
|
Wednesday, 28 February 2007 |
|
Step by step procedure on how to use hypertext documents, chapters and book to store text in SAP and then to retrieve it for use in an email. Why not store your email text in a chapter and if somoene wants to dynamicall y change the email output from your program then they can easily do so. |
|
Read more...
|
|
|
Written by Anon.
|
|
Saturday, 24 February 2007 |
* Display the header using an appropriate color (grayish blue)
WRITE 'Header' COLOR COL_HEADING.
* Switch the standard color
FORMAT COLOR COL_TOTAL.
* Make the color less bright
WRITE / 'total sum' COLOR COL_TOTAL INTENSIFIED OFF.
* Using different colors
FORMAT COLOR COL_HEADING.
WRITE / 'Header'.
FORMAT COLOR OFF.
SKIP.
WRITE: / 'Key field' COLOR COL_KEY,
'Background',
'Negative' COLOR COL_NEGATIVE,
/ 'Total sum' COLOR COL_TOTAL INTENSIFIED OFF. |
|
|
Written by Anon.
|
|
Wednesday, 21 February 2007 |
|
A very comprehensive list of ABAP function modules with some examples of how to use them. |
|
Read more...
|
|
|
Written by Kevin Wilson
|
|
Wednesday, 21 February 2007 |
|
This is a step by step procedure on how to create an ABAP drill down report. |
|
Read more...
|
|
