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 SAP authorizations are required, only in rare cases when explicitly requested by Oracle product support. For standard installations, these authorizations are not required.

Note:

Developer Key is required in this authorization.

Object Field Name Value (BI 7.0) Value (BI 7.5)

S_RFC

ACTVT

16

16

S_RFC

RFC_NAME

RFC1, RSAB, RSB3RD, SDIFRUNTIME, SUTL, SYST, SYSU, ZODI*

RFC1, RSAB, RSB3RD, SDIFRUNTIME, SUTL, SYST, SYSU, ZODI*, RSBAPI_IOBJ

S_RFC

RFC_TYPE

FUGR

FUGR

S_RFCRAIAR

RFC_RAIAR

NR

16

S_TCODE

TCD

SU53, SE38

SU53, SE38

S_ADMI_FCD

S_ADMI_FCD

RFCA

RFCA

S_CTS_ADMI

CTS_ADMFCT

TABL

TABL

S_DATASET

ACTVT

06,33,34

06,33,34,A7

S_DATASET

FILENAME

*

*

S_DATASET

PROGRAM

SAPLSLOG, SAPLSTRF, SAPLZODI*

*

S_TABU_DIS

ACTVT

3

2,3

S_TABU_DIS

DICBERCLS

*

*

S_DEVELOP

ACTVT

01,02,03,06,07,16,70,MA

01,02,03,06,07,16,70,MA

S_DEVELOP

DEVCLASS

$TMP,ZODI_LKM_PCKG,ZODI_RKM_PCKG,RSS,ZODI*

$TMP,ZODI_LKM_PCKG,ZODI_RKM_PCKG,RSS,ZODI*

S_DEVELOP

OBJNAME

*

*

S_DEVELOP

OBJTYPE

FUGR,PROG,DEVC,DEBUG

*

S_DEVELOP

P_GROUP

*

*

S_TRANSPRT

ACTVT

01,02,03

01,02,03

S_TRANSPRT

TTYPE

DTRA, TASK

DTRA, TASK

S_RS_ADMWB

ACTVT

03,16

03,16

S_RS_ADMWB

RSADMWBOBJ

INFOOBJECT

INFOOBJECT

S_RS_ICUBE

ACTVT

03

03

S_RS_ICUBE

RSICUBEOBJ

*

*

S_RS_ICUBE

RSINFOAREA

*

*

S_RS_ICUBE

RSINFOCUBE

*

*

S_RS_IOBJ

ACTVT

03

03

S_RS_IOBJ

RSIOBJ

*

*

S_RS_IOBJ

RSIOBJCAT

*

*

S_RS_IOBJ

RSIOBJPART

DEFINITION

DEFINITION

S_RS_ODSO

ACTVT

03

03

S_RS_ODSO

RSINFOAREA

*

*

S_RS_ODSO

RSODSOBJ

*

*

S_RS_ODSO

RSODSPART

DATA,DEFINITION

DATA,DEFINITION

A.3 Authorizations Required for RKM SAP BW Execution

The following authorizations are required for RKM SAP BW execution.

Object Field Name Value (BI 7.0) Value (BI 7.5)

S_RFC

ACTVT

16

16

S_RFC

RFC_NAME

RFC1, RSAB, RSB3RD, SDIFRUNTIME, SUTL, SYST, SYSU, ZODI*

RFC1, RSAB, RSB3RD, SDIFRUNTIME, SUTL, SYST, SYSU, ZODI*, RSBAPI_IOBJ

S_RFC

RFC_TYPE

FUGR

FUGR

S_TCODE

TCD

SU53

SU53

S_DATASET

ACTVT

06, 33, 34

06, 33, 34

S_DATASET

FILENAME

*

*

S_DATASET

PROGRAM

SAPLSTRF, SAPLSLOG, SAPLZODI*

SAPLSTRF, SAPLSLOG, SAPLZODI*

S_TABU_DIS

ACTVT

03

03

S_TABU_DIS

DICBERCLS

*

*

S_TRANSPRT

ACTVT

01, 02, 03

01, 02, 03

S_TRANSPRT

TTYPE

DTRA, TASK

DTRA, TASK

S_RS_ADMWB

ACTVT

03,16

03,16

S_RS_ADMWB

RSADMWBOBJ

*

*

S_RS_ICUBE

ACTVT

03

03

S_RS_ICUBE

RSICUBEOBJ

DATA, DEFINITION

DATA, DEFINITION

S_RS_ICUBE

RSINFOAREA

*

*

S_RS_ICUBE

RSINFOCUBE

*

*

S_RS_IOBJ

ACTVT

03

03

S_RS_IOBJ

RSIOBJ

*

*

S_RS_IOBJ

RSIOBJCAT

*

*

S_RS_IOBJ

RSIOBJPART

DEFINITION

DEFINITION

S_RS_ODSO

ACTVT

03

03

S_RS_ODSO

RSINFOAREA

*

*

S_RS_ODSO

RSODSOBJ

*

*

S_RS_ODSO

RSODSPART

DATA, DEFINITION

DATA, DEFINITION

S_RS_AUTH

BIAUTH

0*

0*

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

The following authorizations are required for LKM SAP BW execution in a SAP development environment.

