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, then you will need to 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 on registering SAP BW source data, see Overview.
An important step in this process is to choose the InfoPackage that you will update. You will use the selected InfoPackage to create a new external file object that you can load to SAP BW by means of 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. Note that the SAP BW objects are grouped by application component. InfoSources are grouped as Characteristic and Transactional InfoSources. The InfoPackage Browser lists only the InfoSources that contain InfoPackages.

Task Summary

  1. Select Newthen selectSAP BW to start the New SAP BW wizard.
    The SAP Server page displays.
  2. From the Configured SAP Server list box, select the configured SAP server that enables you 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 enables you to run a SAS session. Then 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 displays.
  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. Then, click Next.
    The External File Location page displays.
  6. In the File name field, enter the path to the storage location for the external file that is provided by the InfoPackage metadata. The value entered in the field should match the value defined in the InfoPackage. Click Next. The General Information - Job page displays.
  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 displays.
  8. Review the metadata about the job and external file object. When you are satisfied with your selections, click Finish to register the job and the external file. Note that the Schedule InfoPackage transformation might be added at the end of the process flow, depending upon 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 the rows mapped the way that want them, click Apply. Then click 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. 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 has been generated for the load. The final entry in the log will also suggest that you check the status of the data load by passing the REQUESTID to an SAP administrator.
A job that is not scheduled to be loaded to SAP BW will need to be scheduled by an SAP administrator from within SAP.

See Also

Overview
New SAP BW Wizard Example: Uploading External File Data to SAP Using InfoPackage Metadata