Exporting R/3 Metadata to SAS Warehouse Administrator

With SAS/ACCESS Interface to R/3, you can export metadata from SAP tables to a warehouse environment in SAS Warehouse Administrator.
Follow these steps to export metadata.
  1. From SAS, open SAS/ACCESS Interface to R/3 to display the SAS/ACCESS to R/3 desktop.
  2. Double-click the Datamodel Explorer icon to display the Datamodel Explorer window.
    Datamodel Explorer Window
    Datamodel Explorer Window
  3. For this example, click the plus sign (+) for the application data models topic in the Datamodel Explorer. Then, click the plus sign (+) beside the Industry Solutions and Industry Solutions Public Sector subtopics. Click ISPS_HR IS-PS Human Resources to select this subtopic.
  4. From the main menu of the Datamodel Explorer window, select Filethen selectExport Metadatathen selectSAS Warehouse Administrator to display the SAS/ACCESS to R/3: Export Metadata to SAS Warehouse Administrator window.
    SAS/ACCESS to R/3: Export Metadata to SAS Warehouse Administrator Window
    SAS/ACCESS to R/3: Export Metadata to SAS Warehouse Administrator Window
  5. From the Data Warehouse Environment drop-down list, select a pre-defined environment from the SAS/ACCESS to R/3 folder.
  6. From the Operational Data Group drop-down list, select an operational data group from the selected data warehouse environment. The Operational Data Group field is disabled until you select a data warehouse environment.
  7. Click OK to export the metadata to the selected data warehouse environment in SAS Warehouse Administrator.