Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
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

Page: Function Module DATE_COMPUTE_DAY - Returns weekday for a date Page: Function Module CONVERSION_EXIT_PDATE_OUTPUT - Conversion Exit for Domain Page: FunctionModule CONVERT_TO_FOREIGN_CURRENCY- Translate local currency amount to foreign currency Page: FunctionModule CONVERT_TO_LOCAL_CURRENCY - Translate foreign currency amount to local currency Page: Function Module DATE_CONVERT_TO_FACTORYDATE - Calendar function: Returns factory calendar date for a date Page: Function Module DATE_GET_WEEK - Calendar function: Returns week for a date Page: FunctionModule FISCPER_FROM_CALMONTH_CALC – Convert 0CALMONTH to Financial Year or Period Page: FunctionModule MONI_TIME_CONVERT - Time Conversion Page: FunctionModule RRMX_JUMP_TARGET_DELETE - Delete Jump Target global ID Page: FunctionModule RRMX_JUMP_TARGETS_GET - Get list of views that are related to a given workbook object Page: FunctionModule RRMX_QUERY_WHERE_USED_GET - Lists where a query has been used Page: FunctionModule RRMX_WORKBOOK_LIST_GET - Get complete list of Excel workbooks Page: FunctionModule RRMX_WORKBOOK_QUERIES_GET - Get all queries in a workbook Page: Function Module RSAOS_METADATA_UPLOAD - Metadata upload from ECC Page: Function Module RSARCH_DATE_CONVERT - Calendar function: Returns various dates Page: FunctionModule RSAX_BIW_GET_DATA_SIMPLE - Template FM to transfer transactional data Page: Function Module RSDMD_DEL_MASTER_DATA - Tool for maintaining master data Page: Function Module RSPC_CHAIN_ACTIVATE_REMOTE – Remote activation of a process chain Page: FunctionModule TERM_TRANSLATE_TO_UPPER_CASE – Language dependent conversion to upper case Page: FunctionModule TZ_GLOBAL_TO_LOCAL – Used to convert timestamp to local time Page: Report CUBE_SAMPLE_CREATE - Create sample records Page: Report RRHI_HIERARCHY_ACTIVATE - Activation of a hierarchy Page: Report RSCDS_NULLELIM - Delete fact table rows where all Key Figure values are zero Page: Report RSDDS_AGGREGATES_MAINTAIN - Execute Hierarchy Attribute Changes Page: Report RSDG_CUBE_COPY - Make InfoCube Copies Page: Report RSDG_CUBE_DELETE - Deleting InfoCubes Page: Report RSDG_DODS_REPAIR - Activation of All ODS Objects with Navigation Attributes Page: Report RSDG_IOBJ_DELETE - Deleting InfoObjects Page: Report RSDG_IOBJ_REORG_TEXTS - Reorganization of Texts for InfoObjects Page: Report RSDG_IOBJ_REORG - Repair InfoObjects Page: Report RSDG_MPRO_DELETE - Delete MultiProviders Page: Report RSSM_SET_REPAIR_FULL_FLAG - Set Repair Indicator for Full Requests Page: Report SAP_ANALYZE_ALL_INFOCUBES - Create DB Statistics for all Infocubes Page: Report SAP_CONVERT_NORMAL_TRANS - Conversion: Normal <--> Transactional InfoCube Page: Report SAP_CREATE_E_FACTTABLES - Creates missing E fact tables for InfoCubes and aggregates Page: Report SAP_INFOCUBE_DESIGNS - Cubes in the system and their layout Page: Report SAP_RSADMIN_MAINTAIN - RSADMIN Administration Page: Function Module SLS_MISC_GET_LAST_DAY_OF_MONTH - FM calculating the last day of a month Page: Function Module RSPC_API_CHAIN_START - Start Process Chain Page: Function Module ARCHIVFILE_CLIENT_TO_SERVER – Transfer File from Application server to client Page: Function Module ARCHIVFILE_SERVER_TO_CLIENT – Transfer File from Application client to server Page: Function Module FACTORYDATE_CONVERT_TO_DATE - Calendar function: Returns factory calendar date for a date Page: Function Module HOLIDAY_CHECK_AND_GET_INFO - Public holiday check with information Page: Function Module LAST_FACTORYDATE_GET - Return last factory date for a factory calendar Page: Function Module WEEK_GET_FIRST_DAY - Return first day for a week Page: Report RSBKDTPREPAIR – DTP Repair

15 Comments

  1. Guest

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

  2. Guest

    Good resource.

  3. Guest

    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. Former Member

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

    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. Former Member

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

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

    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.