This appendix lists the required privileges for accessing the SAP system using Oracle Data Integrator.
For connecting to the SAP system a SAP dialog user is required for RKM installation and LKM execution during development. A SAP RFC user is not sufficient.
This user has to 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.
Later for RKM execution and LKM execution in production a SAP RFC user is sufficient.
These SAP user types can be used for the following operations:
Table A-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 |
Testing ODI Generated Extraction RFCs |
SAP Dialog user or SAP RFC user |
The following tables list the privileges required for using SAP BW Knowledge Modules:
Authorizations Required for LKM SAP BW Upload (Background mode)
Authorizations Required for LKM SAP BW Execution (Background mode)
Authorizations Required for LKM SAP BW Execution (Dialog mode)
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 authorizations are required for first time installation of RKM SAP BW.
Note:
Developer Key is required in this authorization.Object | Field Name | Value (BW 3.5) | Value (BI 7.0) |
---|---|---|---|
S_RFC |
ACTVT |
16 |
|
RFC_NAME |
RFC1, RSAB, RSB3RD, SDIFRUNTIME, SUTL, SYST, SYSU, ZODI_FGR |
SDIFRUNTIME, (NR - {RSAB,RSB3RD, SYSU}) |
|
RFC_TYPE |
FUGR |
||
S_TCODE |
TCD |
SU53, SE38 |
|
S_ADMI_FCD |
S_ADMI_FCD |
MEMO |
|
S_CTS_ADMI |
CTS_ADMFCT |
TABL |
|
S_DATASET |
ACTVT |
34 |
33 |
FILENAME |
D:\usr\sap\trans\actlog\DBT*,
|
\\DELBI7\SAPMNT\trans\actlog\BIDZ* |
|
PROGRAM |
SAPLSTRF |
||
S_TABU_DIS |
ACTVT |
03 |
|
DICBERCLS |
MA |
||
S_DEVELOP |
ACTVT |
01,02,03,06 |
07,16 |
DEVCLAS |
$TMP, ZODI_LKM_PCKG, ZODI_RKM_PCKG |
||
OBJNAME |
Z$$$XRFC, ZODI_FGR, ZODI_FGR_PROD, ZODI_LKM_PCKG, ZODI_RKM_PCKG |
||
OBJTYPE |
DEVC, FUGR, PROG |
||
P_GROUP |
* |
||
S_TRANSPRT |
ACTVT |
01,02,03,06 |
06 (NR) |
TTYPE |
DTRA, TASK |
||
S_RS_ADMWB |
ACTVT |
03,16 |
|
RSADMWBOBJ |
INFOOBJECT |
||
S_RS_ICUBE |
ACTVT |
03 |
|
RSICUBEOBJ |
DATA, DEFINITION |
||
RSINFOAREA |
NODESNOTCONNECTED |
0* |
|
RSINFOCUBE |
0*,Z* |
1* |
|
S_RS_IOBJ |
ACTVT |
03 |
|
RSIOBJ |
0*, Z* |
||
RSIOBJCAT |
* |
0*,0CHANOTASSINED, Z* |
|
RSIOBJPART |
DEFINITION |
DATA,DEFINITION |
|
S_RS_ODSO |
ACTVT |
03 |
|
RSINFOAREA |
0*, NODESNOTCONNECTED |
||
RSODSOBJ |
0*,Z* |
||
RSODSPART |
DATA,DEFINITION |
The following authorizations are required for first time installation of RKM SAP BW.
Object | Field Name | Value (BW 3.5) | Value (BI 7.0) |
---|---|---|---|
S_RFC |
ACTVT |
16 |
|
RFC_NAME |
RFC1, RSB3RD, SDIFRUNTIME, SYST, ZODI_FGR |
||
RFC_TYPE |
FUGR |
||
S_TCODE |
TCD |
SU53 |
|
S_TABU_DIS |
ACTVT |
03 |
|
DICBERCLS |
MA |
SC |
|
S_RS_ADMWB |
ACTVT |
03,16 |
16 NR |
RSADMWBOBJ |
INFOOBJECT |
||
S_RS_ICUBE |
ACTVT |
03 |
|
RSICUBEOBJ |
DATA,DEFINITION |
||
RSINFOAREA |
NODESNOTCONNECTED |
0* |
|
RSINFOCUBE |
0*,Z* |
||
S_RS_IOBJ |
ACTVT |
03 |
|
RSIOBJ |
0*,Z* |
Z* (NR) |
|
RSIOBJCAT |
* |
0* |
|
RSIOBJPART |
DEFINITION |
||
S_RS_ODSO |
ACTVT |
03 |
|
RSINFOAREA |
0*, NODESNOTCONNECTED |
T*,Z*, NODESNOTCONNECTED (NR) |
|
RSODSOBJ |
0*,Z* |
*U |
|
RSODSPART |
DATA,DEFINITION |
The following authorizations are required for running the mappings using SAP BW LKMs in a SAP development environment when LKM option BACKGROUND_PROCESSING
is set to true
(recommended default).
Note:
Developer Key is required in this authorization.Object | Field Name | Value (BW 3.5) | Value (BI 7.0) |
---|---|---|---|
S_RFC |
ACTVT |
16 |
|
RFC_NAME |
RFC1, SDIFRUNTIME, SLST, SYST, ZODI_FGR, ZODI_FGR_PROD*,RSAB,SYSU |
(NR : {RSAB, SYSU}) |
|
RFC_TYPE |
FUGR |
||
S_TCODE |
TCD |
SE38,SU53 |
|
S_APPL_LOG |
ACTBT |
03,06 |
|
ALG_OBJECT |
ZODI_APPOBJ |
||
ALG_SUBOBJ |
ZODI_SUBOBJ |
||
S_BTCH_ADM |
BTCADMIN |
Y |
|
S_BTCH_JOB |
JOBACTION |
RELE |
|
JOBGROUP |
'' |
||
S_CTS_ADMI |
CTS_ADMFCT |
TABL |
|
S_DATASET |
ACTVT |
06,33,34 |
|
FILENAME |
D:\usr\sap\trans\actlog\DBT*,
|
||
PROGRAM |
SAPLSTRF, ZODI* |
SAPLSLOG*D22, SAPLZODI* |
|
S_DEVELOP |
ACTVT |
01 |
02,03,06,16 |
DEVCLASS |
|||
OBJNAME |
ZODI_FGR_PROD* |
||
OBJTYPE |
FUGR,PROG* |
||
P_GROUP |
|||
S_PROGRAM |
P_ACTION |
NR |
EDIT, SUBMIT, VARIANT |
P_GROUP |
NR |
||
S_TRANSPRT |
ACTVT |
01,02,03 |
03 (NR) |
TTYPE |
DTRA,TASK |
||
S_RS_AUTH |
BIAUTH |
NR |
0* |
S_RS_ICUBE |
ACTVT |
03,06 |
NR |
RSICUBEOBJ |
DATA,DEFINITION |
NR |
|
RSINFOAREA |
NODESNOTCONNECTED |
NR |
|
RSINFOCUBE |
0*,Z* |
NR |
The following authorizations are required for running the mappings using SAP BW LKMs in a SAP production environment when LKM option BACKGROUND_PROCESSING
is set to true
(recommended default).
Object | Field Name | Value (BW 3.5) | Value (BI 7.0) |
---|---|---|---|
S_RFC |
ACTVT |
16 |
|
RFC_NAME |
RFC1, SDIFRUNTIME, SLST, SYST, ZODI*,SYSU |
SYSU(NR) |
|
RFC_TYPE |
FUGR |
||
S_TCODE |
TCD |
SU53 |
|
S_APP_LOG |
ACTBT |
03,06 |
|
ALG_OBJECT |
ZODI_* |
||
ALG_SUBOBJ |
ZODI_* |
||
S_BTCH_ADM |
BTCADMIN |
Y |
|
S_BTCH_JOB |
JOBACTION |
RELE |
|
JOBGROUP |
'' |
||
S_DATASET |
ACTVT |
06,33,34 |
|
FILENAME |
D:\usr\sap\trans\actlog\DBT*,
|
||
PROGRAM |
ZODI* |
||
S_DEVELOP |
ACTVT |
NR |
01,02,03,06,07,16 |
DEVCLASS |
NR |
||
OBJNAME |
NR |
S_TCODE |
|
OBJTYPE |
NR |
SUSO |
|
P_GROUP |
NR |
||
S_RS_AUTH |
BIAUTH |
NR |
|
S_RS_ICUBE |
ACTVT |
03 |
|
RSICUBEOBJ |
DATA,DEFINITION |
||
RSINFOAREA |
NODESNOTCONNECTED |
0*, Z*, (NR : {NODESNOTCONNECTED}) |
|
RSINFOCUBE |
0*,Z* |
The following authorizations are required for running the mappings using the SAP BW LKMs in a SAP development environment when LKM option BACKGROUND_PROCESSING
is set to false
(non-default).
Note:
Developer Key is required in this authorization.Object | Field Name | Value (BW 3.5) | Value (BI 7.0) |
---|---|---|---|
S_RFC |
ACTVT |
16 |
|
RFC_NAME |
RFC1, SDIFRUNTIME, SYST, ZODI_FGR, ZODI_FGR_PROD*,SYSU,RSAB |
RSAB(NR) |
|
RFC_TYPE |
FUGR |
||
S_TCODE |
TCD |
SE38,SE53 |
|
S_CTS_ADMI |
CTS_ADMFCT |
TABL |
|
S_DATASET |
ACTVT |
06,33,34 |
|
FILENAME |
D:\usr\sap\trans\actlog\DBT*,
|
||
PROGRAM |
SAPLSLOG*,
|
||
S_DEVELOP |
ACTVT |
01,02,03,06 |
|
DEVCLASS |
|||
OBJNAME |
ZODI_FGR_PROD* |
||
OBJTYPE |
FUGR, PROG |
||
P_GROUP |
|||
S_PROGRAM |
P_ACTION |
NR |
EDIT, SUBMIT, VARIANT |
P_GROUP |
NR |
||
S_TRANSPRT |
ACTVT |
01 |
|
TTYPE |
DTRA, TASK |
||
S_RS_AUTH |
BIAUTH |
NR |
0* |
S_RS_ICUBE |
ACTVT |
03 |
NR |
RSICUBEOBJ |
DATA,DEFINITION |
NR |
|
RSINFOAREA |
NODESNOTCONNECTED |
NR |
|
RSINFOCUBE |
0*,Z* |
NR |
The following authorizations are required for running the mappings using the SAP BW LKMs in a SAP production environment when LKM option BACKGROUND_PROCESSING
is set to false
(non-default).
Object | Field Name | Value (BW 3.5) | Value (BI 7.0) |
---|---|---|---|
S_RFC |
ACTVT |
16 |
|
RFC_NAME |
RFC1, SDIFRUNTIME, SYST, ZODI_FGR_PROD* |
||
RFC_TYPE |
FUGR |
||
S_TCODE |
TCD |
SU53 |
|
S_DATASET |
ACTVT |
06,33,34 |
|
FILENAME |
\\10.30.0.214\ODI_SAPTEST\ZODI*,
|
||
PROGRAM |
SAPLSLOG*, SAPLSTRF*, SAPLZODI* |
||
S_RS_AUTH |
BIAUTH |
NR |
0* |
S_RS_ICUBE |
ACTVT |
03 |
|
RSICUBEOB |
DATA,DEFINITION |
DATA (NR) |
|
RSINFOAREA |
NODESNOTCONNECTED |
NR |
|
RSINFOCUBE |
0*,Z* |
NR |
|
S_RS_IOBJ |
ACTVT |
NR |
03 |
RSIOBJ |
NR |
||
RSIOBJCAT |
NR |
||
RSIOBJPART |
NR |
DEFINITION |
|
S_RS_ODSO |
ACTVT |
NR |
03 |
RSINFOAREA |
NR |
||
RSODSOBJ |
NR |
||
RSODSPART |
NR |
DEFINITION |