SAP BW - How to copy BEx query from one infoprovider to another infoprovider using RSZC

You can use this tcode - RSZC

RSZC can be used to copy the queries from one InfoProvider to another if the structure of the both InfoProviders are same.

Please double check on the below points:
  1. Structure of both InfoProviders are same.
  2. At least, the characteristics used in Query you are copying should be present in Target InfoProvider