topic Re: Performance issue with the ABAP statements in Application Development and Automation Discussions

Performance issue with the ABAP statements

Former Member — Thu, 29 Jul 2010 14:02:39 GMT

Hello,

Please can some help me with the below statements where I am getting performance problem.

SELECT * FROM /BIC/ASALHDR0100 into Table CHDATE.


SORT CHDATE by DOC_NUMBER.
SORT SOURCE_PACKAGE by DOC_NUMBER.


LOOP AT CHDATE INTO WA_CHDATE.
   READ TABLE SOURCE_PACKAGE INTO WA_CIDATE WITH KEY DOC_NUMBER =
   WA_CHDATE-DOC_NUMBER BINARY SEARCH.

   MOVE WA_CHDATE-CREATEDON  to WA_CIDATE-CREATEDON.
 APPEND WA_CIDATE to CIDATE.

ENDLOOP.

I wrote an above code for the follwing requirement.

1. I have 2 tables from where i am getting the data

2.I have common fields in both the table names CREATEDON date. In both the tables I hve the values.

3. While accessing the 2 table and copying to thrid table i have to modify the field.

I am getting performance issues with the above statements.

Than

Edited by: Rob Burbank on Jul 29, 2010 10:06 AM

Re: Performance issue with the ABAP statements

Former Member — Thu, 29 Jul 2010 14:23:16 GMT

Hello,

try a select like the following one instead of you code.


SELECT field field2 ...
INTO TABLE it_table
FROM table1 AS T1 INNER JOIN table2 AS T2
ON t1-doc_number = t2-doc_number

Re: Performance issue with the ABAP statements

Former Member — Thu, 29 Jul 2010 18:37:29 GMT

You can go for parallel cursor method.

https://wiki.sdn.sap.com/wiki/display/Snippets/ABAPCodeforParallelCursor-Loop+Processing

Regards,

Nikhil