Creating an XML DataSource 

Use

An rfc-capable function module is generated with the XML DataSource that is required to push the data into SAP BW. You can also activate the data transfer to the delta queue – which is the inbound queue for the data push into SAP BW - for the XML DataSource.

Prerequisites

You have connected a file system to SAP BW as the source system.

Procedure

You are in the Modeling InfoSource tree of the Administrator Workbench.

...

       1.      Choose InfoSources → Your Application Component → Context Menu (secondary mouse click) → Create InfoSource...

       2.      Create an InfoSource with flexible updating (see Flexibly Updating Data from a Flat File).

Flexible updating is a prerequisite for being able to set up the delta process for the file DataSource and being able to write the data to the delta queue.

       3.      Assign the file system as the source system to the InfoSource after activating the communication structure.

The system generates a file DataSource with the same technical name as the InfoSource and assigns it to the InfoSource. The system also generates a proposal for the transfer structure and the transfer rules.

       4.      Change the transfer structure or the transfer rules where necessary.

       5.      Activate the transfer rules.

The transfer structure and the DataSource are then likewise activated.

When the transfer rules are activated, the menu option Extras → Create BW DataSource with SOAP Connection becomes active. Once you have activated the file DataSource you can create the XML DataSource.

If you want to use a file DataSource that already exists, is not active or is not in the SAP namespace, the XML DataSource cannot be generated. You cannot generate an XML DataSource if the file DataSource is not active or if the file DataSource is in the SAP namespace.

       6.      In the InfoSource menu, choose Extras → Create BW DataSource with SOAP Connection

The system generates the XML DataSource in its own namespace (<xml-datasource> = 6A<file-datasource>). The extraction structure is suitably generated for the file DataSource transfer structure. The field selectability and the XML DataSource delta process are likewise based on the file DataSource. The new DataSource is replicated and is assigned in the Administrator Workbench source system tree to the myself BW System in the Delta Queue application component under Business Information Warehouse.

For the XML DataSource, the system generates the RFC-compatible function module - matching the extract structure -  which runs the data update in the delta queue.

       7.      Assign the XML DataSource to the InfoSource.

You get to the transfer rules maintenance screen. The system automatically makes a proposal for the transfer rules on the basis of the file DataSource.

       8.      Activate the transfer rules.

Result

The XML DataSource with the generated function module for transferring data to the SAP BW is available to you.

Now you can activate data transfer to the delta queue for the DataSource and from now on, you can send data to SAP BW that is then written to the delta queue.