Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Flat File to XML :: Multiple sub-structure issue

Hi

My scenario is to convert the Flat file into XML file. Flat file is having variable number of substructures for Recordset Structure.

Now when I am giving <i>Recordset Structure as Student,1,Sub1,3</i>. I am getting the XML payload.

But when I am using <i>Recordset Structure as Student,1,Sub1,*</i>. File is picked up by the adapter but nothing in RWB & MONI, which suggest that file is not even coming to XI.

The other parameters I am using are :

<i>Sub1.keyFieldValue "subject"

Student.keyFieldValue "stud"</i>

In short when I am giving an exact number of sub-structures the XML file is coming but not in case when I am using <b>*</b>. Pls. suggest what can be the issue.

I already checked the following weblog /people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30 . All the settings are same.

Best Regards

- lalit chaudhary -

Former Member
Former Member replied

Hi,

i tried ur scenario,initially i had the same experience as u had.when i made these specific changes it worked.

try giving the stud.keyFieldvalue and subjetc.keyFieldValue without quotes

ie.,

stud.keyFieldValue stud(instead of "stud")

subject.keyFieldValue subject(instead of "subject")

this is how i defined the parametrs

student.fieldNames give ur field names

student.fieldSeparator :

student.keyFieldValue stud

subject.fieldNames specify ur field names

subject.fieldSeparator :

subject.keyFieldValue subject

try giving the keyfieldvalues without quotes("").

regards

jithesh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question