|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
XI - File Content Conversion
By Punit J, YASH PI Competency Team, Yash Technologies
Description: File Content Conversion is used
to convert non-XML file (flat file) to XML file and vice-versa. In this blog, we
will see how to convert flat file to XML file when file structure is bit
complex. For example, when same columns shows different information in different
Business Case: Let’s take an example with file
shown below. The file contains employee details. First row contains Header
information of Employee (Employee ID and Name), Second and Third row contains
his weekly details (Week No, Working Hours in the Week and Wage for the Week),
there can be n number of rows for weekly details and Last row contains Employee
Monthly Summary (Total hours worked and Total Wage).
Find below the step-by-step procedure to achieve this
on Integration Repository side.
1. Create Data Type.
Here I have added a filed Key in all the records, we will
discuss about this field while configuring Sender File Adapter.
Create Message Type.
Create Message Interface for Sender and Receiver. In this scenario I am
using same Message Type for both Sender and Receiver as we are converting flat
file to XML file.
4) Create Message Mapping.
Here we don’t have to map the field ‘Key’.
5. Create Interface Mapping.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards