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.


RELATED POSTS

SEARCH HELP

What is SAP and Why do we are in need of It
What is SAP Full form and its definition part one
SAP Full form and introduction part two
SAP architecture,its full form of working and enjoy sap products
SAP journey from R/3 towards MySAP.com
MySAP technology RFC,BAPI,ALE and IDOC overview
MySAP new generation technologies overview
SAP cost,definition,authorization and architecture
What is enjoySAP technology and how it is used