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
Explain how do you move on to the next screen in interactive reporting?
What is the difference between free and refresh?
Explain what is the purpose of sap script?
Can a posting run be deleted? : sap abap hr
Control Break statements- At new...endat.
How do you import pay scale data from non sap to sap? : sap abap hr
What are the types of subroutines? : abap modularization
What is the bitwise operator in the sap abap?
What are the prerequisites for creating foreign key relationship?
What are dml commands in abap?
Explain the advantages/disadvantages of logical databases?
What data is contained? : abap data dictionary
How do you get the number of lines in an internal table? How to use a specific number occurs statement?
What are the different methods of bdc? : abap bdc
What are the different functions used in sap script? What are the parameters used in each function?