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
What is the role of ‘refresh’ in internal table?
Fallback class
What was the requirement of IDoc in your project? How it was working?
How will you define posting procedures?
Advantages and disadvantages of different types of bdc's?
What are base tables of an aggregate object? : abap data dictionary
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
What are the data types of the abap/4 layer? : abap data dictionary
What is the meaning of client independent?
Difference between function group and function module?
How do you populate data into a multiple line field?
Explain the difference between a dialog program and a report?
What are the events in screen programming?
What is lock objects? : sap abap data dictionary
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/