Note:

Developer Key is required in this authorization.

This section contains authorizations for both background and foreground executions.

Object Field Name Value (BI 7.0) Value (BI 7.5)

S_RFC

ACTVT

16

16

S_RFC

RFC_NAME

RFC1, SDIFRUNTIME, SLST, SYST, ZODI*

RFC1, SDIFRUNTIME, SLST, SYST, ZODI*

S_RFC

RFC_TYPE

FUGR

FUGR

S_TCODE

TCD

SE38,SU53

SE38,SU53

S_DEVELOP

ACTVT

1, 2, 3, 6, 7, 16

1, 2, 3, 6, 7, 16

S_DEVELOP

DEVCLASS

*

*

S_DEVELOP

OBJNAME

*

*

S_DEVELOP

OBJTYPE

FUGR, FUNC, PROG*, SUSO

FUGR, FUNC, PROG*, SUSO

S_DEVELOP

P_GROUP

NR

NR

S_PROGRAM

P_ACTION

BTCSUBMIT, SUBMIT, VARIANT

BTCSUBMIT, SUBMIT, VARIANT

S_PROGRAM

P_GROUP

NR

NR

S_TRANSPRT

ACTVT

1, 2, 43

1, 2, 43

S_TRANSPRT

TTYPE

DTRA,TASK

DTRA,TASK

S_TABU_DIS

ACTVT

3

3

S_TABU_DIS

DICBERCLS

*

*

S_BTCH_ADM

BTCADMIN

Y

Y

S_BTCH_JOB

JOBACTION

RELE

RELE

S_BTCH_JOB

JOBGROUP

‘’

‘’

S_CTS_ADMI

CTS_ADMFCT

TABL

TABL

S_DATASET

ACTVT

06,33,34

06,33,34

S_DATASET

FILENAME

*

*

S_DATASET

PROGRAM

*

*

S_RS_AUTH

BIAUTH

*

*

S_RS_ICUBE

ACTVT

3, 6

3, 6

S_RS_ICUBE

RSICUBEOBJ

DATA, DEFINITION

DATA, DEFINITION

S_RS_ICUBE

RSINFOAREA

*

*

S_RS_ICUBE

RSINFOCUBE

*

*

S_RS_IOBJ

ACTVT

3

3

S_RS_IOBJ

RSIOBJ

*

*

S_RS_IOBJ

RSIOBJCAT

*

*

S_RS_IOBJ

RSIOBJPART

DATA, DEFINITION

DATA, DEFINITION

S_RS_ODSO

ACTVT

3

3

S_RS_ODSO

RSINFOAREA

*

*

S_RS_ODSO

RSODSOBJ

*

*

S_RS_ODSO

RSODSPART

DATA, DEFINITION

DATA, DEFINITION

S_APP_LOG

ACTVT

03, 06

03, 06

S_APP_LOG

ALG_OBJECT

*

*

S_APP_LOG

ALG_SUBOBJ

*

*

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

The following authorizations are required for LKM SAP BW execution in a SAP production environment.

This section contains authorizations for both background and foreground executions.

Object Field Name Value (BI 7.0) Value (BI 7.5)

S_RFC

ACTVT

16

16

S_RFC

RFC_NAME

RFC1, SDIFRUNTIME, SLST, SYST, ZODI_FGR_PROD*

RFC1, SDIFRUNTIME, SLST, SYST, ZODI_FGR_PROD*

S_RFC

RFC_TYPE

FUGR

FUGR

S_TCODE

TCD

SU53

SU53

S_TABU_DIS

ACTVT

3

3

S_TABU_DIS

DICBERCLS

*

*

S_BTCH_ADM

BTCADMIN

Y

Y

S_BTCH_JOB

JOBACTION

RELE

RELE

S_BTCH_JOB

JOBGROUP

‘’

‘’

S_DATASET

ACTVT

06,33,34

06, 33, 34

S_DATASET

FILENAME

*

*

S_DATASET

PROGRAM

*

*

S_TRANSPRT

ACTVT

1, 2, 43

1, 2, 43

S_TRANSPRT

TTYPE

DTRA, TASK

DTRA, TASK

S_RS_AUTH

BIAUTH

*

*

S_RS_ICUBE

ACTVT

3, 6

3, 6, 23, 63, 66

S_RS_ICUBE

RSICUBEOBJ

*

*

S_RS_ICUBE

RSINFOAREA

*

*

S_RS_ICUBE

RSINFOCUBE

*

*

S_RS_IOBJ

ACTVT

3

3

S_RS_IOBJ

RSIOBJ

*

*

S_RS_IOBJ

RSIOBJCAT

*

*

S_RS_IOBJ

RSIOBJPART

DATA, DEFINITION

DATA, DEFINITION

S_RS_ODSO

ACTVT

3

3

S_RS_ODSO

RSINFOAREA

*

*

S_RS_ODSO

RSODSOBJ

*

*

S_RS_ODSO

RSODSPART

DATA, DEFINITION

DATA, DEFINITION

S_APP_LOG

ACTVT

03, 06

03, 06

S_APP_LOG

ALG_OBJECT

*

*

S_APP_LOG

ALG_SUBOBJ

*

*