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 |
Setting up a BDC program where you find information from?
can any post me all steps in MM ,SD, PP FLOW in detail?
what is the role of ST05 in performance tuning?
What will you code in start-of-selection & end-of-selecton & why?
How to handle Error in LSMW. This is urgent anybody know this answer plz post me...
What is a table pool?
what is result set of an inner join at database level ?
When a function module is activated syntax checking is performed automatically. State yes or no. : abap modularization
What are the disadvantages of abap query tool?
what is the t-code to link technical and functional operation?
Define subtype ? : abap hr
what is use of STOP stsment