OrgPlus 5.1.5 – Importing Data from SAP
OP-0515-S1500

Summary:

The SAP Adaptor is an add-on module for OrgPlus Professional that enables you to extract data from SAP. OrgPlus Professional uses the HR-OCI (Organizational Charting Interface) to extract data from SAP. HumanConcepts is certified against SAP HR-OCI.

Prerequequisites:
  • SAP R/3 version 4.6c, 4.7, or newer
  • SAP HR implemented with Organizational Management
  • R/3 Web Plugin version 2003 or 2004 (installed on your SAP system)
  • OrgPlus Professional version 5.1.5
  • The librfc32.dll file (Installed on user’s computer)

Note: On Machines with the SAPGUI installed, the librfc32.dll file can usually be found in C:\WINDOWS\system32\librfc32.dll. If necessary, you can copy the librfc32.dll file to the C:\WINDOWS\system32 directory of the windows machine on which you run OrgPlus Professional.

If the librfc32.dll file is not installed, you will receive the following error message:



Procedure:

Procedure:

> Creating an SAP View

You will need to work with your SAP team to create SAP Views and to make sure the SAP R/3 Web Plugin is installed in your SAP system.

Two SAP Views that are provided upon installation of the R/3 Web Plug-in are:

  • OCIMIN
  • OCIOFO

Note: Go to transaction SM31 and display table V_TWPC_COL to see the columns that are available in your system. SAP Administrative access is required to create and access SAP Views within SAP.

Objects and structures to be extracted from SAP Organizational Management are defined in an SAP view.   Key components include:

  • Eval Path for Root Objects or Function Module Root Objects – Use one of these fields to define the evaluation path to locate the root object.
  • Evaluation Path Objects – Use this field to define the evaluation path that identifies the objects subordinate to the root object.
  • Initial Evaluation Path – Use this field to determine the depth of the SAP Object to be returned. To return the entire tree, leave this field at 0.
  • Column Group – Use this field to define the columns from which data will be retrieved.

Additional info-types can be added to SAP views as desired; some info-types will require creation of function modules.

See SAP documentation or contact ope.support@humanconcepts.com for additional information on SAP configuration.

> Creating an SAP HR-OCI Connection File  

  1. Open OrgPlus Professional 5.1.5.

  2. Select Import Data from the File menu to display the Select Data Source dialog box.



  3. Click the New Source button.

    If the Desktop SAP HR-OCI Adaptor is unlocked, the Select Data Source dialog displays.

    Note: If the Desktop SAP HR-OCI Adaptor is not unlocked, you will see the following display. Click the appropriate link to evaluate, purchase or unlock the adaptor.



  4. Select the SAP (HR-OCI) radio button and click Next.



    The SAP Connection Wizard displays.

  5. Specify the SAP connection parameters.



    Note: The first 6 items (Application Server through Password) are the same as your SAPGUI configuration. These data tell OrgPlus how to get to and log into your SAP Environment:

    • View or View ID (required) field enter the name or ID of a previously defined SAP view or a default view.
    • Refresh Properties View or View ID (Optional) enter the name or ID of a previously defined SAP view or a default view for setting your refresh properties. For more information regarding this option, please see > Refreshing SAP Data in this article.
    • Query Scenario (Optional). An SAP Query can be defined to extract additional items or infotypes beyond those identified by the SAP View.
    • Object Type (Required) must match the Root Object Evaluation Path specified in the SAP View creation step.
    • Extended Object ID (Required) is the ID of the desired root object of the charts. This ID must match the object type specified in the SAP View creation step.
    • Plan Version (Optional) is the version number of the matrix organization that has your desired organizational structure. If left blank it defaults to 01
    • Begin Date, End Date, and Key Date (Optional) Use these fields to take advantage of SAP’s effective dating functionality. If left blank each defaults to the current date.

  6. Click the Next button to test the connection to the SAP system.

    You will get a response indicating either that the connection was successful or that it failed.

    If unsuccessful you will receive a Connection Failed dialog. Click the View Log button for information regarding the problem.

    If  successful you will see the SAP Wizard Result dialog box.



    To delete the temporary files created in the connection process, check the Delete temporary files checkbox.

    To save the login information for automated refreshes of the data, check the Save password file checkbox.

  7. Click Finish to save the SAP Adapter connection file.  

> Importing SAP Data

With your SAP Adaptor configured, you can import your SAP HR data.

  1. Select  Import Data… from the File menu select to display the Select Data Source dialog box.

  2. Select the SAP Adapter connection file created in step 7 above (op.saphr by default) from the data shown in the dialog box and click Open.

The Retrieving Data message displays the progress of your data retrieval as OrgPlus connects to the data source and retrieves the data.

When Data Retrieval is completed, The Import Wizard displays the data settings.

To view your SAP data in your default XML editor, click the View XML Response button.

To view a log of the transactions between OrgPlus and SAP HR, click the View Log button.

Click the Finish button to close the Import Wizard.

Refer to the OrgPlus 5 User Guide for more information on the data import process.  

> Refreshing SAP Data

Once you have created an OrgPlus file that is linked to an SAP HR-OCI data source, you can refresh your SAP HR data by selecting Refresh Data from the Data menu or by clicking on the Refresh Data button on the Toolbar. After refreshing your chart data, OrgPlus displays the following panel.

To view a report of your data refresh, click Refresh Delta Report.

To view your SAP data in your default XML editor, click SAP XML Response.

To view a log of the transactions between OrgPlus and SAP HR, click SAP Transaction Log.  

> Refreshing Properties View or View ID

Refresh Properties View or View ID is an optional parameter for configuring your SAP connection in OrgPlus. This option allows you to perform a smaller (and faster) query when opening the Refresh Properties dialog. The Refresh Properties View or View ID is not used to perform the data refresh.

When setting up the Refresh Properties View or View ID in SAP, use the same settings used in the “View or View ID” but specify a depth. We recommend a depth of 6.

Note: Although the Refresh Properties View or View ID parameter may decrease the time it takes to open the refresh properties dialog, OrgPlus requires all the fields in your data be included in the Refresh Properties View or View ID. This enables OrgPlus to correctly map your data fields.

If you do not specify a Refresh Properties View or View ID, OrgPlus will use the required View or View ID parameter when opening the refresh properties dialog.

Refer to the OrgPlus 5 User Guide for more information on data refresh.

Return to OrgPlus 5 Knowledge Base Articles