INNER AND OUTER JOINS IN ABAP

INNER AND OUTER JOINS 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.

(124)


RELATED POSTS

PROGRAM INTERFACE AN INTRODUCTION DAY 36

INTERACTIVE REPORT LIST TECHNIQUES DAY 37

SCREEN PROGRAMMING AN INTRODUCTION DAY 38

SCREEN ELEMENTS FOR OUTPUT ABAP REPORT DAY 39

SCREEN ELEMENTS FOR INPUT DAY 40