Integrating SAP with Oracle database

[Former Member]

Hi Experts,

I need to integrate SAP system with Oracle database.

I have to extract the data from 3 tables of SAP.

Assume table1 having 3 fields,table2 having 2 fields,table3 having 4 fields, total 9 fields.

But here Instead of extract data from 3 tables,SAP side they r creating one z-table(custom) having only 1 field.

In that field they r providing data of 3 table fields in xml format data.

we have to extract that xml format data from z-table(that xml format data having all 9 fields data of SAP).

how can i achive that.

thanks,

sreedhar goud

[Former Member]

Hi,

This could be pretty straight forward scenario as you need to get the values from XML structre. This you could achive using various syntax in ABAP code only.

Or else You could generate the flat file with this XMl data and could be able to read to via XI. But this will be long process better option to add the logic in ABAP code to read the XML structure.

In any XML structure, the data will as

<field1>XYZ</field1>

<field2>AAA</field2>

<field3>BBB</field3>

Now the values of field1, field2 and field3 can be get by substring between <field1> & </field1>.

You need to add ABAP logic to procee this way.

Thanks

swarup

[Former Member]

first of all... is it possible 2 store data into r/3 tables in XML format?

[Former Member]

Yes this is possible..you might want to check your database config for this..

asas

[Former Member]

k

[Former Member]

hi sreedhar,

is this solved.

can u share ur experiences on this.

thanks,

kiran

[Former Member]

hi kiran,

it is not yet solved.We r working on that.

thanks,

sreedhar

[Former Member]

Hi,

You can achive this very easily using ABAP code.

one more suggession , why complecate the thing by create one z table having one field?

design the z table as per requirement, which can give you comfort in maintanance.

Regds,

[Former Member]

hi,

Can u please tell me how can i achive this using ABAP code?

Sreedhar.

[Former Member]

i wonder if this possible?

storing of values of a field in XML format???

intresting.. i look forward...

thanks

kiran