Search This Blog

Thursday, May 6, 2010

List of the frequently used ABAP Programs in SAP BI List of the frequently used ABAP

List of the frequently used ABAP Programs in SAP BI List of the frequently used ABAP Programs in SAP BI
• 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 InfoCubes 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.

List of the frequently used Function Module in SAP BW.

List of the frequently used Function Module in SAP BW.
1.RRMX_WORKBOOK_DELETE: Delete BW Workbooks permanently from Roles & Favorites
2.RRMX_WORKBOOK_LIST_GET: Get list of all Workbooks
3.RRMX_WORKBOOK_QUERIES_GET: Get list of queries in a workbook
4.RRMX_QUERY_WHERE_USED_GET: Lists where a query has been used
5.RRMX_JUMP_TARGET_GET: Get list of all Jump Targets
6.RRMX_JUMP_TARGET_DELETE: Delete Jump Targets
7.MONI_TIME_CONVERT: Used for Time Conversions.
8.CONVERT_TO_LOCAL_CURRENCY: Convert Foreign Currency to Local Currecny.
9.CONVERT_TO_FOREIGN_CURRENCY: Convert Local Currency to Foreign Currency.
10.TERM_TRANSLATE_TO_UPPER_CASE: Used to convert all texts to UPPERCASE
11.UNIT_CONVERSION_SIMPLE: Used to convert any unit to another unit. (Ref. table: T006)
12.TZ_GLOBAL_TO_LOCAL: Used to convert timestamp to local time
13.FISCPER_FROM_CALMONTH_CALC: Convert 0CALMONTH or 0CALDAY to Financial Year or Period
14.RSAX_BIW_GET_DATA_SIMPLE: Generic Extraction via Function Module
15.RSAU_READ_MASTER_DATA: Used in Data Transformations to read master data InfoObjects
16.RSDRI_INFOPROV_READ
17.RSDRI_INFOPROV_READ_DEMO
18.RSDRI_INFOPROV_READ_RFC: Used to read Infocube or ODS data through RFC
19.DATE_COMPUTE_DAY
20.DATE_TO_DAY: Returns a number what day of the week the date falls on.
21.DATE_GET_WEEK: Will return a week that the day is in.
22.RP_CALC_DATE_IN_INTERVAL: Add/Subtract Years/Months/Days from a Date.
23.RP_LAST_DAY_OF_THE_MONTHS
24.SLS_MISC_GET_LAST_DAY_OF_MONTH: Determine Last Day of the Month.
25.RSARCH_DATE_CONVERT: Used for Date Converstions. We can use in Info Package routines.
26.RSPC_PROCESS_FINISH: To trigger an event in process chain
27.DATE_CONVERT_TO_FACTORYDATE: Returns factory calendar date for a date
28.CONVERSION_EXIT_PDATE_OUTPUT: Conversion Exit for Domain GBDAT: YYYYMMDD - DD/MM/YYYY
29.CONVERSION_EXIT_ALPHA_INPUT: Conversion exit ALPHA, external->internal
30.CONVERSION_EXIT_ALPHA_OUTPUT: Conversion exit ALPHA, internal->external
31.RSPC_PROCESS_FINISH: Finish a process (of a process chain)
32.RSAOS_METADATA_UPLOAD: Upload of meta data from R/3
33.RSDMD_DEL_MASTER_DATA: Deletion of master data
34.RSPC_CHAIN_ACTIVATE_REMOTE: To activate a process chain after transport