Skip to Content

Note (27 Aug 2014) : Good to see that SAP is listening and coming up with so many new enhancements 🙂 . One of the most common requirement of Message Mapping documentation has been taken care. You can use the feature to export message mappings into Excel sheet with PI >=7.31 SP12/7.4 SP07. For details, please check Exporting Mapping Details as Spreadsheet and What’s new in SAP Process Orchestration 7.31 SP12 / 7.4 SP07 .


Are you finding it difficult to document complex PI mappings? Do you think the effort involved in documenting mappings is more than the development efforts? If yes, there are some good tools available already like The easy PI message mapping documentation service and SAP PI : Mapping Documenter that generates documentation.  From now on, we have one more tool MappingMaster 🙂

MappingMaster is an Excel based application that helps generating mapping documentation easily.

Here are some key features that make it special:

1. No need to download xim/tpz/metadata for mapping from IR/ESR.

2. Select mapping with top to down filter with swc, namespace and multiplicity.

3. Local and function library udf can be easily identified with different color.

4. Local udf list is also provided along with code.

Generated Mapping Documentation

You are just 4 steps away. Want to try, here you go!

1. Open MappingMaster and enable macro.

2. Press alt + F11 > Tools > References and select the required library > click OK > close the window.

image

3. Click MappingMaster button or press ctrl + alt + M > fill up the details > press Login button.

4. Select the swc, namespace and mapping > click Generate Documentation button.

I am sure it will be helpful to you and would save a lot of time while documention.

To report this post you need to login first.

20 Comments

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

  1. Samiullah Qureshi
    Hi Sunil,

    I am unable to select the libraries as instructed in step 2. *****************************************
    2. Press alt + F11 > Tools > References and select the required library > click OK > close the window.
    *****************************************

    References is disabled.

    Could you please guide me?

    Regards,
    Sami.

    (0) 
  2. Varun Goel
    Hi Sunil,

    Appreciate your efforts in creating this user friendly PI Documentor, But I am currently facing the problem “Authentication failed”.
    However with the same credentials I am able to login to the ESR & ID.

    Regards
    Varun

    (0) 
        1. Varun Goel
          Hi Sunil,

          Excellent work done for creating the version1.2 and this mapping sheet no doubt contains all the information in organized format with all the UDF details and Function Libraries. It is working fine now, however at the place of Local UDF the sheet is showing calculate4 or calculate3 whereever there are many UDFs are used in the mapping. For a single UDF it is showing the correct name of the UDF. Is there any limitation for the number of UDFs?

          Regards
          Varun

          (0) 
    1. Sunil Chandra Post author
      Thanks Varun. The tool is in beta stage and has been tested only with some specific PI versions. For now I request you to report it as a bug in Tracker > Bugs section alongwith PI version and wait for v1.2.

      Regards,
      Sunil Chandra

      (0) 
        1. Miguel Anthony Dietz

          Hi,

          We have the v1.3 relase of the MappingMaster but we get an “Authentication failed”-error, while connecting to a XI 3.0. Does anyone have a clue how to solve this?

          Thanks and regards,

          Miguel

          (0) 
  3. Varun Goel
    Hi Sunil,

    I believe that using the host name,user name and password in an external tool, will create risk on the client SAP system. Also, if you have seen santhosh’s or Daniel’s PI documentation tools, no user name/password is required.

    Regards
    Varun

    (0) 
    1. Sunil Chandra Post author
      MappingMaster is an open source tool that has been designed to read/display PI mapping in your local network/environment, so I don’t see any risk involved in using that. If you still find it risky, you have other choices 🙂

      Regards,
      Sunil Chandra

      (0) 
  4. Pratibha Kale

    Hi Sunil,

    I have downloaded the zip file from the url… File name: Lets Excel – MappingMaster v1.2.

    But, I am not able to find the Mapping master. (Step 1: Open MappingMaster and enable macro)

    Please help!

    Thanks,

    Pratibha

    (0) 
    1. Sunil Chandra Post author

      Change the file name to “Lets Excel – MappingMaster v1.2.xlsm”. Seems that the extension was lost while downloading.

      Regards,

      Sunil Chandra

      (0) 
      1. Pratibha Kale

        Thanks Sunil.

        I was able to dwnld the file and have enabled the macros.

        When I try to click on the Mapping Master button it gives me an error pop-up without any error text.

        Regards,

        Pratibha

        (0) 
  5. Jeevitha Natarajan

    Hi Sunil,

    I am able to select SWCV,namespace details and all, but documentation is not generating for me. it neither gives error nor documentation. can u pls help.

    (0) 
  6. Mariusz Marczak

    Hi Sunil,

    do you still support the solution?

    I have problem with FixedValues table  – it is not fetched completely, key values are missing.

    Beside of that, it is really useful tool!

    Thanks

    (0) 
  7. Rashmi Joshi

    Hi Sunil,

    I have v1.3, I am able to give swcm namescape n mapping name but its not giving document. I am getting below error –

    Compile error –

    User Defined Type not defined

    Please suggest how can I rectify this error.

    Thanks & Regards,

    Rashmi Joshi

    (0) 

Leave a Reply