Create or maintain currency translation types

A currency translation type is a combination of different parameters that establish how the exchange rate for the translation is determined. Currency translation types can be created or maintained via transaction RSCURFor more info regarding currency translation types, click here

More

Find out if R/3 field is already transferred to BW

When executing a fit/gap analysis (are all necessary R/3 fields already extracted and transferred to BW), table RSOLTPSOURCEFIE can be used.Within the selection screen you can enter, for example, R/3 field MATNR if you want to know in which datasources MATNR is used.The screenshot below shows the overview of all...

More

Prevent automatic migration of 3.x queries to version 7.0

Once you’ve migrated a 3.x query to version 7.0, you can’t alter it anymore within a 3.x query designer, as a 7.0 query is not downward compatible. (Even though you can still execute a migrated 7.0 query with a 3.x BEx Analyzer/Query designer, you aren’t able to alter it anymore)...

More

Display joblog (SM37) in source system

After having upgraded a customers BI system to version 7.0 last weekend (and worked lots of hours), the last step was to extract the missing delta data from the R/3 source system. As a pre-caution all collective runs were stopped in both clients, prior to the upgrade, so they needed...

More

Shortdump when accessing a (role) menu

When logging on to a BW system via the SAPGui, you can access your user (role) menu. Within this user menu/SAP easy access menu, a hierarchy of roles/menu entries will be displayed upon wich can be clicked. Clicking such an entry generated a shortdump (MESSAGE_TYPE_X) which was not self explanatory....

More

Inconsistent Multiprovider after upgrade to version 7.0

After having upgraded to SAP BI version 7.0, several multiproviders became inconsistent. (Starting a query, based upon these multiproviders, ended with a BRAIN 152 error)Inserting a “NO_A135_A152” entry to table RSADMIN solves the problem. You can use program SAP_RSADMIN_MAINTAIN to add an entry to the RSADMIN table(For more info please...

More