How the DT should be for File sender

[Former Member]

Hi,

I have a follwiing XML file and I need to create a data type. how would be the strcture of the DT should be?

Req

...Type

...A

......Name

......City

.../A

...B

......region

.../B

....C

......Parameters

........parameter

..........name

..........value

........./parameter

........parameter

..........name

..........value

........./parameter

........parameter

..........name

..........value

........./parameter

........parameter

..........name

..........value

........./parameter

........parameter

..........name

..........value

........./parameter

......./Parameters

..../C

/Req

The follwing node is repeting... Do I need to create the DT same as the above strcuture?

........parameter

..........name

..........value

........./parameter

Thanks

Rajeev

[Former Member · Accepted solution]

This is simple one.. just create like this..

Req 1:1
...Type       0:1
...A            0:1
......Name
......City
.../A
...B          0:1
......region
.../B
....C 
......Parameters 0:1
........parameter 0:unbound
..........name
..........value
....../Parameters
..../C
/Req

[Former Member · Accepted solution]

Hi,

How should FCC parameters will be?

Recordset strcuture: Req 1,A 1,B 1, C* ??

Thanks

Rajeev

[Former Member · Accepted solution]

Hi Raajeev,

Check this links

https://wiki.sdn.sap.com/wiki/display/XI/XI_File_Content

https://wiki.sdn.sap.com/wiki/display/XI/File%2bcontent%2bto%2bFile%2bcontent%2bdata%2bconversion

Check this link for predefined module

/people/gabrielsagayaselvam.panneerselvam/blog/2009/08/31/solve-key-field-problem-using-structplain2xml-in-messagetransformationbean

Regards

Ramesh

[Former Member · Accepted solution]

It should be something like this..

> Recordset strcuture: Req 1,A 1,B 1, C 1, Parameters 1, Parameter *

BTW any specific reason for having deep hierarchy.

--Sarvesh

[former_member200962]

Have your Datatype format as shown below:

Have the occurence accordingly....

Looking at your requirement every node from Req to Parameters may have occurence as 0..1

Parameter will have 0..unbounded

Name and Value will again have 0..1

Req

->Type

-->A

--->Name

--->City

-->B

--->Region

-->C

--->Parameters

-

---

>Parameter

-

---

>Name

-

---

>Value

Regards,

Abhishek.

Edited by: abhishek salvi on Sep 1, 2009 7:31 PM