1 Reply Latest reply: Apr 24, 2012 3:45 PM by Martin Nooteboom RSS

Open Text Vendor Invoice Management & ECC HCM Organizational Hierarchy Configuration

Robert Zinsmeister
Currently Being Moderated

I am working with a large utility to determine if a standard implementation is feasible for Open Text Vendor Invoice Management within SAP for our situation.  The procedure includes scanning an invoice into the computer, taking advantage of OCR to identify key data and populating this data into the appropriate fields within SAP.   The SAP Invoice Receipt is complete immediately after the OCR process finishes or once a clerk reviews and adjusts the document.  Next, the invoice must be approved.  Open Text requires the configuration of 2 tables to determine the Delegation of Authority.  The configuration is accessed through the transaction “/n/OPT/VIM_7CX1” including table “/ORS/USERMAP” to simulate the firm’s organizational hierarchy and table “/OPT/BL_APPCOA” to  list the user’s monetary approval level by the expense type and the account assignment.

 

Since the SAP ECC HCM Organizational Hierarchy is available, we wanted to avoid the effort to duplicate the data into the SAP Open Text table “/ORS/USERMAP” and to eliminate the on-going maintenance of this table as organizational changes occur.  In addition to avoiding the costs of creation and maintenance, we wanted to avoid the inconsistencies that are likely to occur in an attempt to maintain 2 sets of duplicate data.  Then, we decided to modify the Open Text workflow redirecting it from the Open Text table “/ORS/USERMAP” to the SAP ECC HCM Organizational Hierarchy.  Custom code is necessary to make the changes necessary to redirect the Open Text workflows.

 

SAP SRM allows only 1 type of expense, therefore, we were already planning to develop a custom table for this utility to differentiate the delegation of authority approval levels for Shopping Carts and Purchase Orders among different expense types based on the pay grade of the user.  This table is to be included within SAP SRM.  Since this table was already designed and is similar to the Open Text table “/OPT/BL_APPCOA”, then the same custom table will be placed into both ECC and SRM to replace the Open Text table “/OPT/BL_APPCOA”.  Maintenance will be performed on 1 table only.  Once the changes to the source table are saved, then the table will be automatically interfaced and the data duplicated into the other system.   We have not decided whether the source table will reside in ECC or SRM.  

 

I researched, but was unable to find, any recommendations from Open Text consultants or independent SAP consultants that had worked with Open Text to provide a standard solution when the SAP ECC HCM Organizational Hierarchy is available.  Are there standard Open Text configuration elements available within SAP that would allow the SAP ECC Organizational Hierarchy to replace the Open Text table “/ORS/USERMAP” as a normal feature of the Vendor Invoice Management product?  Are Open Text programs, reports, function modules, or any other programmatic device available to duplicate the SAP ECC Organizational Hierarchy into the standard Open Text tables “/ORS/USERMAP”?  Does Open Text provide a standard capability to replicate the table “/OPT/BL_APPCOA” from a source ECC system into any other ECC or SRM systems?  If so, we may consider using it to replace our custom table.  We would prefer to find standard solutions to avoid customizing the ECC and SRM systems.  

  • Re: Open Text Vendor Invoice Management & ECC HCM Organizational Hierarchy Configuration
    Martin Nooteboom
    Currently Being Moderated

    Hi Robert,

     

    The short answer to your questions is no, no standards are delivered. But I'll try to give a longer answer for each of your question of the options available.

     

    Are there standard Open Text configuration elements available within SAP that would allow the SAP ECC Organizational Hierarchy to replace the Open Text table “/ORS/USERMAP” as a normal feature of the Vendor Invoice Management product?  There is no standard code available but you have the option to create your own logic. The approval process is steered by the approver calss. You can create a subclass for this class and redefine the methods as appropriate. By entering your subclass in the constant table you can make sure you use your class in stead of the standard one. In that way you can use the Organizational Hierarchy. To be able to still use all functionality but not the usermap table you probably would need to create your own usermap class also.

     

     

     

     

     

    Are Open Text programs, reports, function modules, or any other programmatic device available to duplicate the SAP ECC Organizational Hierarchy into the standard Open Text tables “/ORS/USERMAP”?  As stated at the beginning no there aren't. You would need to create your own logic to populate the Usermap table from the Organizational Hierarchy. Open Text could deliver this, but for a consulting fee. It is not delivered as standard. In the usermap class methods are available to create the entries in a controlled manner.

     

     

    Does Open Text provide a standard capability to replicate the table “/OPT/BL_APPCOA” from a source ECC system into any other ECC or SRM systems? Same as for your previous question, you would need to create it yourself.

     

     

    Hope this helps a little.

     

    Regards,

    Martin

Actions