Skip to Content
Technical Articles
Author's profile photo ALEXANDR ZAYTSEV

Refresh test data in test SAP Financial Consolidation (FC)

Hello colleagues,

If you are facing the task of updating test data with production data of SAP FC, I will try to help you solve it. Below you will find my experience.

Environment:

SAP Financial Consolidation 10.1 (production and test server)
Windows Server
SAP HANA 2.0

High-level steps:
  1. Determine a schema in SAP HANA which is used by a production data source
  2. Check the size of an exported schema in SAP HANA
  3. Multiply by two the size of the exported scheme, that’s how much free space should be on the servers (production and test SAP HANA server)
  4. Stop the production data source
  5. Export the schema to FS of the production SAP HANA server
  6. Start the production data source
  7. Move the export from the production SAP HANA server to test (see step 3)
  8. Stop the test data source
  9. (Optional) Export the test schema to FS of the test SAP HANA server
  10. Import the export (step 7) to the test schema on the test server
  11. Check size of imported tables (CT_FACT_DATA)
  12. Start the test data source
  13. Connect to the test data source via SAP FC application as user with admin permissions
  14. Change production server names to test server name in Address book section, in General options -> External links, in General options -> Transfers

 

Some extra info about the steps:

  1. Open SAP FC administration console ( https://<server_name>/FCWebAdmin/Default.aspx?TimezoneOffset=120 ), click on a data source -> Configuration -> Find User ID in Database configuration string field
  2. SAP Note 1969700 -> Data -> Schemas , check the row Total under the schema name
  3. Increase or create temp directories in the production and test SAP HANA server
  4. Open SAP FC administration console, click on a data source -> click Data source options -> click Stop data source
  5. EXPORT "<schema_name>"."*" AS BINARY INTO '<dir_for_export>' WITH THREADS 10 , 
    You need to have permissions to export the schema or to log in as schema owner user.
    If the export will stop with "Export aborted due to concurrent operations", please re-execute script again or set threads to 1.
  6. Open SAP FC administration console, click on a data source -> click Data source options -> click Start data source
  7. scp -r <dir_export> <user>@<test_server>:<dir_target>
  8. Open SAP FC administration console, click on a data source -> click Data source options -> click Stop data source
  9. (Optional) see step 5
  10. IMPORT "<prod_schema_name>"."*" FROM '<dir_target(see step 7)>' WITH REPLACE THREADS 4
    You need to have permissions to import the schema or to log in as schema owner user.
    
    If your target test schema has a different name:
    IMPORT "<prod_schema_name> "."*" FROM '<dir_target(see step 7)>' WITH REPLACE THREADS 4 RENAME SCHEMA <prod_schema_name> TO <test_schema_name>
  11. See step 2 and compare the test schema after the import with the production schema
  12. Open SAP FC administration console, click on a data source -> click Data source options -> click Start data source
  13. Run Financial Consolidation application (Windows) and log in with admin permissions
  14. Change production server names to test server name in Address book section, in General options -> External links, in General options -> TransfersFinancial%20Consolidation%20General%20optionsFinancial%20Cosolidation%20Address%20book

 

Useful links:

SAP Notes: 
2033956 - How to create/copy a test environment from production? - FC 
1969700 - SQL Statement Collection for SAP HANA

How to Export and Import the SAP HANA Schema
Creating a Data Source
EXPORT Statement (Data Import Export)
Import Schemas, Tables, and Other Catalog Objects

Assigned Tags

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