B Additional Information for SAP ABAP ERP Adapter

This appendix describes the privileges that are required for connecting to SAP System, how you can test the connection outside of ODI using a standalone java utility, and how to uninstall SAP components.

This appendix includes the following sections:

For more information about the SAP ERP KMs see Connectivity and Knowledge Modules Guide for Oracle Data Integrator.

B.1 SAP ABAP ERP Required Privileges

An SAP dialog user is required for connecting to the SAP system, for the RKM installation and for the LKM execution during development. A SAP RFC user is not sufficient.

During development, this user must have a developer license key. License keys can be retrieved from http://service.sap.com. Any execution attempts without this developer license key will lead to failure and may cause the need for clean-up operations.

For RKM and LKM execution in production, an SAP RFC user is sufficient.

These SAP user types can be used for the following operations:

Table B-1 Required SAP User Types

Operation	Required SAP User Type
RKM: Setup	SAP Dialog user
RKM: Reverse Engineering	SAP Dialog user or SAP RFC user
LKM: Development	SAP Dialog user or SAP RFC user
LKM: Production	SAP Dialog user or SAP RFC user

The following tables list the privileges required for using SAP ABAP Knowledge Modules:

B.1.1 Important points to consider

Consider the following points while configuring the SAP privilieges:

S_DATASET is an authorization object that controls access to physical file, so you need to provide access to SAP directories & folder mounted path. The values provided here are sample paths, you need to provide your landscape directories path or provide *(all).
NR or (NR) means NOT REQUIRED.

B.1.2 Authorizations Required for RKM SAP ERP Setup

The following SAP authorizations are required for RKM SAP ERP setup.

Note:

Developer key is required in this authorization.

Object	Field Name	Value (4.6c)	Value (4.7)	Value (ECC 5)	Value (ECC 6)
`S_RFC`	`ACTVT`	`16`	`16`	`16`	`16`
`S_RFC`	`RFC_NAME`	`RFC1, SDIFRUNTIME, SUTL, SYST, ZODI_FGR, SDIF`	`RFC1, SDIFRUNTIME, SUTL, SYST, ZODI_FGR`	`RFC1, SDIFRUNTIME, SUTL, SYST, ZODI_FGR`	`RFC1, SDIF, SDIFRUNTIME, SUTL, SYST, SYSU, ZODI_FGR`
`S_RFC`	`RFC_TYPE`	`FUGR`	`FUGR`	`FUGR`	`FUGR`
`S_TCODE`	`TCD`	`SU53,SE38`	`SU53,SE38`	`SU53,SE38`	`SU53,SE38`
`S_ADMI_FCD`	`S_ADMI_FCD`	`MEMO,SM02`	`MEMO`	`MEMO`	`''`
`S_CTS_ADMI`	`CTS_ADMFCT`	`TABL`	`TABL`	`TABL`	`TABL`
`S_DATASET`	`ACTVT`	`34`	`34`	`34`	`34`
`S_DATASET`	`FILENAME`	`\\HYPTEST01\sapmnt*`	`G:\usr\, \\10.30.0.201\ODI_SAPTEST, \\10.30.32.30*`	`D:\usr\, \\10.30.0.201\ODI_SAPTEST, \\10.30.32.42*`	`*`
`S_DATASET`	`PROGRAM`	`SAPLSLOG, SAPLSTRF`	`SAPLSLOG, SAPLSTRF`	`SAPLSLOG, SAPLSTRF, SAPLZODI, ZODI`	`SAPLSLOG, SAPLSTRF`
`S_TABU_DIS`	`ACTVT`	`03`	`03`	`03`	`03`
`S_TABU_DIS`	`DICBERCLS`	`*`	`*`	`*`	`*`
`S_DEVELOP`	`ACTVT`	`01,02,03`	`01,02,03`	`01,02,03`	`01,02,03`
`S_DEVELOP`	`DEVCLAS`	`$TMP, ZODI_LKM_PCKG, ZODI_RKM_PCKG`	`$TMP, ZODI_LKM_PCKG, ZODI_RKM_PCKG`	`$TMP, ZODI_LKM_PCKG, ZODI_RKM_PCKG`	`$TMP, ZODI_LKM_PCKG, ZODI_RKM_PCKG`
`S_DEVELOP`	`OBJNAME`	`Z$$$XRFC, ZODI_FGR, ZODI_FGR_PROD, ZODI_LKM_PCKG, ZODI_RKM_PCKG`	`Z$$$XRFC, ZODI_FGR, ZODI_FGR_PROD, ZODI_LKM_PCKG, ZODI_RKM_PCKG`	`Z$$$XRFC, ZANU*, ZODI_FGR, ZODI_FGR_PROD, ZODI_LKM_PCKG, ZODI_RKM_PCKG`	`Z$$$XRFC, ZODI_FGR, ZODI_FGR_PROD, ZODI_LKM_PCKG, ZODI_RKM_PCKG, ZODI_MSG`
`S_DEVELOP`	`OBJTYPE`	`DEVC,FUGR,PROG`	`DEVC,FUGR,PROG,MSAG`	`DEVC,FUGR,PROG`	`DEVC,FUGR,PROG,MSAG`
`S_DEVELOP`	`P_GROUP`	`''`	`''`	`''`	`''`
`S_TRANSPRT`	`ACTVT`	`01,03`	`01`	`01,03`	`01`
`S_TRANSPRT`	`TTYPE`	`DTRA,TASK`	`DTRA,TASK`	`DTRA,TASK`	`DTRA,TASK`

