Skip to Content

Hi All,

As we know getting Message Mapping Documented is a tedious job many times. There are ways to get XIM files from the Message Mapping using Hidden Buttons like ctrl + shft + 0 in lower versions of PI and then convert it into spreadsheets. But these buttons are disabled from the PI versions like 7.11 or sometimes may face issues like authorizations etc.

In this article we will see the two simple ways to download message mapping from SAP PI to excel sheet.

This method is useful for the versions higher than SAP PI 7.11.

Method 1 —

1. Goto URL –> http://PIHOSTNAME:PORT/rep/support/SimpleQuery

2. Select your desired SWCV —

     URL1.PNG

3. Once you select your SWCV, now scroll down the page and select Message Mapping under Define the Object type(s). Click on “refresh dependant values”.

     MM.PNG

4. Now under Define the Query Conditions(s). Select condition –> NAME –> LIKE –> Provide your Map Name else you can also use wildcard entries too like “*”

and click on Start Query Button –

     Start.PNG

5. One object will be generated. Download the RAW file R in XML format

     RAW.PNG

6. Now open this R.XML file in edit mode and get the value from the below tag and copy that in notepad with .zip format

<p1:content>

        <tr:XiTrafo xmlns:tr=”urn:sap-com:xi:mapping:xitrafo”>

            <tr:MetaData>

                <tr:blob type=”zip” zipped=”true”>

7. After zipping file it gets encoded. Its time to decode this file now. Use any Base46 online free tools for this.

8. Once the file is encoded, extract a file by name “Value” from it. Again save it as .zip

9. Open Value file in winzip, you will get metadata file. You will see all the fields in this file

10. Get the jnlp tool to convert this metadata file into xsl file format

Testing –>

MM –

     MM_ESR.PNG

Excel Sheet –

     excell.PNG

Method 2 –


This method is really very simple and less time consuming too. One should have NWDS in the landscape to utilise this functionality.

1. Open NWDS

2. Connect to ESR objects (Windows –> Perspective –> ESR)

3. Right click on the required Message Mapping Program and Select option Export to Spreadsheet –

     NWDS.png

Testing –

     MM_ESR.PNG

Excel –

     NWDS_EXCEL.PNG

Thanks & Regards,

Rashmi Joshi

To report this post you need to login first.

22 Comments

You must be Logged on to comment or reply to a post.

  1. Yee Loon Khoo

    HI Rashimi,

    Could you explain more the step 10? what jnlp tool? how to convert xml to xls? Any additional development conversion involved?

    “10. Get the jnlp tool to convert this metadata file into xsl file format”

    Many thanks.

    Regards,

    Yee Loon

    (0) 
    1. Rashmi Joshi Post author

      Hi Shrikanth,

      Try to search the value in tags –

      <p1:content>

              <tr:XiTrafo xmlns:tr=”urn:sap-com:xi:mapping:xitrafo”>

                  <tr:MetaData>

                      <tr:blob type=”zip” zipped=”true”>

      Get this value and then paste it in notepad as an .zip file then you need to use Base64. You can google Base64 encoder and use any free online tool for the same.

      Please let me know if this is clear to you.

      Regards,

      Rashmi Joshi

      (0) 
      1. Srikanth Mavuri

        Hi Rashmi,

        Actually i have done upto above step…

        Like  searching the value in tags:

        <p1:content>

                <tr:XiTrafo xmlns:tr=”urn:sap-com:xi:mapping:xitrafo”>

                    <tr:MetaData>

                        <tr:blob type=”zip” zipped=”true”>

        After getting this value i have pasted in Notepad and saved as a Sample.zip format… I have used online base64 tool to encode this…. but After this only i am getting confusion…

        Could you please tell me the procedure….

        Regards,

        Srikanth Mavuri.

        (0) 
          1. Srikanth Mavuri

            Hi Joshi,

            Please find the details below.

            <p1:content><tr:XiTrafo xmlns:tr=”urn:sap-com:xi:mapping:xitrafo”>

            <tr:MetaData>

            <tr:blob type=”zip” zipped=”true”>

            !zip!UEsDBBQACAAIAPQwbEcAAAAAAAAAAAAAAAAFAAAAdmFsdWUBQAq/9VBLAwQUAAgACABFY4VDAAAAAAAAAAAAAAAACAAAAG1ldGFkYXRh3VlZb+pKEn6fX5FBui+DJl6x8Z0kV17BYANeWa5GkXcb7yvLrx+bhCQnKyfnSqMZHkzTXa76quqr6ra5+WMfR1eN……………….

            </tr:blob>

            </tr:MetaData>

            I have copied this content…. is this correct ?

            Regards,

            Srikanth.

            (0) 
              1. Srikanth Mavuri

                Hi Rashmi,

                Actually i am not getting these three steps.

                7. After zipping file it gets encoded. Its time to decode this file now. Use any Base46 online free tools for this.

                8. Once the file is encoded, extract a file by name “Value” from it. Again save it as .zip

                9. Open Value file in winzip, you will get metadata file. You will see all the fields in this file

                My Doubts:

                Actually i am copying these values in notepad…. UEsDBBQACAAIAPQwbEcAAAAAAAAAAAAAAAA …. Regarding save… in which format you want me to save…give me example like sample.zip or any other name…

                After saving you are telling use any decoder tool…in those tools either i  want pass that saved  zip file or those values(UEsDBBQACAAIAPQwbEcAAAAAAAAAAAAAAAA )…why becase in some tools they asking me either paste the data or upload the file. So Thats y i am getting confusion….

                Can u explain 8 & 9 steps….

                Sorry to asking you again & again…

                Regards,

                Srikanth.

                (0) 
      1. suchita tomar

        Hi Rasmi ,

        I have certain doubts

        1) you want us to copy whatever there after

        <tr:MetaData>

          <tr:blob type=”zip” zipped=”true”>!zip!

        and copy till end of

        </tr:blob>

          </tr:MetaData>

        ???? is it right ? also tell me in which format should i save the notepad file once i copy this.

        2) let me know which decoding tool should i use, as there are many and tell me i should paste above notepad file data or it should be the ZIP file data ? which has to be decoded.

        Regards

        S Tomar

        (0) 

Leave a Reply