Useful ABAP Programs and Function Modules in SAP BI

Applies to 3.x / 7.x

Program name  

RSCDS_NULLELIM Delete fact table rows where all Key Figure values are zero. See Note
619826.

RSDG_CUBE_ACTIVATE Activation of InfoCubes

RSDG_CUBE_COPY Make InfoCube Copies

RSDG_CUBE_DELETE Delete InfoCubes

RSDG_DODS_REPAIR Activation of all ODS Objects with Navigation Attributes

RSDG_ODSO_ACTIVATE Activation of all ODS Objects

RSDG_IOBJ_ACTIVATE Activation of all InfoObjects

RSDG_IOBJ_DELETE Deletion of InfoObjects

RSDG_IOBJ_REORG Repair InfoObjects

 RSDG_IOBJ_REORG_TEXTS Reorganization of Texts for InfoObjects

RSDG_MPRO_ACTIVATE Activating Multiproviders

RSDG_MPRO_COPY Make Multiprovider Copies

RSDG_MPRO_DELETE Deleting Multiproviders

RS_COMSTRU_ACTIVATE_ALL Activate all inactive Communication Structures

RS_TRANSTRU_ACTIVATE_ALL Activate Transfer Structure

RSAU_UPDR_REACTIVATE_ALL Activate Update Rules

RRHI_HIERARCHY_ACTIVATE Activate Hierarchies

SAP_AGGREGATES_ACTIVATE_FILL Activating and Filling the Aggregates of an InfoCube

SAP_AGGREGATES_DEACTIVATE Deactivating the Aggregates of an InfoCube

RS_PERS_ACTIVATE Activating Personalization in Bex(Inactive are highlighted)

RSSM_SET_REPAIR_FULL_FLAG Convert Full Requests to Repair Full Requests

SAP_INFOCUBE_DESIGNS Print a List of Cubes in The System and Their Layouts

SAP_ANALYZE_ALL_INFOCUBES Create DB Statstics for all InfoCubes

SAP_CREATE_E_FACTTABLES Create Missing E-Fact Tables for InfoCubes and Aggregates

SAP_DROP_EMPTY_FPARTITIONS Locate/Remove Unused or Empty partitions of F-Fact Table

SAP_DROP_TMPTABLES Remove Temperory Database Objects

SAP_RSADMIN_MAINTAIN Add, change, delete RSADMIN table entries

CUBE_SAMPLE_CREATE A fast way to put some "sample" records in a InfoCube. No need to use
Flatfiles,
just enter the value in a ALV-Grid or let fill the Cube with random value.

SAP_CONVERT_NORMAL_TRANS Convert BasisCube to Transactional Cube and the opposite way around.

RSDDS_AGGREGATES_MAINTAIN Handle change runs; same functionality as the function 'Tools ->
Hierarchy/Attribute changes'

RSDDS_AGGREGATES_MAINTAIN Handle change runs; same functionality as the function 'Tools ->
Hierarchy/Attribute changes'

RSDS_DATASOURCE_ACTIVATE_AL Activates DataSources

RSDG_TRFN_ACTIVATE Activate Transformation and DTP

RSSM_OLTP_INIT_DELTA_UPDATE Init-delta settings written from rssdlinit/sel to OLTP

RSBKDTPREPAIR Repair DTP

Listed below are some of the frequently used Function Modules within BW.

Function Module Description (Function Group RRMX)

RRMX_WORKBOOK_DELETE Delete BW Workbooks permanently from Roles & Favourites

RRMX_WORKBOOK_LIST_GET Get list of all Workbooks

RRMX_WORKBOOK_QUERIES_GET Get list of queries in a workbook

RRMX_QUERY_WHERE_USED_GET Lists where a query has been used 

RRMX_JUMP_TARGETS_GET Get list of all Jump Targets

RRMX_JUMP_TARGET_DELETE Delete Jump Targets

Function Module Description

MONI_TIME_CONVERT Used for Time Conversions.

CONVERT_TO_LOCAL_CURRENCY Convert Foreign Currency to Local Currecny.

CONVERT_TO_FOREIGN_CURRENCY Convert Local Currency to Foreign Currency.

TERM_TRANSLATE_TO_UPPER_CASE Used to convert all texts to UPPERCASE

UNIT_CONVERSION_SIMPLE Used to convert any unit to another unit. (Ref. table : T006)

TZ_GLOBAL_TO_LOCAL Used to convert timestamp to local time

FISCPER_FROM_CALMONTH_CALC Convert 0CALMONTH or 0CALDAY to Financial Year or Period

RSAX_BIW_GET_DATA_SIMPLE Generic Extraction via Function Module

RSAU_READ_MASTER_DATA Used in Data Transformations to read master data InfoObjects

RSDRI_INFOPROV_READ  Used to read Infocube or ODS data through RFC

DATE_COMPUTE_DAY   Returns a number what day of the week the date falls on.

DATE_GET_WEEK Will return a week that the day is in.

SLS_MISC_GET_LAST_DAY_OF_MONTH Determine Last Day of the Month.

RSARCH_DATE_CONVERT Used for Date Converstions. We can use in Info Package routines.

RSPC_PROCESS_FINISH    To trigger an event in process chain

DATE_CONVERT_TO_FACTORYDATE Returns factory calendar date for a date

CONVERSION_EXIT_PDATE_OUTPUT Conversion Exit for Domain GBDAT: YYYYMMDD  -> DD/MM/YYYY

CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal

RSAOS_METADATA_UPLOAD Upload of meta data from R/3

RSDMD_DEL_MASTER_DATA Deletion of master data

RSPC_CHAIN_ACTIVATE_REMOTE To activate a process chain after transport

ARCHIVFILE_CLIENT_TO_SERVER Transfer a File from an applicatioserver to a client

RSPC_API_CHAIN_START Apis and Bapis for Process Chains

FACTORYDATE_CONVERT_TO_DATE Calendar function: Returns date for a factory calendar date

HOLIDAY_CHECK_AND_GET_INFO Public holiday check with information 

USEFUL ABAP-CLASS in NW 7 - BI to fix problems with Transformation

Class CL_RSTRAN_STAT Description

DELETE_VERSION_FROM_DB (Static For deleting the transformation version from database, helpful if the

DELETE_RULE_FROM_DB For deleting a given rule of transformation