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..

2. Type the FM RSZ_I_COPY_QRY_TO_CUBE and click DISPLAY..

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..

go to Debugger menu and click Goto statement..

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

15 Comments

You must be Logged on to comment or reply to a post.

Gajesh Nagesh August 11, 2015 at 4:25 am

Good document Leod

like (0)
1. Loed Despuig Post authorAugust 11, 2015 at 4:30 am
  
  Thanks a lot Gajesh! 🙂
  
  Loed
  
  like (0)
Prakash K August 11, 2015 at 6:34 am

Thanks for sharing Loed.

Regards,

Prakash K

like (0)
1. Loed Despuig Post authorAugust 11, 2015 at 3:47 pm
  
  Welcome Prakash.. 🙂
  
  Loed
  
  like (0)
Roel Camacho November 27, 2015 at 2:00 am

Exellent Loed!!!

like (0)
HITESH GAVANDE November 27, 2015 at 5:45 am

Good1.. Keep it up!!!

like (0)
Karthik Vasudevan November 27, 2015 at 11:25 am

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

like (0)
Loed Despuig Post authorDecember 1, 2015 at 6:50 am

Thanks a lot guys for your comments.. 🙂

Loed

like (0)
Vengal B December 1, 2015 at 8:59 am

Hi Loed,

Simple and useful doc. Thanks for sharing.

Regards,

Vengal.

like (0)
1. Loed Despuig Post authorDecember 3, 2015 at 8:46 pm
  
  Thanks Vengal.. 🙂
  
  Loed
  
  like (0)
Radek Herskovic August 19, 2016 at 7:34 am

Work of art ! Btw. why Classic theme ?

like (0)
1. Aparajit Banik August 19, 2016 at 11:35 am
  
  Loed is a very simple human being.. 😘
  He does very well with classic 😉
  
  like (0)
  1. Loed Despuig Post authorAugust 22, 2016 at 8:17 am
    
    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
    
    like (0)
Naveen Kumar August 22, 2016 at 8:26 am

Many Thanks.

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

Regards,

NK

like (0)
1. Loed Despuig Post authorAugust 24, 2016 at 2:03 pm
  
  Good to know that this doc helped you.. 🙂
  
  Regards,
  
  Loed
  
  like (0)