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
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 mapping.select 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.