Thursday, December 22, 2011
Wednesday, December 21, 2011
Useful ABAP Programs and Function Modules in SAP BI
Listed below are some of the frequently used ABAP Programs in SAP BI (NW 2004).
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 Statistics 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 Temporary 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 Flat files, just enter the value in a ALV-Grid or let fill the Cube with random value. |
SAP_CONVERT_NORMAL_TRANS | Convert Basis Cube 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 & Favorites | |
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 Currency. | |
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 the transformation version from database, helpful if the transformation metadata are corrupted. |
DELETE_RULE_FROM_DB | For deleting a given rule of transformation |
Labels:
ABAP
Subscribe to:
Posts (Atom)