Use this page to specify
whether you want to search the SAP R/3 metadata, to generate a subset
of tables using metadata that you have already extracted, or to extract
the SAP R/3 table metadata to SAS data sets. Here is how you can search
and subset tables dynamically or using pre-extracted metadata.
-
Display only the SAP R/3 tables
that meet your search criteria.
-
Display the SAP R/3 tables in an
alphabetical tree view in which tables are grouped according to the
first letter of the table name.
-
Display a structured view of the
SAP tables where tables are grouped according to the SAP data model.
-
Display all SAP R/3 tables in alphabetical
order by table name.
-
Display a subset of tables that
is generated by building a WHERE clause for an SQL query that selects
only the tables that meet your specific search criteria.
Because a large amount
of data generally exists in your SAP R/3 system, searching through
all data to find the tables that you want to use as data sources can
be a lengthy process. You can use the
Subset Tables page to generate a more manageable subset of data so you can more
easily identify your data sources.
Options that display
on this page are determined by whether the metadata location that
you selected in the
SAP Server page contains pre-extracted metadata. If
no metadata is found in the specified location, you can dynamically
access your SAP R/3 system and browse metadata without pre-extracting
that metadata. However, when you are dynamically accessing your SAP
metadata, subset options are limited.
The page contains these
items.
lets you select a method
for navigating or viewing the SAP R/3 metadata in a tree view. Here
are the tree view options.
displays the
Search Metadata for String dialog box. You can use the dialog box to search the SAP R/3 metadata
and generate a subset of SAP R/3 tables that contain a specified search
string. You can search the entire SAP R/3 system for a given text
string and limit the search to tables, entities, and data models.
You can also select other filtering choices. This view option is selected
by default. It is available if you have previously extracted SAP metadata
to the SAP metadata library.
Select SAP Tables By Starting Letter of Table
displays the
Select Tables and Select Folder
Location dialog box. You can use the dialog box to view
the extracted SAP R/3 metadata in an alphabetical tree view that groups
tables by the first letter of the table name. This option is enabled
even if the SAP metadata library that you selected contains pre-extracted
metadata.
Structured View of SAP Tables SAP Data Model Explorer
displays the
SAP R/3 Data Model Explorer page. You can use the page to view the extracted SAP R/3 metadata
in the SAP structured tree view. This option is available if you have
previously extracted SAP metadata to the SAP metadata library.
lets you select a method
for navigating or viewing the SAP R/3 metadata in a list view. Here
are the list view options.
List of All SAP Tables in Alphabetical Order
Subset of SAP Tables Based on Selection Criteria
displays the
Build Expression (WHERE Clause) page. You can use the page to specify selection criteria to use
to generate a subset of SAP R/3 tables. You can then more easily locate
the SAP R/3 tables that you want to use as data sources. You can use
the Build Expression (WHERE Clause) page to specify a WHERE clause
for an SQL query that generates this subset of tables. This option
is enabled even if the metadata location that you selected contains
pre-extracted metadata.
pre-extracts the SAP
R/3 metadata to SAS data sets. Pre-extracting your SAP R/3 metadata
improves performance, and you can perform text-based searches on the
table metadata that you extract. Here is the extract option.
Extract SAP Metadata to SAS Data Sets
displays the
Metadata Extraction Parameters page. You can use the page to specify the metadata that you want
to extract. The extract option is enabled only if you select an SAP
metadata library that does not contain previously extracted SAP R/3
metadata. You can specify the SAP metadata library and location on
the
SAP Server page.
If you choose the
Extract SAP Metadata to SAS Data Sets option, then this
run of the
SAP R/3 Register Tables wizard
creates the SAP metadata library. To use your SAP data in jobs, you
need to run the wizard a second time.