Why is it necessary to delete the tables ALCONSEG, ALSYSTEMS, DBSNP, MONI, OSMON, PAHI, SDBAD, SDBAP, SDBAR, TPFET, and TPHFT in an SAP System Refresh

Those tables contain information specific to the source system. On the target system this piece of information will be misleading or wrong.


Tables SDBAD, SDBAP, SDBAR are about backup history. Backups of the source system won't tell you anything about backups of the target system.

TPFET and TPHFT are about SAP instance profiles. You can't keep profiles of the source system; you will have to create new ones for the target system anyway.


Below tables:

SDBAP = SAP DBA Plan Table
SDBAR = SDBA Resource Table
SDBAH = Header table for DBA protocols
SDBAD = Detail table for DBA protocols

belong to sapdba. They contain the log information of the logs that
sapdba and BrBackup and BrArchive write. The sapdba -cleanup function
will enable you to delete the entries from the db-tables, as well as the
respective files in the operating system.

The tables
MONI = Monitor table
PAHI = History of OS system, DB and SAP parameters
ALAMO = Collector of alert events
OSMON = Operating system monitor data
DBSNP = Table for DB snapshots

contain statistical data tha can be displayed in transaction st04. They
can partially be deleted from within the R/3-System following
st04->Monitor->Performance->Database

Tables:
ALSYSTEMS:CCMS Central System Management: Remote Managed Systems

As they contain information related to that source system and will be misleading if copied to target system.

They can partially be deleted from within the R/3-System following
st04->Monitor->Performance->Database

If not work, you can truncate these tables with sqlplus.

sqlplus sapr3/sap
truncate table ;

There is another option to delete all the data with SE14, using database
utility.

Source : https://forums.sdn.sap.com/thread.jspa?threadID=1204044