cancel
Showing results for 
Search instead for 
Did you mean: 

cleanup tables - CDCLS/CDHDR

Former Member
0 Kudos

Hi

I'm looking to cleanup our current MaxDB database to reduce the size, Current DB size is 970 GB.

SAP System is ABAP - SAP ECC 6.0 (EHP5).

These are the tables > 10 GB:

Table NameGBDescription
CDCLS    193
CDHDR    105Change document header
N2PCDOC    56IS-H*MED: Content of Word6 for Windows documents (DMS)
COEP    46CO Object: Line Items (by Period)
GLPCA    27EC-PCA: Actual Line Items
ACCTIT    24Compressed Data from FI/CO Document
NTSP    20IS-H: Columns in Service Catalog
VBRP    17Billing Document: Item Data
MSEG    16Document Segment: Material
NLEI    16IS-H: Services Performed
DYNPSOURCE    14Contains Screen Source Information (Compressed)

I have not done a clean up previously. Can this be cleaned from BASIS side?  Please assist with step/documentation on how (and if) I can cleanup these large tables.

Best Regards

Willem

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Thanks for the responses.

To confirm, it seems like we will have to recommend a Data Archiving Solution to reduce the size of this database?

michael_kozlowski
Active Contributor
0 Kudos

You definetely should consider a Data Archiving Solution. Espacially in financials aera it is very important to have the whole history of change documents available on demand.

Answers (2)

Answers (2)

raquel_gomez
Employee
Employee
0 Kudos

Hi Willem,

Following Notes may also be helpful:
1591251 - CD: Archiving change documents

1257133 - CD: Archiving options for CDCLS


Regards,
Raquel

michael_kozlowski
Active Contributor
0 Kudos

Use Archiving Workbench for data archiving to ensure data consistency of objects. Refer also  The Data Archiving Process (Archiving Workbench) - Overview of the Archiving Workbench - SAP Library