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 difference between FOR ALL ENTRIES and SELECT *
FROM ?

Answer Posted / srinivas reddy

For all entries is used to join the one or more tables based on condition.Select * from is used to fetch the data from db
table,but don't use select * from due to performance standards. The code like this
select vbeln
erdat
ernam
vkorg from vbak into table it_vbak
where vbeln eq v_vbeln.
select vbeln
posnr
matnr
matkl from vbap into table it_vbap
for all entrie in it_vbak
where vbeln eq it_vbak-vbeln.

The sequence of fields used in select query must be same as
the sequence of fields in internal table.
thanks,i hpoe this is corrct...........

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the role of ‘refresh’ in internal table?

1009


Fallback class

2196


What was the requirement of IDoc in your project? How it was working?

2007


How will you define posting procedures?

1328


Advantages and disadvantages of different types of bdc's?

983


What are base tables of an aggregate object? : abap data dictionary

1040


There is a delivery that is being created through the ABAP code and in the middle it says delivery created but someone is modifying , how would you rectify this issue

8493


What are the data types of the abap/4 layer? : abap data dictionary

1166


What is the meaning of client independent?

998


Difference between function group and function module?

1133


How do you populate data into a multiple line field?

1017


Explain the difference between a dialog program and a report?

959


What are the events in screen programming?

1132


What is lock objects? : sap abap data dictionary

1058


I have 3 transactions,where the output of one transaction is input of another and output of 2nd transaction is input of 3rd transaction.i have one flat file with all data for the 3 transaction.if the 3rd transaction failed can we rollback the remaining 2 transactions or not.Is this possible in BDC,How/

2273