Skip to Content

cleanup tables - CDCLS/CDHDR

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 28, 2016 at 03:14 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 26, 2016 at 02:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 26, 2016 at 02:21 PM

    Hi Willem,

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

    1257133 - CD: Archiving options for CDCLS


    Regards,
    Raquel

    Add comment
    10|10000 characters needed characters exceeded