CDHDR table performance issue.

[Subbaka11]

As per the current requirement, we need to retrieve change document records based only on OBJECTCLAS and UDATE. In our current object, there is no scope to pass additional key fields such as OBJECTID or CHANGENR. Due to the large volume of data in CDHDR, fetching records using only OBJECTCLAS and UDATE is causing performance concerns.

Could you please suggest any suitable SAP standard function module, API, or recommended approach to efficiently fetch CDHDR data based on OBJECTCLAS and UDATE without impacting system performance? Also, kindly advise if there are any best practices or alternative solutions to handle this requirement.

[BaerbelWinkler]

Hi Subbaka11!

Are you already on a HANA database? If you are, you could try with JOINING CDHDR with CDPOS and restrict the selected data based on for example the table you are interested in. We have quite a few such selects in our Z-code and it's working fine.

Hope this helps!

Bärbel

[Lakshmipathi]

In that z-report, you can very well copy the logic from the standard report AUT_REP10.

[Lakshmipathi]

Execute Transaction AUT10 followed by F9 key.  You will have multiple options over there

[Subbaka11]

Hi Lakshmipathi, Thanks for the response, but we are using CDHDR table in ZREPORT and facing performance issue at selection query we are trying to improve performance using different data fetching techniques.