Versions Compared

Old Version 4

changes.mady.by.user Alexander Dürrstein

Saved on

compared with

New Version 5

changes.mady.by.user Alexander Dürrstein

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Lookup

...

Description

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

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

JOIN

Code Block
languagexml
<parent ...">
    <node>
      ...
      <code>
        <extractedItem>
          <name>sflight</name>
          <type>TABL</type>
          <lookup>JOIN</lookup>
        </extractedItem>
      </code>
    </node>
    ...
</parent>

INNER JOIN

Image Added

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

RIGHT JOIN

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

RIGHT OUTER JOIN

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

LEFT JOIN

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

LEFT OUTER JOIN

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

CROSS JOIN

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

FULL JOIN

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