Problem with CDHDR table

[Former Member]

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

[Former Member]

Hi Singh,

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

Cheers...

Santosh.

P.S. Mark usefull Answers

[Former Member]

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

[Former Member]

Hi,

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

Cheers.