How to create variable with exist : (no more cmod t-code but BAPI)
BW Naming Conventions#Bapi & Exists Variable
How to create BEx Variant based on Security Authorization
How to compare Queries between 2 systems
- On both systems, run transaction SE38
- Launch program "RSRQ_QUERYDEFINITION"
- Run the program for the Query you want to analyse.
- Click on the "Download" button. Then OK.
- Go to "System" -> List -> Save --> Local File
- Export to the "Clipboard"
- Open a txt file and paste the content.
- Use a code comparison tool to compare both files. Exemple : http//www.tareeinternet.com/scripts/comparison-tool/
How to find queries using an info object
You can use the following function modules in order to display the queries using an info object.
Function modules
RSZ_I_BASIC_CHA_WHERE_USED
RSZ_I_BASIC_KEYFIG_WHERE_USED
It’s much more efficient than using the metadata repository.
Example for info object 0GL_ACCOUNT__C_GL_TYPE. With metadata repository I list around 40 queries with this object.
The reality is much more different because with the function module I obtain 96 queries!
There are also some tables to list the info provider using the nav attributes
RSDODSOATRNAV – For DSO
RSDCUBEIOBJ – For Cubes and MPR
In this page, there is a list of very useful tables
http//wiki.scn.sap.com/wiki/display/BI/Important+Tables+in+SAP+BW+7.x