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 | <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>
|