Use the
SAP
R/3 Register Tables wizard to browse through SAP R/3
metadata and select the SAP R/3 tables that you want to use as data
sources in SAS Data Integration Studio. The wizard then creates jobs
that extract the data from the selected SAP R/3 source tables and
loads it into a SAS library.
Follow these steps
to select SAP R/3 metadata for SAS Data Integration Studio using the
wizard.
-
Select
StartProgramsSASSAS Data Integration Studio to
start SAS Data Integration Studio.
-
-
Select
SourcesEnterprise ApplicationsSAP R/3 and click
Next.
-
If you are prompted,
enter the appropriate user name and password to connect to the SAS
application server that enables you to run a SAS session, and click
OK.
-
From the
Configured
SAP Server list box, select the SAP server and
SAP
Metadata Location, and click
Next.
-
Specify the type of
metadata that you want to load into your metadata repository by selecting
one of these options.
Tables
lets you load metadata
for SAP tables and columns into your metadata repository. If you select
this option, click
Next to display the
Subset Tables page
and continue to step 7.
Standard hierarchies or groups
lets you extract data
from standard SAP hierarchies or groups. If you select this option,
click
Next to display the
Hierarchy Type Selection page
and continue to step 10.
-
If you selected the
Tables option
in the
Source Type Selection page, specify
whether you want to search the SAP R/3 metadata or generate a subset
of tables using metadata that you already extracted by selecting one
of the following options. Then click
Next.
SAP Metadata Search
lets you search all
metadata in your R/3 system for a specified text string.
Select SAP Tables by Starting Letter of Table
lets you browse a tree
view of tables sorted alphabetically by table name
Structured View of SAP Tables SAP Data Model Explorer
lets you browse tables
using a data model view of your R/3 system.
List of All SAP Tables in Alphabetical Order
lets you browse a list
of tables sorted alphabetically by table name.
Subset of SAP Tables Based on Selection Criteria
lets you define a WHERE
clause and browse only the tables that meet your search criteria.
Note: The
Select SAP
Tables By Starting Letter of Tables and
Subset
of SAP Tables Based on Selection Criteria are the only
two options that let you dynamically view your SAP R/3 system.
-
Depending on which selection
you make in the
Subset Tables page, one of
these items is displayed.
-
-
-
Select the tables that
you want from the
Search Results tree and
click
to move them to the
Selected Sources tree.
Click
Browse to change the metadata folder
location that is to hold table metadata.
-
-
-
Browse through the data
models to locate the source tables that you want to use.
-
Select the tables that
you want from the
SAP Data Model Explorer list
and click
to move them to the
Selected Tables list.
Click
Browse to change the metadata folder
location that is to hold the table metadata.
-
-
-
-
Select the tables that
you want from the
Available Tables list and
click
to move them to the
Selected Tables list.
Click
Browse to change the metadata folder
location that is to hold the table metadata.
-
-
-
Select the tables that
you want from the
Available Tables list and
click
to move them to the
Selected Tables list.
Click
Browse to change the metadata folder
location that is to hold the table metadata.
-
-
If you selected the
Standard
hierarchies or groups option in the
Source Type Selection page,
specify the type of hierarchies or groups that you want to extract
and click
Next. The
Set Selection page
is displayed.
-
-
On the
Options
for Set Extraction page, specify the date that is associated
with the data that you want to extract. Also, specify whether you
want to add parent-child relationships and source system IDs. Then
click
Next.
-
Specify the name, location,
and file options for the SAS data set where the set or hierarchy data
is to be saved and click
Next. The
General Properties page
is displayed.
-
Enter the metadata name,
description for the table, and folder location in the metadata repository
and click
Next. The
Wizard Finish page
is displayed.
-
Review the metadata
about the tables to be registered with the metadata repository. When
you are finished with your selections, click
Finish to
write the metadata to the metadata repository. If an error occurs,
the SAS log is displayed.