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