In the previous section, we created a master data InfoObject while specifying that there are language-dependent texts. These are located in the ProductText table.

Create a new data flow (or a new package), prepare the connection manager and define an OleDB source for the ProductText table. Now define a BW Loader target and draw the pipeline to the target.

BWLoader-Text-01

As all necessary BW objects have been already created in the last section. Now create a new InfoPackage by clicking Create New InfoPackage button. The dialog should be filled in as follows:

BWLoader-Text-02

Because we already specified in the ZPROD setup that there are language dependent short and long texts, the transfer structure is already built accordingly. Now only the pipeline elements have to be mapped to the transfer structure elements, as shown in the following screenshot:

BWLoader-Text-03

A test run uploads the texts to the BW. The following screenshot now shows the RSA1 transaction. We can see very nice here how both InfoPackages for the attributes and texts are displayed under the ZPROD InfoSource. The XTRACTSYS source system forms the transfer layer. Depending on the release you are using, this screenshot might look different.

BWLoader-Text-04

The following screenshot shows the contents of the PSA table after posting. In an Unicode system, any fonts can be posted (e.g. Japanese).

BWLoader-Text-05