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.

if u have two internal table such as itab1 and itab2.in itab1 has four fields such as f1,f2,f3,f4 and in itab2 has two fields such as f1,f2.then how can u copy data from first internal table to second internal table.

5 Answers   Wipro,

---

what is basic difference between script&smart forms?

4 Answers   KPIT,

---

Difference between SY-CPROG and SY-REPID? Plz give me the answer,its urgent!

6 Answers   Accenture,

---

What is table buffer? Which type of tables used this buffer?

2 Answers  

---

what are the two methods of modifying sap standard tables? : abap data dictionary

0 Answers  

---

I need the coding for BDC program to upload Purchase orders of known vendor (ME21) in Material Management

0 Answers   CSC,

---

What are the different types of enhancements?

1 Answers   Infosys,

---

How do you use tab sets in layout sets?

0 Answers  

---

How to transfer legacy data into base tables by scheduling a time frame using bdc?

2 Answers  

---

what is a binary search ? and how it is useful in a sorted internal table ?

1 Answers  

---

Explain SD and MM Flow?

12 Answers   Keane India Ltd, Mascon, Tech Mahindra,

---

how to prepare technical specs? what are the steps used to prepare it?

2 Answers   HCL,

---