Extract SAP R/3 Metadata Using the SAP R/3 Register Tables Wizard

If no SAP metadata was previously extracted, use the SAP R/3 Register Tables wizard to extract SAP R/3 metadata to SAS data sets. This is similar to how the Extract from R/3 wizard in SAS Management Console works.
When you pre-extract metadata and view it in the SAP R/3 Register Tables wizard, it improves performance when you browse the SAP R/3 metadata. If you pre-extracted metadata, you can also perform text-based searches on the tables for which you extracted metadata.
Follow these steps to extract SAP R/3 metadata into SAS data sets using the SAP R/3 Register Tables wizard.
  1. Select Startthen selectProgramsthen selectSASthen selectSAS Data Integration Studio to start SAS Data Integration Studio.
  2. Select Filethen selectRegister Tables to start the Register Tables wizard. The Register Tables page is displayed.
  3. Select Sourcesthen selectEnterprise Applicationsthen selectSAP R/3 and click Next.
  4. If you are prompted, enter a user name and password to connect to the SAS application server that lets you run a SAS session and click OK. The SAP Server page is displayed.
  5. From the Configured SAP Server list box, select the SAP server that enables you to connect to your SAP R/3 system and click Next. A Metadata Not Found warning dialog box is displayed.
    Tip
    If you do not see this warning dialog box, this procedure cannot work because the SAP metadata library location has information from a previous extraction.
  6. Click Yes on the warning dialog box to continue. The Source Type Selection page is displayed.
  7. Select Tables and click Next. The Subset Tables page is displayed.
  8. Select the Extract SAP Metadata to SAS Data Sets option and click Next.
  9. In the Select the type of Metadata to extract group box, specify the types of metadata that you want to extract from your SAP R/3 system. If you select the Tables check box, you can click Table Ranges and specify a range of tables to extract. You can also click Options and specify other extraction options, such as whether to extract structures, maintenance views, and help views.
  10. Click View selections to display the Metadata Extract Selection dialog box, where you can view all metadata selections and extract options that you have specified. Click OK to return to the Metadata Extraction Parameters page and then click Next. The Save SAS Source Code page is displayed.
  11. If you want to save the SAS program to reuse in the future, click Browse and select a filename. Click Next. The Wizard Finish page is displayed.
  12. Review the metadata extraction selections that you have made. When you are satisfied with your selections, click Finish to write the metadata to SAS data sets in the specified metadata location.
After the extraction is complete, you can use the SAP R/3 Register Tables wizard again to browse the extracted metadata and load table metadata into the repository. For more information, see Select SAP R/3 Metadata and Create Extraction Jobs Using the SAP R/3 Register Tables Wizard.

See Also

Extract SAP R/3 Metadata Using the Extract from R/3 Wizard
Copyright © SAS Institute Inc. All Rights Reserved.