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

Write the bdc table structure? : abap bdc

780


What does the extract statement do in extract datasets?

829


How to write a bdc – how do you go about it?

872


How move-corresponding works

1114


What is the meaning of table buffer? This buffer is used by which type oftable?

957






What is an update task?

780


How many types of data classes are there in sap abap? : abap data dictionary

787


What is the difference between a substructure and an append structure?

830


Explain the difference between domain and data element? What are aggregate object?

791


Difference between sy-tabix and sy-index?

1015


What is a database view? : abap data dictionary

814


What is the full form of spro? : sap abap hr

913


Can we display a list in a pop-up screen other than full-size stacked list?

876


– Programming using BAPI : Create Debit Memo Request (DMR) with reference to Sales Order and update the delivery number and PO number in the newly created DMR. Send the spool of the report by E-mail if the E-mail option is enabled. Selection Screen Required:  Sales Org  Delivery type  Sales document type Optional:  Planned Goods movement date  Option to choose E-Mail  E-mail Address  Output device Output Output should display both successful and unsuccessful creation of DMR with the following fields,  Success/Error (S/E)  Sales Document number  Delivery number  New Debit memo request number  Error message Tables TVAK, TVCPA, VBAK, LIKP, LIPS

5794


How to create user interfaces for lists?

776