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;

COUNT(*)
———-
2517434

Cross verify the count from SMQ2 with Oracle Result.

SQL>truncate table SAPSR3.TRFCQIN;

From SAP

SE14 – TRFCQIN

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:
SPRO
spro

Choose Define Text Objects & Text Types
sapscript

Click Change

Double click on CRM_ORDERH

crm_order

Create New Field

z08

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

text_id

save the same & capture in TR.

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

SPRO

text_det

Select CRM_ORDERH & Dobule click on “Definition of Procedure”

procedure

now enter manually by selecting ZMHF0001 (Urgent Change Connection)

zmhf

below screen will appear
crmh

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

requirment

req1

save & capture in TR.

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

ui

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

SPRO
spro

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

mapp_proj

click on New Entries
text_map

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

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.

result

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).

ZMIN

ZMIN

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.

smin

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.