Documentation - Metadata API
Documentation - Metadata API
Breadcrumbs

Transformation - Code Scan

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


XML
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>0MATERIAL</name>
          <type>IOBJ</type>
          <lookup>FROM</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>

JOIN


XML
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>sflight</name>
          <type>TABL</type>
          <lookup>JOIN</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>


INNER JOIN
image-20220720-090458.png


XML
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>sflight</name>
          <type>TABL</type>
          <lookup>INNER JOIN</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>


RIGHT JOIN


XML
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>sflight</name>
          <type>TABL</type>
          <lookup>RIGHT JOIN</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>


RIGHT OUTER JOIN


XML
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>sflight</name>
          <type>TABL</type>
          <lookup>RIGHT OUTER JOIN</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>


LEFT JOIN


XML
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>sflight</name>
          <type>TABL</type>
          <lookup>LEFT JOIN</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>


LEFT OUTER JOIN


XML
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>sflight</name>
          <type>TABL</type>
          <lookup>LEFT OUTER JOIN</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>


CROSS JOIN


XML
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>sflight</name>
          <type>TABL</type>
          <lookup>CROSS JOIN</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>


FULL JOIN


XML
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>sflight</name>
          <type>TABL</type>
          <lookup>FULL JOIN</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>