topic Re: Table type/structure to XML in Application Development and Automation Discussions

Table type/structure to XML

Former Member — Thu, 09 Apr 2009 09:00:14 GMT

Hi Everyone

I would like to Export a u201CTable Typeu201D to XML or any other readable format. I need to send the SE11 structure of the Table/Structure to a 3rd party vendor so they can create the table on there side.

Can any one give me a Function module or Class that will download the Table type/Structure to a readable format.

Thanks in advance

Re: Table type/structure to XML

Former Member — Thu, 09 Apr 2009 09:14:00 GMT

Why don't you take a dump from table DD03L. This table contains information about Table fields, their length, data type position and key field information etc.You can download them to any format you want from Table content(SE16) output screen by menu path System->List->Save->Local file.

Hope it helps.

Regards,

Re: Table type/structure to XML

uwe_schieferstein — Thu, 09 Apr 2009 09:17:58 GMT

Hello Wian

Fm DDIF_FIELDINFO_GET returns all metadata of a DDIC structure (alternatively you may use RFC_GET_NAMETAB or DD_GET_NAMETAB_FOR_RFC).

You can convert the itab data (DFIES or X031L) into an XML using CALL TRANSFORMATION.

Or you may have a look at function group SDIXML (available on ERP 6.0).

Regards

Uwe

Re: Table type/structure to XML

Former Member — Thu, 09 Apr 2009 09:35:13 GMT

Hi Guys

Thanks for your replys

The problem is that table and structures I would like to send to the 3rd party guys is nested with other table types and structures. These functions and DD03L table does not display the nested table but only the first level.

If the table was rather simple then I would run the Functions for the nested structures and put all the fields together manualy but the problem is that the table is very complex and I will change a lot over time depending on requirements. Therefore I need some sort of automated solution.