...
Lookup
...
FROM
...
JOIN
...
INNER JOIN
...
RIGHT JOIN
...
RIGHT OUTER JOIN
...
LEFT JOIN
...
LEFT OUTER JOIN
...
CROSS JOIN
...
In all the statements the API translates a table of a BW artifact into the BW artifact itself (e.g. Select * from "/BI0/PMATERIAL" is translated into the InfoObject 0MATERIAL).
All calls on tables (also for table of BW artifacts), dynamic variables (DYNAMIC), and CDS entities (DDLS) have another attribute ”lookup” which identifies how the tables are called. E.g. with a standard select from, or in a join, outer join, etc. (see list below).
The calls of coding elements (FUNC - Function Modules, REPS - ABAP Programs/Reports, and METH - Methods) don’t have that property.
SQL Relation | SAP | Metadata API |
|---|
FROM | | | Code Block |
|---|
| <parent ...">
<node>
...
<code>
<extractedItem>
<name>0MATERIAL</name>
<type>IOBJ</type>
<lookup>FROM</lookup>
</extractedItem>
</code>
</node>
...
</parent> |
|
JOIN | | | Code Block |
|---|
| <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent> |
|
INNER JOIN |  Image Added | | Code Block |
|---|
| <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>INNER JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent> |
|
RIGHT JOIN | | | Code Block |
|---|
| <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>RIGHT JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent> |
|
RIGHT OUTER JOIN | | | Code Block |
|---|
| <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>RIGHT OUTER JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent> |
|
LEFT JOIN | | | Code Block |
|---|
| <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>LEFT JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent> |
|
LEFT OUTER JOIN | | | Code Block |
|---|
| <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>LEFT OUTER JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent> |
|
CROSS JOIN | | | Code Block |
|---|
| <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>CROSS JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent> |
|
FULL JOIN | | | Code Block |
|---|
| <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>FULL JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent> |
|
