PI Mapping in a certain Format using SOAP Adapter

[Former Member]

Hello Everyone,

i new to PI and my requirement is as

the mail triggered by th PI has format, mentioned below

Matrial Number: 000000000000000000 with the following short description XXXXXXXX,XXXXXXX,XXXXX:00000-0000, Legacy code 000000000000000 and Requester SAP ID ABCDEFG has been sent to ECC.

but i want to break the Body in the below mentioned format

Material Number :

Short Description :

Legacy Code:

Requester SAP ID :

If it is possible, how can this be achived in the Mapping function.

Waiing for your replies

regards,

Abhishek Biwal

[Former Member]

If below are your fixed headers then at target side you can concatenate them using constant function along with their actual value from source.

Example: Let say you are mapping Material Number, then in mapping use the text "Material Number" as constant and concatenate with it's actual value from source by using "Substring" function. The same logic should be implemented for rest of the fields as well.

It will be easy for you if you know the values will always come at certain fiexd position because then you can use Substring from that fixed positon till it's actual length.

[Harish]

Hi Abhishek,

If you are receiving the data in one node from mail server so you can convert into your required format in message mapping.

If the input format is fixed length then you can convert based on length and if CSV then based or separation.

Regards,

Harish

[Former Member]

Hello Harish,

thank you for your reply,

the Details are coming from MDM via PI to ECC

so the records details are in different Tags.

Name in MDM Name in XML

Material No -> Material Code

Description -> Shortdescription

KCM Code -> Legacy Code

MDM Admin -> Noun (From emailid)

Requestor Id in eNOMCAT (SAP ID) -> RequestBy

eNOMCAT Requestor emailid -> VERSIONID (To emailid)

the above are mapped one to one in Message Mapping

in the content Tag i have used concat function, hence i get a a full message rather than in the required message format in different lines

Edited by: Abhishek Biwal on Mar 3, 2011 1:16 PM