Execute sql statement from SAP

Execute sql statement from SAP  Prerequisite : SE30 tips tricks function should be enabled ,In higher release i observed it’s disable and User should have editing authorization. Goto T code : SE30 click ‘Tips & tricks’ (Runtime ABAP/4 Statements) click ‘Initializing Strings’ put cursor in right box and click on Measure run-time ,It will execute your sql query.

How to understand Oracle Error Codes

How to understand Oracle Error Codes Here i explain special trick for Basis Admin to understand Oracle Error Codes with complete explanation without doing Google. Login to OS level (tested in Unix) as SIDADM user. Execute Command- oerr ora <err#> Suppose i need to look in ora 1652 which i got in some error message,Execute as below: <Host Name> oerr ora 1652 01652, 00000, “unable to extend temp segment by %s in tablespace %s” // *Cause: Failed to allocate an extent of the required number of blocks for // a temporary segment in the tablespace indicated. // *Action: Use ALTER TABLESPACE ……

Java Post Steps in SAP after Oracle Upgrade

Java Post Steps in SAP after Oracle Upgrade If you are running with Dual Stack and You have recently upgrade Oracle to new version then Java will not come ,You’ll have to do some additional steps pointing to correct oracle client version and correct rdbms.driverLocation.Please follow below steps after oracle upgrade for Java:   Change the file config.properties as follows: 1) Change to the correct directory containing the file config.properties Goto /usr/sap/<SAPSID>/DVEBMGS<instance_number>/j2ee/configtool 2) Replace the old driver location with the new one:/oracle/client/<Oracle_client_major_version>x_64/instantclient/<java_class_archive>.jar where <Oracle_client_major_version> is the major version of the Oracle client that you are using after this upgrade. Make sure ……

ADS Connection test in sap and Troubleshooting

  ADS Connection Test in sap and Troubleshooting ADS stands for Adobe Document Services .ADS is part of SAP Netweaver installation and ADS is used for viewing PDF preview in SAP. Here i am explaining the steps how you can verify that ADS in you system is working fine and How you can perform ADS Connection test in sap and Troubleshooting Here i explain how you can verify all ADS Configuration Steps including ADS Connection in SAP are correct in SAP. Please follow below steps : From SE38, test the following. – All the three tests should pass. FP_TEST_00 FP_PDF_TEST_00 FP_CHECK_DESTINATION_SERVICE   Test1: Execute Report from ……

Unlock sap* and ddic from os level database

Unlock sap* and ddic from OS level database  When we don’t have any user to login into SAP ABAP level to unlock sap* and ddic user ,Mostly it requires in client 000 as it is supported by SAP BASIS Team . In this case we can unlock sap* or ddic user from OS level / Databse / Sql Level   Unlock DDIC User from OS Level / database /SQL /Oracle level: Login into Sqlplus: sqlplus / as sysdba SQL> select MANDT, BNAME, UFLAG from <schema Name>.USR02 where MANDT=<Client No> and BNAME=’DDIC’; MAN BNAME UFLAG — ———— ———- 600 DDIC   ……

How to Activate Business Function sap

What is Business Function in sap When we upgrade our SAP system ( EHP upgrade or Version Upgrade) during Stack generation file ,we select Business Usage and Technical usage and based upon our selection for Technical Usage at the end of the upgrade some additional Business Function comes in our upgraded system. In order to get those business functionalities in upgraded system ,we need to activate corresponding Business Function else There is no use of upgrade from Business point of view. How to Activate Business Function sap Go to Sap T Code : SFW5   Click on Continue: Select related ……

BDLS Logical System Name Conversion in sap

BDLS Logical System Name Conversion    BDLS is used for LOGICAL System Name conversion after System Refresh activity.When we refresh our quality system (QAS) from Production system (PRD) then in Quality system production system entries come in database that need to changed with Quality system’s entry in order to Quality system work properly . BDLS conversion is mandatory step in Post System Refresh Steps ,In BDLS Conversion ,Production Logical System Name is changed to Quality Logical System Name. Example: If we are doing refresh from PRD Client 300 to QAS Client 300 then we need to run BDLS for PRDCLNT300 ……

How to Prepare SAP SYSTEM for Daylight Saving Time Change

On Sunday 2016, November 6th  at 2:00 AM Local time (where servers reside, here its ET), annual Time Change to daylight savings will take place. Daylight Saving Time Details: Year DST Start (Clock Forward) DST End (Clock Backward) 2015 Sunday, March 8, 2:00 AM Sunday, November 1, 2:00 AM 2016 Sunday, March 13, 2:00 AM Sunday, November 6, 2:00 AM 2017 Sunday, March 12, 2:00 AM Sunday, November 5, 2:00 AM During this time of one hour “Fall Back” on the clock, as is our Basis team best practice (SAP Note #7417, #102088 and others) we intend to gracefully shut ……

SE06 System Change Option

SE06 System Change Option SE06 is used for 2 purpose: 1>SE06 post installation actions for transport Organizer,It has been already explained in my separate article Please Read:  SE06 Post Installation TMS Configuration 2> Another important use of SE06 is for System change option: SE06 is used to modify the system objects across the Client ,Setting from SE06 will be applicable to all the client while setting from SCC4 is limited to particular client where we made changes in SCC4 When SE06 System change system option is required over SCC4  I have explained earlier : How to Open Client to change client specific ……

How to Open Client in Sap

How to Open Client in Sap Many time we receive request from functional team to Open Client in Sap. Why to Open Client in SAP: There are many objects which can’t be modified without Open Client So this request comes from Development team. How to Open Client in SAP : Transaction SCC4: Go to Transaction SCC4 and make the changes as per below screen and Save it.