PowerExchange for SAP NetWeaver User Guide for PowerCenter

10.5
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.4.1
- 10.4.0

Back Next

Generating Open SQL

Open SQL is proprietary to SAP and is sometimes referred to as SAP SQL. Open SQL extracts data from buffers on the application server. When you generate the ABAP program with open SQL, the Designer uses a SELECT statement to select data. You can generate the ABAP program using open SQL for all mappings.

The following sample shows an open SQL statement that the Designer generated:

select MANDT KVEWE KAPPL KSCHL KOZGF DATVO DTVOB 
into (T685-MANDT,T685-KVEWE,T685-KAPPL,T685-KSCHL,T685-KOZGF,
T685-DATVO,T685-DTVOB)
from T685 where [...].
endselect.

When you join several sources in one Application Source Qualifier, open SQL uses a nested loop to select data. The Designer issues multiple SELECT statements and then generates WHERE clauses for the join conditions within the nested loop.

To select Open SQL:

In the Application Source Qualifier transformation, click the Properties tab.

Select Force Nested Loop.

Generating an ABAP Program

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal