Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with PowerExchange for SAP NetWeaver
  3. Part 2: Data Integration Using PowerExchange for SAP Dynamic ABAP Table Extractor
  4. Part 3: Data Integration Using ABAP
  5. Part 4: IDoc Integration Using ALE
  6. Part 5: Data Integration Using BAPI/RFC Functions
  7. Part 6: Data Migration
  8. Part 7: Business Content Integration
  9. Part 8: SAP BW Data Extraction
  10. Part 9: Loading Data to SAP BI
  11. Appendix A: Data Type Reference
  12. Appendix B: Code Pages and Unicode Support
  13. Appendix C: Glossary

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Using Multiple Outer Joins

Using Multiple Outer Joins

When you use an outer join, the Designer generates a LEFT OUTER JOIN statement in the ABAP program. You can use more than one outer join in the ABAP program flow. However, the tables you can join using outer join depends on how you join other tables in the program flow.
For example, you have three tables, KONH, KONP, and KONM in the ABAP program flow. You join KONP with KONH using an outer join. When you select KONM in the program flow, you cannot join KONM with KONP using an outer join. If you join KONM with KONP using an outer join, the Designer returns an error message when you generate the ABAP program.
In this example, you can only choose KONH because you already joined KONP with KONH using an outer join. When you join KONP and KONH with an outer join, the ABAP program selects rows that exist in both KONP and KONH, and it discards rows that only exist in KONP.
The same outer join concept applies to an ABAP program with any number of objects.

0 COMMENTS

We’d like to hear from you!