===== Useful ABAP Programs and Function Modules in SAP BI =====

Directly from SCN.

^ Program name^ Description^
| 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'|
^ 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| Used to read Infocube or ODS data through RFC|
| RSDRI_INFOPROV_READ_DEMO| Used to read Infocube or ODS data through RFC|
| RSDRI_INFOPROV_READ_RFC| 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_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| Determine Last Day of the Month.|
| 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 the transformation version from database, helpful if the transformation metadata are corrupted.|
| DELETE_RULE_FROM_DB| For deleting a given rule of transformation|