Extract SAP R/3 Metadata to SAS Datasets Page

Use the Extract SAP R/3 Metadata to SAS Datasets page in the Extract from R/3 wizard to specify which metadata you want to extract and to identify the location of the SAP R/3 metadata library. The SAP R/3 metadata library is the location into which the SAP R/3 metadata is saved. The extracted metadata is saved in SAS data sets in this library.
You can also use the Extract SAP R/3 Metadata to SAS Datasets page to specify the following extract options:
  • whether you want to overwrite existing metadata or append newly extracted metadata to the existing metadata.
  • whether you want to exclude structures, maintenance views, and help views when extracting the SAP R/3 metadata.
  • whether you want to extract field metadata only for the tables for which metadata has already been extracted. This option applies only if you have previously extracted metadata.
The Extract SAP R/3 Metadata to SAS Datasets page in the Extract from R/3 wizard contains the following items:
Metadata Library
enables you to verify the SAP R/3 metadata library, which is the library into which the SAS data sets are written, and to specify whether you want to overwrite or append to any existing data sets that are in the SAP metadata library. This library is selected in the previous window, which is the SAP Server page. The Metadata Library group box contains the following items:
Selected Path
displays the physical location of the directory that you defined as the SAP R/3 metadata library.
Merge into Existing Metadata
enables you to specify whether you want to overwrite any existing SAS data sets in the SAP metadata library. If this is selected, the existing metadata is overwritten. If this is not selected, metadata is appended to the existing SAS data sets in the SAP R/3 metadata library.
Note: When using the SAP R/3 Register Tables wizard to extract metadata, this check box is disabled if the metadata library that you selected on the SAP Server page is empty.
Select the type of Metadata to extract
enables you to specify which SAP R/3 metadata you want to extract to SAS data sets and set extract options for the extraction process. The Select the type of Metadata to extract group box contains the following items:
Tables
specifies whether you want to include table metadata when you extract metadata from your SAP R/3 System. If this is selected, then table metadata is included.
Fields
specifies whether you want to include field metadata when you extract metadata from your SAP R/3 System. If this is selected, then field metadata is included.
Data Models and Entities
specifies whether you want to include metadata about the SAP data models and entities when you extract metadata from your SAP R/3 System. If this is selected, data model and entity metadata is included.
The Extract SAP R/3 Metadata to SAS Datasets page in the Extract from R/3 wizard contains the following buttons:
Table Ranges
displays the Table Ranges to Extract dialog box. You can use it to limit the SAP R/3 tables that are included in the extraction process.
Note: This button is enabled only if you select the Tables check box.
Options
displays the Options dialog box so that you can specify extract options such as whether to exclude structures, maintenance views, and help views when extracting the SAP R/3 metadata and whether you want to extract field metadata only for the tables for which metadata has already been extracted.
View selections
displays the Metadata Extract Selection dialog box so that you can view all metadata selections and extract options that you have specified in the Extract SAP R/3 Metadata to SAS Datasets page.