Wednesday, March 31, 2021

SAP BW4/HANA related t-codes

 

In case of BW4/HANA majority of activities are performed either in SAP HANA Studio (mostly modeling activities) or in web environment (mostly administration activities). However, the backend (based on SAP NetWeaver, which is now transitioned to ABAP Platform) is still there.  Here is brief overview of t-codes that are used in BW4/HANA based systems. Most of them are not really the BW4/HANA specific as they may started to appear already in BW classic e.g., BW 7.4 and BW 7.5 based systems.

t-code

ABAP prg

Description

RSMNG

RSPM_MANAGE

Support Function: Manage

HANA_ABAP_PYTHON

HANA_ABAP_PYTHON

execute report HANA_ABAP_PYTHON

HDB_SQLDBC

RSHDB_SQLDBC_CONS

SQLDBC Trace for HANA

ODQMON

SAPLODQ_MONITOR

Monitor for Operational Delta Queue, a new RSA7 t-code

RS_HANA_CONSUMPTION

RS_HDI_SETTINGS

Settings for HANA consumption in BW

RS2HANA_ADMIN

RS2HANA_ADMIN

Administration ext. SAP HANA views

RS2HANA_CHECK

RS2HANA_CHECK

SAP HANA Model Generation Check

RS2HANA_GEN

RS2HANA_AUTH_RUN

Replicate Authorizations to SAP HANA

RS2HANA_VIEW

RS2HANA_VIEW_SETTINGS

Settings for SAP HANA Views

BW4WEB

BW4_WEB_SHOW

BW HANA Cockpit

BW4CHECK

BW4_UI5_IFC_CONSISTENCY

Check BW/4HANA Cockpit Setup

BW4_WEB_START

BW4_WEB_START

BW/4HANA: Web UI Entry Point

RSB4HTRF

RS_B4HANA_TRANSFER

SAP HANA Transformation

RSB4HAPDR

RS_B4HTAPD_APD_LIST

B4H - APD conversion remote

RSB4HCONV

RS_B4HANA_CONVERSION_CONTROL

BW/4 Conversion

RSDD_LTIP

RSDDLTIP_ADMIN

Administration of Analytic Indexes

RSDDSTAT

SAPLRSDDSTAT_UI

Maintain the BW Statistics Settings

RSDHAAP

SAPLRSDHAF_ANALYSIS_UI

SAP HANA Analysis Process Designer

RSDHAAP_MONITOR

SAPLRSDHAF_ANALYSIS_UI

SAP HANA Analysis Process Monitor

RSDHATR

SAPLRSDHAF_ANALYSIS_UI

SAP HANA Transformation

RSDRC_HANA_HIER

RSDRH_ACTIVATE_HANA_HIERS

Activate Use of HANA Hierarchies

RSDSHANA

SAPLRSDS_ACCESS_HANA

Manage SAP HANA Remote Subscriptions

RSDSHANAS

SAPLRSDS_ACCESS_HANA

Overview Realtime Repl. (SAP HANA)

RSHDBMON

RSHDB_MON

HDB Monitoring

RSLIMO

SAPLRSDD_GUI_LM

BW Lean Modeler Test UI

RSLIMOBW

SAPLRSDD_GUI_LM

Composite Providers

RSMIGRHANADB

RSDRI_CONVERT_CUBE_TO_INMEMORY

Conversion to In-Memory Optimized

RSOADSO

SAPLRSO_RES_HCPR_SUPPORT

DataStore (ADSO) Support, a new LISTCUBE t-code

RSOADSODTO

RSO_RES_ADSO_TEMP_MAIN

Temperature Maintenance

RSOADSODTOEXE

RSO_RES_ADSO_TEMP_MAIN_EXEC

Transaction for the DTO Execution

RSOADSODTOS

RSO_RES_ADSO_TEMP_MAIN_START

TX for RSOADSODTO for eclipse calls

RSODSO_BRKPNT

RSODSO_BRKPNT

DataStore-Specific Breakpoints

RSODSO_HDB_LOCK

RSODSO_HDB_LOCK

Management of Native Locks (HDB)

RSODSO_RUNTIME

RSODSO_RUNTIME

Runtime Measurements

RSODSO_SETTINGS

RSODSO_SETTINGS

Maintenance of Runtime Param. DS Obj

RSODSO_SETTINGS_OLD

RSODSO_MAINTAIN_SETTINGS

Parameter maintenance for DataStores

