Online Tutorials & Training Materials | STechies.com
Register Login

Delete records from CRMD_CIC_CTI_H & CRMD_CIC_CTI_I Tables

vaibhav gupta || 23 Jan 2018 1:16 pm || 1

How to delete records from CRMD_CIC_CTI_H and CRMD_CIC_CTI_I tables?

Hello SAP Experts,

There are many outdated rows in CRMD_CIC_CTI_H and CRMD_CIC_CTI_I which are not needed anymore. 

Please follow steps below in table sizes for CRMD_CIC_CTI_H and CRMD_CIC_CTI_I:

  • Please run T-codes SE16 
  • Then click 'Number of Entries'

How can I delete records from CRMD_CIC_CTI_H and CRMD_CIC_CTI_I tables?


Comments

  • 23 Jan 2018 6:47 pm

    If you need data for any purpose (such as for Auditing):

    • Please Back up both tables (CRMD_CIC_CTI_H and CRMD_CIC_CTI_I) or ensure that you have any backup where you can restore these tables if needed.
    • Then you can truncate both tables (CRMD_CIC_CTI_H and CRMD_CIC_CTI_I) at SQL level, using your Database Administration tools.