Thursday, March 31, 2011

Convert SQVI Quick Views to SQ01 Queries

Quickviewer in transaction SQVI:


1.      To enable convert quick viewer
è     Transaction SQ01
è     Go Environment
è     Query Areas


è     select standard area (client-specific)
è     choose


2.      Create a user group
è     Go to transaction SQ03


è     Create new user group and assign users.


3.      Converting quick viewer to query
è     Go to SQ01
è     Query
è     Convert Quickview

* Make sure the queries of the user group you created are being displayed in the query list in SQ01 transaction, because it will automatically pick up the user group.
* If not go to SQ03 and display your user group and come back to SQ01 transaction.


è     select your quickview
è     Now input intended query name & infoset name.



Note: Since SQVI quick views are client specific, when we follow above steps and convert to SQ01 queries it would be client specific and would need to transport to access from other clients using report RSAQR3TR.

4.      Assigning transaction to Query:
è     Go to transaction SE93
è     Create parameter transaction
è     Transaction = START_REPORT
è     Select skip first screen checkbox
è     In default values give the below details:
D_SREPOVARI-REPORTTYPE = AQ
D_SREPOVARI-EXTDREPORT = <Name of the Query>
D_SREPOVARI-REPORT = <User Group>

Tuesday, March 29, 2011

How to write rupee symbol in MS word or excel

è     Download Rupee Foradian Font & unzip the above file.
è     Double click on .ttf file to install the font and click on install or copy paste the location .ttf file in location C:\WINDOWS\Fonts
è     Now open the word document.
è     Select font as rupee foradian.


è     Press keyboard key “~”. Enjoy the rupee symbol