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

If no SAP metadata has been previously extracted, use the SAP R/3 Register Tables wizard to extract SAP R/3 metadata to SAS data sets similar to the way the Extract from R/3 wizard in SAS Management Console works.
Pre-extracting the metadata and then viewing it in the SAP R/3 Register Tables wizard improves performance when browsing the SAP R/3 metadata. If you have pre-extracted the 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 displays.
  3. Select Sourcesthen selectEnterprise Applicationsthen selectSAP R/3 and click Next.
  4. 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.
  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 displays.
    Tip
    If you do not see this warning dialog box, then this procedure will not 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 displays.
  7. Select Tables and click Next.
    The Subset Tables page displays.
  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, and click OK to return to the Metadata Extraction Parameters page. Click Next.
    The Save SAS Source Code page displays.
  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 displays.
  12. Review the metadata extraction selections 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.
Note: After the extraction is complete, you can then 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.