Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Active Contributor

Last Changed: 25th of January 2023

Software Logistics (SL) for SAP BW and BW/4HANA

Blog Content



More flexibility with SAP BW Post-Copy Automation

To reduce downtime for your production landscape, one of the recommended migration paths of SAP NetWeaver Business Warehouse (SAP NetWeaver BW) to SAP NetWeaver BW on SAP HANA comprises a system copy of your SAP NetWeaver BW system. The system copy procedure of SAP NetWeaver BW systems and landscapes is complex for a number of reasons however. A large number of configuration settings are involved for example (such as connections and delta queue handling for data loading), as well as system copy scenarios of SAP NetWeaver BW (each with different landscape aspects) that have to be handled as part of every system copy, regardless of whether the system copy is part of the migration to SAP HANA or you want to perform regular system copies of your SAP NetWeaver BW landscape.

To achieve this, SAP NetWeaver Landscape Virtualization Management offers preconfigured "task lists" used by the ABAP task manager for lifecycle management automation.

You can also enable SAP BW powered by SAP HANA to “go productive” with parallel operation of your existing production system, both connected to the same back-end systems. This is achieved with a special and unique automated solution for delta queue cloning and synchronization on production systems.

SAP Note 886102 (SMP login required) thus becomes obsolete. Using the post-copy automation for SAP BW (BW PCA) in the migration process of SAP BW to SAP BW on SAP HANA, this process can be shortened by weeks and becomes easier, faster and more reliable.

The former presentation TechEd 2014 - Session ITM206 still illustrates the migration to SAP BW on SAP HANA from an end-to-end perspective.

SAP BW System Copy

PDF help: User Guide for SAP BW Note Analyzer
Note 2743291 - PCA for BW/4HANA
Note 2570363 - Availability of BW PCA for BW/4HANA
Note 1707321 - BW System Copy: Post Copy Automation (BW-PCA)
Note 1614266 - System Copy: Post-Copy Automation (PCA) / SAP Landscape Management (LaMa)

SAP BW 7.30  - Systemcopy ABAP => Update from January 2020

Since Release 7.30 SP05, it is now possible to perform a heterogeneous system copy (including unicode migration) to migrate existing systems based on SAP BW 7.30 SP05 and higher to SAP BW on SAP HANA (HDB) based systems.

With this major step forward, a new procedure called "Post Copy Automation (BW PCA)" now supports customers with what can often be complex post-steps before and after the homogenous/heterogeneous BW system copy. This presentation is the delta information to the existing document "SAP NetWeaver 7.30 - BW Systemcopy ABAP" shown above. The technical Improvements with the leaner data model provides advantages with BW on HANA too.

You can also refer to the SAP First Guidance Documents
SAP First Guidance – SAP BW on HANA – Edition 2021
SAP First Guidance - BW Housekeeping and BW-PCA

To ease this generic step of BW system copy, a new procedure called "BW Post Copy automation (BW PCA)" is available, which supports customer now in the complex pre and post steps during the homogeneous/heterogeneous SAP BW  system copy (information from the SAP ALM group) procedure.

Please note that these procedure can be used independently from your BW and Database Version starting from NetWeaver 7.0x

Blog - System Copy Automation for SAP Business Warehouse System Landscapes
Blog - New Note Analyzer for SAP BW PCA and Housekeeping
Blog - System Copy Automation for SAP Business Warehouse System Landscapes (BW PCA)

We distinguish between two use cases explained in the FAQ for BW-PCA:

  • Initial copy
    based on an existing original BW system and connected BW source systems

Task Lists - SAP_BW_COPY_INITIAL_PREPARE (SAP BW systems only)

Note 2534288 - HEC Service "Homogeneous System Copy / System Refresh (ABAP)
Note 2681701 - System Copy: Task Content (12.1 Improvements)

  • Refresh of an existing system
    based on an existing SAP BW system and connected SAP BW source systems


Updating to the minimum level of the mentioned Support Stacks is recommended to minimize the manual effort. For both cases the BW-PCA Task lists support the customer together with the software provisioning manager 1.0 (SWPM) in these software lifecycle management tasks. BW-PCA is embedded in the SAP NetWeaver Landscape Virtualization Management

SAP BW Housekeeping Tasks

Here, you will learn about various housekeeping activities that should be part of the operational concept of your Enterprise Data Warehouse. These housekeeping activities will support you in removing unwanted and unneeded data as well as unused metadata. Scheduling these activities regularly in the system will ensure optimum utilization of system resources while at the same time increasing the overall system performance.

SAP First Guidance - SAP BW Housekeeping and BW-PCA

Note 1829728 - BW Housekeeping Task List
Note 1855296 - BW Housekeeping, Upgrade and Migration Task List Improvements 1
Note 2124850 - Class CL_RSO_DTP_ERROR_LOG_DELETE is missing Housekeeping task list
Note 2407784 - How to clean up RSBKDATA and related tables

The Housekeeping Task List (Pre/Post Steps) allows you to automate mandatory tasks prior to upgrade/migration with DMO to ensure the quality of the migration process and the health of your BW System.

Blog: Create #SAP #BW Housekeeping task list
Blog: House Keeping / Performance Tuning Activities in SAP BW Systems
Blog: SAP BW-Performance Tuning through System Tables

Event Presentations

Presentation - Hitchhiker’s Guide to NetWeaver or “thank you for the fish …” (simply timeless)

Presentation - Upgrade S/4HANA Version 2020 -Basis View


Additional Topics like References, Experiences, etc.

For information about lower releases, see SAP BW 7.0 and lower - exclusively.

Product Availability Matrix (PAM) for Business Warehouse Accelerator 7.20 (BWA)
Note 1845809 - Latest Revision for BWA 7.20
Note 2495501 - BWA 7.20: Revision 41
Note 2665383 - BWA 7.20: Revision 42
Note 2887737 - BWA 7.20: Revision 44 (05.02.2020)
Note 3284562 - BWA 7.20: Revision 49 (30.12.2022)

This is a collection of resources from the former SCN Network and its content is not reflecting the findings from this document of future upgrade and enhancements.

Blog - IE11 will no longer be supported by various SAP UI technologies in newer releases
Blog -
 SAP BW Upgrade: Pre and Post upgrade activities with answer to why?
Blog - SAP BW 7.4 Powered by HANA -- Promising Features (Part 1)
Blog - SAP BI4.x Installation/Update/Patching
Blog - Removal of only Time Dependent Attribute added Accidentally
Blog - Some interesting Facts of Compatibility Views in SAP BW/4HANA and SAP S/4HANA - SAP Cloud Integration into SAP BW/4HANA - further Content from frank.riesner1 (SAP)
Blog - How to load Flat Files from MS Office 365 to BW/4HANA using SDI / DP-Agent

DSAG Forum: "TG Road 2 BW/4HANA" => (DSAG-ID requested) share your experience with other DSAG members.

Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics



“I have no special talent, I am only passionately curious.”