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

Create any functions? How to go about it?

562


how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....

1565


What is going life actually? What is the role of a functional consultant in it? : sap abap hr

542


What is the difference between Check and Continue?

648


dynamic programming in sap abap

992






Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary

607


What is the relationship existing between the various data elements? : abap data dictionary

583


What is the logo in sap script?

565


What are the properties of selection screen?

553


Mention what is alv programming in abap?

578


What is an “on input filed” statements?

624


Explain the disadvantages of logical databases?

540


Differentiate between abap memory and sap memory?

631


What is meant by write lock? : sap abap data dictionary

582


How do you use tab sets in layout sets?

647