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:
Expression Text
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 is displayed 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 is displayed in the Expression
Text field.
syntax shortcuts toolbar
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.
Functions tab
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 is displayed
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.
Data Sources Tab
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.
Validate Syntax
validates the syntax
of the SQL WHERE clause that you wrote. When you click this button,
the WHERE clause that currently is displayed in the Expression
Text field is validated, and either a confirmation message
or an error message is displayed. The syntax must be valid in the
SAS SQL procedure.
Undo
reverses the previous
changes to the expression in the Expression Text field.
Redo
repeats the changes
that were reversed with the Undo button.
Insert
inserts the selected
function or data source into the Expression Text field.