Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

cdhdr too big

Hi

A program is making use of the table cdhdr

With where condition objectid AND udate. using a for all entries condition

But since this table contain 28 million data in is when a time out occur because the search is too big and also we are not making use of the primary key criteria. Please advise how this can be solve. to prevent time out

Tags:
Former Member
replied

Make use of the primary key criteria. No way around that.

Most of the time you are looking for change documents for a certain object (e.g. EINKBELEG = purchase orders), so always select a single value of OBJECTCLAS to even have a chance for a quick select.

Not too many values in the internal table with OBJECTIDs cannot hurt either.

Thomas

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question