ABAP Programs in SAP BI


ABAP Programs Used in SAP BI (NW 2004).
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,


Listed below are some of the  used ABAP Programs in SAP BI (NW 2004).
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.

Listed below are some of  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_TARGET_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 RSDRI_INFOPROV_READ
_DEMO  RSDRI_INFOPROV
_READ_RFC
Used to read Infocube or ODS data through RFC
DATE_COMPUTE_DAY  DATE_TO_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.
RP_CALC_DATE_IN_INTERVAL
Add/Subtract Years/Months/Days from a Date.
RP_LAST_DAY_OF_THE_MONTHS 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
CONVERSION_EXIT_ALPHA_OUTPUT
Conversion exit ALPHA, internal->external
 RSPC_PROCESS_FINISH
Finish a process (of a process chain)
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
                         
USEFUL ABAP-CLASS in NW 7 - BI to fix problems with Transformation

Class CL_RSTRAN_STAT

Description
DELETE_VERSION_FROM_DB (Static Method)
For deleting a transformations rule version f
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,