Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Compare 2 internal tables based on key field

sapient_abaper
Explorer
0 Kudos

Hi All,

I have 2 internal tables with different field but some fields as common and its a key field.

Now my requirement is that I am getting a data in both the tables,

I will be getting some common records based on that key field, but when looping 1st table & reading another table based on

key field,by this performance is getting reduced coz I need to loop more no. of times to check.

I want that both the tables with same product field should only be Read to check & proceed further.... Is there any alternate to do this...

Please let me know if any solutions

Thanks in advance...

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Sapient,

In your scenario, you can use parallel cursor method to improve the performance.

Please see the below links for parallel cursor.

http://www.google.com.au/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CFwQFjAB&url=http%3A%2F%2Fwww...

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP+Code+for+Parallel+Cursor+-+Loop+Processing

Regards,

Rajesh

2 REPLIES 2

Former Member
0 Kudos

Hi Sapient,

In your scenario, you can use parallel cursor method to improve the performance.

Please see the below links for parallel cursor.

http://www.google.com.au/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CFwQFjAB&url=http%3A%2F%2Fwww...

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP+Code+for+Parallel+Cursor+-+Loop+Processing

Regards,

Rajesh

kesavadas_thekkillath
Active Contributor
0 Kudos

How does parallel cursor improve performance ?