Skip to end of metadata
Go to start of metadata

Applies to 3.x / 7.x

Listed below are some of the frequently used ABAP Programs in SAP BW.

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.

RSDDS_AGGREGATES_MAINTAIN

Handle change runs; same functionality as the function 'Tools -> Hierarchy/Attribute changes'

RSDDS_AGGREGATES_MAINTAIN

Handle change runs; same functionality as the function 'Tools -> Hierarchy/Attribute changes'

RSDS_DATASOURCE_ACTIVATE_ALLActivates DataSources
RSDG_TRFN_ACTIVATE Activate Transformation and DTP
RSSM_OLTP_INIT_DELTA_UPDATEInit-delta settings written from rssdlinit/sel to OLTP
RSBKDTPREPAIR Repair DTP


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_TARGETS_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

DATE_COMPUTE_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.

SLS_MISC_GET_LAST_DAY_OF_MONTH

Determine Last Day of the Month. Marked as obsolete. Out of maintenance since 2005.

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

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

ARCHIVFILE_CLIENT_TO_SERVERTransfer a File from an applicatioserver to a client
RSPC_API_CHAIN_STARTApis and Bapis for Process Chains
FACTORYDATE_CONVERT_TO_DATECalendar function: Returns date for a factory calendar date
HOLIDAY_CHECK_AND_GET_INFOPublic holiday check with information 

                        

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

15 Comments

  1. Unknown User (98c1jx6t)

    Big 10xs. How about NW 2004s... (wink)

  2. Unknown User (syp8buw)

    Good resource.

  3. Unknown User (10122natr)

    I just wanted to add to Jame's comment above. 

    This is an excellent resource!  I find myself periodically using the programs/function modules to reactivate transfer rules or datasources.  However, I don't perform those actions enough to commit the program/fm names to memory.  This wiki definitely help those of us who occasionally use these very useful programs.

  4. Definitely, this is good source of information. Great work..!

    One finding is that the FM RP_CALC_DATE_IN_INTERVAL is not exist in BI 7.0. Do you know any program/FM equivalent to this FM?

  5. Unknown User (k30remv)

    I just wanted to add to Jame's above.

     Excellent Resource

  6. Former Member

    Dear team,

    Do agree with the Martin, Jame about the resource is helpfull.....

    Regards,

    Gaurav Patwari

  7. This is the information I was trying to consolidate for late hours . This comprehensive  list of programs and function modules  has  really saved my time.

    Thanks & Regards

    Paramesh

  8. Unknown User (kn7e4kp)

    a lot of useful date methods in class "CL_RSAR_FUNCTION", use SE24 to test and play around

    CALL METHOD CL_RSAR_FUNCTION=>DATE_FISCPER(
                EXPORTING I_DATE    = l_calday
                          I_PER     = 'K4'
                IMPORTING E_FISCPER = l_fiscper  ).

  9. Former Member

    Just wanted to add to the content another Function Module

    ARCHIVFILE_CLIENT_TO_SERVER - To upload file from presentation server to application server.

    Regards,

    Anjali

  10. Unknown User (gej2z09)

    Thanks a lot!

  11. RSBM_GUI_CHANGE_USTATE: manually change the status of the old request to red or green by using this function module 


    for more 

    Change Status of DTP Request

  12. Former Member

     

    Thank you very much!

  13. Former Member

    Very useful document..

    Thanks,

    Rk

  14. Very good and useful collection.

    Thank you.

    Kunal

  15. Great collection. Thanks.