Many times in SAP, you may come across situations where in the users wants to have a separate transaction codes for some of the tables which can be easily maintained or displayed in SM30. There are many reason why someone would need like this? reasons may be to have a easy to remember transaction code then to remember the lengthy and complicated table name and so on.. so how do we achieve this.

Go to SE93 – Click on create and then select either Transaction with Variant or Transaction with parameters.

I-choose transaction with parameters and now enter in the transaction  ‘SM30′, and in the end you will see a small table control, click on the first line in “Name on Screen Field” and press F4  and select “viewname” and in the corresponding field value enter the table name and now go to the second line and press F4 again and select either show/update (depends either you want to display or maintain it) and now in the corresponding field value enter ‘X’ then save. Refer the screenshot below if you are lost. Continue Reading …

Login to your Transport Domain Controller.
Run STMS –> Overview –> System
Choose the system you want to disable “Import All” button. Goto transport tool tab. Add/Create Parameter “NO_IMPORT_ALL” set it’s value to 1.

Easy way to Get SAP transactions?

Want to have the list of SAP transactions handy? Well you don’t have you download SAP transactions from any website.  The SAP table TSTC itself contains the list of all the SAP Transactions.

So anytime you forget a SAP transaction, just go to the table TSTC and you can get the entire list of sap transactions or how about using the SEARCH_SAP_MENU? even that also helps you to find any SAP transaction easily.

Remeber, we discussed about a simple hack on how we can change the database table directly.  Do you want to track the guy who did the changes in these tables directly? Like CDHDR and CDPOS which holds the table entry changes, there is a similar table to track SE16N changes also.

Refer these tables to track the changes:
SE16N_CD_KEY – Table Display: Change Documents – Header
SE16N_CD_DATA – Table Display: Change Documents – Data

Copyright: SAP Database

Well, I know we have already talked about finding user exits in the program and also we have a program to find out the user exits in a given Program/Transaction. But, how many times have you searched in SPRO for the user exits. Just go to SPRO –> SAP Reference IMG –> Find (user exits). You will be amazed with the list of other places containing user exits.