Answer / sukhbir

View and Join : two different way to join 2 or more
database table.

Join should be used to join 2 or 3 table small size table ..
performance will reduce in case of join b/w two large
database table.

View are always better then join in terms of performance....

Answer / rupali

view is used to display only selected coloumns,it provides
restriction to display selected coloumns to the selected
user.
but in joins there nothin like restrictions,it is simple
join of two tables or more than two tables....

Answer / gireesh

view is just virtually Create table and perform a task.
join is combine(group) two or more tables based on
conditions to collect data

Answer / visweswara

view contains 5 number of types.
in database view is joins 2 or more tables,
joins also do same work.
join is nothing but a database view.
view is generate the code and gives the result of table.
but our own 'join code' not genrate any programe but we
write reqired code for it and there is no external code is
genrated. thatsway join is better than view.
so we used to 'join' for write report programs.

how to debug ale/idocs and how to correct errors and how to find out where the exact error occur

1 Answers   HCL,

---

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

2 Answers  

---

For Sap ABAP which institute is best in Hyderabad?

6 Answers  

---

what are the characteristics of a bapi?

2 Answers  

---

What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary

0 Answers  

---

What are the domains and data element?

0 Answers  

---

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?

0 Answers   Infosys,

---

what are medruck, rvorder01

2 Answers  

---

how to run bdc program in background?

2 Answers   HCL,

---

What is the length of function code at user-command?

0 Answers  

---

8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?

0 Answers  

---

Difference between BDC vs Direct Loads?

0 Answers  

---