Hello Friends. We have Standard DSO where the Change Log Table is growing in size 7999978 due to overwrite functionality used. Which means Records for Fiscal year/period Each quarter example 001.2008 - 003.2008 is loaded every alternate day for business reason since material automobile code is changed alternative day. so we are overwriting it in DSO and loading to Cube
Can u tell what is the optimum range where Change Log will grow after 7999978 that will degrade the performance. Any link or OSS on sap where it recommend the data records range for performance on change log.
Also can u suggest me Can we delete only the change log for old requests so that it does not grow in size. and also please tell steps in automated way to delete the selected request from change log of DSO