Skip Headers
Oracle® Fusion Middleware Getting Started with SAP ABAP BW Adapter for Oracle Data Integrator
11g Release 1 (11.1.1)

Part Number E16597-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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.

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 RKM SAP BW Setup

The following authorizations are required for setting up the configuration for the RKM SAP BW and install the required RFC programs to retrieve the metadata about SAP tables.

Object Field Name Value

S_ADMI_FCD

S_ADMI_FCD

NADM

S_ADMI_FCD

S_ADMI_FCD

PADM

S_ADMI_FCD

S_ADMI_FCD

SM21

S_DATASET

ACTVT

*

S_DATASET

FILENAME

*

S_DATASET

PROGRAM

*

S_DEVELOP

ACTVT

01, 02, 03

S_DEVELOP

DEVCLASS

*

S_DEVELOP

OBJNAME

*

S_DEVELOP

OBJTYPE

*

S_DEVELOP

P_GROUP

*

S_GUI

ACTVT

*

S_RFC

ACTVT

16

S_RFC

RFC_NAME

*

S_RFC

RFC_TYPE

*

S_RS_ADMWB

ACTVT

*

S_RS_ADMWB

RSADMWBOBJ

*

S_RS_AUTH

BIAUTH

*Foot 1 

S_RS_ICUBE

ACTVT

*

S_RS_ICUBE

RSICUBEOBJ

*

S_RS_ICUBE

RSINFOAREA

*

S_RS_ICUBE

RSINFOCUBE

*

S_RS_IOBJ

ACTVT

*

S_RS_IOBJ

RSIOBJ

*

S_RS_IOBJ

RSIOBJCAT

*

S_RS_IOBJ

RSIOBJPART

*

S_RZL_ADM

ACTVT

*

S_TABU_DIS

ACTVT

02, 03

S_TABU_DIS

DICBERCLS

*

S_TCODE

TCD

AL11

S_TCODE

TCD

SE10

S_TCODE

TCD

SE11

S_TCODE

TCD

SE16

S_TCODE

TCD

SE37

S_TCODE

TCD

SE38

S_TCODE

TCD

SE80

S_TCODE

TCD

SE91

S_TCODE

TCD

SM21

S_TCODE

TCD

SM50

S_TCODE

TCD

SM58

S_TCODE

TCD

SM59

S_TCODE

TCD

ST22

S_TCODE

TCD

SU53

S_TRANSPRT

ACTVT

01, 02, 03

S_TRANSPRT

TTYPE

*


Footnote 1 For SAP BW 7.0 only. Not for SAP BW 3.5.

Authorizations Required for RKM Execution

The following authorizations are required for running a reverse-engineering using the RKM SAP BW.

Object Field Name Value

S_RFC

ACTVT

16

S_RFC

RFC_NAME

*

S_RFC

RFC_TYPE

*

S_TCODE

TCD

SE16

S_RS_ADMWB

ACTVT

*

S_RS_ADMWB

RSADMWBOBJ

*

S_RS_ICUBE

ACTVT

03

S_RS_ICUBE

RSICUBEOBJ

*

S_RS_ICUBE

RSINFOAREA

*

S_RS_ICUBE

RSINFOCUBE

*

S_RS_IOBJ

ACTVT

*

S_RS_IOBJ

RSIOBJ

*

S_RS_IOBJ

RSIOBJCAT

*

S_RS_IOBJ

RSIOBJPART

*

S_RS_AUTH

BIAUTH

*Foot 1 


Footnote 1 For SAP BW 7.0 only. Not for SAP BW 3.5.

Authorizations Required for LKM Execution

The following authorizations are required for using the LKM SAP BW to Oracle (SQLLDR). This set of authorization is needed to install the ABAP code generated by the LKM and execute it.

Object Field Name Value

S_CTS_ADMI

CTS_ADMFCT

*

S_DATASET

ACTVT

06, 33, 34

S_DATASET

FILENAME

*

S_DATASET

PROGRAM

*ZODI*

S_DEVELOP

ACTVT

01, 02, 03

S_DEVELOP

DEVCLASS

*

S_DEVELOP

OBJNAME

*

S_DEVELOP

OBJTYPE

*

S_DEVELOP

P_GROUP

*

S_RFC

ACTVT

16

S_RFC

RFC_NAME

*

S_RFC

RFC_TYPE

*

S_RS_IOBJ

ACTVT

*

S_RS_IOBJ

RSIOBJ

*

S_RS_IOBJ

RSIOBJCAT

*

S_RS_IOBJ

RSIOBJPART

*

S_TRANSPRT

ACTVT

*

S_TRANSPRT

TTYPE

*


Authorizations Required for LKM Execution for Production

The following authorizations are required for using the LKM SAP BW to Oracle (SQLLDR) in a production environment. In such environment, the ABAP code generated by the LKM is not installed by the LKM but simply executed.

Object FIeld Name Value

S_DATASET

ACTVT

*

S_DATASET

FILENAME

*

S_DATASET

PROGRAM

*ZODI*

S_RFC

ACTVT

16

S_RFC

RFC_NAME

*

S_RFC

RFC_TYPE

*


Privileges for Testing ODI Generated Extraction RFCs

The following authorizations are required for manual testing of ODI generated extraction RFCs e.g. in SE37.

Object FIeld Name Value

S_DATASET

ACTVT

33

S_DATASET

FILENAME

*

S_DATASET

PROGRAM

*

S_TCODE

TCD

SE37

S_DEVELOP

ACTVT

03, 16

S_DEVELOP

RSICUBEOBJ

*

S_DEVELOP

RSINFOAREA

*

S_DEVELOP

RSINFOCUBE

*

S_DEVELOP

DEVCLASS

*

S_DEVELOP

OBJNAME

*

S_DEVELOP

OBJTYPE

*

S_DEVELOP

P_GROUP

*