Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Performance enhancement for CDPOS search

Former Member
0 Kudos

Hi,

The requirement is a report of the history of changes to various fields(approximately 11 of them) for an equipment serial number selected by the user. The report has to search CDPOS with the equipment serial number and find all the changes to the various fields for the past few years. This is taking hours to output the result or the system times out. Has someone come across this issue. Please suggest if there is an efficient way to get this report or to read CDPOS.

Thanks!

6 REPLIES 6

ferry_lianto
Active Contributor
0 Kudos

Hi,

Have you looked standard program RSSCD200?

Regards,

Ferry Lianto

Former Member
0 Kudos

Hi Kris,

First try to get header data from CDHDR. Get CDHDR data based on based on objectclas, objectid, udate and tcode.

Based on this CDHDR key fields, fetch CDPOS values based on this key fields.

First change one equipment number and check in cdhdr entries for this tcode and date. Here you can find what objectclass and objectid for this tcode.

This objectclass you can consider it as hardcode value.

Cheers

Hema

0 Kudos

Hi Hema,

Thanks for the reply. But the report needs to pick all the equipment records for which a particular field has been changed. So the only value I have to read the table is the old and new value field and then pick the equipment number(object id) from there. All other variables like object class, object ID, date, tcode etc are unknown. That is why the performance issue is occuring. Is there any way to read CDPOS faster?

0 Kudos

As I said, It would be best if you could post the seelct you are using.

Rob

Former Member
0 Kudos

Can you use FM CHANGEDOCUMENT_READ? If not, could you please post the SELECT statement you are using?

Rob

Former Member
0 Kudos

Please get the chngnum from CDHDR by passing objectclas, objectid into an internal table

Go for all entries and select from CDPOS by passing objectclas and changenumber as well as date range.