Skip to Content
Author's profile photo Loed Despuig

How To Copy Query With Different Infoproviders or Different Infoobjects

***if image is unclear, just click it to maximize the picture…

Hi guyz,

We use the TCODE RSZC to copy queries, filter, structures, restricted key figures (RKF), and calculated key figures (CKF)..However, if the infoproviders we will be using have different objects we will encounter an error by using the said tcode..

I know that we already have so many ways to copy queries from infoproviders having different structures..I have compiled some of these below:

Force Copy Queries from One Info Provider to Another with Different Structure

How to copy a BEx query with different Cube in SAP BW 7.3+

SAP BW – Copy Query Between Mismatch Info Providers and Queries

I would just like to add one (1) more method which I think is one of the simpliest ways to do this copying of queries from different infoproviders..

1. Go to tcode SE37..

3. Place a soft breakpoint in LINE 32 (just click the SPACE beside the number 32)..

4. Type tcode /NRSZC and press ENTER key..

5. Enter the SOURCE (infoprovider of query you wanted to copy) and TARGET (infoprovider where you wanted to copy the query) providers..Choose also the type of components you wanted to copy (query, filter, etc.)..Then press F8 or click the EXECUTE button..

6. The transaction will stop at the line where we placed the soft breakpoint..

7. Place your cursor in LINE 63 and press SHIFT+F12..

8. Press F8 or click the Continue (the button on the left side of the STOP) button..

9. Select the query (or queries) you wanted to copy and click the Transfer Selections button..

10. Rename the technical name of your copied query then press F8 or click the Continue (CHECK mark) button..

11. You will get this message if you successfully copied your query..

That’s it!

Using any of the methods above will arrive at THE SAME RESULT..Just use the method which you think is easier for you..

Regards,

Loed

Assigned tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gajesh Nagesh
      Gajesh Nagesh

      Good document Leod

      Author's profile photo Loed Despuig
      Loed Despuig
      Blog Post Author

      Thanks a lot Gajesh! 🙂

      Loed

      Author's profile photo Prakash K
      Prakash K

      Thanks for sharing Loed.

      Regards,

      Prakash K

      Author's profile photo Loed Despuig
      Loed Despuig
      Blog Post Author

      Welcome Prakash.. 🙂

      Loed

      Author's profile photo Former Member
      Former Member

      Exellent Loed!!!

      Author's profile photo HITESH GAVANDE
      HITESH GAVANDE

      Good1.. Keep it up!!!

      Author's profile photo Karthik Vasudevan
      Karthik Vasudevan

      This will be very helpful to many of us 🙂 Thanks for sharing

      Author's profile photo Loed Despuig
      Loed Despuig
      Blog Post Author

      Thanks a lot guys for your comments.. 🙂

      Loed

      Author's profile photo Vengal B
      Vengal B

      Hi Loed,

      Simple and useful doc. Thanks for sharing.

      Regards,

      Vengal.

      Author's profile photo Loed Despuig
      Loed Despuig
      Blog Post Author

      Thanks Vengal.. 🙂

      Loed

      Author's profile photo Radek Herskovic
      Radek Herskovic

      Work of art ! Btw. why Classic theme ?

      Author's profile photo Aparajit Banik
      Aparajit Banik

      Loed is a very simple human being.. 😘
      He does very well with classic 😉

      Author's profile photo Loed Despuig
      Loed Despuig
      Blog Post Author

      Haha..Thanks Aparajit Banik.. 🙂

      @Radek Herskovic

      I'm just used in using CLASSIC theme, that's why..Also, it consumes low memory.. 😉

      Thanks for your comment.. 🙂

      Regards,

      Loed

      Author's profile photo Naveen Kumar
      Naveen Kumar

      Many Thanks.

      This helps us in many BW support Projects and saved us lot of time and memory.

      Regards,

      NK

      Author's profile photo Loed Despuig
      Loed Despuig
      Blog Post Author

      Good to know that this doc helped you.. 🙂

      Regards,

      Loed