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

What are the different types of internal table?

1183

---

What are the ways you can do the tuning?

1149

---

Can you define a field without a data element? : abap data dictionary

1206

---

Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?

1580

---

What is a table pool? : abap data dictionary

1119

---

What is the difference between collect and sum?

1276

---

Explain the components of selection table?

1193

---

What are system fields for secondary lists?

1118

---

Why do we need enhancements?

1234

---

What are Delivery classes? What data will you want to transport during client copy?

1470

---

What are domains and data element? : abap hr

1117

---

Under Data Transfer Portion of ABAP, what do you mean by DX Project

2357

---

How can a lock object be called in the transaction?

1086

---

singleton class

1456

---

Name the function module used to convert logical file names to physical file names in abap/4 programs?

1228

---