SAP Library - Find your answers

Archiving and Reorganization are totally different issues

Archiving is a process when you archive old master/transactional records which are not in use any more from long time. You archive those records keep on some backup device. These records can be displayed, and only Display, can never be reloaded in tables again physically.
This will free up the space in tables from those records which are not in use any more but exist in tables physically.

Reorganization basically removes deleted data from tables. During different transactions you delete some records, which are deleted virtually but not physically. Even Archive process delete those records virtually.
So you run Reorganization to free up the space consumed by deleted records.

This make the difference between the two clear.

Now about reorganization.

It depends on which OS and DB you are using.

If Oracle, SAPDBA is best tool to reorganise.

In addition to above, you can reorganise the whole database, but it takes time depending upon your database. Some times it can be more than a day or you can reorganise a table suggested in Early Watch system.

It all depends on you.

Archiving is a process when you archive old master/transactional records which are not in use any more from long time. You archive those records keep on some backup device. These records can be displayed, and only Display, can never be reloaded in tables again physically.
This will free up the space in tables from those records which are not in use any more but exist in tables physically.

Reorganization basically removes deleted data from tables. During different transactions you delete some records, which are deleted virtually but not physically. Even Archive process delete those records virtually.
So you run Reorganization to free up the space consumed by deleted records.

This make the difference between the two clear.

Now about reorganization.

It depends on which OS and DB you are using.

If Oracle, SAPDBA is best tool to reorganise.

In addition to above, you can reorganise the whole database, but it takes time depending upon your database. Some times it can be more than a day or you can reorganise a table suggested in Early Watch system.

You can reset the buffers using following commands
Just run the following in SAP command field.
Note: Resetting of the buffers could change the performance of the entire system
/$ DYNP - To reset the screen buffer of the application server
/$ SYNC - This command resets the buffers of the application server
/$ CUA - This resets the CUA buffer of the application server
/$ TAB - This resets the TABLE buffers of the application server
/$ NAM - To reset the nametab buffer of the application server

Use the Transaction code SCMP to compare the tables. You need an RFC connection for the
comparison server client.
Parameters for this Tcode are:
View/Table: Please give the Table name which you want to compare.
R/3 Connection: Give the RFC connection name (Use F4).

...then there are some options, select the options to meet your requirement

Keyword: BASIS
Title : Transport Guide :: Tips for Different SAP Objects

Keyword: BASIS
Title : Copying Tables Entries Between Two Different Systems

You can reset the buffers using following commands
Just run the following in SAP command field.
Note: Resetting of the buffers could change the performance of the entire system
/$ DYNP - To reset the screen buffer of the application server
/$ SYNC - This command resets the buffers of the application server
/$ CUA - This resets the CUA buffer of the application server
/$ TAB - This resets the TABLE buffers of the application server
/$ NAM - To reset the nametab buffer of the application server