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.
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:
Authorizations Required for LKM SAP ERP Execution in Production
Authorizations Required for LKM SAP ERP Execution as Background Process
Authorizations Required for LKM SAP ERP Execution as Background Process in Production
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.
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 |
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 |
|
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 |
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* |
* |
|
PROGRAM |
SAPLSLOG, SAPLSTRF |
SAPLSLOG, SAPLSTRF |
SAPLSLOG, SAPLSTRF, SAPLZODI*, ZODI* |
SAPLSLOG, SAPLSTRF |
|
S_TABU_DIS |
ACTVT |
03 |
03 |
03 |
03 |
DICBERCLS |
* |
* |
* |
* |
|
S_DEVELOP |
ACTVT |
01,02,03 |
01,02,03 |
01,02,03 |
01,02,03 |
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 |
|
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 |
|
OBJTYPE |
DEVC,FUGR,PROG |
DEVC,FUGR,PROG,MSAG |
DEVC,FUGR,PROG |
DEVC,FUGR,PROG,MSAG |
|
P_GROUP |
|||||
S_TRANSPRT |
ACTVT |
01,03 |
01 |
01,03 |
01 |
TTYPE |
DTRA,TASK |
DTRA,TASK |
DTRA,TASK |
DTRA,TASK |
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 |
RFC_NAME |
RFC1,SDIF,SYST,ZODI_FGR,SDIFRUNTIME |
RFC1,SDIFRUNTIME,SYST,ZODI_FGR |
RFC1,SDIFRUNTIME,SYST,ZODI_FGR |
RFC1,SDIF, SDIFRUNTIME, SYST, ZODI_FGR |
|
RFC_TYPE |
FUGR |
FUGR |
FUGR |
FUGR |
|
S_TCODE |
TCD |
SU53 |
SU53 |
SU53 |
SU53 |
S_TABU_DIS |
ACTVT |
03 |
03 |
03 |
03 |
DICBERCLS |
* |
* |
* |
* |
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 |
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* |
|
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 |
FILENAME |
\\10.30.0.201\ODI_SAPTEST\ZODI*,
|
*\\10.30.0.201\ODI_SAPTEST*,
|
*\\10.30.0.201\ODI_SAPTEST*,
|
*\\DEL-7TMK2BS\odiagentbox*, \\DEL-7TMK2BS\odiagentbox |
|
PROGRAM |
SAPLSLOG,
|
SAPLSLOG,
|
SAPLSLOG,
|
SAPLSLOG,
|
|
S_DEVELOP |
ACTVT |
01 |
01,02,03,06 |
01,02,03,06 |
01 |
DEVCLASS |
ZODI_LKM_PCKG |
||||
OBJNAME |
ZODI_FGR_PROD* |
ZODI_FGR_PROD* |
ZODI_FGR_PROD* |
ZODI_FGR_PROD* |
|
OBJTYPE |
FUGR |
FUGR,PROG |
FUGR |
FUGR |
|
S_PROGRAM |
P_ACTION |
EDIT,SUBMIT,VARIANT |
EDIT,SUBMIT,VARIANT |
||
P_GROUP |
|||||
S_CTS_ADMI |
CTS_ADMFCT |
TABL |
|||
S_TRANSPRT |
ACTVT |
01 |
01 |
01 |
01 |
TTYPE |
DTRA,TASK |
DTRA,TASK |
DTRA,TASK |
DTRA,TASK |
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 |
RFC_NAME |
SDIFRUNTIME, SYST,ZODI* |
RFC1, SDIFRUNTIME, SYST,ZODI_FGR_PROD* |
RFC1, SDIFRUNTIME, SYST,ZODI_FGR_PROD* |
RFC1, SDIFRUNTIME, SYST,ZODI_FGR_PROD* |
|
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 |
|
FILENAME |
*\\DEL-7TMK2BS\odiagentbox*, \\DEL-7TMK2BS\odiagentbox |
*\\DEL-7TMK2BS\odiagentbox*, \\DEL-7TMK2BS\odiagentbox |
*\\DEL-7TMK2BS\odiagentbox*, \\DEL-7TMK2BS\odiagentbox |
||
PROGRAM |
SAPLSLOG, SAPLSTRF, SAPLZODI |
SAPLSLOG, SAPLSTRF, SAPLZODI* |
SAPLSLOG, SAPLSTRF, SAPLZODI*,ZODI* |
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 |
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* |
|
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 |
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 |
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* |
|
PROGRAM |
SAPLSLOG,
|
SAPLSLOG,
|
SAPLSLOG*,
|
SAPLSLOG,
|
|
S_DEVELOP |
ACTVT |
01 |
01,02,03,06,16 |
01,02,03,06,16 |
01 |
DEVCLASS |
|||||
OBJNAME |
ZODI_FGR_PROD* |
ZODI_FGR_PROD* |
ZODI_FGR_PROD* |
ZODI_FGR_PROD* |
|
OBJTYPE |
FUGR |
FUGR |
FUGR,PROG |
FUGR |
|
P_GROUP |
|||||
S_PROGRAM |
P_ACTION |
EDIT,SUBMIT,VARIANT |
EDIT,SUBMIT,VARIANT |
||
P_GROUP |
|||||
S_TRANSPORT |
ACTVT |
01,02,03 |
01,02,03 |
01,02 |
01,02 |
TTYPE |
DTRA,TASK |
DTRA,TASK |
DTRA,TASK |
DTRA,TASK |
|
S_APPL_LOG |
ACTVT |
06 |
06 |
06 |
06 |
ALG_OBJECT |
ZODI_APPOBJ |
ZODI_APPOBJ |
ZODI_APPOBJ |
ZODI_APPOBJ |
|
ALG_SUBOBJ |
ZODI_SUBOBJ |
ZODI_SUBOBJ |
ZODI_SUBOBJ |
ZODI_SUBOBJ |
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 |
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* |
|
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 |
JOBGROUP |
'' |
'' |
'' |
'' |
|
S_DATASET |
ACTVT |
06,33,34 |
06,33,34 |
06,33,34 |
06,33,34 |
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* |
|
PROGRAM |
SAPLSLOG,
|
SAPLSLOG,
|
SAPLSLOG,
|
SAPLSLOG,
|
|
S_APP_LOG |
ACTVT |
06 |
06 |
06 |
06 |
ALG_SUBOBJ |
ZODI_SUBOBJ |
ZODI_SUBOBJ |
ZODI_SUBOBJ |
ZODI_SUBOBJ |
|
ALG_SUBOBJ |
ZODI_SUBOBJ |
ZODI_SUBOBJ |
ZODI_SUBOBJ |
ZODI_SUBOBJ |
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.
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.