Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What are the advantages of logical databases?

1110


What are the functional areas, user groups? How does abap query work in relation to these?

1100


What is the function of the transport system and workbench organiser? : abap data dictionary

1116


How to create user interfaces for lists?

1064


Explain the structure of a bdc sessions?

1048


Did you create secondary index?

1207


Have you set up a back ground job ? How to create a background job without a variant ?

1092


What is a help view? : abap data dictionary

1128


What is its?

1145


Which commands are used for interactive reports?

1303


what is friend class

1464


How do you find the information on the current screen? : abap bdc

1112


Can we access static attribute from instance method

1553


what are the main technical differences between oracle and sap? it would be more helpful to me if get this answer...

2182


BDC program to migrate data to SAP R/3 database. The data will be uploaded using transaction ME11. (Session Method) plz mention the detail coding Tahnks, Rahul

2311