Disadvantages of Forall entries

-

2 Tips to avoid most common bugs related to "FOR ALL ENTRIES" :

This selection contains 2 drawbacks:


1. As mentioned in SAP HELP documentation, "FOR ALL ENTRIES" behaves like a "SELECT DISTINCT" statement. That means all duplicates are removed. As a consequence, some relevant entries will not appear in the selection hit list!

2. If the table used in the WHERE clause is empty (this is the table LT_OBJNR in the statement above), all rows of the source table will be selected. You guess that it causes important and unnecessary performance degradation, especially for huge tables like COSP, although no result should be returned for this statement!!!

Next are 2 simple tips to avoid these problems:

1. Declare all primary keys of your database table in your select statement. It ensures that you have no duplicates in you hit list

2. Check that the table used in the "For all entries" statement is not empty. This avoids executing the select statement if no result is expected.

 

 

Comments

Post a Comment

Popular posts from this blog

SAP ABAP-Internal Table Operations and Example Program

-
Image
Internal Table Operations: Below are the Operations of Internal Table Append Insert Delete Modify Describe Sort Refresh Clear Free Loop … Endloop Read Table   1.Append   - to append the workarea record at the last position of internal table. we can append:   a. single record   b. multiple records a. single record (one -> Many / Workarea-> Internal table) Syntax:   APPEND <WORKAREA NAME> TO <INTERNAL TABLE NAME>. Example:    wa_data-PATIENTID               = 9999.    wa_data-PATIENTNAME    = 'Addition1'.    wa_data-HOSPITALNAME = 'Alpha Hospital'.      APPEND wa_data to IT_DATA.    CLEAR wa_data.     b. Multiple records (Many->Many / Internal table1 to internal table2) Syntax: APPEND LINES OF <Internal table name1> to <Internal table name2>. Note: While appending 1 internal table data with another interna
Read more

HR ABAP Interview Questions and Answers

-
1)        Difference Between ABAP & HR-ABAP ? ABAP and HR-ABAP are almost similar but HR-ABAP has some different approach to program like logical      database (like PNP & PCH) are extensively used in HR-ABAP. Infotypes and Infotypes related tables are used in HR-ABAP. Some specific comments like provide ...endprovide are used in HR-ABAP but not generally in ABAP. 2)        Infotype ? The data fields of HR master data, time management and recruitment are grouped logically into information types or infotypes for short. Examples of infotypes are "Family/Related Person", "Organizational Assignment, "Basic Pay". Infotype Category’s: o     Infotypes 0000 - 0999 - HR master data   and sometimes for applicant data o     Infotypes 1000 - 1999 - organizational management o     Infotypes 2000 - 2999 - time data o     Infotypes 4000 - 4999 - applicant data o     Infotypes 9000 - 9999 - customers 3)        Subtype ?   Subtypes are
Read more

BDC (Batch Data Communication) - SAP ABAP

-
Image
BDC (Batch Data Communication) Batch input is a standard technique used to transfer large volumes of data into an SAP system. The advantage of batch input is that all the transaction-level checks can be performed on the data and then the data is updated through the transactions (Via Screens). Data transfer project involves the following steps:  1. Identifying the data that needs to be transferred to the SAP. 2.Record the screen fields using transaction: SHDB & generate a program from it. 3. Write the BDC program separately by making use of Recoding code (Step no:2) 4. If required, Convert the data while passing from Non-SAP to SAP (External to Internal). 5. Handle various errors/messages in program as per requirement. 6.Validate the data while processing. 7 . Process the program and verify the transferred data in SAP. 8. Set the data transfer frequency as per business requirement. Note: Batch input programs allow us to capture all t
Read more