Flashback Query for Restoring the Table Entries from UNDO

Flashback Query for Restoring the Table Entries from UNDO
July 11, 2014 | No Comments »

If you wrongly delete any table entry from oracle database level and you want to get your data back then you can use this procedure easily…

Change Spool Request Creater Name

Change Spool Request Creater Name
July 10, 2014 | 1 Comment »

If you want to change a created SPOOL request owner’s name then you can do this easily from transaction code SP01 with the following steps…

SAPGUI Installation Check

SAPGUI Installation Check
July 09, 2014 | No Comments »

If you want to check your SAPGUI installation status then you can use the following easy steps to do that…

SAP Local System Log Repair

SAP Local System Log Repair
July 08, 2014 | No Comments »

If your local system log file is damaged then you can check and repair the log file via SAP program RSLG0020

“Central system log cannot be read” Message on SM21

"Central system log cannot be read" Message on SM21
July 07, 2014 | No Comments »

On windows NT systems there is no central system log but if you using UNIX system and if you got the message “Central system log cannot be read” then check the following info…

Count Number of Entries for SAP Table

Count Number of Entries for SAP Table
July 06, 2014 | No Comments »

If you want to get count number of your database table then you can use two different way for it…one is from oracle environment and the other one is SAP transaction SE16

Mass Generation of Profiles via SUPC

Mass Generation of Profiles via SUPC
July 05, 2014 | No Comments »

You can use the transaction code SUPC to determine the missing authorization profiles for the related roles and also you can generate all profiles automatically….

CPU Time Usage List in SM50 Transaction

CPU Time Usage List in SM50 Transaction
July 04, 2014 | No Comments »

If you want to list “CPU Time Usage” info in your SM50 transaction code then you have to activate on transaction SM50 with following way..

Background Job Statistics

Background Job Statistics
July 03, 2014 | No Comments »

If you want to get statistical informations about any SAP background job then you can use the following tip to get it..

Extended Job Selection

Extended Job Selection
July 02, 2014 | No Comments »

If you want to select background jobs with more detail informations which already defined on your SAP system then you can use the “Extended Job Selection” criteria or transaction SM37C

ST13 Analysis and Service Tools Launchpad

ST13 Analysis and Service Tools Launchpad
July 01, 2014 | No Comments »

SAP transaction ST13 Analysis and Service Tools Launchpad helps to execute a lot of service tools like BACKGROUND_JOB_ANALYSIS , BW-TOOLS , RSECNOTE , RTCCTOOL etc…

Consistency Check for Inbound and Outbound Queues

Consistency Check for Inbound and Outbound Queues
June 30, 2014 | No Comments »

You can check your SAP systems inbound and outbound queues consistency status easily with two related report via transaction code SE38

INS ( Insert) and OVR (Overwrite) Options in SAP System

INS ( Insert) and OVR (Overwrite) Options in SAP System
June 29, 2014 | No Comments »

You can see the word of INS or OVR on the right bottom side of the SAP screen if you curious about these words lets check it together…

List All Function Modules of SAP System

List All Function Modules of SAP System
June 28, 2014 | No Comments »

You can easily list all function modules of your SAP system with related table entry…Just use transaction code SE16 and list…

List All SAP Tables with Further Infos

List All SAP Tables with Further Infos
June 27, 2014 | No Comments »

You can list all SAP tables and their further informations like description , field name or field description etc.

REDO LOG Informations on SAP

REDO LOG Informations on SAP
June 26, 2014 | No Comments »

If you need any REDO LOG Backup status or Archiving directory informations then you can use the transaction code DB12

Finding Corrupt Indexes on Oracle

Finding Corrupt Indexes on Oracle
June 25, 2014 | No Comments »

You can find the corrupted INDEXES via ORACLE database view “v$database_block_corruption”..Let’s check with an example…

Rebuild an Oracle Database Index via SQLPLUS / RSANAORA / BRTOOLS

Rebuild an Oracle Database Index via SQLPLUS  / RSANAORA / BRTOOLS
June 24, 2014 | No Comments »

When you are required to rebuild an index that is in an unusable, missing, or bad index status then you can use several tools like i would like to share with you below…

Changing the Password of User TMSADM

Changing the Password of User TMSADM
June 23, 2014 | No Comments »

If you get a message like “Password XXXX is Well Known” after the result of the report “RSUSR003″ for the user TMSADM then you should use the following procedure to change it…

SICK Transaction Shows “CPU Timers not Synchronized”

SICK Transaction Shows "CPU Timers not Synchronized"
June 22, 2014 | No Comments »

After executing the SICK transaction,  we may get an error message like “CPU timers not synchronized. Check note 1036194.”

Increase STAD History Data

Increase STAD History Data
June 21, 2014 | No Comments »

Transaction STAD (The Business Transaction Analysis ) delivers workload statistics across jobs and business transactions.By default,  these data storing value is 48 hours for every SAP system but you can change it via profile parameter…

Edit TMS RFC Definitions on SM59

Edit TMS RFC Definitions on SM59
June 20, 2014 | 1 Comment »

Normally you cannot EDIT TMS RFC definitions which defined under transaction code SM59,  but if you want to open these definitions for editing then you can use the following tip…

Rebuild an Index via DB02

Rebuild an Index via DB02
June 19, 2014 | No Comments »

If you want to rebuild an index over SAP system then you can use the DB02 transaction for this operation….Let’s see the steps…

Program RSUSR003 Reports Security Violation

Program RSUSR003 Reports Security Violation
June 18, 2014 | No Comments »

If you get an error in your SM21 log screen like Program RSUSR003 Reports Security Violation” then you firstly check your RSUSR003 report result and if everthing is OK but you still getting error line then you should check the related OSS note below…

Blogroll