change log deletion issues

[former_member186160]

hi all, i have to manually delete change log entries from some 30 DSO list manually.

we have created process chains for it, but its not deleting for some reason, we have created a ticket to SAP on this.

till it gets resolved, its my task to manuallty delete change log requests from DSO from so many DSO's

i need some help on this.

1. is there any table , from which upon giving DSO list, it shld display

the number of entries in each DSO,

created date for entries

- from this i can decide upon what selections i need to give to delete change log entry

-like if more than 60K entries , i want to decide to delete

-if created date > 7 days, i want to delete........

2. pls give me tips to do this in a short span and easier way

[Former Member · Accepted solution]

Create a process chain wherein you have only two process steps start and Deletion of requests from changelog.

May be you might not have checked the check box, also it is enough if you give all the DSO names.

Regards,

Vishnu

[Former Member]

Hi Swetha,

You can see the no of entries of a particular DSO using below table.

/bic/A(DSO name)00

Go to Se16 give table name and click on no of entries.

[former_member186160]

PFA

in se11 - checked table names for change log

found that there is not one common change log details table, but one table for change log details for each DSO

if i display any one table , no option to select fields of my choic

more over the list takes long time to display

i only wnat number of records, created date etc

this is a very timeconsuming and tedious way to get details on what table's data to delete

even manual deletion isnt working for some. pls suggest on this also.