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

Explain how do you move on to the next screen in interactive reporting?

748


What is the difference between free and refresh?

768


Explain what is the purpose of sap script?

750


Can a posting run be deleted? : sap abap hr

773


Control Break statements- At new...endat.

1126






How do you import pay scale data from non sap to sap? : sap abap hr

814


What are the types of subroutines? : abap modularization

753


What is the bitwise operator in the sap abap?

764


What are the prerequisites for creating foreign key relationship?

825


What are dml commands in abap?

841


Explain the advantages/disadvantages of logical databases?

743


What data is contained? : abap data dictionary

863


How do you get the number of lines in an internal table? How to use a specific number occurs statement?

689


What are the different methods of bdc? : abap bdc

765


What are the different functions used in sap script? What are the parameters used in each function?

831