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 are extracts?
Explain how is batch input process different from processing on line?
How many types of tables exist and what are they in data dictionary?
What are the different functions used in sap script? What are the parameters used in each function?
What is the relationship existing between the various data elements in data dictionary? : abap data dictionary
What are the properties of selection screen?
Update function modules are classified as either v1 or v2. Which type of update is performed first and in what mode (asynchronously, synchronously or locally) can each type be processed in?
What is page window?
What is append search help? : sap abap data dictionary
What is table attribute? : abap data dictionary
What are the different types of parameters? : abap modularization
B -Credit Note report Selection Screen Ranges: Creation date Sales Org Sold to Party Selection condition: Document Category – VBTYP should be ‘O’ Table to be used: VBRK, VBRP,VBPA,ADRC List the CR order types or credit billing type by customer number (or selected customer) and displays the: - Billing Document date (FKDAT) - Customer number (KUNRG) - Name of the reseller (on top of the SAP No) (NAME1) - Billing document number,(VBELN) - order reason (AUGRU_AUFT) - Amount (NETWR) - Currency (WAERK) Group Currency wise, billing type wise sum of Net value. When user double click on field ‘Billing Document #’ , display the document in VF03 Do this using OO ABAP.
We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???
send coding to write a program to create customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA2/BAPI_QUOTATION_CREATEFR OMDATA'
What is the difference between native sql & open sql? : abap data dictionary