Introduction

Program: Z_COPY_QRY is used to copy queries from Production (WBP) to Development system (WBD), mainly to align the BW queries in WBD with Production (WBP) queries , alignment of queries in both systems is mandatory to enhance existing queries and move them to production.

Pre-Requisite

Authorization to run this program is hard coded with in this program. Your SAP USER ID is need to be added in with in this program to be able to run.

TECHNO - BI TEAM > How to Use Query Copy Program Z_COPY_QRY. > image2017-11-17 20:7:42.png

How to Run :

Program is saved in WBD.

GOTO TCODE : SE38 and enter Z_COPY_QRY (program name) and execute it by clicking F8 button.

TECHNO - BI TEAM > How to Use Query Copy Program Z_COPY_QRY. > image2017-11-17 20:13:39.png

Once it is executed with F8 , Below screen will be displayed asking you to enter query name to be copied and source system of query. Do not forge to select Update Query under Processing Mode.

TECHNO - BI TEAM > How to Use Query Copy Program Z_COPY_QRY. > image2017-11-17 20:26:25.png

Click on 'YES'

TECHNO - BI TEAM > How to Use Query Copy Program Z_COPY_QRY. > image2017-11-17 20:30:3.png

After its execution message will be displayed with the copy query name in WBD.

TECHNO - BI TEAM > How to Use Query Copy Program Z_COPY_QRY. > image2017-11-17 20:32:19.png