SAP ERP RDS for profitability analysis with SAP HANA –

SAP ERP RDS for profitability analysis with SAP HANA – data provisioning

Using the CO-PA replication program / transaction KEHW

(image page No 361 Not clear)

Actual and plan line items are always transferred (CE1 and CE2)

Realignment data (CE4) are transferred if customized in kehc – basic settings

SAP ERP RDS for profitability analysis with SAP HANA – data provisioning

Performance & frequency considerations

Initial load can take substantial time

Measurements are showing 3-20 mio CE1 records per hour. Bottleneck is rather on reading the traditional database.

Example: 60 mio records in CE1 + 4 mio records in CE4 => —  hours processing

NO downtime is required

CO-PA reporting and processing can continue, HANA accelerator will not become active before data has been transferred

Schedule the program frequently to —- id long reading time from traditional database

CO-PA read function module will federate data from HANA and from original tables The more frequent you run the replication, the less data needs to be read from the original tables

Proposal: Schedule replication program once per day. Analyze performance trace. If read access to original table consumes more time than HANA access, increase the frequency.

CO-PA accelerator should decrease total load on traditional database.

SAP ERP RDS for profitability analysis with SAP HANA – data provisioning

Segment table / realignment data

Relevant entries in CE4 table are automatically transferred during initial load

Changes to existing CE4 entries are transferred at the end of realignment run automatically

  • Realignment accelerator status is set to red
  • Application tries to replicate changed entries to HANA
  • If successful, CO-PA accelerator becomes operational again
  • If not successful, a message will be shown and status ——- red until program RKE_HDB_WRITE_REALIGNMENT_DATA has been run successfully

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on SAP ERP RDS for profitability analysis with SAP HANA – data provisioning"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please leave a message and we'll get back to you soon.
    Three + 6