cancel
Showing results for 
Search instead for 
Did you mean: 

SAP PI Mapping to get out xml tags included in xml tag

davidschievers
Participant

Hi all,

we are receiving the follwoing message in SAP PI/ PO:

<E1IDOCENHANCEMENT SEGMENT="1">

<IDENTIFIER>000005990000122022</IDENTIFIER>

<DATA><ZE1WBBP SEGMENT="1"><MSTAE>20</MSTAE><WGBEZ>MTDUJ_T-Shirts</WGBEZ><MATKL>102330702</MATKL><SD_STORE_FROM>20231116</SD_STORE_FROM><SD_STORE_TO>20230820</SD_STORE_TO><SD_DLDT_FROM>20231116</SD_DLDT_FROM><SD_DLDT_TO>20230820</SD_DLDT_TO><SD_ORDT_FROM>20230818</SD_ORDT_FROM><SD_ORDT_TO>20230819</SD_ORDT_TO><STAWN/><HERKL>CN</HERKL><FSH_MG_AT2/><LADGR>Z005</LADGR><FIBER_CODE1>CO</FIBER_CODE1><FIBER_PART1>100</FIBER_PART1><FIBER_CODE2/><FIBER_PART2/><FIBER_CODE3/><FIBER_PART3/><FIBER_CODE4/><FIBER_PART4/><FIBER_CODE5/><FIBER_PART5/></ZE1WBBP></DATA>

</E1IDOCENHANCEMENT>

The task is to get out the tags in the DATA tag into the following structure:

Do you know if there is a way to archive this with graphical mapping?

Regards
David

fprokopiuk
Active Participant
0 Kudos

Aren't those the same structures? You can simply map it one to one.

Accepted Solutions (0)

Answers (2)

Answers (2)

javier_alonso
Participant
0 Kudos

The problem is that there is an inner escaped XML.

You need XSLT or JAVA Mapping to unescape the XML RAW string and then map it to your message type.

The following links might help you.

davidschievers
Participant
0 Kudos

Hi,

unfortunately, not. Somehow the data is received the following way on by the PI:

And we are not able to get the Tag which are in “DATA” separate.

Regards
David