Overview

Use the SAP R/3 Register Tables wizard in SAS Data Integration Studio to access data in your SAP R/3 system. You can use it to perform these tasks:
  • Browse SAP R/3 table metadata.
  • View SAP R/3 table data.
  • Extract SAP R/3 table metadata or create a job that you can use to extract SAP R/3 hierarchy or group metadata to SAS data sets.
After you use the Extract from R/3 wizard, you can use the SAP R/3 Register Tables wizard to perform these tasks:
  • Select which data sources you want to use in SAS Data Integration Studio.
  • Write metadata about those data sources to your metadata repository.
As an alternative, you can extract metadata by using the SAP R/3 Register Tables wizard to dynamically access your SAP R/3 system. In this case, you can view metadata for a subset of SAP R/3 tables or create a job to extract metadata from SAP R/3 hierarchies or groups at a later time.
Using metadata that was previously extracted to SAS data sets improves performance. It also lets you perform text-based searches on the table metadata that has been extracted.
Because the SAP R/3 Register Tables wizard provides View access to SAP R/3 metadata, here are the benefits to you:
  • You can know more about your SAP R/3 data.
  • You have better access to data that is stored in SAP R/3 tables and columns.
  • You can use the analytical power of SAS Data Integration Studio to further analyze your SAP R/3 data.