Skip to Content
author's profile photo
Former Member

Modeling to capture Change Log table

Hi Experts,

We are continuously getting requirements from client for reports using the change log header and item table (CDHDR and CDPOS) for MM and ICL_HISTPOS_GUI for insurance.

I have noticed that these tables contain huge amount of records and which is really difficult to deal with.

Can anyone please suggest a better and efficient modeling to capture the records from these table on personal experience.

Right now I have planned for

u2022For a FM custom extractor to do most of the selection of records in the code/ or may be a view extractor can work with proper selection condtions.

u2022Using the write optimized DSO for staging in BW

u2022Then pulling the Delta into the cube

But what worrying me is the volume of records thatu2019s flowing in per day even per hour. Per day the number of records reaches sometime 4-5ks for couple of weeks it goes to 20-30ks. How to handle these huge amount of records. How to do the archiving for the same? How to do the performance optimization for the same.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Posted on Feb 16, 2011 at 02:25 PM

    try to delete delete the changelog use ST14 tcode...

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 16, 2011 at 08:24 PM

    Hi,

    The number of records should not be a problem in your case but the only thing is that these two system tables are set to be refreshed after a certain amount of time, so check the details from your basis/ECC team. Also, try to extract the minimum amount of data by providing proper filter conditions in order to fasten up the process as these tables contain all the changed values in the system which is huge.

    Regards,

    Arminder

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 04, 2011 at 02:19 PM

    Its done.

    Add comment
    10|10000 characters needed characters exceeded