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
Create any functions? How to go about it?
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....
What is going life actually? What is the role of a functional consultant in it? : sap abap hr
What is the difference between Check and Continue?
dynamic programming in sap abap
Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary
What is the relationship existing between the various data elements? : abap data dictionary
What is the logo in sap script?
What are the properties of selection screen?
Mention what is alv programming in abap?
What is an “on input filed” statements?
Explain the disadvantages of logical databases?
Differentiate between abap memory and sap memory?
What is meant by write lock? : sap abap data dictionary
How do you use tab sets in layout sets?