ABAP Programs in SAP BI (NW 2004).
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 |
| 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 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_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 from database, helpful if the transformation metadata are corrupted. |
No comments:
Post a Comment