Find Sybase(ASE) Database version

Use the following command to determine the Sybase database version installed. Select @@ version go Or use below command sp_version go&nbs...

Start and Stop Max DB

Start  and Stop Via DBMCLI The  dbmcli commands to start/stop MaxDB Instance. Shutdown: dbmcli –d <db_name> -u <dbm_user>,<password> db_offline Restart: dbmcli –d <db_name> -u <dbm_user>,<password> db_online ...

What is SAP ALV?

ALV stands for ABAP List Viewer. ALV gives us a standard List format and user interface to all our ABAP reports. ALV is created by a set of standard function modules provided by SAP. ALV provides a lot of inbuilt functions to our reports and some of the functions  are listed...

SAP Transport Return Code Status

RC = 0, successfully imported. RC = 4, imported ended with warning.Common issue:• Generation of programs and screens• Columns missing and Rows missing. RC = 8, not imported ended with errorCommon issue:• Syntax error.• Program generation error.• Dictionary activation error.• Method execution error. RC = 12, import is cancelled.Common issue:• Import is canceled due to object missing.•...

How to generate SAP Solman Key without having Solution manager

You might want to install SAP ECC 5 or SAP ECC 6 and been asking SolmanKey. What if you don't have Solman Server ? Then how would you generate solman key ? There are 2 ways (if you don't have Solman Server to generate solman key) : 1. Ask your friend which have Solman Server to generate it. OR 2. Use this simple script (VB Script) to generate it. '   Solution Manager Key...

How to change the default SAP GUI client number

You need to change an instance profile parameter on the R/3 system.  Goto :TCODE RZ10, login/system_client The default value is 000. Which Client you want change client value like 300,800,000,. ...

How to increase Dialog work process time in SAP

Goto transaction code RZ11, enter the parameter name – rdisp/max_wprun_time and press enter. Once you get the below screen, click on Change Value and enter the desired time. Please not to set the value to 0 as it will make the running time unlimited. No restart required as the parameter is dynamically switchable. For permanent change, please do it on transaction code RZ10. You can...

How to Modify SAP Transport Number Range

You want to change the transport number range on the SAP System. SAP stored the last transport request in the table E070L. You can find the information using transaction code SE16 or SE16N. Due to non-modifiable function on transaction code SE16/SE16N, you may need to update the table from database level. Below example is on Oracle database. If let say, the latest transport number...