Parallel cursor

Answer Posted / cg

Parallel cursor is a technique to overcome loop inside loop technique in abap.
When we have two internal tables , and we have a situation where the entries from first internal table are to be dependant on the second table.
For e.g
Select matnr ernam from mara into table lt_mat where matnr = p_matnr.
Select maktx from makt into table lt_mat1 where matnr = lt_mat.
so for getting maktx we need to wirte first loop for lt_mat and then nested loop for lt_mat1 .
If we write like this , It will take more time to run the program to avoid this we use parallel cursor technique .
E.G select matnr from mara into table lt_mat where matnr = p_matnr.
Select maktx from mara into table lt_mat1 for all entries in lt_mat where matnr = lt_mat
then write loop for 1st select query only and read the second query with read table statment
Loop at lt_mat into lw_mat.
read table lt_mat1 into lw_mat1 where matnr = lw_mat.
endloop.
This is called Parallel cursor technique.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to transfer data into line items using batch input session method? : abap bdc

586


Is sap xi intended to replace ale?

583


What are the data types of the external layer? : abap data dictionary

796


What is an authorization in sap?

612


What are the user groups?

569






WHY CLUSTER TABLE CALLED AS CLUSTER TABLE.

1637


Differentiate between the uline and write: sy-uline statements if any?

730


after creating lock object if does n't access record by second user what should we do?

1547


Explain some essential objects in abap dictionary?

702


What is the difference b/t Session method and call transaction method ??

5253


What is at exit-command:?

571


what is the transaction transaction for setting parameters rdisp/buffermode

3587


What is difference between dialog program and a report?

593


Difference between domain and data element? What are aggregate object?

607


What is pretty printer?

597