How to verify SAP BI 7 Transformations between systems

Frequently a transport log for a transformation ends with errors or warnings. There are multiple causes for errors, most of them due to out of sync objects, for example, an object (cube, DSO) was modified in the source system and not transported to the target system. In case of errors, after diagnosis, a new transport is needed.

However, there are cases in which there are warnings, with no or little guidance as if they are relevant, such as ‘could not delete routine’ or ‘routine deleted’. In order to verify that the transformations are OK, the long way to go is to compare all mappings and routines between the 2 systems. A quick way is based on the transformation programs comparison, using transaction SE39 “Splitscreen Editor: (New)”. This transaction allows to compare 2 programs, either in the same system or separate systems.

To find the name of the programs for the transformations, execute transaction SE16 “Data Browser” in both systems. Entering both fields SOURCENAME and TARGETNAME with the corresponding fields will suffice. If you don’t know which transformation the transport refers to, get the Transformation ID from the transport object list (SE09) and enter it in the source system RSTRAN field TRANID. Be aware that this same TRANID won’t show up on the target system, but in the RSTRAN field ORGTRANID (this also happens with DTPs, table RSBKDTP). Field RSTRAN-TRANPROG contains the transformation program name, just add prefix “GP” to this value.

Execute transaction SE39 and click on the button “Compare Different Systems” (Shift-F7)

 

Once you click on the button, a new field will open for the RFC destination. As the landscape Development -> Quality -> Production is normally configured, normally you will find a corresponding RFC entry. It is also helpful to compare between landscapes, project versus production support, but not always the RFC connection is available.

Once you have entered the RFC destination (e.g. the quality system), and the 2 transformation program names, this initial screen will look like this

Now, click on the “Display” button.

Depending on the system settings, you may need to login into the target system. You will get a 2 column display of the programs

To check the differences, click on the button “Comparison On” (CTRL-F4), this will highlight the differences, and with the button “Next Difference From Cursor” (CTRL-SHIFT-F9), you will navigate through the differences. Normally the differences are only related to timestamps and user IDs between systems, but you will find differences if the transformations are not identical.

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.