Define a Target and Create a Job Using the New SAP BW Wizard

Preparation
Task Summary
Next Tasks

Preparation

To load external source data to SAP BW, you must first register the source data with the Register Tables wizard in SAS Data Integration Studio—whether it is from SAP BW, SAS, a DBMS, or another source. If you use SAP BW source data, you must register the tables that you want to process in the SAP BW Register Tables wizard before you complete the steps described in this topic. For more information about registering SAP BW source data, see Overview.
An important step in this process is to choose the InfoPackage that you plan to update. Use the selected InfoPackage to create a new external file object that you can load to SAP BW by using the job that the wizard creates.
When selecting the InfoPackage on the InfoPackage Browser page of the wizard, you can right-click the InfoPackage to review detailed information about it. SAP BW objects are grouped by application component. InfoSources are grouped as Characteristic and Transactional InfoSources. The InfoPackage Browser lists only those InfoSources that contain InfoPackages.

Task Summary

Follow these steps to define a target and create a job using this wizard.
  1. Select Newthen selectSAP BW to start the New SAP BW wizard. The SAP Server page is displayed.
  2. From the Configured SAP Server list box, select the configured SAP server that you can use to connect to your SAP BW system. Click Next.
  3. If you are prompted, enter the appropriate user name and password to connect to the SAS application server that you can use to run a SAS session. Click OK.
  4. The InfoPackage Browser page displays a list of available InfoPackages. You can either enter a search term or drill down in the list to find the data that you need. When you have selected the proper InfoPackage, click Next. The General Information - External File page is displayed.
  5. Enter a metadata name for the external file in the File name field. Click Browse to change the default metadata folder location for the file metadata and click Next to continue. The External File Location page is displayed.
  6. In the File name field, enter the path to the storage location for the external file that the InfoPackage metadata provides. The value that you enter in this field should match the value that you defined in the InfoPackage. Click Next. The General Information - Job page is displayed.
  7. Specify a name for the job in the Job Name field. Click Browse to change the default metadata folder location for storing the job. Click Next. The Wizard Finish page is displayed.
  8. Review the metadata about the job and external file object. After you make your selections, click Finish to register the job and the external file. The Schedule InfoPackage transformation might be added at the end of the process flow, depending on the settings of the InfoPackage.
  9. Open the job. You can now connect a registered source table to the input port of the SAP BW File Writer transformation. Next, right-click the SAP BW File Writer transformation and select the Properties option.
  10. Select the Mapping tab. If the source table is not properly mapped to the target table, complete the mapping process manually by linking each row in the source table to the row with a similar name in the target table.
  11. When you have mapped the rows as you want them, click Apply and then OK to exit the Properties window for the SAP BW File Writer transformation.
  12. Right-click the Schedule SAP InfoPackage transformation and select the Properties option. Select the Options tab to review the InfoPackage Name and SAP Library values.
  13. Click OK to exit the Properties window for the Schedule SAP InfoPackage transformation.
  14. Run the job.

Next Tasks

You can review the data that is loaded into the target table by right-clicking the .csv file and selecting the View Data option. You should also check the log to make sure that the job ran properly.
For a job that is scheduled to be loaded to SAP BW with a Schedule SAP InfoPackage transformation, the next-to-last entry in the log should confirm that a REQUESTID was generated for the load. The final entry in the log should also suggest that you check the status of the data load by passing the REQUESTID to an SAP administrator.
For a job that is not scheduled to be loaded to SAP BW, an SAP administrator needs to schedule it from within SAP.

See Also

Overview
New SAP BW Wizard Example: Uploading External File Data to SAP Using InfoPackage Metadata
Copyright © SAS Institute Inc. All rights reserved.