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.

difference between append and collect statement?

4 Answers  

---

what is the use of select for all entries in an internal table?

2 Answers  

---

in the event at selection-screen output we use loop screen,what is screen intenal table,structure or DB table?

4 Answers   IBM,

---

How to debug a smart form?

5 Answers   IBM, Mind Tree, TCS,

---

what are selection screens which one triggers first?

3 Answers  

---

HOW MANY IMPLEMENTATIONWE CAN CREATE IN BADI? WHAT IS THE USE OF REUSABLE IN BADI? HOW MANY IMPLEMENTATION IS ACTIVE IN PRODUCTION SYSTEM AT A TIME?

2 Answers   Siemens,

---

What are matchcodes?

0 Answers  

---

How 10 Digits are stored in Packed Decimal?

2 Answers   Atos Origin,

---

What is object in OM

1 Answers  

---

Can we have two reports running parallely and both the reports sharing the same internal table for processing the data?

1 Answers   General Mills,

---

What are the events used for logical database?

0 Answers  

---

can anyone told me name of abap interview question book with autor name?

7 Answers  

---