SAP BW ABAP Programs and Function Modules

Listed below are some of the frequently 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 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_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_COVERT Used for Date Converstions. We can use in Info Package routines. RSPC_PROCESS_FINISH                              To trigger an event in process chain