B.1.3 Authorizations Required for RKM SAP ERP Execution

The following SAP authorizations are required for RKM SAP ERP execution.

Object	Field Name	Value (4.6c)	Value (4.7)	Value (ECC 5)	Value (ECC 6)
`S_RFC`	`ACTVT`	`16`	`16`	`16`	`16`
`S_RFC`	`RFC_NAME`	`RFC1,SDIF,SYST,ZODI_FGR,SDIFRUNTIME`	`RFC1,SDIFRUNTIME,SYST,ZODI_FGR`	`RFC1,SDIFRUNTIME,SYST,ZODI_FGR`	`RFC1,SDIF, SDIFRUNTIME, SYST, ZODI_FGR`
`S_RFC`	`RFC_TYPE`	`FUGR`	`FUGR`	`FUGR`	`FUGR`
`S_TCODE`	`TCD`	`SU53`	`SU53`	`SU53`	`SU53`
`S_TABU_DIS`	`ACTVT`	`03`	`03`	`03`	`03`
`S_TABU_DIS`	`DICBERCLS`	`*`	`*`	`*`	`*`

B.1.4 Authorizations Required for LKM SAP ERP Execution

The following SAP authorizations are required for LKM SAP ERP execution.

Note:

Developer Key is required in this authorization.

Object	Field Name	Value (4.6c)	Value (4.7)	Value (ECC 5)	Value (ECC 6)
`S_RFC`	`ACTVT`	`16`	`16`	`16`	`16`
`S_RFC`	`RFC_NAME`	`RFC1,SDIF, SYST, ZODI_FGR, ZODI_FGR_PROD*`	`RFC1,SDIFRUNTIME,SYST, ZODI_FGR, ZODI_FGR_PROD*`	`RFC1,SDIFRUNTIME,SYST, ZODI_FGR, ZODI_FGR_PROD*`	`RFC1,SDIFRUNTIME,SYST, ZODI_FGR, ZODI_FGR_PROD*`
`S_RFC`	`RFC_TYPE`	`FUGR`	`FUGR`	`FUGR`	`FUGR`
`S_TCODE`	`TCD`	`SU53`	`SE38,SU53`	`SE38,SU53`	`SU53`
`S_DATASET`	`ACTVT`	`06,33,34`	`06,33,34`	`06,33,34`	`06,33,34`
`S_DATASET`	`FILENAME`	`\\10.30.0.201\ODI_SAPTEST\ZODI,` `\\HYPTEST01\sapmnt`	`\\10.30.0.201\ODI_SAPTEST,` `\\10.30.0.201\ODI_SAPTEST\ZODI_233030*`	`\\10.30.0.201\ODI_SAPTEST,` `\\10.30.0.201\ODI_SAPTEST\ZODI_233030*`	`\\DEL-7TMK2BS\odiagentbox, \\DEL-7TMK2BS\odiagentbox`
`S_DATASET`	`PROGRAM`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`
`S_DEVELOP`	`ACTVT`	`01`	`01,02,03,06`	`01,02,03,06`	`01`
`S_DEVELOP`	`DEVCLASS`	`''`	`ZODI_LKM_PCKG`	`''`	`''`
`S_DEVELOP`	`OBJNAME`	`ZODI_FGR_PROD*`	`ZODI_FGR_PROD*`	`ZODI_FGR_PROD*`	`ZODI_FGR_PROD*`
`S_DEVELOP`	`OBJTYPE`	`FUGR`	`FUGR,PROG`	`FUGR`	`FUGR`
`S_PROGRAM`	`P_ACTION`	`''`	`EDIT,SUBMIT,VARIANT`	`EDIT,SUBMIT,VARIANT`	`''`
`S_PROGRAM`	`P_GROUP`	`''`	`''`	`''`	`''`
`S_CTS_ADMI`	`CTS_ADMFCT`	`''`	`TABL`	`''`	`''`
`S_TRANSPRT`	`ACTVT`	`01`	`01`	`01`	`01`
`S_TRANSPRT`	`TTYPE`	`DTRA,TASK`	`DTRA,TASK`	`DTRA,TASK`	`DTRA,TASK`

B.1.5 Authorizations Required for LKM SAP ERP Execution in Production

The following SAP authorizations are required for LKM SAP ERP execution in the SAP production environment.

Object	Field Name	Value (4.6c)	Value (4.7)	Value (ECC 5)	Value (ECC 6)
`S_RFC`	`ACTVT`	`16`	`16`	`16`	`16`
`S_RFC`	`RFC_NAME`	`SDIFRUNTIME, SYST,ZODI*`	`RFC1, SDIFRUNTIME, SYST,ZODI_FGR_PROD*`	`RFC1, SDIFRUNTIME, SYST,ZODI_FGR_PROD*`	`RFC1, SDIFRUNTIME, SYST,ZODI_FGR_PROD*`
`S_RFC`	`RFC_TYPE`	`FUGR`	`FUGR`	`FUGR`	`FUGR`
`S_TCODE`	`TCD`	`SU53`	`SU53`	`SU53`	`SU53`
`S_DATASET`	`ACTVT`	`''`	`06,33,34`	`06,33,34`	`06,33,34`
`S_DATASET`	`FILENAME`	`''`	`\\DEL-7TMK2BS\odiagentbox, \\DEL-7TMK2BS\odiagentbox`	`\\DEL-7TMK2BS\odiagentbox, \\DEL-7TMK2BS\odiagentbox`	`\\DEL-7TMK2BS\odiagentbox, \\DEL-7TMK2BS\odiagentbox`
`S_DATASET`	`PROGRAM`	`''`	`SAPLSLOG, SAPLSTRF, SAPLZODI`	`SAPLSLOG, SAPLSTRF, SAPLZODI*`	`SAPLSLOG, SAPLSTRF, SAPLZODI,ZODI`

B.1.6 Authorizations Required for LKM SAP ERP Execution as Background Process

The following SAP authorizations are required for executing LKM SAP ERP as background process.

Object	Field Name	Value (4.6c)	Value (4.7)	Value (ECC 5)	Value (ECC 6)
`S_RFC`	`ACTVT`	`16`	`16`	`16`	`16`
`S_RFC`	`RFC_NAME`	`RFC1,SDIF, SLST,SYST, ZODI,ZODI_FGR,ZODI_FGR_PROD`	`RFC1, SDIFRUNTIME, SLST,SYST, ZODI_FGR, ZODI_FGR_PROD*`	`RFC1, SDIFRUNTIME, SLST,SYST, ZODI_FGR, ZODI_FGR_PROD*`	`RFC1, SDIFRUNTIME, SLST,SYST, ZODI_FGR, ZODI_FGR_PROD*`
`S_RFC`	`RFC_TYPE`	`FUGR`	`FUGR`	`FUGR`	`FUGR`
`S_TCODE`	`TCD`	`SU53`	`SE38,SU53`	`SE38,SU53`	`SE38,SU53`
`S_BTCH_ADM`	`BTCADMIN`	`Y`	`Y`	`Y`	`Y`
`S_BTCH_JOB`	`JOBACTION`	`RELE`	`RELE`	`RELE`	`RELE`
`S_BTCH_JOB`	`JOBGROUP`	`'`	`'`	`'`	`'`
`S_CTS_ADMI`	`CTS_ADMFCT`	`TABL`	`TABL`	`TABL`	`TABL`
`S_DATASET`	`ACTVT`	`06,33,34`	`06,33,34`	`06,33,34`	`06,33,34`
`S_DATASET`	`FILENAME`	`\\10.30.0.201\ODI_SAPTEST\ZODI, \\HYPTEST01\sapmnt`	`\\10.30.0.201\ODI_SAPTEST, \\10.30.0.201\ODI_SAPTEST\ZODI_233030*`	`\\10.30.0.201\ODI_SAPTEST, \\10.30.0.201\ODI_SAPTEST\ZODI_233030*`	`\\DEL-7TMK2BS\odiagentbox, \\DEL-7TMK2BS\odiagentbox, \\DELRC6\sapmnt*`
`S_DATASET`	`PROGRAM`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI*`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`
`S_DEVELOP`	`ACTVT`	`01`	`01,02,03,06,16`	`01,02,03,06,16`	`01`
`S_DEVELOP`	`DEVCLASS`	`''`	`''`	`''`	`''`
`S_DEVELOP`	`OBJNAME`	`ZODI_FGR_PROD*`	`ZODI_FGR_PROD*`	`ZODI_FGR_PROD*`	`ZODI_FGR_PROD*`
`S_DEVELOP`	`OBJTYPE`	`FUGR`	`FUGR`	`FUGR,PROG`	`FUGR`
`S_DEVELOP`	`P_GROUP`	`''`	`''`	`''`	`''`
`S_PROGRAM`	`P_ACTION`	`''`	`EDIT,SUBMIT,VARIANT`	`EDIT,SUBMIT,VARIANT`	`''`
`S_PROGRAM`	`P_GROUP`	`''`	`''`	`''`	`''`
`S_TRANSPORT`	`ACTVT`	`01,02,03`	`01,02,03`	`01,02`	`01,02`
`S_TRANSPORT`	`TTYPE`	`DTRA,TASK`	`DTRA,TASK`	`DTRA,TASK`	`DTRA,TASK`
`S_APPL_LOG`	`ACTVT`	`06`	`06`	`06`	`06`
`S_APPL_LOG`	`ALG_OBJECT`	`ZODI_APPOBJ`	`ZODI_APPOBJ`	`ZODI_APPOBJ`	`ZODI_APPOBJ`
`S_APPL_LOG`	`ALG_SUBOBJ`	`ZODI_SUBOBJ`	`ZODI_SUBOBJ`	`ZODI_SUBOBJ`	`ZODI_SUBOBJ`

B.1.7 Authorizations Required for LKM SAP ERP Execution as Background Process in Production

The following SAP authorizations are required for executing LKM SAP ERP as background process in a SAP development environment.

Object	Field Name	Value (4.6c)	Value (4.7)	Value (ECC 5)	Value (ECC 6)
`S_RFC`	`ACTVT`	`16`	`16`	`16`	`16`
`S_RFC`	`RFC_NAME`	`RFC1,SDIF,SYST,SLST, ZODI_FGR_PROD*`	`SDIF,SDIFRUNTIME,SLST,SYST,ZODI_FGR_PROD*`	`RFC1,SDIFRUNTIME,SLST, SYST,SYSU, ZODI_FGR_PROD*`	`RFC1,SDIFRUNTIME,SYST,ZODI_FGR_PROD*`
`S_RFC`	`RFC_TYPE`	`FUGR`	`FUGR`	`FUGR`	`FUGR`
`S_TCODE`	`TCD`	`SU53`	`SU53`	`SU53`	`SU53`
`S_BTCH_ADM`	`BTCH`	`Y`	`Y`	`Y`	`Y`
`S_BTCH_JOB`	`JOBACTION`	`RELE`	`RELE`	`RELE`	`RELE`
`S_BTCH_JOB`	`JOBGROUP`	`''`	`''`	`''`	`''`
`S_DATASET`	`ACTVT`	`06,33,34`	`06,33,34`	`06,33,34`	`06,33,34`
`S_DATASET`	`FILENAME`	`\\10.30.0.201\ODI_SAPTEST\ZODI, \\HYPTEST01\sapmnt`	`\\10.30.0.201\ODI_SAPTEST, \\DEL-7TMK2BS\odiagentbox, \\DELRC6\sapmnt*`	`\\10.30.0.201\ODI_SAPTEST, \\DEL-7TMK2BS\odiagentbox, \\DELRC6\sapmnt*`	`\\10.30.0.201\ODI_SAPTEST, \\DEL-7TMK2BS\odiagentbox, \\DELRC6\sapmnt*`
`S_DATASET`	`PROGRAM`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI,` `ZODI`
`S_APP_LOG`	`ACTVT`	`06`	`06`	`06`	`06`
`S_APP_LOG`	`ALG_SUBOBJ`	`ZODI_SUBOBJ`	`ZODI_SUBOBJ`	`ZODI_SUBOBJ`	`ZODI_SUBOBJ`
`S_APP_LOG`	`ALG_SUBOBJ`	`ZODI_SUBOBJ`	`ZODI_SUBOBJ`	`ZODI_SUBOBJ`	`ZODI_SUBOBJ`

