SAP Missing Excel Templates while exporting

Recently we are facing issue while exporting in excel format.

It’s throwing below error.

Solution – Run Report in SA38 – BCALV_BDS_IMPORT_SAP_TEMPLATE in DIALOG mode.

The above report will not ask any input & complete in seconds.

Then try again to export the same contents in excel, you will receive an error first time but next time it will solve & export the contents in excel successfully.

Create Dummy Project for local transport

We have CHARM implemented in our landscape & all the local creation of TR’s are prohibited as per policy. During upgrade of Solution Manager 7.2 it’s asking for perform some change in Shadow System. Change is Shadow System asking TR & which we are not able to save as LOCAL due to CTS enabled.

Alternative Solution for the same is.

Create dummy project in system directly via SA38 – RSWBO_AUX_PROJECT

This new dummy project will visible in system & you can save the local TR & continue with the change or upgrade.

SAP Java Portal change password through Telnet

I am working on SAP Java Portal upgrade from NW 7.3 to 7.4. While SUM enter in execution phase, security team changed the credentials of “Administrator”. due to this upgrade got stuck & i am not able to change password back to same in Portal.

I performed the same through telnet by following below method. before performing this i change UME parameter in config tool & restart the cluster.

Change minimum length of password – 4
Keep password history – 3

telnet localhost 50008

Enter user name
enter current password

Type – add user
enter current password — click Enter

enter user – Administrator
enter new password
confirm new password

Now you can set same password what you have given during Configuration Phase in SUM & continue to upgrade.

Let me know if this works for you.

Z programs behaving like SAP Program after changing the domain controller

After changing the Domain Controller, if your Customize Programs (z) behave like SAP Program, please follow below steps to change the same.

Z programs behaving like SAP Program after changing the domain controller
( ED1 –> EX1)

Need to switch off the Assistant

SA38 – Program – Edit – Modification Operations – Switch off Assistant

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.


Recently we have configured HTTPS in our SAP system. After configuring the same our NWBC portal is not working with HTTP, whenever we open portal, it tries forwarding HTTP to HTTPS & give us error. We don’t have self certificate installed for HTTPS as we are using HTTPS for third party communication. All other traffic on https are blocked. No user is able to open NWBC.

for permanent solution of NWBC to use only HTTP, change as below:

SICF — Search for NWBC

Double click on NWBC

Go to Error Pages Tab

Click on Configuration

Change – Action During Logon

Select Protocol – Do No Switch

Click on Save – It will ask for transport. You can forward the same settings to further systems.

Now when you open again NWBC, it will not switch from HTTP to HTTPS.