How to supress messages generated by BW Queries

Standard Solution :You might be aware of a standard solution. In transaction RSRT, select your query and click on the "message" button. Now you can determine which messages for the chosen query are not to be shown to the user in the front-end.
Custom Solution:
Only selected messages can be suppressed using the standard solution. However, there's a clever way you can implement your own solution... and you don't need to modify the system for it!
All messages are collected using function RRMS_MESSAGE_HANDLING. So all you have to do is implement an enhancement at the start of this function module. Now it's easy. Code your own logic to check the input parameters like the message class and number and skip the remainder of the processing logic if you don't want this message to show up in the front-end.

FUNCTION rrms_message_handling.
Start
ENHANCEMENT 1 Z_CHECK_BIA.
* Filter BIA Message
if i_class = 'RSD_TREX' and i_type = 'W' and i_number = '136'
* just testing it.
* exit
end if.
ENHANCEMENT
End
IMPORTING
---------
---------
--------
EXCEPTIONS
Dummy

SAP BI - Meta data tables

Below are some of the tables that contain info about BI reporting related queries, IOs, etc.

RSRREPDIR Number of queries available in BW system
RSZELTDIR Directory of the reporting component elements
RSZELTTXT Texts of reporting component elements
RSZELTXREF Directory of query element references
RSRREPDIR Directory of all reports (Query GENUNIID)
RSZCOMPDIR Directory of reporting com

DTP tables

Table Description
RSBKDTP BW: Data Transfer Process Header Data
RSBKDTPH DTP: Historic Versions
RSBKDTPSTAT Status Information on Data Transfer Process
RSBKDTPT Texts on Data Transfer Processes
RSBKDTPTH Texts on Data Transfer Processes
RSDDSTATDTP Table for WHM Statistics. Details DTP
RSOACUBE_DTP BW: OLTP Direct Access: Directory of Assigned Remote DTPs

Transformation tables

Table Description
RSTRAN Transformation
RSTRANFIELD Mapping of Rule Parameters - Structure Fields
RSTRANRULE Transformation Rule
RSTRANSTEPROUT Rule Type: Routine
RSTRANRULESTEP Rule Steps for a Transformation Rule
RSTRANSTEPMAP Mapping for Rule Step Within a Rule

BW SD MM FI Data Sources

In addition, Find how the data Flows among R3 tables:

SD Tables:

http://www.erpgenie.com/abap/tables_sd.htm

SD Data Sources:

Document Header: 2LIS_11_VAHDR

Document Item: 2LIS_11_VAITM

Document Condition: 2LIS_11_VAKON

Document Schedule Line: 2LIS_11_VASCL

Document Item Allocation: 2LIS_11_V_ITM

Allocation Schedule Line: 2LIS_11_SCL

Order Delivery: 2LIS_11_SSL

MM Tables:

http://www.erpgenie.com/sap/abap/tables_mm.htm

MM Data Sources:

Goods Movements: 2LIS_03_BF

Stock Revaulations: 2LIS_03_UM

FI Tables:

http://www.erpgenie.com/abap/tables_fi.htm

Transport a specific infoobject

How to transport a specific info object? . How to manually transport that object? 1. Administrator Workbench (RSA1), then Transport Connection
2. Object Types, then from the list of objects put the requested one on the right side of the screen (drag & drop)
3. Click "Transport Objects", put the development class name and specify the transport (or create the new one)
4. Transaction SE01, check transport and release it
5. Move the transport up to the another system.
If you change and reactivate the infoobject, but get no transport request, this means that your infoobject is still in $tmp class.
go in to the maintenance of the infoobject, menu extras, object directory entry and change the development class. at this point you should have a pop-up requesting a transport request
If you're not getting a transport request when you change and activate, it could also be that the InfoObject is already on an open transport. When you collect the object in the transport connection as described above, you will see in the right hand pane an entry called Transport Request. If there is an entry here, the object is already on a transport and this gives you the transport number. You can then use SE01 or SE10 to delete the object from the existing transport if that is what you want to do then, when you change and activate the object again, you should be prompted for a transport request. Alternatively, you can use the existing transport depending on what else is on it.
How To Do Transports in BW?

Step by step procedure for transporting in BW:
1. In RSA1 go to Transport Connection
2. Select Object Types Your Object that you want to transfer.
3. Choose grouping method (in data flow before and after)
4. Drag and drop your object.
5. Click the Truck button to transfer
6. In Source System (e.g Dev SE09).
a. Expand to choose your child request
b. Click on the release button (truck)
c. Choose the parent request and click the Truck button release.
7. In Target System (e.g QA) go to STMS
a. Click on Truck button (Import Overview)
b. Dbl click on your QA system queue
c. Clck on Refresh
d. Clk on adjust import queue
e. Select ur request and click on F11.