Skip to Content
Author's profile photo Balabrahmachari Achari

Live cache backup in HANA

This is document is helpful to Create Live Cache Backup in HANA.

Scenario 1:  APO on HANA database.


Scenario 2: APO on SQL/Oracle database(other than HANA).


Please follow the below steps to create LiveCache backup in HANA:

Step1: Replication Model by using Transaction /SAPAPO/REPL_MOD_VIE.


Click on ‘New Entries’ button

Give name for  Replication Model ID and Description.

Choose Planning Book, Data View, Planning Version, Secondary Database Connection and Selection ID is optional.

Select check box for Delta Replication Relevant Model and Delta Replication Executable.

Scenario 1: Select ‘DEFAULT’ as Secondary Database Connection and this is standard database connection.

Hana_no db connection.JPG

Scenario 2: Select Secondary Database connection HD4 which is created by using Transaction DBCO.


Add Key Figures


Step2: Activate Replication Model by using /SAPAPO/REPL_MOD_MNG.

activated model.JPG

Replication model relevant tables/views will be created in HANA.

Step 3: Check tables/views in HANA which is relevant to replication model.

demandplanning calculation view1.JPG

Step4: Replication of Planning Data to HANA by using Transaction /SAPAPO/REPL and this is full data load.

Replication of Planning data to HANA.JPG

Replication of planning data toSAP HANA.jpg

Step 5: Check full data load in HANA. Demand Plan calculation view under Replication Model.


Can view data in Chart also.


Step 6: Delta Replication of Planning Data to HANA by using Transaction /SAPAPO/REPL_DELTA.



Step 7: Can check delta change in HANA.


Step 8: Create Delta Job by using program /SAPAPO/REPL_REPLICATION_DELTA with periodic.

This Delta job will take care backup in HANA based on periodic intervals.

delta job.JPG

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.