| Datasource | Tcode | Program |
| 2LIS_02* | OLI3BW | RMCENEUA |
| 2LIS_03_BX | MCNB | RMCBINIT_BW |
| 2LIS_03_BF | OLI1BW | RMCBNEUA |
| 2LIS_03_UM | OLIZBW | RMCBNERP |
| 2LIS_04* orders | OLI4BW | RMCFNEUA |
| 2LIS_04* manufacturing | OLIFBW | RMCFNEUD |
| 2LIS_05* | OLIQBW | RMCQNEBW |
| 2LIS_08* | VTBW | VTRBWVTBWNEW |
| 2LIS_08* (COSTS) | VIFBW | VTRBWVIFBW |
| 2LIS_11_V_ITM | OLI7BW | RMCVNEUA |
| 2LIS_11_VAITM | OLI7BW | RMCVNEUA |
| 2LIS_11_VAHDR | OLI7BW | RMCVNEUA |
| 2LIS_12_VCHDR | OLI8BW | RMCVNEUL |
| 2LIS_12_VCITM | OLI8BW | RMCVNEUL |
| 2LIS_12_VCSCL | OLI8BW | RMCVNEUL |
| 2LIS_13_VDHDR | OLI9BW | RMCVNEUF |
| 2LIS_13_VDITM | OLI9BW | RMCVNEUF |
| 2LIS_17* | OLIIBW | RMCINEBW |
| 2LIS_18* | OLISBW | RMCSNEBW |
| 2LIS_45* | OLIABW | RMCENEUB |
Wednesday, December 15, 2010
Extraction Logistics Datasources: Tcode and program
An overview of Datasources and the programs filling the relevant setup table (named MC*SETUP). With this handy table you can find the status of your current job or previous initialization jobs through SM37.
Wednesday, October 13, 2010
Initial BI Settings for Portal and BI Integration
After we have integrated BI with Portal, there are few initial BI Settings which has to be done by Portal Administrator to go forward.
Let's have a look as what need to be done at the BI server end.
Procedure:
1. Start the transaction Table View Maintenance (transaction code SM30).
2. Enter RSPOR_T_PORTAL as the table.
3.Choose Maintain.
4.To create a new entry, choose New Entries.
5.Maintain the connected portal:
a) RFC destination:
b) Name of the system: ( Please give the system which has been created in the Portal)
c) Default:
d) Portal URL Prefix:, for example, http://:
e) RM prefix for BW metadata:, for example /bw_metadata
f) KM Service URL:
6. Save your entries.
Let's have a look as what need to be done at the BI server end.
Procedure:
1. Start the transaction Table View Maintenance (transaction code SM30).
2. Enter RSPOR_T_PORTAL as the table.
3.Choose Maintain.
4.To create a new entry, choose New Entries.
5.Maintain the connected portal:
a) RFC destination:
b) Name of the system:
c) Default:
d) Portal URL Prefix:
e) RM prefix for BW metadata:
f) KM Service URL:
6. Save your entries.
Tuesday, October 12, 2010
Upgrade & Migration -Wiki links
https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=85000722
Technical and Functional Migration
Changed Terminology for BI in SAP NetWeaver 7.0 (2004s)
A summary of changed and new terminology for BI7.0Upgrade to Netweaver BI 7.0- SAP Noteshttps://wiki.sdn.sap.com/wiki/display/BI/Upgrade+to+NetWeaver+BI+7.0+%28SAP+Notes+%29
Important notes for upgrading to SAP BI7.0Upgrade from BW 3.X to BI 7.0 (SP13)
Upgrade strategy for Upgrading from BW3.x to BI7.0Technical and Functional upgrade from 3.1 to 7.0
Details on Technical and Functional Upgrade from BW3.1 to 7.0Migration of 3.x objects to BI 7.0
A summary on how Objects created in 3.x are to be migrated to 7.0. Objects here would mean SAP BI ObjectsChanges in BI 7.0 & BW 3.5
A summary of changes to terminology and new additions in SAP BI 7.0 that will help you understand the new SAP BI 7.0 system betterQuery Migration and Learnings
Migration of 3.x BEx Queries to BI7.0 - Useful Tips
Useful Tips on how and what to watch out for when migrating BEx Queries from their 3.x versions to the new 7.0 versionQueries or Workbooks Migration - Errors and Fixes
Common Errors and their resolution when migrating BEx workboks from their 3.x version to the new 7.0 versionBW Report Migration Issues
Common issues when migrating BW Reports
Bex Analyzer 2004s - Upgrade and Migration BI Upgradation-Helpful OSS notes from EDW perspective BW Report Migration Issues Changed Terminology for BI in SAP NetWeaver 7.0 (2004s) Changes in BI 7.0 & BW 3.5 Issue with Migrating BEx Query and Workbook Migration of 3.x BEx Queries to BI7.0 - Useful Tips Migration of 3.x objects to BI 7.0 Queries or Workbooks Migration - Errors and Fixes Technical and Functional upgrade from 3.1 to 7.0 - Check List Technical Upgrade - BI NW2007 Upgrade from BW 3.X to BI 7.0 (SP13) Upgrade to NetWeaver BI 7.0 (SAP Notes ) Useful Transactions and Notes goes with NetWeaver 7.0 Migration of Queries and Work Books from BW 3.x to BI 7
Introduction
This Blog Explains step by step procedure for Migration of Queries and Work Books from BW 3.x to BI 7.0 and also explains the lessons learned while migrating reports/work books from bw 3.x to BI 7.This Blog is useful for consultants who are going to work on migration of reports and work books Projects in BW.
Pre-requisites for Migration
Open the Existing Query in change mode with the new 2004s BEX Query Designer and Save the Query.
Once you save the Query it will be automatically migrated.
Query Migration Procedure:
Before Migration Check the Table RSZCOMPDIR:
Enter your Query Technical Name as input to the field COMPID in the table RSZCOMPDIR and execute.
Field VERSION in the Table RSZCOMPDIR should have the value below 100, It means Query is in 3.x version…
If it is Greater Than 100 means, it is already Migrated. Here it is ‘15’, means query is not yet migrated
Open the existing query using the BI7 Query Designer and Save it. It will be automatically Migrated.
Now you can check your RSZCOMPDIR table will have a value which is more than 100 for the field VERSION…Here it is ‘101’, means it is Migrated.
Standard Workbooks are automatically upgraded.
Workbooks with customer coding (If there are any macros exists) will need manual adoption.
Work Book Migration Procedure:
Open the existing Workbook from BI 7 Bex Analyzer and Save it…It will be automatically Migrated.
This Blog Explains step by step procedure for Migration of Queries and Work Books from BW 3.x to BI 7.0 and also explains the lessons learned while migrating reports/work books from bw 3.x to BI 7.This Blog is useful for consultants who are going to work on migration of reports and work books Projects in BW.
Pre-requisites for Migration
Install the new SAP GUI release 7.10 with Latest Patch level.
Make sure that all the Migration team should have the same version of GUI and Excel.
After new GUI installation, make sure that you should have both 3.x BEX options and 2004s BEX options are available.
Migration Process:
Migration will happen when the Existing 3.x objects (Queries and Workbooks) are opened in the new tools (Using BI 7 Bex Options).
Query Migration: Open the Existing Query in change mode with the new 2004s BEX Query Designer and Save the Query.
Once you save the Query it will be automatically migrated.
Query Migration Procedure:
Before Migration Check the Table RSZCOMPDIR:
Enter your Query Technical Name as input to the field COMPID in the table RSZCOMPDIR and execute.
Field VERSION in the Table RSZCOMPDIR should have the value below 100, It means Query is in 3.x version…
If it is Greater Than 100 means, it is already Migrated. Here it is ‘15’, means query is not yet migrated
Open the existing query using the BI7 Query Designer and Save it. It will be automatically Migrated.
Note: Once a Query is migrated to BI7, system will not allow editing the Query using 3.x Query Designer. However, it will allow execution of the Query in 3.x.
Workbook Migration:
Open the Existing 3.x Workbook by using the 2004s BEX analyzer and Save the Work Book. Once you save the Work Book, it will be automatically migrated. Standard Workbooks are automatically upgraded.
Workbooks with customer coding (If there are any macros exists) will need manual adoption.
Work Book Migration Procedure:
Open the existing Workbook from BI 7 Bex Analyzer and Save it…It will be automatically Migrated.
Note: Should delete data in the Work Book before Save it
Once a Workbook is Migrated, we will not be able to open it using the 3.x version.
Thursday, October 7, 2010
Analyzing Throughput Times Process Chains
To analyze your process chains in SAP BI (but also other BI elements, SAP provides the program /SSA/BWT.
How to use:
Select the first bullet after running the program in SA38:
Enter the technical name of the process chain to be analyzed:
In the following screen you can see all details of the different process chain runs, but also compare different process chain runs with each other.
This program is very useful when you want to analyse why a certain process chain is taking longer.
Try it out!
Extraction Logistics Datasources: Tcode and program
| Datasource | Tcode | Program |
| 2LIS_02* | OLI3BW | RMCENEUA |
| 2LIS_03_BX | MCNB | RMCBINIT_BW |
| 2LIS_03_BF | OLI1BW | RMCBNEUA |
| 2LIS_03_UM | OLIZBW | RMCBNERP |
| 2LIS_04* orders | OLI4BW | RMCFNEUA |
| 2LIS_04* manufacturing | OLIFBW | RMCFNEUD |
| 2LIS_05* | OLIQBW | RMCQNEBW |
| 2LIS_08* | VTBW | VTRBWVTBWNEW |
| 2LIS_08* (COSTS) | VIFBW | VTRBWVIFBW |
| 2LIS_11_V_ITM | OLI7BW | RMCVNEUA |
| 2LIS_11_VAITM | OLI7BW | RMCVNEUA |
| 2LIS_11_VAHDR | OLI7BW | RMCVNEUA |
| 2LIS_12_VCHDR | OLI8BW | RMCVNEUL |
| 2LIS_12_VCITM | OLI8BW | RMCVNEUL |
| 2LIS_12_VCSCL | OLI8BW | RMCVNEUL |
| 2LIS_13_VDHDR | OLI9BW | RMCVNEUF |
| 2LIS_13_VDITM | OLI9BW | RMCVNEUF |
| 2LIS_17* | OLIIBW | RMCINEBW |
| 2LIS_18* | OLISBW | RMCSNEBW |
| 2LIS_45* | OLIABW | RMCENEUB |
Monday, October 4, 2010
FM RSBM_GUI_CHANGE_USTATE
I have loaded master data through DTP. The background job failed with a dump. Now I could not turn the status to red from DTP monitor. As it is not allowing to set the status for master data. As this request is in yellow state system is not allowing me to do another load also.
I tried doing in table RSREQDONE. It is not effecting the changes in DTP monitor.
I looked up in SDN forum there was a post to follow the below steps.
This request sits in table RSBKREQUEST with processing type as 4 in data elements USTATE, TSTATE and this 4 is actually "WIP" status which is obviously wrong.
All we need is, ask your basis person to change the status to 3 in both these data elements.Then you can repeat the load.....Once you repeat the load.......the request status gets updated as "4" in table RSBKREQUEST.
For manually status change you can use the function module RSBM_GUI_CHANGE_USTATE
Issue resolved.
I tried doing in table RSREQDONE. It is not effecting the changes in DTP monitor.
I looked up in SDN forum there was a post to follow the below steps.
This request sits in table RSBKREQUEST with processing type as 4 in data elements USTATE, TSTATE and this 4 is actually "WIP" status which is obviously wrong.
All we need is, ask your basis person to change the status to 3 in both these data elements.Then you can repeat the load.....Once you repeat the load.......the request status gets updated as "4" in table RSBKREQUEST.
For manually status change you can use the function module RSBM_GUI_CHANGE_USTATE
Issue resolved.
Frequently used Transaction Codes in BI
"Search Transaction"-Transaction: se93
| S.No | Tcode | Description |
| 1 | RSA1 | Administrator Work Bench |
| 2 | RSA11 | Calling up AWB with the IC tree |
| 3 | RSA12 | Calling up AWB with the IS tree |
| 4 | RSA13 | Calling up AWB with the LG tree |
| 5 | RSA14 | Calling up AWB with the IO tree |
| 6 | RSA15 | Calling up AWB with the ODS tree |
| 7 | RSA2 | OLTP Metadata Repository |
| 8 | RSA3 | Extractor Checker |
| 9 | RSA5 | Install Business Content |
| 10 | RSA6 | Maintain DataSources |
| 11 | RSA7 | BW Delta Queue Monitor |
| 12 | RSA8 | DataSource Repository |
| 13 | RSA9 | Transfer Application Components |
| 14 | RSBBS | Maintain Query Jumps (RRI Interface) |
| 15 | RSD1 | Characteristic maintenance |
| 16 | RSD2 | Maintenance of key figures |
| 17 | RSD3 | Maintenance of units |
| 18 | RSD4 | Maintenance of time characteristics |
| 19 | RSDBC | DB connect |
| 20 | RSDCUBE | Start: InfoCube editing |
| 21 | RSDCUBED | Start: InfoCube editing |
| 22 | RSDCUBEM | Start: InfoCube editing |
| 23 | RSDDV | Maintaining |
| 24 | RSDIOBC | Start: InfoObject catalog editing |
| 25 | RSDIOBCD | Start: InfoObject catalog editing |
| 26 | RSDIOBCM | Start: InfoObject catalog editing |
| 27 | RSDL | DB Connect - Test Program |
| 28 | RSDMD | Master Data Maintenance w.Prev. Sel. |
| 29 | RSDMD_TEST | Master Data Test |
| 30 | RSDMPRO | Initial Screen: MultiProvider Proc. |
| 31 | RSDMPROD | Initial Screen: MultiProvider Proc. |
| 32 | RSDMPROM | Initial Screen: MultiProvider Proc. |
| 33 | RSDMWB | Customer Behavior Modeling |
| 34 | RSDODS | Initial Screen: ODS Object Processng |
| 35 | RSDS | Data Source Repository |
| 36 | RSIMPCUR | Load Exchange Rates from File |
| 37 | RSINPUT | Manual Data Entry |
| 38 | RSIS1 | Create InfoSource |
| 39 | RSIS2 | Change InfoSource |
| 40 | RSIS3 | Display InfoSource |
| 41 | RSISET | Maintain InfoSets |
| 42 | RSKC | Maintaining the Permittd Extra Chars |
| 43 | RSLGMP | Maintain RSLOGSYSMAP |
| 44 | RSMO | Data Load Monitor Start |
| 45 | RSMON | BW Administrator Workbench |
| 46 | RSOR | BW Metadata Repository |
| 47 | RSORBCT | BI Business Content Transfer |
| 48 | RSORMDR | BW Metadata Repository |
| 49 | RSPC | Process Chain Maintenance |
| 50 | RSPC1 | Process Chain Display |
| 51 | RSPCM | Monitor daily process chains |
| 52 | RSRD_ADMIN | Broadcasting (7.x) Administration |
| 53 | RSRCACHE | OLAP: Cache Monitor |
| 54 | RSRT | Start of the report monitor |
| 55 | RSRT1 | Start of the Report Monitor |
| 56 | RSRT2 | Start of the Report Monitor |
| 57 | RSRTRACE | Set trace configuration |
| 58 | RSRTRACETEST | Trace tool configuration |
| 59 | RSRV | Analysis and Repair of BW Objects |
| 60 | SE03 | Transport Organizer Tools |
| 61 | SE06 | Set Up Transport Organizer |
| 62 | SE07 | CTS Status Display |
| 63 | SE09 | Transport Organizer |
| 64 | SE10 | Transport Organizer |
| 65 | SE11 | ABAP Dictionary |
| 66 | SE18 | Business Add-Ins: Definitions |
| 67 | SE18_OLD | Business Add-Ins: Definitions (Old) |
| 68 | SE19 | Business Add-Ins: Implementations |
| 69 | SE19_OLD | Business Add-Ins: Implementations |
| 70 | SE21 | Package Builder |
| 71 | SE24 | Class Builder |
| 72 | SE80 | Object Navigator |
| 73 | SE91 | Create Newsclasses |
| 74 | SE93 | Transaction Overview |
| 75 | RSCUSTA | Maintain BW Settings |
| 76 | RSCUSTA2 | ODS Settings |
| 77 | RSCUSTV* | |
| 78 | RSSM | Authorizations for Reporting |
| 79 | SM04 | User List |
| 80 | SM12 | Display and Delete Locks |
| 81 | SM21 | Online System Log Analysis |
| 82 | SM37 | Overview of job selection |
| 83 | SM50 | Work Process Overview |
| 84 | SM51 | List of SAP Systems |
| 85 | SM58 | Asynchronous RFC Error Log |
| 86 | SM59 | RFC Destinations (Display/Maintain) |
| 87 | SU20 | Authorization Fields |
| 88 | SU21 | Authorization Objects |
| 89 | LISTCUBE | List viewer for InfoCubes |
| 90 | LISTSCHEMA | Show InfoCube schema |
| 91 | WE02 | Display IDoc |
| 92 | WE05 | IDoc Lists |
| 93 | WE06 | Active IDoc monitoring |
| 94 | WE07 | IDoc statistics |
| 95 | WE08 | Status File Interface |
| 96 | WE09 | Search for IDoc in Database |
| 97 | WE10 | Search for IDoc in Archive |
| 98 | WE11 | Delete IDocs |
| 99 | WE12 | Test Modified Inbound File |
| 100 | WE14 | Test Outbound Processing |
| 101 | WE15 | Test Outbound Processing from MC |
| 102 | WE16 | Test Inbound File |
| 103 | WE17 | Test Status File |
| 104 | WE18 | Generate Status File |
| 105 | WE19 | Test tool |
| 106 | WE20 | Partner Profiles |
| 107 | WE21 | Port definition |
| 108 | WE23 | Verification of IDoc processing |
| 109 | DB02 | Tables and Indexes Monitor |
| 110 | DB14 | Display DBA Operation Logs |
| 111 | DB16 | Display DB Check Results |
| 112 | DB20 | Update DB Statistics |
| 113 | KEB2 | DISPLAY DETAILED INFO ON CO-PA DATA SOURCE R3 |
| 114 | RSD5 | Edit InfoObjects |
| 115 | SM66 | Global work process Monitor |
| 116 | SM12 | Display and delete locks |
| 117 | OS06 | Local Operating System Activity |
| 118 | RSKC | Maintaining the Permittd Extra Chars |
| 119 | SMQ1 | qRFC Monitor (Outbound Queue) |
| 120 | Changerunmoni | |
| 121 | RSREP | Reporting Agent maintenance screen |
BI FAQ - Important Transaction Codes in SAP Business Intelligence
Compiled below is a list of Transaction codes used in SAP BI - please correct or add to it if you feel that something is required.
| Tcode | Description |
|---|---|
| DB02 | Tables and Indexes Monitor |
| DB14 | Display DBA Operation Logs |
| DB16 | Display DB Check Results |
| DB20 | Update DB Statistics |
| KEB2 | DISPLAY DETAILED INFO ON CO-PA DATA SOURCE R3 |
| LISTCUBE | List viewer for InfoCubes |
| LISTSCHEMA | Show InfoCube schema |
| LBWE | LO Data Extraction: Customizing Cockpit |
| LBWF | BW Log |
| LBWG | To Delete Setup Tables |
| OLI*BW | To fill Setup Tables (* Application Component) [ie 7 for SD Sales Orders] |
| OS06 | Local Operating System Activity |
| OB08 | Currency Exchange Rates |
| RSA1 | Administrator Work Bench |
| RSA2 | OLTP Metadata Repository |
| RSA3 | Extractor Checker |
| RSA5 | Install Business Content |
| RSA6 | Maintain DataSources |
| RSA7 | BW Delta Queue Monitor |
| RSA8 | DataSource Repository |
| RSA9 | Transfer Application Components |
| RSA11 | Calling up AWB with the IC tree |
| RSA12 | Calling up AWB with the IS tree |
| RSA13 | Calling up AWB with the LG tree |
| RSA14 | Calling up AWB with the IO tree |
| RSA15 | Calling up AWB with the ODS tree |
| RSBBS | Maintain Query Jumps (RRI Interface) |
| RSBICA | Modeling BI Integrated Planning |
| RSCUSTA | Maintain BW Settings |
| RSCUSTA2 | ODS Settings |
| RSCUSTV* | |
| RSD1 | Characteristic maintenance |
| RSD2 | Maintenance of key figures |
| RSD3 | Maintenance of units |
| RSD4 | Maintenance of time characteristics |
| RSD5 | Edit InfoObjects |
| RSDBC | DB connect |
| RSDCUBE | Start: InfoCube editing |
| RSDCUBED | Start: InfoCube editing |
| RSDCUBEM | Start: InfoCube editing |
| RSDDBIAMON | BI Accelerator Monitor |
| RSDDV | Maintaining |
| RSDIOBC | Start: InfoObject catalog editing |
| RSDIOBCD | Start: InfoObject catalog editing |
| RSDIOBCM | Start: InfoObject catalog editing |
| RSDL | DB Connect - Test Program |
| RSDMD | Master Data Maintenance w.Prev. Sel. |
| RSDMD_TEST | Master Data Test |
| RSDMPRO | Initial Screen: MultiProvider Proc. |
| RSDMPROD | Initial Screen: MultiProvider Proc. |
| RSDMPROM | Initial Screen: MultiProvider Proc. |
| RSDMWB | Customer Behavior Modeling |
| RSDODS | Initial Screen: ODS Object Processing |
| RSDS | Data Source Repository |
| RSIMPCUR | Load Exchange Rates from File |
| RSINPUT | Manual Data Entry |
| RSIS1 | Create InfoSource |
| RSIS2 | Change InfoSource |
| RSIS3 | Display InfoSource |
| RSISET | Maintain InfoSets |
| RSKC | Maintaining the Permitted Extra Chars |
| RSLGMP | Maintain RSLOGSYSMAP |
| RSMO | Data Load Monitor Start |
| RSMON | BW Administrator Workbench |
| RSOR | BW Metadata Repository |
| RSORBCT | BI Business Content Transfer |
| RSORMDR | BW Metadata Repository |
| RSPC | Process Chain Maintenance |
| RSPC1 | Process Chain Display |
| RSPCM | Monitor daily process chains |
| RSPLAN | Modeling BI Integrated Planning |
| RSPLSE | BI Planning Lock Management |
| RSRCACHE | OLAP: Cache Monitor |
| RSRT | Start of the report monitor |
| RSRT1 | Start of the Report Monitor |
| RSRT2 | Start of the Report Monitor |
| RSRTRACE | Set trace configuration |
| RSRTRACETEST | Trace tool configuration |
| RSRV | Analysis and Repair of BW Objects |
| RSSM | Authorizations for Reporting |
| RZ20 | To see log for Process Chains |
| SE03 | Transport Organizer Tools |
| SE06 | Set Up Transport Organizer |
| SE07 | CTS Status Display |
| SE09 | Transport Organizer |
| SE10 | Transport Organizer |
| SE11 | ABAP Dictionary |
| SE18 | Business Add-Ins: Definitions |
| SE18_OLD | Business Add-Ins: Definitions (Old) |
| SE19 | Business Add-Ins: Implementations |
| SE19_OLD | Business Add-Ins: Implementations |
| SE21 | Package Builder |
| SE24 | Class Builder |
| SE80 | Object Navigator |
| SE93 | to view Transaction Codes |
| SM04 | User List |
| SM12 | Display and Delete Locks |
| SM21 | Online System Log Analysis |
| SM37 | Overview of job selection |
| SM50 | Work Process Overview |
| SM51 | List of SAP Systems |
| SM58 | Asynchronous RFC Error Log |
| SM59 | RFC Destinations (Display/Maintain) |
| SM66 | Global work process Monitor |
| SMQ1 | qRFC Monitor (Outbound Queue) |
| SMQ2 | qRFC Monitor (Inbound Queue) |
| ST22 | ABAP Runtime Error (Dumps) |
| ST14 | BW Evaluation Application Analysis |
| WE02 | Display IDoc |
| WE05 | IDoc Lists |
| WE06 | Active IDoc monitoring |
| WE07 | IDoc statistics |
| WE08 | Status File Interface |
| WE09 | Search for IDoc in Database |
| WE10 | Search for IDoc in Archive |
| WE11 | Delete IDocs |
| WE12 | Test Modified Inbound File |
| WE14 | Test Outbound Processing |
| WE15 | Test Outbound Processing from MC |
| WE16 | Test Inbound File |
| WE17 | Test Status File |
| WE18 | Generate Status File |
| WE19 | Test tool |
| WE20 | Partner Profiles |
| WE21 | Port definition |
| WE23 | Verification of IDoc processing |
Wednesday, September 29, 2010
Listed below are some of the frequently used 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. |