cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

In SAP PO we are trying to extract an excel with all the ICOs and related Configuration scenarios.

rahulgowthamn
Discoverer
0 Kudos
1,511

Hi All,

In SAP PO ,we are trying to extract an excel with all the ICOs and related Configuration scenarios. Is there a way to do it instead of manually extracting the list from ID ?

Accepted Solutions (0)

Answers (3)

Answers (3)

martinbindner
Explorer
0 Kudos

Hi Rahul,

As pointed out by Caner, SAP offers some APIs to retrieve ICO objects as well as other Director objects like Communication Channels, Sender Agreements etc.


However, there are several aspects to consider when using these APIs. For example:

  • If you have a large number of ICOs, you may experience timeouts
  • Some attributes are returned in a non-human readable format (e.g. dates, SWCV)
  • The data structures can be deeply nested (e.g. Receiver Interfaces with or without conditions)
  • There are different versions of the APIs, as they have evolved over time like PI/PO

Given these challenges, you may want to consider a simpler solution.
The company I work for, Arianim, offers a tool called UDO to extract Director information within minutes. In addition to the extract, UDO also offers:

  • Automatic documentation of your interfaces, including IFlow-Diagrams
  • Global search for any string in any object. Our customers love this feature e.g. it can be used to identify a Communication Channel, based on a filename
  • Migration analysis from PI/PO to CPI/IS, as well as to non-SAP integration technologies like Boomi or MuleSoft
  •  All mappings are available and can be displayed or queried, including Message Mappings, Java, XSLT, and Function Libraries
  • Visualization of your interfaces
  • Trading Partners and - Agreements are displayed
  • Certificates are listed, including their expiry date, cipher etc.
  • All data can be stored offline
  • And much more

The tool has been established in the market for over 12 years and has a mature, proven track record.
Additionally, we have numerous customers who successfully operate and manage more than 10,000 interfaces with our solution.

For your convenience, I have attached a full Excel extract of our small Demo system, including ICO information. It gives you an idea what you can expect from the tool.

Here is a screenshot of the UI:ico_ui.png

 

 

For more information, please visit our website.
There, you can also request a trial version of our product to experience its capabilities firsthand.

Best regards,
Martin

rahulgowthamn
Discoverer
0 Kudos

Hi ,

Thanks alot for the reply . We can get ICO list here with this call but can we link ICO and related configuration scenerio ? Our need is to get all the ICOs and the related configuration scenerio in an excel .

Thanks and Regards,

Rahul

Ryan-Crosby
Active Contributor
0 Kudos
Yes, the information can be retrieved via APIs. Many years ago I wrote a custom Java application to read and compile a bunch of data for a monitoring application.
caner_genis
Explorer
0 Kudos

Hello rahulgowthamn,

Could you please check the video in this blog:

https://community.sap.com/t5/technology-blogs-by-members/how-to-consume-web-services-hosted-by-sap-p...

You can use SOAP UI to get all ICOs in XML format. You can export XML data to an excel file. 

Good luck.

Caner.

rahulgowthamn
Discoverer
0 Kudos
Hi , Thanks alot for the reply . We can get ICO list here with this call but can we link ICO and related configuration scenerio ? Our need is to get all the ICOs and the related configuration scenerio in an excel . Thanks and Regards, Rahul
rahulgowthamn
Discoverer
0 Kudos

Hi All,

Can anyone help me on this topic?

Thanks and Regards,

Rahul