Getting Started with SAS/ACCESS Interface to R/3

Exporting R/3 Metadata to SAS Warehouse Administrator

The SAS/ACCESS Interface to R/3 enables you to export metadata from SAP tables to a warehouse environment in SAS Warehouse Administrator.

To export metadata:

From SAS, open the SAS/ACCESS Interface to R/3 to display the SAS/ACCESS to R/3 desktop.
Double-click the Datamodel Explorer icon to display the Datamodel Explorer window.

Datamodel Explorer Window
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.
From the main menu of the Datamodel Explorer window, select File Export Metadata SAS 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
From the Data Warehouse Environment drop-down list, select a pre-defined environment from the SAS/ACCESS to R/3 folder.
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.
Click OK to export the metadata to the selected data warehouse environment in SAS Warehouse Administrator.