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...

what is the use of FOR ALL ENTRIES in an internal table?

Answer Posted / sriram

Actually It is used instead of inner join because when we want to join morn than 3 tables using inner join it will put a heavy load on the database server. instead of taking heavy load on DB server we will use for all entries ...
USED to retrieve the matched Records from the Different DB Tables..
Syntax :
select * from DBTABLE1 into table ITAB1
if itab1 is not initial
select * from DBTABLE2 into table itab2
where condition.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is sap script? What is the purpose of sap script?

1099


How can we use multiple transactions by using bdc_insert? : abap bdc

1139


What are the data classes in abap?

1147


How you attach search help to data element? : sap abap data dictionary

1131


What are logical databases?

1110


What is the length of function code at user-command?

1321


What is the difference between a substructure and an append structure? : abap data dictionary

1127


A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?

956


Did you create any joins?

987


How to call other programs?

1087


How many main windows will be there in a page window?

970


Explain the client concept of sap.

1034


Can a domain, assigned to a data element be changed? : abap data dictionary

1052


Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?

1104


What is dialog module?

1081