Finding Message id based on delivery number in sap pi Dual stack system

om

Real time scenario

Delivery number given by other non sap team.

Need to check whether the message is processed in xi/pi side or not.

Steps to check

Step1:

Step2:

Step3:

Step4:

Step5:

By seeing port it is a dual stack system.

Step6:

 checking is not possible with IDOC number

Step7:

 So Take message id in details Tab

Step8:

 Pstee message id in Dual stack system in SXMB_MONI

Step9:

 Click on execute

Step10:

 By seeing Message Flag Message Processed Successfully.

Step11:

Step12:

Finally verified message processed Successfully

Xls to Xml conversion and real time use

om

Steps to create .XML from .xls XML data file

Step 1:

Sample xls file with XML tabular data

Step 2:

Click on Office button on top right corner

then save as other formats

Step 3:

Save the file in desired location

Step 4:

click on continue button

Step 5:

converted xml file

Step 6:

Open the xml file with notepad ++

Our desired XML format is obtained.

Scenarios faced in real-time:

• Client sent  xls file in mail attachment.It contains xml data
• To test inbound proxy scenario in sap pi
• I need XML file to test in the sap
• I tried many online tools won't work
• Finally I converted the xls file to XML based on above steps and I Successfully converted xls file to xml and tested in proxy scenario.

Xml to Xls xml tabular format conversion

om

Steps to convert Xml data to .xls format

Step1:

Sample Xml file

Step2:

Open the excel blank document,

Step3:

Drag the sample xml file into excel book

Step4:

Select the radio button As an Xml Table

Step5:

click on ok button

Step6:

 xml is converted to tabular format.

Save the document.