Product and Customer Indexing Bottleneck

In SAP ECC data changes are stored in the CDHDR table (Change Document Header). This is a standard SAP ECC table and it stores a lot of data. The keys in this table are object class - material and customer, and material and customer numbers.

Sana retrieves material and customer changes from the CDHDR table in SAP ECC based on the UDATE (Update date) and UTIME (Update time) fields. Since UDATE and UTIME are non-key fields, fetching data from a query based on these fields can be slow or even lead to a timeout depending on the amount of data. If you need to change some data of a large number of materials or customers in SAP ECC at once, it can take a lot of time for Sana to update the product or customer index.

Some companies use the SAP system for many years and they have millions of records in the CDHDR table which makes it difficult for Sana to access this table and check for material and customer data changes there.