Excel Add-in (V1)

End-of-life

The Promenta Excel Add-in V1 is designed to work with Internet Explorer 11 exclusively. With the End-of-life of Internet Explorer in Jun 2022 Promenta is no longer able to support Version 1.

All customers are recommended to upgrade to Promenta Add-in Version 3 which supports Edge browser.

Overview

The Promenta Add-in enables a more convenient integration point for users to submit journal requests.

Please note : Additional maintenance and/or license fees may be applicable – please check with your Promenta Account Manager

Excel service

The excel service is the interface between the excel add-in installed on every users desktop and the SAP finance (ECC/S4Hana) system. It can be enabled for Single-sign-on with HTTP SSO technologies.

The Excel service is available in 2 versions

Portal version – this is deployed as part of the Promenta Portal [patch and must be configured. Connection to SAP is made from the portal via the SAP JCO service. As such the SAP Portal client JCO service must be configured in the portal

WAS (ABAP) version – this is deployed as part of the core delivery. No additional configuration is needed in SAP.

Excel Add-in functionality

The excel Ribbon provides additional integration functionality such as submitting a journal excel sheet for workflow approval, access to the approval inbox and value look-ups.

Every user must have an SAP named user to be able to logon to SAP.

Excel Installation Guide

The install guide is updated regularly. The guide is available on request.

Excel SAP connection

This section for IT administrators only

The Excel add-in is connected to SAP via the INI file of teh add-in. The INI file must be set up with your connection parameters and distributed to your end users.

The INI file must be placed in the same directory as the install location of the Add-in file 

The INI file contains the server for the connection. For Portal connection this will be the portal URL, for ABAP connection it will be the SAP ECC/S4Hana system itself. An example INI file is supplied as part of teh install.

XML configuration

Each system that should be connected to must have entry like below in the ini file

<system>
<!– memorable name –>
<name>CUSTOMER : DEV</name>

<!– description of connection. This will be seen by end users in the listbox –>
<description>CUSTOMER : Dev sysyetm</description>

<!– SAP system id –>
<system_id>XXX</system_id>

<!– SAP Client –>
<client>100</client>

<!– url to excel service – either pointing to the SAP portal or SAP WAS/BSP

SAP PORTAL protocol:portal_base_url:port/irj/servlet/prt/portal/prtroot/com.promenta.pct.excelservice.excelservice

SAP WAS protocol:was_abap_server:port/sap/bc/bsp/promenta/wfbsp/excelservice.htm?sap-client=100&sap-sessioncmd=open&sap-syscmd=nocookie

–> <serviceurl>http://portal1.promenta.internal:50000/irj/servlet/prt/portal/prtroot/com.promenta.pct.excelservice.excelservice</serviceurl>

<!– if using portal – set to YES –>
<portal>YES</portal>

<!– default alias MCC_R3_SYS will be used if blank and will point to the linked server.

If you have several alias then enter the portal alias here for the SAP landscape connection
The format for specifying an alias is ?SAPALIAS=alias_id. Note the ? is important
Example : <portal_alias>?SAPALIAS=DEV</portal_alias>
–>
<portal_alias></portal_alias>

</system>

Scroll to Top