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 |
How the at-user command serves mainly in lists?
what is DATA ,TYPES,PaRAMETERS called in ABAP terms?
What are the difference between call screen and leave screen?
What application areas are you comfortable in?
can i use table key and key in an internal table and explain the functionalities of each one and what functionality does it give if both are used for same internal table
In Dialog program Syntax of Synchronous and Asynchronous?
how top handle error in LSMW?
What are reference fields in data dictionary ? how do u assign them to a table field?
What do you mean by batch data communications programming?
How we will handle the Page Breaking in Smart Form?
The loop-endloop on extract datasets can be used without any kind of errors. State true or false. : abap modularization
How can u transfer the data from one itab to another without using move & write statements?