Accessing Production Data in QA Environment

[adnanmaqbool]

Dear Guys

Is there any way to test your reports with Production data in QA server.

I want to check the results of my report available in QA with production data before moving it to production server. Report is just a List which is not modifying tables data.

[former_member156446]

before transporting its not possible..

ask your basis person how new is the data in QA, if its a recent copy of production..then that will be the output in Prd as well..

[Clemenss]

Hi Adnan,

it will cost you some effort but it is possible to read table data via RFC if a connection is set up.

See function modules like "RFC_READ_TABLE".

Regards,

Clemens

[Arslan1]

Hi , 

How to access the data in the prod from the QA system?

[raymond_giuseppi]

Basically thru a RFC destination, so you can use some GET BAPI or RFC FM such as RFC_READ_TABLE. There are other solutions for SQL via DBCON or IDOCs exchanges that depend on your exact requirement.

But ask first to your basis and security team.

[Arslan1]

I just want to access Prod data from the QA system and I want to do this in QA. Is there an ABAP Editor? If there is, I want to do it with ABAP Is there a way to do this?Can you show a code example?

Thank you.

[Arslan1]

1. Creating an RFC Link
Log in to SAP GUI: Log in to the QA system via SAP GUI.
Run SM59 Transaction Code: Open the RFC Connections screen by entering the SM59 transaction code in the SAP menu.
Define New Connection: Create a new RFC connection by clicking the "Create" button.
Enter Connection Details:
Enter a name and description for the connection.
Select "3" (ABAP Connection) as connection type.
Enter the details of the prod system such as application server name, system number and client number.
Save and Test the Connection: Save the connection information you defined and test the connection with "Connection Test" option.
2. Creating RFC Function Module
Run SE37 or SE80 Transaction Code: Use SE37 (Function Builder) or SE80 (Object Navigator) transaction codes to open the function module editor.
Create a New Function Module: Create a new function module by clicking the "Create" button.
Enter Function Module Details: Give the function module a name and define the necessary parameters (import, export, changing, tables, etc.).
Write the Function Module Code: Write the ABAP code that will perform the operation that the function module needs to do.
Save and Activate the Function Module: Register and activate the function module you wrote.

3. Calling the RFC Function Module
Write a Program to Include RFC Function Call: Write an ABAP program that will make an RFC call from the QA system to the prod system. This program should call the function module you created in step 2.
Perform the Function Call Using the RFC Link: In your program, use CALL FUNCTION ... DESTINATION, specifying the RFC connection name (destination) as defined in SM59.
Test the Program: Test whether the RFC call from the QA system to the prod system was successful by running the program you wrote.   

Is that what you're talking about?

[raymond_giuseppi]

Yes, but you'll have to modify your report to such an extent that it won't be a true proof of concept (replacing many SQL select/fetch with RFC_READ_TABLE, etc.).
Is your quality assurance system so old that it justifies this effort?

[Arslan1]

I know it's very troublesome, but is there another way? 

[raymond_giuseppi]

Ask your security team, and observe their reaction.
Why don't you transport to production or request a refresh of the qualification environment

[Arslan1]

 I am a trainee, they just asked me to investigate 🙂
Thank you very much for your help.