topic Re: LOOP & ENDLOOP & PARELLEL CURSOR in Application Development and Automation Discussions

LOOP & ENDLOOP & PARELLEL CURSOR

yasu_1096 — Tue, 04 Jul 2023 06:03:56 GMT

Hi All,

Can anyone tell about the Loop & endloop , parllel cursor why it is used exact meaningful use for loop & endloop ?

what is parellel cursor why it is used exact meaning for the parlell cusrsor ?

Re: LOOP & ENDLOOP & PARELLEL CURSOR

FredericGirod — Tue, 04 Jul 2023 06:07:03 GMT

Do you know there are some documentation about all that

What it is not clear in these docs, blogs ... ?

Re: LOOP & ENDLOOP & PARELLEL CURSOR

adityaIngale66 — Tue, 04 Jul 2023 06:10:08 GMT

Hi yasu_1096,

There are lot of threads available on SCN on this.

https://answers.sap.com/questions/4324015/what-is-meant-by-parallel-cursor.html

https://answers.sap.com/questions/10664194/correct-usage-of-parallel-cursors.html

https://answers.sap.com/questions/3814347/parallel-cursor.html

https://answers.sap.com/questions/5869000/parallel-cursor-method.html

Re: LOOP & ENDLOOP & PARELLEL CURSOR

matt — Tue, 04 Jul 2023 08:19:13 GMT

The parallel cursor technique is obsolete and has been for nearly 25 years. The advent of HASHED and SORTED internal tables removed the need for this technique.

Re: LOOP & ENDLOOP & PARELLEL CURSOR

former_member145111 — Thu, 06 Jul 2023 08:57:47 GMT

TO follow the concept you need minimum 2 tables which are have common keys for example if I take PO related data of EKKO, EKPO and EKET. I will need to do as follows:

sort: iekko by ebeln, iekpo by ebeln ebelp, ieket by ebeln ebelp ETENR.

loop at iekko.

read table iekpo with key ebeln = iekpo-ebeln.

check sy-subrc is intital.

loop at iekpo from sy-tabix.

if iekpo-ebeln ne iekko-ebeln.

exit.

endif.

... process logic.

read table ieket with key ebeln = iekpo-ebeln ebelp = iekpo-ebelp.

check sy-subrc is initial.

loop at ieket from sy-tabix

if ieket-ebeln ne iekpo-ebeln or ieket-ebelp ne iekpo-ebelp.

exit.

endif.

... process logic.

endloop

endloop.