SAP SMQ2 Mass Queue Deletion


In some scenario or as per customer requirement, you need to delete all the Q from SMQ2. Manual deletion of Q is pain & it takes lot of time.

You can follow below method to truncate the table in safe method.

Table Name – TRFCQIN (SMQ2)

For Oracle

SQL>select count(*) from sapsr3.TRFCQIN;


Cross verify the count from SMQ2 with Oracle Result.

SQL>truncate table SAPSR3.TRFCQIN;

From SAP


Delete Data – Activate & Adjust Database.

Now your SMQ2 is empty.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.