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).
Lookup | SAP | Metadata API |
|---|---|---|
FROM | <parent ...">
<node>
...
<code>
<extractedItem>
<name>0MATERIAL</name>
<type>IOBJ</type>
<lookup>FROM</lookup>
</extractedItem>
</code>
</node>
...
</parent>
| |
JOIN | <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent>
| |
INNER JOIN |  | <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>INNER JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent>
|
RIGHT JOIN | <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>RIGHT JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent>
| |
RIGHT OUTER JOIN | <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>RIGHT OUTER JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent>
| |
LEFT JOIN | <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>LEFT JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent>
| |
LEFT OUTER JOIN | <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>LEFT OUTER JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent>
| |
CROSS JOIN | <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>CROSS JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent>
| |
FULL JOIN | <parent ...">
<node>
...
<code>
<extractedItem>
<name>sflight</name>
<type>TABL</type>
<lookup>FULL JOIN</lookup>
</extractedItem>
</code>
</node>
...
</parent>
|