In this first example, our goal is to create and fill in a master data InfoObject. Set up a new data flow and create an OleDB source that reads the product table. Link the pipeline with a BW Loader target (after setting up the connection manager to SAP):
Now you can open the editor of the BW Loader. Click the New button for the InfoSource.
Select Master Data in the following dialog window.
Now a dialogue window will open in which an InfoSource can be set up. This InfoSource should be based on a master data InfoObject that does not yet exist. For this purpose, click the Create New InfoObject button.
Enter the name of the InfoObject (ZPROD) here and click the CHAR data type (with a length of 20). In addition, short and long texts are to be filled here later, which are language dependant, and the InfoObject will have master data:
Our products also have another attribute: their color. This attribute has to be added to the ZPROD InfoObject. The color attribute can be newly created by clicking the Create New Attribute button. The screenshot below shows the ZCOLOR InfoObject to be created; it has no master data, but allows lower case characters (see above right).
Now the ZPROD InfoObject is complete and can be saved and activated. The program returns to our original InfoSource setup. Some specifications still have to be made here (see screenshot). Then the InfoSource can also be saved and activated. Apart from creating an InfoSource, transfer rules for the selected source system are also created here.
In our last step, we still need an InfoPackage, which you can create in the main template with the Create New InfoPackage button. The InfoPackage is based on the previously created InfoSource.
Back in the main template, the following tasks now have to be completed: Definition of the technical access parameters for the source system and mapping of the pipeline elements to the InfoPackage’s transfer structure. The main template should look like this when you’re done:
Now the upload can be started in debug-mode. In the monitor in transaction RSA1, the upload will look like this: