A SAP ABAP BW Required Privileges

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:

A.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.

A.2 Authorizations Required for RKM SAP BW Upload

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`	`''`
`S_RFC`	`RFC_NAME`	`RFC1, RSAB, RSB3RD, SDIFRUNTIME, SUTL, SYST, SYSU, ZODI_FGR`	`SDIFRUNTIME, (NR - {RSAB,RSB3RD, SYSU})`
`S_RFC`	`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`
`S_DATASET`	`FILENAME`	`D:\usr\sap\trans\actlog\DBT,` `\\10.30.0.214\ODI_SAPTEST\ZODI,` `\\DELRC6\sapmnt\trans\actlog\DBT*`	`\\DELBI7\SAPMNT\trans\actlog\BIDZ*`
`S_DATASET`	`PROGRAM`	`SAPLSTRF`	`''`
`S_TABU_DIS`	`ACTVT`	`''`	`03`
`S_TABU_DIS`	`DICBERCLS`	`''`	`MA`
`S_DEVELOP`	`ACTVT`	`01,02,03,06`	`07,16`
`S_DEVELOP`	`DEVCLAS`	`$TMP, ZODI_LKM_PCKG, ZODI_RKM_PCKG`	`''`
`S_DEVELOP`	`OBJNAME`	`Z$$$XRFC, ZODI_FGR, ZODI_FGR_PROD, ZODI_LKM_PCKG, ZODI_RKM_PCKG`	`''`
`S_DEVELOP`	`OBJTYPE`	`DEVC, FUGR, PROG`	`''`
`S_DEVELOP`	`P_GROUP`	`''`	`*`
`S_TRANSPRT`	`ACTVT`	`01,02,03,06`	`06 (NR)`
`S_TRANSPRT`	`TTYPE`	`DTRA, TASK`	`''`
`S_RS_ADMWB`	`ACTVT`	`03,16`	`''`
`S_RS_ADMWB`	`RSADMWBOBJ`	`INFOOBJECT`	`''`
`S_RS_ICUBE`	`ACTVT`	`03`	`''`
`S_RS_ICUBE`	`RSICUBEOBJ`	`DATA, DEFINITION`	`''`
`S_RS_ICUBE`	`RSINFOAREA`	`NODESNOTCONNECTED`	`0*`
`S_RS_ICUBE`	`RSINFOCUBE`	`0,Z`	`1*`
`S_RS_IOBJ`	`ACTVT`	`03`	`''`
`S_RS_IOBJ`	`RSIOBJ`	`0, Z`	`''`
`S_RS_IOBJ`	`RSIOBJCAT`	`*`	`0,0CHANOTASSINED, Z`
`S_RS_IOBJ`	`RSIOBJPART`	`DEFINITION`	`DATA,DEFINITION`
`S_RS_ODSO`	`ACTVT`	`03`	`''`
`S_RS_ODSO`	`RSINFOAREA`	`0*, NODESNOTCONNECTED`	`''`
`S_RS_ODSO`	`RSODSOBJ`	`0,Z`	`''`
`S_RS_ODSO`	`RSODSPART`	`DATA,DEFINITION`	`''`

A.3 Authorizations Required for RKM SAP BW Execution

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`	`''`
`S_RFC`	`RFC_NAME`	`RFC1, RSB3RD, SDIFRUNTIME, SYST, ZODI_FGR`	`''`
`S_RFC`	`RFC_TYPE`	`FUGR`	`''`
`S_TCODE`	`TCD`	`SU53`	`''`
`S_TABU_DIS`	`ACTVT`	`03`	`''`
`S_TABU_DIS`	`DICBERCLS`	`MA`	`SC`
`S_RS_ADMWB`	`ACTVT`	`03,16`	`16 NR`
`S_RS_ADMWB`	`RSADMWBOBJ`	`INFOOBJECT`	`''`
`S_RS_ICUBE`	`ACTVT`	`03`	`''`
`S_RS_ICUBE`	`RSICUBEOBJ`	`DATA,DEFINITION`	`''`
`S_RS_ICUBE`	`RSINFOAREA`	`NODESNOTCONNECTED`	`0*`
`S_RS_ICUBE`	`RSINFOCUBE`	`0,Z`	`''`
`S_RS_IOBJ`	`ACTVT`	`03`	`''`
`S_RS_IOBJ`	`RSIOBJ`	`0,Z`	`Z* (NR)`
`S_RS_IOBJ`	`RSIOBJCAT`	`*`	`0*`
`S_RS_IOBJ`	`RSIOBJPART`	`DEFINITION`	`''`
`S_RS_ODSO`	`ACTVT`	`03`	`''`
`S_RS_ODSO`	`RSINFOAREA`	`0*, NODESNOTCONNECTED`	`T,Z, NODESNOTCONNECTED (NR)`
`S_RS_ODSO`	`RSODSOBJ`	`0,Z`	`*U`
`S_RS_ODSO`	`RSODSPART`	`DATA,DEFINITION`	`''`

A.4 Authorizations Required for LKM SAP BW Upload (Background mode)

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`	`''`
`S_RFC`	`RFC_NAME`	`RFC1, SDIFRUNTIME, SLST, SYST, ZODI_FGR, ZODI_FGR_PROD*,RSAB,SYSU`	`(NR : {RSAB, SYSU})`
`S_RFC`	`RFC_TYPE`	`FUGR`	`''`
`S_TCODE`	`TCD`	`SE38,SU53`	`''`
`S_APPL_LOG`	`ACTBT`	`03,06`	`''`
`S_APPL_LOG`	`ALG_OBJECT`	`ZODI_APPOBJ`	`''`
`S_APPL_LOG`	`ALG_SUBOBJ`	`ZODI_SUBOBJ`	`''`
`S_BTCH_ADM`	`BTCADMIN`	`Y`	`''`
`S_BTCH_JOB`	`JOBACTION`	`RELE`	`''`
`S_BTCH_JOB`	`JOBGROUP`	`''`	`''`
`S_CTS_ADMI`	`CTS_ADMFCT`	`TABL`	`''`
`S_DATASET`	`ACTVT`	`06,33,34`	`''`
`S_DATASET`	`FILENAME`	`D:\usr\sap\trans\actlog\DBT,` `\\10.30.0.214\ODI_SAPTEST\ZODI,` `D:\usr\sap\DBT\DVEBMGS40\work\ZODI*`	`''`
`S_DATASET`	`PROGRAM`	`SAPLSTRF, ZODI*`	`SAPLSLOGD22, SAPLZODI`
`S_DEVELOP`	`ACTVT`	`01`	`02,03,06,16`
`S_DEVELOP`	`DEVCLASS`	`''`	`''`
`S_DEVELOP`	`OBJNAME`	`ZODI_FGR_PROD*`	`''`
`S_DEVELOP`	`OBJTYPE`	`FUGR,PROG*`	`''`
`S_DEVELOP`	`P_GROUP`	`''`	`''`
`S_PROGRAM`	`P_ACTION`	`NR`	`EDIT, SUBMIT, VARIANT`
`S_PROGRAM`	`P_GROUP`	`NR`	`''`
`S_TRANSPRT`	`ACTVT`	`01,02,03`	`03 (NR)`
`S_TRANSPRT`	`TTYPE`	`DTRA,TASK`	`''`
`S_RS_AUTH`	`BIAUTH`	`NR`	`0*`
`S_RS_ICUBE`	`ACTVT`	`03,06`	`NR`
`S_RS_ICUBE`	`RSICUBEOBJ`	`DATA,DEFINITION`	`NR`
`S_RS_ICUBE`	`RSINFOAREA`	`NODESNOTCONNECTED`	`NR`
`S_RS_ICUBE`	`RSINFOCUBE`	`0,Z`	`NR`

A.5 Authorizations Required for LKM SAP BW Execution (Background mode)

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`	`''`
`S_RFC`	`RFC_NAME`	`RFC1, SDIFRUNTIME, SLST, SYST, ZODI*,SYSU`	`SYSU(NR)`
`S_RFC`	`RFC_TYPE`	`FUGR`	`''`
`S_TCODE`	`TCD`	`SU53`	`''`
`S_APP_LOG`	`ACTBT`	`03,06`	`''`
`S_APP_LOG`	`ALG_OBJECT`	`ZODI_*`	`''`
`S_APP_LOG`	`ALG_SUBOBJ`	`ZODI_*`	`''`
`S_BTCH_ADM`	`BTCADMIN`	`Y`	`''`
`S_BTCH_JOB`	`JOBACTION`	`RELE`	`''`
`S_BTCH_JOB`	`JOBGROUP`	`''`	`''`
`S_DATASET`	`ACTVT`	`06,33,34`	`''`
`S_DATASET`	`FILENAME`	`D:\usr\sap\trans\actlog\DBT,` `\\10.30.0.214\ODI_SAPTEST\ZODI,` `D:\usr\sap\DBT\DVEBMGS40\work\ZODI*`	`''`
`S_DATASET`	`PROGRAM`	`ZODI*`	`''`
`S_DEVELOP`	`ACTVT`	`NR`	`01,02,03,06,07,16`
`S_DEVELOP`	`DEVCLASS`	`NR`	`''`
`S_DEVELOP`	`OBJNAME`	`NR`	`S_TCODE`
`S_DEVELOP`	`OBJTYPE`	`NR`	`SUSO`
`S_DEVELOP`	`P_GROUP`	`NR`	`''`
`S_RS_AUTH`	`BIAUTH`	`NR`	`''`
`S_RS_ICUBE`	`ACTVT`	`03`	`''`
`S_RS_ICUBE`	`RSICUBEOBJ`	`DATA,DEFINITION`	`''`
`S_RS_ICUBE`	`RSINFOAREA`	`NODESNOTCONNECTED`	`0, Z, (NR : {NODESNOTCONNECTED})`
`S_RS_ICUBE`	`RSINFOCUBE`	`0,Z`	`''`