B.2 SAP Connection Test

This connection test should be performed after configuring the SAP ABAP data server in the topology.

This test preforms the following operations:

It establishes a test connection to the configured SAP system.
It validates the proper setup of SAP JCo by displaying the About dialog.

This test is performed using an RKM called RKM SAP ERP Connection Test. This KM does not perform any reverse operation. It simply runs the connection test.

To run the connection test:

Create an SAP ERP Model based on the SAP ABAP technology and on the SAP ABAP logical schema using the standard procedure, as described in "Creating a Model" of the Developing Integration Projects with Oracle Data Integrator.
In the Reverse Engineer tab of the SAP ERP Model, select the RKM SAP ERP Connect Test.
Save the model.
Click Reverse-Engineer to start the reverse.

Within a few seconds, the SAP JCo About dialog should appear. If not, review the session execution log in the Operator Navigator. Please verify that the output of task "Test SAP Connection" contains Successfully connected to SAP System. If not, the connection test has failed and the connection problem must be analyzed.

B.3 SAP Stand-Alone Connection Test

In addition to the Connection Testing, a test can be performed outside of ODI using a standalone java utility. This utility is available with the Standalone agent.

To use a standalone java utility to test the connection:

Open a command window.
Go to the <ODI_HOME>/odi/sdk/lib directory.
Make sure that JAVA_HOME points to a supported JVM.
Make sure that you have installed SAP Java Connector and that the sapjco3.jar and the sapjco3 library are in the <ODI_HOME>/odi/sdk/lib directory.
Launch the utility using the following command:

