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.
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.
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.
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.
“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:
Activate the function Module now.
Henceforth execute your custom FM instead of TCODE RSZC to copy your BEx queries.
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.