Parallel cursor
Answer / 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 |
What is the relationship existing between the various data elements? : abap data dictionary
If I code parameters and selection events without writing the start-of-selection, will the report runs?
Hi, If anyone is interested in SAP ABAP from basics to Expert. Email me your contact details to sap.abap9@gmail.com
when we use the SELECT statement along with FOR ALL ENTRIES then what type of validations we have do before executing this statement
2 Answers Cap Gemini, Mphasis, TCS,
If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc
to explicititly intialize the selection screen for each call you must you the event ________________?
What is pretty printer?
what is difference bt ABAP MEMORY AND SAPMEMORY
What are the differences between a database index and a match code? : abap data dictionary
write the codes for how to handle currency and date fields in bdc
How to write a bdc – how do you go about it?
Explain what are the events used for logical database?