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.

SAP ITSM Text Determination Procedure & Copy Control

Recently while working on Charm Project, there is a requirement from client where we need to add some extra Text fields in “Request for Change” screen. We have added some Z fields & these all fields need to display in “Urgent Change” as Text Log while following up from the same screen.

Request for Change Extra Text Determination Z fields:
Request for Change Text Determination

After filling up all the entries you want to display these details in Urgent Change as Text Log. I have created 1 more Text field(Requirement) in Urgent Change & copy all text from RFC under that.

Below is the procedure:

Choose Define Text Objects & Text Types

Click Change

Double click on CRM_ORDERH


Create New Field


Below are the Text ID (creation of Text ID’s are common & you can assign as per your requirement)


save the same & capture in TR.

    Text ID is created & now assigning in Urgent Connection transaction.



Select CRM_ORDERH & Dobule click on “Definition of Procedure”


now enter manually by selecting ZMHF0001 (Urgent Change Connection)


below screen will appear

Add new entry “Requirement” & set sequence as per your requirement.



save & capture in TR.

Also verify the same in CRM UI. (Urgent for Change)


Now configuring copy all text values of “request for change” to “Urgent Change”. All values will be copied in requirement tab only.


Select below ZMCR – ZMHF (Maintenance Project) & double click on “Text ID Mapping”


click on New Entries

now add values here (Source to Target)
Z08(Requirement) — Target

save in TR.

Now create New request for change in UI & insert scope Urgent Change. Fill all the entries & & check all values should be visible in Urgent Change.


Share your comments & feedback.

ITSM: How to block unwanted Transaction Type

if you are getting below screen in ITSM while clicking on Create Incident / Service Request & you want to block unwanted transaction type (SMIN).



You can go To SPRO – SAP Solution Manager – Capabilities – IT Service Management – Transactions – Define Transaction Type

Find the SMIN & make it inactive. while saving it will ask you TR number, you can also forward the same to further systems.


Can’t connect to X11 window server using ‘hostname:2’

If you are getting this below error in while opening SAPINST GUI in linux machine then run below command.

May 8, 2015 6:38:04 AM [Info]: GUI started.
May 8, 2015 6:38:04 AM [Info]: >> No protocol specified
May 8, 2015 6:38:04 AM [Info]: >> Closed input stream
May 8, 2015 6:38:04 AM [Error]: GUI terminated with return code 4
May 8, 2015 6:38:05 AM [Info]: >> Invocation target exception: Can’t connect to X11 window server using ‘hostname:2’ as the value of the DISPLAY variable; you may consider checking your DISPLAY environment variable.

xhost +

on base machine where we start vnc.

then ssh the host and start GUI.