Answer / 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...........

Answer / surya

For all entries means: select query will be fetch the
records based on the records which are in the internal
table fields using for all entries.it gives the better
performance,while fetching records from the database.

select * from : it will fetch the records of all the fields
in the database table.it consumes the time .performace
problem.

How to type casting in OOPS ABAP and ABAP ?

2 Answers   CTS,

---

when do you need to create an internal table with header line ?and with out a header line?

2 Answers  

---

Do you use select statement in loop end loop, how will be the performance? To improve the performance?

2 Answers  

---

what is variable window?

1 Answers  

---

what are Hana Basics

0 Answers   Infosys,

---

Which is the event trigger last?

5 Answers   Wipro,

---

Type casting and error handling

0 Answers   Infosys,

---

What is Set Screen and Leave screen?

1 Answers   IBM,

---

how many index created for table

10 Answers   Wipro,

---

Types of windows in SAP scripts?

9 Answers   vCentric Technologies,

---

What are the various types of the Internal tables used?

4 Answers   TCS,

---

I have two internal tables itab1 and itab2 and I had move the content of the itab1 to itab2 and then itab1 had to deleted

4 Answers   Accenture,

---