Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can Install the Role /BLTG/MAPI_EMBEDDED_ANALYTICS via Transport Request (download

View file
nameMetadata API - S4 Role.zip
).

Depending on the approach you have chosen, you will need a HANA or a BW an ERP user. The tables which has have to be authorized can be copied from the list below. In case of an ERP user the tables should be included into authorization object S_TABU_NAM with activity 3 (display). Besides that the authorization object S_RFC is needed with RFC_TYPE = FUGR and FUNC, activity 16 (execute) and the following characteristics in RFC_NAME:

  • /BLTG/*

  • DDIF_FIELDINFO_GET

  • EM_GET_NUMBER_OF_ENTRIES

  • RFCPING

  • RFC_GET_FUNCTION_INTERFACE

  • RFC_READ_TABLE

  • RFC_SYSTEM_INFO

If you use the HANA connection you can create a hdbrole in your HANA database with the following statements to have all the rights you need.
If you want to make it easier you can simply authorize the schema of your BW ERP system with select rights.

Code Block
languagesql
role <your package name>::<your role name>{

--StandardObject Edition	Level
catalog sql object "<your BWS/4 schema name>"."TCESYSTDD26I":			SELECT; catalog sql object "<your BW schema name>"."RSAOOBJT":			SELECT;
catalog sql object "<your BWS/4 schema name>"."RSAOOBJXREF":		SELECT;
catalog sql object "<your BW schema name>"."RSBOHDESTT":		SELECT;
catalog sql object "<your BW schema name>"."RSDCUBEMULTI":DD02L":			SELECT;
catalog sql object "<your BWS/4 schema name>"."RSDCUBETDD02T":			SELECT;
catalog sql object "<your BW schema name>"."RSDIOBJT":			SELECT;
catalog sql object "<your BW schema name>"."RSDODSOT":			SELECT;
catalog sql object "<your BW schema name>"."RSDST":				SELECT;
catalog sql object "<your BW schema name>"."RSFBPSEMANTICS":	SELECT;
catalog sql object "<your BW schema name>"."RSFBPSOURCE":		SELECT;
catalog sql object "<your BW schema name>"."RSFBPT":			SELECT;
catalog sql object "<your BW schema name>"."RSKSNEWT":			SELECT;
catalog sql object "<your BW schema name>"."RSOADSOT":			SELECT;
catalog sql object "<your BW schema name>"."RSOHCPRT":			SELECT;
catalog sql object "<your BW schema name>"."RSOOBJXREF":		SELECT;
catalog sql object "<your BW schema name>"."RSPLS_ALVL":			SELECT;
catalog sql object "<your BW schema name>"."RSPLS_ALVLT":		SELECT;
catalog sql object "<your BW schema name>"."RSQISETT":			SELECT;
catalog sql object "<your BW schema name>"."RSQTOBJ":			SELECT;
catalog sql object "<your BW schema name>"."RSTRAN":			SELECT;
catalog sql object "<your BW schema name>"."RSTRANT":			SELECT;
catalog sql object "<your BW S/4 schema name>"."TADIR":				SELECT;
catalog sql object "<your BWS/4 schema name>"."V_CMP_JOINDF14L":		SELECT;
catalog sql object "<your BW schema name>"."V_ELTDIR_TXT":		SELECT;
catalog sql object "<your BWS/4 schema name>"."V_REP_JOINROOSOURCE":		SELECT;
catalog sql object "<your BWS/4 schema name>"."RSOOBJXREF_HANAROOSOURCET":	SELECT;

--Premium Edition catalog sql object "<your BW schema name>"."DD07T":				SELECT;
catalog sql object "<your BWS/4 schema name>"."RSBOHDESTDDLDEPENDENCY":			SELECT;
catalog sql object "<your BWS/4 schema name>"."RSBOHFIELDSTDEVC":		SELECT; catalog sql object "<your BW schema name>"."RSBOHFIELDST":		SELECT;
catalog sql object "<your BW schema name>"."RSDATRNAVT":		SELECT;
catalog sql object "<your BWS/4 schema name>"."RSDBCHATRTSTC":			SELECT;
catalog sql object "<your BW schema name>"."RSDBCHATRXXL":		SELECT; catalog sql object "<your BW schema name>"."RSDCHA":			SELECT;
catalog sql object "<your BWS/4 schema name>"."RSDIOBJCMPTSTCP":		SELECT;
catalog sql object "<your BW schema name>"."RSDS":				SELECT;
catalog sql object "<your BW schema name>"."RSDSSEGFD":			SELECT;
catalog sql object "<your BWS/4 schema name>"."RSDSSEGFDTTSTCT":		SELECT;
catalog sql object "<your BW schema name>"."RSFBP":				SELECT;
catalog sql object "<your BW schema name>"."RSFBPFIELD":		SELECT;
catalog sql object "<your BWS/4 schema name>"."RSFBPFIELDTSEOCLASSDF":		SELECT;
catalog sql object "<your BW schema name>"."RSFBPNAVATR":		SELECT;
catalog sql object "<your BWS/4 schema name>"."RSFBPNAVATRTTCESYST":		SELECT;
catalog sql object "<your BW schema name>"."RSFOBUEV001":		SELECT;
catalog sql object "<your BW schema name>"."RSKSFIELDNEW":		SELECT;
catalog sql object "<your BWS/4 schema name>"."RSKSFIELDNEWTTFDIR":		SELECT;
catalog sql object "<your BW schema name>"."RSKSNEW":			SELECT;
catalog sql object "<your BW schema name>"."RSOADSO":			SELECT;
catalog sql object "<your BWS/4 schema name>"."RSOHCPRDDDDLSRCT":			SELECT; catalog sql object "<your BW schema name>"."RSPLS_ALVL_IOBJ":	SELECT;
catalog
sql--Field object "<your BW schema name>"."RSTRANFIELD":		SELECT;
Level
catalog sql object "<your BWS/4 schema name>"."RSTRANRULEDD27I":		SELECT;
catalog sql object "<your BW schema name>"."RSTRANRULET":		SELECT;
catalog sql object "<your BWS/4 schema name>"."RSTRANSTEPADSODD03T":	SELECT;
catalog sql object "<your BW schema name>"."RSTRANSTEPCNST":	SELECT;
catalog sql object "<your BW schema name>"."RSTRANSTEPMASTER":	SELECT;
catalog sql object "<your BWS/4 schema name>"."RSTRANSTEPROUT":	SELECT;
catalog sql object "<your BW schema name>"."RSZCALC"DD03L":			SELECT;
catalog sql object "<your BWS/4 schema name>"."RSZCOMPDIR":		SELECT;
catalog sql object "<your BW schema name>"."RSZELTDIR"DD04T":			SELECT;
catalog sql object "<your
BW
schema name>"."RSZELTPROP":		SELECT;
catalog sql object "<your BW schema name>"."RSZELTTXT":			SELECT;
catalog sql object "<your BW schema name>"."RSZELTXREF":		SELECT;
catalog sql object "<your BW schema name>"."RSZGLOBV":			SELECT;
catalog sql object "<your BW schema name>"."RSZRANGE":			SELECT;
catalog sql object "<your BW schema name>"."RSZSELECT":			SELECT;
catalog sql object "<your BW schema name>"."RSZELTATTR":		SELECT;

--Extended Edition--ABAP Scan
catalog sql object "<your BWS/4 schema name>"."RSAABAP":		    SELECT;
catalog sql object "<your BW schema name>"."RSTRANSTEPSCRIPT":	SELECT;
catalog sql object "<your BW schema name>"."SEOCLASSDF":		SELECT;
catalog sql object "<your BW schema name>"."TMDIR":		        SELECT;
catalog sql object "<your BW schema name>"."TRDIR":		        REPOSRC":			SELECT;

}