Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Introduction

When you want to copy queries, structures or restricted/calculated key figures from one info-provider to another in SAP BW, you can use the standard transaction <RSZC>. Unfortunately, this transaction will return an error message and will not help you further when the two info-providers have a different structure and the target info-provider is for example missing characteristics that are available in the source info-provider. This document describes how you can copy the above mentioned elements even when the source and target info-provider do not have the same structure. Why another document on this topic? Because I always forget the function module name and where to put the breakpoint. I could have put it in my local documents folder, but why not share?

Audience

SAP BW Administrators / Developers.

Table of Contents

Introduction

Audience 

Table of Contents

1. Process Steps

1. Process Steps

This chapter describes the steps to copy queries, structures or restricted/calculated key figures from one info-provider to another when the source and the target info-provider have a different structure.

Step 1: Log on to the BW system.

Step 2: Execute transaction <SE37> and display function module <RSZ_I_COPY_QRY_TO_CUBE>.

Step 3: Move the cursor to line 42 ( IF l_subrc <> 0 OR l_is_compliant = rs_c_false. ) and set an external breakpoint usingor pressing <CTRL><SHIFT><F9>.

Step 4: Execute transaction <RSZC> and fill out the source and target info-providers that are involved in the copy.

When the program runs into the breakpoint, the debugger is started. You will now have to change the value for variable L_IS_COMPLIANT to bypass the consistency check that returns the error message when the source info-provider and the target info-provider have a different structure.

Step 5:  Click the pencil next to the field <L_IS_COMPLIANT> to change the field content.

Step 6:  Change the value to 'X' and press <ENTER>.

Step 7: Continue the program by pressing <F8>.

Step 8: Select the elements that you want to copy from the source info-provider to the target info-provider.

Step 9:Rename the elements (if needed) to meet a specific naming convention.

The system will let you know which characteristics/key figures are missing from the target info-provider. This might have an impact on the elements that you have copied since they might be involved in - for example - the query. For this reason, it is required to check the new query (elements) on the target info-provider in the query designer.

Step 10:  Use the query designer to review the newly created reporting elements.

9 Comments
Labels in this area