Transfer of nested XML data to BW

[Former Member]

Hi there Experts

I am trying to transfer XML data to BW. I have done the worked example in the “How to … send XML Data to BW” document and it’s all working fine.

The problem with the example is that the data is in a “flat” format without any nested loops. So for one Vendor 4711 and two materials “gizmo” and “widgets” the data structure essentially looks like this:

<DATA>

<item>

<VENDOR>4711</VENDOR>

<MATERIAL>gizmo</MATERIAL>

</item>

<item>

<VENDOR>4711</VENDOR>

<MATERIAL>widget</MATERIAL>

</item>

<DATA>

Now, since we have a fair bit of data, rather than creating one new line (item) for each combination of VENDOR and MATERIAL we want to set up a nested structure in XML that can be read in BW, something along the lines of

<DATA>

<item>

<VENDOR>4711</VENDOR>

<MATERIAL>gizmo</MATERIAL>

<MATERIAL>widget</MATERIAL>

</item>

<DATA>

Unfortunately, all attempts have failed so far to create such a structure and admittedly I know very little about XML to begin with. Any ideas?

Thanks and greetings from Hamburg!

Christian

[former_member619464 · Accepted solution]

Hi Christian,

To transfer Data we have to generate XML Data source. For this XML Data source system generate RFC- Compatable function module with in BW.

Hope it helps...let me know

Regards,

R.Ravi

[Former Member]

Hello there Prathima,

I did encounter the same error on a different system. It turned out that the parser hadn't been installed, I found a reference to this problem somewhere else on this forum. You can download a parser from the Microsoft Website, but I did admittedly found it safer to entrust our administrators with this task.

Hope this helps.

Christian

[Former Member]

Hi ,

You mentioned that you have sucessfully configured to load the XML data into BW.

Even I also tried to configure by refering to the "How to" document, but am not sucessfull. Could you please help me in this regard.

I configured the .dll files, but still am getting the

error "Automation server can't create the object".

Could you send me the step by step procedure..

The operating system we are using is the Windows XP.

Even i searched the SDN, couple of them replied, its not sucessfull.

Thanks in Advance,

Prathima Suram

[Former Member]

According to some SAP documentation (e.g. course notes 310) this cannot be done. They assume that only very limited amounts of data will be transferred this way (e.g. individual transactions), thus rendering a hierarchical data structure unnecessary.

the only way for mass data therefore is to upload data in CSV format as per usual.