topic Re: Improving performance while fetching data from CDHDR in Application Development and Automation Discussions

Improving performance while fetching data from CDHDR

Former Member — Tue, 03 Apr 2007 12:25:11 GMT

Hi friends,

I have to fetch data from cdhdr table, and iam passing DEBI as objectclas and customer number as object id to get CHANGEDON and CHANGEDBY details for the customer.

But, i am getting the results so slowly, and some sometimes i have to cancel the transaction because of the processing time it takes to fetch.

Can u plz suggest me how to overcome this problem .

How to improve the performance.

Iam waiting eagerly for u r reply.

Thanks and Regards,

Anil reddy.

Re: Improving performance while fetching data from CDHDR

Former Member — Tue, 03 Apr 2007 12:33:10 GMT

Try to see the report MF01ADEB

Max

Re: Improving performance while fetching data from CDHDR

Former Member — Tue, 03 Apr 2007 12:41:18 GMT

Hi,

Enter DEBI as Object Class and approx number range(customer Range) in Object ID and can enter the Tcode like created customers(XD01) or changed customers(XD02) along with approx Udate (date of creation/change)

this will fetch the records fast.

regards,

Anji

Re: Improving performance while fetching data from CDHDR

Former Member — Tue, 03 Apr 2007 12:57:01 GMT

HI,

Try using standard FM like

1)chage_document_read

2)CHANGEDOCUMENT_READ_HEADERS

3)HANGEDOCUMENT_READ_POSITIONS