Skip to Content

Introduction to simple(File-XI-File)scenario and complete walk through for starters(Part1)

Here specifics of SLD are not covered.Scenario is simple the csv file is picked up by the file adapter from a business system and posted on to the same system using file adapter.At the end of this scenario I am sure you will be able to challenge with various other complex scenarios.


The Map Designer is a client component of the Design Builder used to develop maps defining input and output specifications and mapping rules that perform data transformation as desired.
The Mapping Object of the Integration Repository uses the definitions of data stored or defined in the data type object (that are created using the Data Type Design editor) to specify the transformation logic in the form of map rules. Map rules operate on input data objects and build output data objects.


Basic Steps for Building the Desired Output Data

Building the desired output data consists of two main steps:

1 Choose the message types in the Mapping Design.

2 Defining the data definitions in the data type editor

Working on the Message Mapping Object

In order to use the Mapping Object, you must already have the data structure that defines your data in the data Type object. The Mapping Object uses the data object definitions that are stored in the Data type Object.

The Mapping Editor is used to:

1.Create maps to specify the logic necessary to transform the input data to the desired output data.

2.Identify the source and data objects of the input data.

3.Validate and resolve the source data type properties defined in the Data Type Object.

4.Identify the target and data objects of the output data.

5.Specify and build the output data according to the rules specified during mapping.

6.View the test results of the map execution.

Create Maps to Specify Sources and Targets

After defining data objects and their properties in the Data Type Editor, define the mapping in the Mapping Objects where you specify the outbound and inbound Data Types.

To create maps using the Map Designer

1 Select the message type source file and the Target file.

2. Specify the logic necessary by using various functions to transform the input data to the desired output data.

3 Map the respective elements

4 Test your maps with Test tab.

Development of all design objects for the Integration Repository at design time

The objects in the Integration Repository are assigned to a product using the software component version and can therefore be shipped with this product.

A data file is a simple example of data. The file consists of records and each
record consists of fields. Three kinds of data objects exist in this data file: a file,
a record, and a field. In a file of records, think of the data in terms of the three
Data objects:
1)Define your Fields FirstName, MiddleName, LastName, Place, City, State, and Country

Samuel,J,Jackson,Lakefront Drive,Earth City,Missouri,USA

Kenny,m,George,North Beauregard street,Alexandria,Virginia,USA

To define this data , create a Data Type in your Integration Repository.
create Three data types:
FileInput, Record, and Row
Define your fields FirstName,MiddleName,LastName,City,Place,State,Country as shown and their respective properties.


The entire contents of your data must be defined. Define the input data so that each data object of the source data is identified. Define the output data according to your output specifications.Here the requirement is output conatins the same fields as the input.

2)Define output data type structure name as FILEOUTPUT_TEST containing the same elements as the input.


3)Create a Message Type comprises a data type that describes the structure of a message.

This is used to refer the message in SAP XI to be exchanged at runtime.specify your datatype name in this case it is FILEINPUT


4)Create a Message Interface to describe interface, which you want to use to exchange messages between application components using SAP Exchange Infrastructure. for a message interface, it can either have the task of sending a request (outbound) or receiving a request (inbound).
This is an outbound interface,where the Output message type is FILEINPUT and attributes are defined as shown.


This is an Inbound Interface where you specify the Input Message type FILEOUTPUT_TEST and the attributes as shown.


A mapping refers to the mapping of interfaces or messages to other interfaces or messages.
You can define mappings for an interface pair (source and target interface) by using message interfaces and message types in the Integration Repository.

5)Create a Message Mapping FILE_TO_FILE which refers to a mapping of messages and is supported by a graphical mapping editor. The editor enables you to design a structure mapping between any two XML structures and connect to a value mapping.

Using the editor which enables you with the drag and drop metaphor,design your mapping by dragging the elements from the source FILEINPUT structure and dropping them on to the elements on the target structure FILEOUTPUT_TEST. load the two message types and define the mapping as shown.


6)Createan Interface mapping FILEINPUT_TO_FILEOUTPUT_NTERFACE.Interface mappings register your mapping program for an interface pair in the Integration Repository.

Enter the source and target interfaces which in this case are FILEINPUT_OB and FILEOUTPUT_IB.

To import the properties of the interfaces, choose Read Interfaces

An interface mapping can only refer mapping programs that belong to the same or an underlying software component version of the interface the mapping program,in this case it is FILE_TO_FILE.


save and activate in the change list where you select your saved objects.Now the status become from Being Processed to Active.


Please Dont forget to follow up the Part-2 for configuration the contents,the Sender and Receiver File adapter in integration directory.

You must be Logged on to comment or reply to a post.
    • Hi,

      There is no need to specify the output format.XI uses XML standard.

      Please elaborate the question if i am not clear.


  • Hi Venkat,

    It is very nice and useful for new commers like me. Can you please tell me what is the difference between record and row in your example.

    Reddy P

    • Hi,

      A record can contain multiple types of substructures identified by logical names.In this case is the row. There can be a fixed or variable number of substructures in a record.


    • Hi Jeniffer,

      sorry for the delay,Plz check if the ftp server is running and also your file adapter status in Runtime work bench.


  • Hello Venkat

    I find this blog very interesting and I´d like to try it myself , but there´s one problem: some links with the pictures are broken, possibly after one of the many migration process that SDN has undertaken (I´ve tryed with Explorer, Chrome); for instance , after the text:

    “Define your fields FirstName,MiddleName,LastName,City,Place,State,Country as shown and their respective properties.”

    I´m only able to see :


    ¿is there any possibility to fix it?

    Thanks in advance