A.6 Authorizations Required for LKM SAP BW Upload (Dialog mode)

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`	`''`
`S_RFC`	`RFC_NAME`	`RFC1, SDIFRUNTIME, SYST, ZODI_FGR, ZODI_FGR_PROD*,SYSU,RSAB`	`RSAB(NR)`
`S_RFC`	`RFC_TYPE`	`FUGR`	`''`
`S_TCODE`	`TCD`	`SE38,SE53`	`''`
`S_CTS_ADMI`	`CTS_ADMFCT`	`TABL`	`''`
`S_DATASET`	`ACTVT`	`06,33,34`	`''`
`S_DATASET`	`FILENAME`	`D:\usr\sap\trans\actlog\DBT,` `\\10.30.0.214\ODI_SAPTEST\ZODI,` `D:\usr\sap\DBT\DVEBMGS40\work\ZODI*`	`''`
`S_DATASET`	`PROGRAM`	`SAPLSLOG,` `SAPLSTRF,` `SAPLZODI*`	`''`
`S_DEVELOP`	`ACTVT`	`01,02,03,06`	`''`
`S_DEVELOP`	`DEVCLASS`	`''`	`''`
`S_DEVELOP`	`OBJNAME`	`ZODI_FGR_PROD*`	`''`
`S_DEVELOP`	`OBJTYPE`	`FUGR, PROG`	`''`
`S_DEVELOP`	`P_GROUP`	`''`	`''`
`S_PROGRAM`	`P_ACTION`	`NR`	`EDIT, SUBMIT, VARIANT`
`S_PROGRAM`	`P_GROUP`	`NR`	`''`
`S_TRANSPRT`	`ACTVT`	`01`	`''`
`S_TRANSPRT`	`TTYPE`	`DTRA, TASK`	`''`
`S_RS_AUTH`	`BIAUTH`	`NR`	`0*`
`S_RS_ICUBE`	`ACTVT`	`03`	`NR`
`S_RS_ICUBE`	`RSICUBEOBJ`	`DATA,DEFINITION`	`NR`
`S_RS_ICUBE`	`RSINFOAREA`	`NODESNOTCONNECTED`	`NR`
`S_RS_ICUBE`	`RSINFOCUBE`	`0,Z`	`NR`

A.7 Authorizations Required for LKM SAP BW Execution (Dialog mode)

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`	`''`
`S_RFC`	`RFC_NAME`	`RFC1, SDIFRUNTIME, SYST, ZODI_FGR_PROD*`	`''`
`S_RFC`	`RFC_TYPE`	`FUGR`	`''`
`S_TCODE`	`TCD`	`SU53`	`''`
`S_DATASET`	`ACTVT`	`06,33,34`	`''`
`S_DATASET`	`FILENAME`	`\\10.30.0.214\ODI_SAPTEST\ZODI,` `D:\usr\sap\DBT\DVEBMGS40\work\ZODI`	`''`
`S_DATASET`	`PROGRAM`	`SAPLSLOG, SAPLSTRF, SAPLZODI*`	`''`
`S_RS_AUTH`	`BIAUTH`	`NR`	`0*`
`S_RS_ICUBE`	`ACTVT`	`03`	`''`
`S_RS_ICUBE`	`RSICUBEOB`	`DATA,DEFINITION`	`DATA (NR)`
`S_RS_ICUBE`	`RSINFOAREA`	`NODESNOTCONNECTED`	`NR`
`S_RS_ICUBE`	`RSINFOCUBE`	`0,Z`	`NR`
`S_RS_IOBJ`	`ACTVT`	`NR`	`03`
`S_RS_IOBJ`	`RSIOBJ`	`NR`	`''`
`S_RS_IOBJ`	`RSIOBJCAT`	`NR`	`''`
`S_RS_IOBJ`	`RSIOBJPART`	`NR`	`DEFINITION`
`S_RS_ODSO`	`ACTVT`	`NR`	`03`
`S_RS_ODSO`	`RSINFOAREA`	`NR`	`''`
`S_RS_ODSO`	`RSODSOBJ`	`NR`	`''`
`S_RS_ODSO`	`RSODSPART`	`NR`	`DEFINITION`