Skip to Content

SAP BW and SAP Basis List of activities when ECC Quality system is getting refreshed .

Hi Every one .

There is a plan to refresh our Client's SAP ECC QA system from ECC Prod system in couple of days . This SAP ECC Quality system is connected to SAP BW Quality system. I am basically BW consultant and mainly i am concerned of role and list of actvities need to be performed in BW System by a BW consultant / Basis Consultant.

I dont have prior experience in working on these type of projects . I am assigned to this Project and i will have to take the ownership of all the activites and need to complete this Project . I need your help in providing the answers/Suggestions to below listed questions . I have gone thorugh some threads from SCN forums but did not understand clearly .

1.What is system refresh activity in SAP ? ( What exactly will hapen , will tables data in ECC Prod will be copied to QA or anything else ?

2.Why system refresh activity needs to be performed in an organization?(What is the standard /General need of it ?)

3.What happens when system refresh activity happens ( Will Data Overwrite / Structure will overwrite in the target system with the source system )

4.If SAP ECC Quality system is getting refreshed from Prodcution (Source system is: Production and target system is SAP ECC Quality ) and it got connected to BW Quality system . What are the list of activites need to be perfored in BW and Basis point of view ?

5.Pre Refresh activities (BW and BASIS)

6.During Refresh activites (BW and Basis)

7.After refresh activities (BW and Basis)

8.List of Pre requisites need to be performed (BW and Basis)when System refresh happens?

9.What are the list of risks if this activity is not perfored correctly?

10. If we perfrom system refresh activity in ECC , will there any channce of BW objects gets affectected in BW system? ( As per my understanding ... except process chains , Data sources nothing will be impacted . Please correct me if my understanding is wrong )

Thanks alot in advance



Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 18 at 07:12 PM

    Hi Teja.

    1. System refresh

    System refresh means- From the production system source export & target Qas system import action, as SAP standard System copy process. follow the reference link

    2. The system refresh should copy production to quality assurance system for testing with fresh data

    3. Just replacing current QAS from prod system. all the data on Qas will be replaced with production data (Exporting the existing production to importing in QAS system).

    4. In your BW Qas system, In transaction code RSA1 source system connection to be restored so that you can enable the connectivity in between BI & ECC.

    5. 6 & 7 For BI point view nothing to do, after ECC system getting refreshed, you have to follow the point number 4

    8, To my view nothing from BI point view.

    9. If your are following the SAP guide nothing happen, you may not perform the QA testing,& have to consider the disk space in BI QAS after ECC system refreshed from production system.

    10. If the SAP SID are same in QA Ecc you don't have any issues in the BI, after refreshed the ECC you have to consider BI overall DB space.



    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks Sriram for the answer . Do we also need to perform any of the activities from BW Perspective ? Could you pelase confirm.

      1.Do we need to Clear delta queues(Rsa7 ) before this refresh activity performed ?

      2. Disable process chains in BW and Jobs in SAP ECC Quality before refresh activity performed ?

      3. I did not understand the 4th point in the answer you have given . Could you please elaborate on this please ?



  • Posted on Jul 20 at 10:51 AM

    Hi Teja.

    For BW point view nothing is required, only take care the DB disk space,

    1. Once the ECC system refresh it will be fresh system copy from Prod to Qas, in this case its not required to clear the delta queues on existing Qas system.

    2. In QAS Bw you can hold / suspend the process chain schedules.

    3. Once the ECC refresh activities are completed(From Ecc Prod to Qas), in your BW Qas system, In transaction code RSA1 source system connection to be restored so that you can enable the connectivity in between BI & ECC.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 21 at 06:36 AM

    You need to adapt the logical system name in the tables after the copy. This is done via tcode bdls.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.