Use thus page to specify
selection criteria that you want to use to select the SAP R/3 tables
for which you want to extract metadata. You can use this page to specify
the WHERE clause for an SQL query that you want to submit.
Because many tables
exist in your SAP R/3 system, searching through all of them to find
the tables that you want to use can be a lengthy process. You can
use the
Build Expression (WHERE Clause) page
to generate an SQL WHERE clause to use to select tables. When you
do this, you can generate a manageable list or a subset of SAP R/3
tables by selecting only those that match your criteria.
If you used the
Extract from R/3 wizard
in SAS Management Console to pre-extract your SAP R/3 metadata to
SAS data sets, here is the default query syntax:
SELECT *
FROM R3LIB.tables
WHERE user-defined-where-clause;
R3LIB represents the library into which you have extracted SAP R/3 metadata.
If you dynamically access
the metadata in your SAP R/3 system instead of using pre-extracted
metadata, here is the default query syntax:
SELECT DISTINCT P.tabname, P.tabclass, P.ddtext as tabtext
FROM R3Eng.dd02l as P
LEFT JOIN R3Eng.dd02t as G on P.tabname = G.tabname
AND G.as4local = P.as4local AND G.ddlanguage='E'
WHERE (G.ddlanguage='E')
AND (P.tabclass='CLUSTER' OR P.tabclass='POOL'
OR P.tabclass='TRANSP' OR P.tabclass='VIEW')
AND WHERE user-defined-where-clause;The Build Expression
(WHERE Clause) page contains the following items:
specifies the SQL WHERE
clause that you want to use to identify your selection criteria. You
can enter the WHERE clause in the Expression Text field. You can also use the syntax shortcuts toolbar, Functions tab, and the Data Sources tab to create your WHERE clause. The first time you display this
page, the default expression text displays in the Expression
Text field. Each subsequent time that you display the
page, the last valid expression or WHERE clause that was created and
submitted displays in the Expression Text field.
displays a list of
buttons that you can use to insert operators, conditions, and punctuation
marks instead of entering them. Some syntax shortcut buttons include
the Boolean AND Operator button, the Greater Than Or Equals Condition button, and the String Concatenation Operator button. There are also
shortcut buttons for enclosing selected text in either quotation marks
or parentheses.
displays all valid
functions that you can use in your SQL WHERE clause. In the left pane
of the tab, functions are grouped by the type of task. For example,
all functions that relate to calculating financial data are included
in the Financial function group. When you
select a function group, all functions included in that group are
listed in the right pane of the tab. When you select a specific function
in the right pane, the function name and description displays at the
bottom of the Functions tab. To insert a
function into your SQL WHERE clause, double-click on the function
in the right pane of the tab or select the function in the right pane
of the tab and click Insert.
displays all valid
data sources that you can use in your SQL WHERE clause. To insert
a data source into your SQL WHERE clause, double-click on the data
source in the left pane of the tab or select the data source in the
left pane of the tab and then click Insert.
The page contains these
buttons.
validates the syntax
of the SQL WHERE clause that you wrote. When you click this button,
the WHERE clause that currently displays in the Expression
Text field is validated, and either a confirmation message
or an error message displays. The syntax must be valid in the SAS
SQL procedure.
reverses the previous
changes to the expression in the Expression Text field.
repeats the changes
that were reversed with the Undo button.
inserts the selected
function or data source into the Expression Text field.