Thursday, September 20, 2012

LESSON17 VIEWS IN ABAP

The set of data that can be selected with a view greatly depends on whether the view implements an inner join or an outer join.With an inner join, you only get those records which have an entry in all the tables included in the view. With an outer join, on the other hand, those records that do not have a corresponding entry in some of the tables included in the view are also selected.

The hit list found with an inner join can therefore be a subset of the hit list found with an outer join.Database views implement an inner join. You only get those records which have an entry in all the tables included in the view.

Maintenance views implement an outer join.

No comments:

Post a Comment