SAP Knowledge Base Article - Preview

3640149 - Partitioning and Archiving Recommendations For Large CPE Database Tables in Sap Hana

Symptom

  • The tables CPED_TERMCONVIN and CPED_TERMCONVOUT in the Commodity Pricing Engine (CPE) database have grown to 1.5 billion entries and are expected to reach their threshold soon.
  • No standard archiving report exists to clean or archive the CPE data.
  • The system requires recommendations for table cleanup, partitioning, or other actions to manage the growing table size.


Read more...

Environment

Commodity Pricing Engine

Keywords

CPED_TERMCONVIN, CPED_TERMCONVOUT, CPE database, SAP HANA, table partitioning, SAP Note 2044468, large database tables, partition pruning, OLTP queries, partition schema, data cleanup, archiving limitations, Commodity Pricing Engine, SAP Commodity Management. , KBA , CA-GTF-CPE , Commodity Pricing Engine , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.