RSODSO_SHOWLOG

RSODSO_SHOW_LOG

Logs for DataStore Object

RSODSO_SQLTRACE

RSODSO_MPP_SQL_LOG

SQL Statements for MPP DataStores

RSODSVIEW

SAPLRSFBP_UI

Open ODS View

RSOHCPR

SAPLRSO_RES_HCPR_SUPPORT

CompositeProvider(HCPR) Support

RSOSM

RSOSN_MAINTENANCE

BW Search on SAP HANA Maintenance

RSPM_MONITOR

RSPM_PROCESS_MONITOR

BW Process Monitor

RSMONITOR

RSCNV_MONITOR

Generic Monitor

RSMRT

RSCNV_DESIGN

Metadata Remodeling Toolbox

RSWQD

RSL_WQD_LAUNCH

Workspace Query Designer

RSWSP

SAPLRSL_GUI_WSP

Workspace Individual Processing

RSWSP_CUST

SAPLRSL_WSP_GUI_CUST

Workspace General Customizing

RSWSPW

SAPLRSL_GUI_WSP

Workspace Mass Processing

UJHANAMDX

UJHANA_MDX_TEST

BPC HANA MDX Test

RSBITC

SAPLBW_BICS_INA_TEST_TOOLS

InA Trace Cockpit

RSBITT

SAPLBW_BICS_INA_TEST_TOOLS

InA Test Monitor

 

Friday, March 19, 2021

BW/4HANA specific objects

In next generation of BW systems based on SAP BW/4HANA there are significant changes done with regards to the BW object types. The BW objects are simplified and only few of them are supported. So, what are classic BW object types that are not supported in BW/4HANA?

 

- MultiProviders are Composite Providers (object type HCPR) - tables like RSDCUBEMULTI and RSDICMULTIIOBJ are empty

- InfoSet (object ISET) are Composite Providers (object type HCPR) - table RSQISET is empty

- Cubes (object CUBE) are aDSOs (advanced DSO, object type ADSO) - table RSDCUBE is empty

- Classic DSO objects (object ODSO) are aDSOs (object type ADSO) - table RSDODSO is empty

- Virtual Providers (object flag RSDCUBE-CUBETYPE = V) are now Open ODS Views (object type FBPA, stored in table RSFBP) or BADI Providers - table RSDCUBE is empty

- Hybrid Providers (object flag RSDCUBE-CUBETYPE = H) are now aDSOs (object type ADSO) - table RSDCUBE is empty

- Transient Providers (InfoProvider that allows analysis on top of an application object like SAP Business Suite) are now Open ODS Views or BADI Providers (object type FBPA)

- PSA tables are now aDSOs (object type ADSO) - no tables like /BIC/B00* for PSA of DataDources, but Transfer Structure/Change Logs/Error Stack tables remain in BW4 systems

- No APD (object ANPR) are not supported - tables RSANT_PROCESS and RSANT_PROCESSR do not even exit

- InfoObject Catalogs (object IOBC) are now replaced by InfoAreas (object AREA) - tables RSDIOBC and RSDIOBCT having only values for NODESNOTCONNECTED IO catalogs like:

0CHANOTASSIGNED - Unassigned characteristics

0KYFNOTASSIGNED - Not assigned key figures

0TIMNOTASSIGNED - Not assigned time characteristics

0UNINOTASSIGNED - Not assigned units

 - Open Hub of types 3.x or "Third Party Tool" are not supported, OHs (object type DEST) that are supported (TAB, FILO, FILL) are still present in table RSBOHDEST and RSBDBTAB

- No 3.x InfoSource (object ISTD) present in the BW4 system anymore, as is it not supported - table RSISOSMAP is not present in the BW4 system anymore

 - No Communication Structure (object ISCS) present in the BW4 system anymore, as is it not supported - table RSKS is empty

 - InfoSource 7.x (object TRCS - Communication Structure for Transformation) is still available in table RSKSNEW

  

For classic BW object conversion, see Tools for migrating to SAP BW/4HANA (B4H)

BW/4HANA specific object types tables:

RSOADSO - DataStore Object (although table exits in the system starting from BW 7.4 version)

RSOHCPR – HANA Composite Provider

RSDHAMAP - HANA Analysis Processes

 

 

Typical look into table RSDCUBE in classic BW based system where the table has zero records would be pretty scary. However, in the BW/4HANA based system it is pretty normal :)