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.

My internal table exceed the limit. then it goes to dump. how will u handle this issue?

8 Answers   Accenture,

---

What are field symbols and field groups.?

1 Answers  

---

What do you do with errors in BDC batch sessions?

1 Answers  

---

We execute the BDC program in foreground and got list in C drive. If the same program we can execute in back ground what happen?

2 Answers  

---

22) Very important How to find user Exit for a standard SAP Object(field,screen,menu etc)?

1 Answers  

---

what are the diff page formats available in SMARTFORMS ?

1 Answers   Genpact,

---

Can we include customizing include or an append structure with pooled or cluster tables? : abap data dictionary

0 Answers  

---

What is a matchcode?

0 Answers  

---

BAPI IS EFFICIENT THAN BDC?

2 Answers   IBM, Thomson Reuters,

---

Write the bdc table structure? : abap bdc

0 Answers  

---

What is the difference between dialog program and a report?

0 Answers  

---

In Table Maintaince Generator for a table i need some fields to be filled default,like date from sy-datum.........when the displays initailly....HOw

2 Answers   HP,

---