topic Re: Problem with CDHDR table in Application Development and Automation Discussions

Problem with CDHDR table

Former Member — Thu, 16 Nov 2006 09:44:19 GMT

Hi Experts,

Whenever I am trying to update a distribution list in SBWP transaction, program stuck in standard program LSCD4F10 at below select query and gives a short dump

select * from cdhdr client specified into table gt_cdhdr

where mandant in gt_sl_client

and objectclas in gt_sl_objectclas

and objectid in gt_sl_objectid

and changenr in gt_sl_changenr

and udate in gt_sl_udate.

I checked it in Development system and find that valure for gt_sl_changenr field is coming blank. As MANDANT, OBJECTCLAS, OBJECTID, CHANGENR are primary key fields , so this query engine is unable to use Primary key index thus timing out.

Can anybody suggest solution for this to avoid short dump or some standard SAP note for this if someone faced similar problem.?

Thanks in Advance!

Harkamal

Re: Problem with CDHDR table

Former Member — Thu, 16 Nov 2006 09:50:56 GMT

Hi Singh,

Apply these two notes <b>626341, 557683</b>.

Cheers...

Santosh.

P.S. Mark usefull Answers

Re: Problem with CDHDR table

Former Member — Thu, 16 Nov 2006 09:52:14 GMT

TRy using the CHANGEDOCUMENT_READ_HEADERS function module instead.

It is a standard program and hence SAP would have taken care of the performance of the selects used.

Regards,

Ravi

Re: Problem with CDHDR table

Former Member — Thu, 16 Nov 2006 09:54:57 GMT

Hi,

Instead of using select * if possible try to select all the necessary fields only . Its a huge table isnt it?

Cheers.