topic Re: parallel cursor. in Application Development and Automation Discussions

parallel cursor.

Former Member — Tue, 25 Mar 2008 08:49:25 GMT

hi,

Please explain with exactly how the parallel cursor means (Whether only using INDEX).

I have a scenario like this

three internal tables i am using loop at itab WHERE,

how to make the same using parallel cursor, which will improve the performance.

chk this i want similar scenario.

tables:ekko,ekpo.

*parameter: p_ebeln like ekko-ebeln.

select-options: p_ebeln for ekko-ebeln.

data: i type i.

data: itab1 type table of ekko with header line,

itab2 type table of ekpo with header line,

itab3 type table of ekbe with header line.

select * from ekko into table itab1 where ebeln in p_ebeln.

select * from ekpo into table itab2 where ebeln in p_ebeln.

select * from ekbe into table itab3 where ebeln in p_ebeln.

*i = 1.

loop at itab1.

write / 'loop 1'.

loop at itab2 where ebeln = itab1-ebeln.

write / 'loop2'.

loop at itab3 ebeln = itab2-ebeln ebelp = itab2-ebelp.

write / 'loop3'.

endloop.

regards,

Prabhu

Points assured.

Re: parallel cursor.

Former Member — Tue, 25 Mar 2008 09:09:22 GMT

Try the below code. Hope it helps.


sort iekpo by ebeln ebelp.
sort iekbe by ebeln ebelp.

loop at iekko.
 clear: lv_inx.
 read table iekpo with key ebeln = iekko-ebeln binary search.
 if sy-subrc = 0.
   lv_indx = sy-tabix.
   loop at iekpo from lv_indx.
     if iekko-ebeln = iekpo-ebeln.
       clear: lv_indx1.
       read table iekbe with key ebeln = iekpo-ebeln
                                            ebelp = iekpo-ebelp
                                            binary search.
       if sy-subrc = 0.
          lv_indx1 = sy-tabix.
          loop at iekbe from lv_indx1.
             if iekpo-ebeln = iekbe-ebeln and
                iekpo-ebelp = iekbe-ebelp.
                 <<< do ur logic>>
             else.
                 clear: lv_indx1.
                 exit.
              endif.
            endloop.
     else.
       clear: lv_indx.
       exit.
     endif.
   endloop.
 endif.
endloop.

Thanks,

Balaji

Re: parallel cursor.

Former Member — Tue, 25 Mar 2008 11:01:09 GMT

Hi Balaji,

The code is fine if have one entry in itab2 for itab1 and one entry for itab3 in itab1 then you code is fine.

But if we have 2 record(itab2) for 1 entry in itab1 and so on it doesn't work as per the requirement

regards,

Prabhu

Re: parallel cursor.

Former Member — Tue, 25 Mar 2008 11:55:37 GMT

Try the below code.


sort iekpo by ebeln ebelp.
sort iekbe by ebeln ebelp.
 
loop at iekko.
 write:/ iekko.
 clear: lv_inx.
 read table iekpo with key ebeln = iekko-ebeln binary search.
 if sy-subrc = 0.
   lv_indx = sy-tabix.
   loop at iekpo from lv_indx.
     if iekko-ebeln = iekpo-ebeln.
       write:/ iekpo.
       clear: lv_indx1.
       read table iekbe with key ebeln = iekpo-ebeln
                                            ebelp = iekpo-ebelp
                                            binary search.
       if sy-subrc = 0.
          lv_indx1 = sy-tabix.
          loop at iekbe from lv_indx1.
             if iekpo-ebeln = iekbe-ebeln and
                iekpo-ebelp = iekbe-ebelp.
                write:/ iekbe.
                 <<< do ur logic>>
             else.
                 clear: lv_indx1.
                 exit.
              endif.
          endloop.
      endif.
   endloop.
 endif.
endloop.

Hope this helps.

Thanks

Balaji

Re: parallel cursor.

Former Member — Tue, 25 Mar 2008 12:27:45 GMT

hi balaji,

Thanx, whether this will be more efficient then using Loop at with where condition.

regards,

Prabhu

Re: parallel cursor.

Former Member — Tue, 25 Mar 2008 12:31:19 GMT

This will be more efficient when the number of records in itab1, itab2 and itab3 are more.

This will reduce lot of processing time.

Rwd points if helpful.

Thanks

Balaji

Re: parallel cursor.

Former Member — Tue, 25 Mar 2008 12:37:53 GMT

[www.saptechnical.com/Tutorials/ABAP/ParallelCursor.htm]

Got to this link what u require is there perfect with examples

and about the performances while using parallel cursor

regards,

priya.

Re: parallel cursor.

rodrigo_paisante3 — Tue, 25 Mar 2008 12:47:11 GMT

Hi,

see this link.

/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops

Rob shows the performance comparing 4 routines, including nested loop, indexed and parallel.

and this.

/people/siegfried.boes/blog/2007/09/12/runtimes-of-reads-and-loops-on-internal-tables

Siegfried explain how parallel works. Good job

Regards!