what is the use of FOR ALL ENTRIES in an internal table?
Answer Posted / sriram
Actually It is used instead of inner join because when we want to join morn than 3 tables using inner join it will put a heavy load on the database server. instead of taking heavy load on DB server we will use for all entries ...
USED to retrieve the matched Records from the Different DB Tables..
Syntax :
select * from DBTABLE1 into table ITAB1
if itab1 is not initial
select * from DBTABLE2 into table itab2
where condition.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is the difference between commit-work and rollback-work tasks?
What is the use of the raising exception?
Can you print decimals in type n?
How do you restrict the data to be entered in the payroll area? : sap abap hr
What is meant by exclusive, not cumulative lock? : sap abap data dictionary
****THANK YOU ALL ABAP EXPERTS**** I got a JOB as ABAP Consultant in Infosys.I cleared the interview.The question posted here are really good.I cleared interview based on this material only.It really works.I thank all members who posted que&ans here. Those who are in search of job in MNC study this question set only you will get sucess. Thanks once again allinterview.com and members of this community. tulika20021@rediffmail.com
Why do we use FOR ALL ENTRIES and what is the pre-requisite
send coding to write a program to create customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA2/BAPI_QUOTATION_CREATEFR OMDATA'
What are field symbols and field groups? Have you used component idx of structure clause with field groups?
Explain what is sap script?
10) How to get Item Header in Sales Order?
What do you do when the system crashes in the middle of a BDC batch session?
What is the difference between scrolling a table horizontally and vertically?
In which time constraint does the infotype records depend on the subtype ? : abap hr
How do you take care of performance issues in your ABAP programs?