XSLT transformation for XML to ABAP internal table

[Former Member]

Hi, can anyone please tell me how it should be the xslt tranformation to conver this xml

<Embargos_ARBA_DOC>

<ns:Embargos_ARBA_MT

xmlns:ns="un:swissmedical:sap:proxy:embargos_arba:file">

<Embargos_ARBA_MT>

<FECHA>20081101</FECHA>

<CUIT>50000002124</CUIT>

<MONTO>0000013794090</MONTO>

<RAZON_SOCIAL>RAUL ARMANDO CUNQUEIRO S.A.C.I.</RAZON_SOCIAL>

</Embargos_ARBA_MT>

<Embargos_ARBA_MT>

<FECHA>20081101</FECHA>

<CUIT>55000001456</CUIT>

<MONTO>0000001144410</MONTO>

<RAZON_SOCIAL>PARODI ESTEBAN ARMANDO</RAZON_SOCIAL>

</Embargos_ARBA_MT>

</ns:Embargos_ARBA_MT>

</Embargos_ARBA_DOC>

to this abap Table....

DATA: BEGIN OF i_embargos_arba_doc occurs 0,

fecha TYPE d,

cuit TYPE char11,

monto TYPE char13,

razon_social(120),

END OF i_embargos_arba_mt.

so i can transform it with this sentence

CALL TRANSFORMATION ('embargos_transformation')

SOURCE XML source

RESULT Embargos_ARBA_DOC = embargos.

pls i need help because i am unable to create this xslt transformation...

I will give the highest rewards points to the one who can help me.

thanks!

mariano

[Former Member]

Hi Mariano

Why you need to use XSLT for transforming XML file into ABAP table

Code is a part of some ABAP report. Looks like it is reading a file from file system and updating table after transformation

If you have requirement like you need to read XML file and then insert the data into a SAP table

You can use

File to RFC

File to Proxy scenario using SAP PI.

Please provide more inputs on requirement to help

Thanks

Gaurav

[Former Member]

Hi, i am using a File to Proxy interface, but i am using an abap Mapping, because i need to filter the data i want to send to ECC, to do that I am calling a Function via RFC to ECC and that is the reason to use abap mapping.

However i already solve it, i did some research on XSLT transformations for abap mapping and it works great!.

Regards.

Mariano.