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

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
RIGHT OUTER JOIN
LEFT JOIN
LEFT OUTER JOIN
CROSS JOIN
FULL JOIN