Skip to Content

This Document Explains the steps which you need to perform if you want to copy a BEx query from One Info Provider to another incase standard transaction RSZC doesn’t allow you to copy the query due to unavailability of some objects in the target provider.

Many a time it so happens that our standard transaction RSZC doesn’t allow us to copy a query from one infoprovider to another because some Characteristic or key figure is missing in your target Provider which may not even be present in the BEx query which you want to copy./wp-content/uploads/2012/03/1_82208.jpg

Following are the steps which could be performed as a workaround to solve this problem.

RSZC uses Function Module “RSZ_I_COPY_QRY_TO_CUBE” to copy the queries from one provider to other provider.

In this function module there is a step to do a compatibility check of the target Info Provider which we need to bypass to solve our problem.

/wp-content/uploads/2012/03/2_82210.jpg

So to achieve this copy the standard function module “RSZ_I_COPY_QRY_TO_CUBE” along with its function group “RZIMPACT” to a custom function module using Transaction SE80.

/wp-content/uploads/2012/03/3_82220.jpg

Say we provide the name”ZZ_RZIMPACT” to the custom function group.

Copy all the Function modules under this group as custom once and rename them as per naming conventions.

Once you have copied everything please activate your function group along with all its modules.

/wp-content/uploads/2012/03/4_82221.jpg

“ZZ_COPY_QRY_TO_CUBE” is our copies version of standard module “RSZ_I_COPY_QRY_TO_CUBE”.

In our custom module comment following piece of code:

/wp-content/uploads/2012/03/5_82222.jpg

Activate the function  Module now.

Henceforth execute your custom FM instead of TCODE RSZC to copy your BEx queries.

/wp-content/uploads/2012/03/6_82234.jpg

/wp-content/uploads/2012/03/7_82232.jpg

/wp-content/uploads/2012/03/8_82233.jpg

As you can see the BEx query has been copies successfully on top of your target provider.

Hope this document will be helpful to the readers.

To report this post you need to login first.

1 Comment

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

  1. Guy Lamoureux

    Hi Viraj,

    You can also execute RSZC in debug mode and change the value of SY_SUBRC from 4 to 0 after the function call. The program will continue and copy the query.

    This is very helpful sometimes.

    Guy

    (0) 

Leave a Reply