Select SAP R/3 Metadata and Create Extraction Jobs Using the SAP R/3 Register Tables Wizard

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 SAP R/3 Register Tables 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 SAP R/3 Register Tables wizard:

Select StartProgramsSASSAS Data Integration Studio to start SAS Data Integration Studio.
Select FileRegister Tables. The Register Tables wizard displays.
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.

The SAP Server page displays.
From the Configured SAP Server list box, select the SAP server and SAP Metadata Location, and click Next.

The Source Type Selection page displays.
Specify the type of metadata that you want to load into your metadata repository by selecting one of the following options:
- Tables; it enables you to 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; it enables you to 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 have already extracted by selecting one of the following options, and then click Next.
- SAP Metadata Search; it enables you to search all metadata in your R/3 System for a specified text string.
- Select SAP Tables by Starting Letter of Table; it enables you to browse a tree view of tables sorted alphabetically by table name.
- Structured View of SAP Tables SAP Data Model Explorer; it enables you to browse tables using a data model view of your R/3 System.
- List of All SAP Tables in Alphabetical Order; it enables you to browse a list of tables sorted alphabetically by table name.
- Subset of SAP Tables Based on Selection Criteria; it enables you to define a WHERE clause and browse only the tables that meet your search criteria.
For more information about these options, see Subset Tables Page.

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 enable you to dynamically view your SAP R/3 System.
Depending on the selection you make in the Subset Tables page, you will see one of the following items.
- Follow these steps if the Search Metadata for String dialog box displays:
  
  Enter the desired search criteria and select OK. The search results are displayed on the SAP R/3 Metadata Search page.
  
  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 will hold the table metadata.
  
  Click Next to display the Wizard Finish page.
- Follow these steps if the Export SAP Data Model, Select Tables, and Select Folder Location page displays:
  
  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 will hold the table metadata.
  
  Click Next to display the Wizard Finish page.
- Follow these steps if the Build Expression (WHERE Clause) page displays:
  
  Define the desired WHERE clause in the Expression Text field and click Next to display the Select Tables and Select Folder Location page.
  
  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 will hold the table metadata.
  
  Click Next to display the Wizard Finish page.
- Follow these steps if the Select Tables and Select Folder Location page displays:
  
  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 will hold the table metadata.
  
  Click Next to display the Wizard Finish page.
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 then click Next.

The Set Selection page displays.
Select the specific set or hierarchy that you want to extract and click Next.

The Options for Set Extraction page displays.

Note: The fields that are enabled on the Set Selection page depend on the selections that you made on the Hierarchy Type Selection page.
On the Options for Set Extraction page, specify the date that is associated with the data you want to extract and whether you want to add parent-child relationships and source system IDs. Then, click Next.

The SAS Destination page displays.
Specify the name, location, and file options for the SAS data set in which the set or hierarchy data will be saved and click Next.

The General Properties page displays.
Enter the desired metadata name, description for the table, and folder location in the metadata repository and then click Next.

The Wizard Finish page displays.
Review the metadata about the tables to be registered with the metadata repository. When you are satisfied with your selections, click Finish to write the metadata to the metadata repository.

If an error occurs, then the SAS log displays.