This document describes the steps for creating the PI java mapping to handle multiple attachments and create multimapping structure combining each attachment. This also covers use of IOStream to download attachments to application server.
SAP Component Used
SAP PI 7.4 , SAP Netweaver Development Studio 7.3
Version History Version 1.0
Author Ankit Soni
Issue Purpose Initial Version
Date 24/06/14
Page | 2
Table of Contents
1.
General Description ........................................................................................................................... 4
Jar Files Dependency ................................................................................................................ 5
User Guidelines .................................................................................................................................. 6 3.1
3.1.1
Create a new Java Project in NWDS .............................................................................. 6
3.1.2
Include External Jars in Project so that Java class can be compiled ......................... 9
3.1.3
Create a Java Class ......................................................................................................... 11
3.1.4
Enter the Code MultipleAttachment Class .................................................................... 14
3.1.5
Compile and create JAR file ........................................................................................... 17
3.1.6
Add the Java mapping in OM ......................................................................................... 19
3.1.7
Testing the Mapping ........................................................................................................ 20
1. General Description Invoices from external parties are sent as attachments in email to middleware system PI. PI is required to read all the attachments and download them to application server and then create an INVOIC.INVOIC02 IDOC from each XML file and send the path where the XML file was written to a field in IDOC. Currently with standard feature, we cannot handle multiple attachments using mail adapter also file receiver adapter does not have feature to write attachments. This requirement has been achieved by writing a java mapping which reads all attachment from email and generates the multi-mapping structure which is then used in second message mapping to generate IDOCs. Java API’s for PI have been used to access the attachments & set the name of the attachments. IOStream Java classes are used to download the attachments.
SUPPLIERS
SAP PI Mail(Multiple attachments)
SAP ECC One INVOIC02 IDOC per attachment
Page | 4
2. Dependencies 2.1
Dependent Tools
Before using this technical component the following tools need to be installed and configured.
2.2
SAP Netweaver Development Studio 7.3
Jar Files Dependency
In order to develop the module locally on the NW Developer Studio, some PI libraries will be required. These libraries must be included in the external libraries during development.
com.sap.xi.mapping.tool.lib_api.jar
com.sap.xpi.ib.mapping.lib.jar
com.sap.aii.af.ms.ifc_api.jar
Page | 5
3. User Guidelines 3.1
Implementation Steps
A Mail to IDOC scenario should be created first. PI would re ad mail from the Mail server and create m ulti mapping structure from the attachments. This document does not list down details for configuring the scenario; it concentrates more on the steps to build the logic for the java mapping. However it should be ensured that the “keep attachments” option is ticked in the mail sender adapter and also in the operational mapping. This would enable that mail attachments are read and sent as attachments through PI.
3.1.1
Create a new Java Project in NWDS
In SAP NW Developer Studio, follow the below steps: Create a new project by using menu: File → New → Project … Select Java Project. Click “Next ”
Page | 6
Page | 7
Assign project name to Java Project. Java Project Name: MultipleAttachment. Click “Next ”.
Page | 8
3.1.2
Include External Jars in Project so that Java class can be compiled
Add External Jars required Go to “Libraries” tab. Click on “ Add External JARs”. Select the jar files from directory which we extracted. Click “Finish”.
Page | 9
Page | 10
3.1.3
Create a Java Class
Create a Java class extending AbstractTransformation class Right click on “src ” and select New → Class
Page | 11
Assign name to package and Class and select parent class as AbstractTransformation package name: com.sap.multipleattachment class name: MultipleAttachment Click on “Browse” for Superclass Select AbstractTransformation class from the list and click “OK ”. Click “Finish”.
Page | 12
Page | 13
3.1.4
Enter the Code MultipleAttachment Class
Double click MultipleAttachment.java The Java program will be displayed on the right hand panel. Following screenshot shows the code to be written in the java file. Save the file.
Page | 14
Page | 15
Page | 16
3.1.5
Compile and create JAR file
Compile the code and create JAR file. Click on File → Export Select JAR file and click “Next ”. Select the files to be exported. Provide the name for JAR file and click “ Finish”.
Page | 17
Page | 18
3.1.6
Add the Java mapping in OM
Create an Imported archive and add java mapping as first step in OM. Below are the screenshot of OM and second step message mapping after multi-mapping structure is available after java mapping.
Page | 19
3.1.7
Testing the Mapping
Testing Steps: Step1 – A Mail containing three attachments is sent.
Page | 20
Step2 – Mail and three attachments is received by PI System.
The screenshot below shows XML message in PI.
Page | 21
Step3 – Java mapping reads all attachment and download it to application server and generates a multimapping structure. Below screenshot shows files for attachments created on target directory which was passed as parameter to Java mapping.
Step4 – Java mapping creates a node for each XML in multi-mapping structure each of which creates one INVOIC.INVOIC02 IDOC
Page | 22
3.2
Troubleshooting & Error Handling
Following is the list of possible error scenarios and steps to handle them. Type Error Description Troubleshooting/Resolution Steps Exception
IOException
If any exception occurs in the IO stream Code to download attachments, the exception raised in the mapping can be seen in the Message Log. These logs can be viewed for troubleshooting the issue.
Exception
Mapping Exception
The message log can viewed for any exception occurring in the mapping.
4. Reference Code The code used in java mapping has been provided below as an attachment.
