Hi All,
Some-times we need to send a specific message to specific user in SAP which is not possible by using SM02..SO here is the trick to do it :
Use function module TH_POPUP
goto Transaction code SE37 enter the function module name & test run it
the the resulting screen is shown below, type the details and execute.
The user must be logged into the system to receive the message
Enjoy!!
Regards,
Gagan Deep Kaushal
Friday, January 23, 2009
How to Lock or Unlock a Client in SAP ?
Hi All,
Here i am writing the procedure to lock amd unlock a client in SAP,very rarely we need to use it..But stil u should know so follow these simple steps...
1) To lock or unlock a client in R/3 System, run the following function modules in
transaction se37
2. SSCR_LOCK_CLIENT ( to lock the client)
3. SSCR_UNLOCK_CLIENT (to unlock the client)
Run these functions with a client input which is to be locked/unlocked. This function set flag '' Client is locked temporarily for client copy" in client maintenance menu.The client will be available for users DDIC and SAP*. If any other user tries to login, system gives message that ' Client locked temporarily'.
To unlock the client
1. Run transaction SE37
2. Enter the function module as SSCR_UNLOCK_CLIENT
3. press F8 or test run (single run).
4. Specify the client and execute(F8).
Follow similar procedure for locking the client...
Enjoy ........
Regards,
Gagan Deep Kaushal
Here i am writing the procedure to lock amd unlock a client in SAP,very rarely we need to use it..But stil u should know so follow these simple steps...
1) To lock or unlock a client in R/3 System, run the following function modules in
transaction se37
2. SSCR_LOCK_CLIENT ( to lock the client)
3. SSCR_UNLOCK_CLIENT (to unlock the client)
Run these functions with a client input which is to be locked/unlocked. This function set flag '' Client is locked temporarily for client copy" in client maintenance menu.The client will be available for users DDIC and SAP*. If any other user tries to login, system gives message that ' Client locked temporarily'.
To unlock the client
1. Run transaction SE37
2. Enter the function module as SSCR_UNLOCK_CLIENT
3. press F8 or test run (single run).
4. Specify the client and execute(F8).
Follow similar procedure for locking the client...
Enjoy ........
Regards,
Gagan Deep Kaushal
How to Reset Buffers in Sap ?
Hi Friends,
Some-time its needed to reset some buffers in SAP For performance issues So here iam sharing the differnt buffer cleanup T-codes.
But Keep n mind Resetting of the buffers could change the performance of the entire system
/$DYNP - reset the screen buffer of the application server
/$SYNC - resets the buffers of the application server
/$CUA - resets the CUA buffer of the application server
/$TAB - resets the TABLE buffers of the application server
/$NAM - the nametab buffer of the application server
Regards,
Gagan Deep Kaushal
Some-time its needed to reset some buffers in SAP For performance issues So here iam sharing the differnt buffer cleanup T-codes.
But Keep n mind Resetting of the buffers could change the performance of the entire system
/$DYNP - reset the screen buffer of the application server
/$SYNC - resets the buffers of the application server
/$CUA - resets the CUA buffer of the application server
/$TAB - resets the TABLE buffers of the application server
/$NAM - the nametab buffer of the application server
Regards,
Gagan Deep Kaushal
How to find sap transaction codes
Hi All,
How to find SAP t-code incase you are not sure exactly about t-code
How to find sap transaction codes :
1) Goto transction search_sap_menu enter the context or the purpose of the t-code
like "User maintenance"
2) Second option in T-code SE93
Regards,
Gagan Deep Kaushal
How to find SAP t-code incase you are not sure exactly about t-code
How to find sap transaction codes :
1) Goto transction search_sap_menu enter the context or the purpose of the t-code
like "User maintenance"
2) Second option in T-code SE93
Regards,
Gagan Deep Kaushal
Difference Between SAP_ALL and SAP_NEW
Hi Friends,
Most of the times you might have question in your mind that why you give sap_all and sap_new everytime we create admin user (Altough some people used to give sap_all to every one ).So here i am sharing my knowledge about differnce between these 2 :
SAP_NEW:-
SAP_NEW is a SAP standard Profile which is usually assigned to system users temporarily during an upgrade to ensure that the activities and operations of SAP users is not hindered, during the Upgrade. It contains all the necessary objects and transactions for the users to continue their work during the upgrade. It should be withdrawn once all upgrade activities is completed, and replaced with the now modified Roles as it has extensive authorizations than required.
SAP_ALL:-
SAP_ALL is a SAP standard profile, which is used on need basis, to resolve particular issues which may arise during the usage of SAP. It is used by Administrators/Developers only and is applied on a need to use basis, then withdrawn. It contains all SAP system objects and Transactions. SAP_ALL is very critical and only SAP* contains SAP_ALL attached to it in the production system. No other dialog users have SAP_ALL attached to them.
SAP_NEW is used in the Production environment during a version upgrade whereas SAP_ALL shouldn't be or not allowed be used in Production except where necessary, in a controlled manner with all proper approvals from the customer.
Regards,
Gagan Deep Kaushal
Most of the times you might have question in your mind that why you give sap_all and sap_new everytime we create admin user (Altough some people used to give sap_all to every one ).So here i am sharing my knowledge about differnce between these 2 :
SAP_NEW:-
SAP_NEW is a SAP standard Profile which is usually assigned to system users temporarily during an upgrade to ensure that the activities and operations of SAP users is not hindered, during the Upgrade. It contains all the necessary objects and transactions for the users to continue their work during the upgrade. It should be withdrawn once all upgrade activities is completed, and replaced with the now modified Roles as it has extensive authorizations than required.
SAP_ALL:-
SAP_ALL is a SAP standard profile, which is used on need basis, to resolve particular issues which may arise during the usage of SAP. It is used by Administrators/Developers only and is applied on a need to use basis, then withdrawn. It contains all SAP system objects and Transactions. SAP_ALL is very critical and only SAP* contains SAP_ALL attached to it in the production system. No other dialog users have SAP_ALL attached to them.
SAP_NEW is used in the Production environment during a version upgrade whereas SAP_ALL shouldn't be or not allowed be used in Production except where necessary, in a controlled manner with all proper approvals from the customer.
Regards,
Gagan Deep Kaushal
How to List All the T-codes For a Role in SAP ?
Hi All,
Here I am sharing the procedure more-over its a trick to get all the t-codes from a Role.
To find all tcode for role along with the tcode that are present in the tcd field.. goto se16 enter agr_1251 and click on data browser button
enter the role name in agr_name field and enter tcd in FIELD field
Then click on execute button or press F8 to execute and you will see the list of tcodes for that role
Regards,
Gagan Deep Kaushal
Here I am sharing the procedure more-over its a trick to get all the t-codes from a Role.
To find all tcode for role along with the tcode that are present in the tcd field.. goto se16 enter agr_1251 and click on data browser button
enter the role name in agr_name field and enter tcd in FIELD field
Then click on execute button or press F8 to execute and you will see the list of tcodes for that role
Regards,
Gagan Deep Kaushal
Sunday, January 18, 2009
Oracle Expertize
HI All,
Here i am sharing the steps i follow to patchset Oracle from 10.2.0.2 to 10.2.0.4 and activate Oracle enterprise manager
1) Activate OEM in SAP
emca -config dbcontrol db -repos create
Then Provide info as it ask
emctl start dbconsole
then point your browser at http://Srevr_name:5500/em
Note :386413 enterprise manager configuration oracle
592393 - FAQ: Oracle
355770 - Oracle Enterprise Manager Database Control
105047 - Support for Oracle functions in the SAP environmt
2) Note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0
Note 839187 - Oracle Database 10g: Patch set installation
Note 509314 - Downloading Oracle patches from SAP Service Marketplace
Note 839182 - Oracle database 10g: OPatch
Note 1137346 - Oracle Database 10g: Patches for Release 10.2.0.4
3) Download Patchset From Service Market Place
509314 - Downloading Oracle patches from SAP Service Marketplace====IMP
Sap Provide Patch in .bin format (Here i waste My full Day)
To get the original zip-file back, use the following commmands for:
UNIX cataa.bin ab.bin ... >> .zip
Windows copyaa.bin /B + ab.bin /B + ... .zip
4) Now run runinstaller for Patchset before that shutdown DB and all services
5) Post Upgrade Steps:Database upgrade from Release 10.2.0.2 -> 10.2.0.4
When you upgrade a database from Oracle Release 10.2.0.2 to 10.2.0.4, you need to adapt the Oracle Dictionary to the new Oracle version during postprocessing. In this case, catupgrd.sql must run in accordance with the defaults described in the patch set documentation.
dbua -silent -dbname $ORACLE_SID -oracleHome $ORACLE_HOME -sysDBAUserName sys -sysDBAPassword bandhan6 -recompile_invalid_objects true
@/oracle/SID/102_64/rdbms/admin/catupgrd.sql
@/oracle/SID/102_64/rdbms/admin/utlrp.sql
emca -upgrade db
@/oracle/SRP/102_64/rdbms/admin/catupgrd.sql
6) Apply Opatch :Displaying the OPatch version
% opatch version
Displaying the online help
% opatch -help
Displaying the online help for a certain command
% opatch -help
= apply, rollback, lsinventory, util
Displaying the Oracle inventory (see below)
% opatch lsinventory [-all][-detail]
Installing a patch (see below)
% opatch apply
Uninstalling a patch (see below)
% opatch rollback -id
That's All but you can face different problems while following this so ping me AnyTime:
Regards,
Gagan Deep Kaushal
Here i am sharing the steps i follow to patchset Oracle from 10.2.0.2 to 10.2.0.4 and activate Oracle enterprise manager
1) Activate OEM in SAP
emca -config dbcontrol db -repos create
Then Provide info as it ask
emctl start dbconsole
then point your browser at http://Srevr_name:5500/em
Note :386413 enterprise manager configuration oracle
592393 - FAQ: Oracle
355770 - Oracle Enterprise Manager Database Control
105047 - Support for Oracle functions in the SAP environmt
2) Note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0
Note 839187 - Oracle Database 10g: Patch set installation
Note 509314 - Downloading Oracle patches from SAP Service Marketplace
Note 839182 - Oracle database 10g: OPatch
Note 1137346 - Oracle Database 10g: Patches for Release 10.2.0.4
3) Download Patchset From Service Market Place
509314 - Downloading Oracle patches from SAP Service Marketplace====IMP
Sap Provide Patch in .bin format (Here i waste My full Day)
To get the original zip-file back, use the following commmands for:
UNIX cat
Windows copy
4) Now run runinstaller for Patchset before that shutdown DB and all services
5) Post Upgrade Steps:Database upgrade from Release 10.2.0.2 -> 10.2.0.4
When you upgrade a database from Oracle Release 10.2.0.2 to 10.2.0.4, you need to adapt the Oracle Dictionary to the new Oracle version during postprocessing. In this case, catupgrd.sql must run in accordance with the defaults described in the patch set documentation.
dbua -silent -dbname $ORACLE_SID -oracleHome $ORACLE_HOME -sysDBAUserName sys -sysDBAPassword bandhan6 -recompile_invalid_objects true
@/oracle/SID/102_64/rdbms/admin/catupgrd.sql
@/oracle/SID/102_64/rdbms/admin/utlrp.sql
emca -upgrade db
@/oracle/SRP/102_64/rdbms/admin/catupgrd.sql
6) Apply Opatch :Displaying the OPatch version
% opatch version
Displaying the online help
% opatch -help
Displaying the online help for a certain command
% opatch
Displaying the Oracle inventory (see below)
% opatch lsinventory [-all][-detail]
Installing a patch (see below)
% opatch apply
Uninstalling a patch (see below)
% opatch rollback -id
That's All but you can face different problems while following this so ping me AnyTime:
Regards,
Gagan Deep Kaushal
Subscribe to:
Posts (Atom)