On Windows:

java -cp sapjco3.jar;odi-sap.jar oracle.odi.sap.km.test.JCoTest

On Linux/UNIX:

java -cp sapjco3.jar:odi-sap.jar oracle.odi.sap.km.test.JCoTest

This command generates a ODI_SAP_CON_POOL.jcoDestination file in the folder <ODI_HOME>/odi/sdk/lib folder.

For more information, see "Appendix C, SAP Stand-Alone Connection Test" in the Getting Started with SAP ABAP ERP Adapter for Oracle Data Integrator.

Use a text editor to open the ODI_SAP_CON_POOL.jcoDestination file. This file should look as follows:

#for tests only!
jco.client.lang=EN
jco.destination.peak_limit=10
jco.client.client=800
jco.client.passwd=<SAP Password>
jco.client.user=<SAP User>
jco.client.sysnr=00
jco.destination.pool_capacity=5
jco.client.ashost=<SAP Application Server>

Enter you SAP connection information, which you have received from your SAP administrator.
Launch the utility using the same command. The utility uses the file that you have edited, and outputs the test results or the possible issues.

In addition to just testing the SAP connection, the utility will also validate the existence of certain Function Modules required for the RKM.
Delete the ODI_SAP_CON_POOL.jcoDestination file after execution, as it contains the SAP login credentials.