Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between FOR ALL ENTRIES and SELECT *
FROM ?
- 2 Answers
- 10910 Views
- I also Faced
- E-Mail Answers
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 ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA
How can we upload a text file having delimiters in to legacy system? : abap bdc
Difference between Insert, Update and Modify?
Define dispatcher?
Can a constructor be declared private? If yes then in which scenario?
What are the merits of its?-
Which function module would you use to check the user’s authorization to access files before opening a file?
Under Data Transfer Portion of ABAP, what do you mean by DX Project
Print options in smartforms?
java script for push button in adobe forms.
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary
Can a transparent table exist in the data dictionary but not in the database physically?
What is synchronous update?
There is a situation where there is a field "MATERIAL DESCRIPTION" in say 20 display only transaction. You want that whenever user opens any of these transaction, this particular field is masked with ****. But table does not holds ****. It holds the actual value. What are different ways of doing it? Which is the best way.
