Home » Posts tagged 'TCODE'
Tag Archives: TCODE
SAP ERP are 3-tiered application. SAP software consist of Database Server, Application Server, and Client program. Database server hold all data and information from user, company data, transaction data, log, etc. Application program responsible to process all client request and route to database server to request data, and then process data presentation before send them to client program. SAP client program which is installed on user PC is named as SAPGUI. Also called SAPLogon.
SAP has provide 3 type of SAPGUI which are :
- SAPGUI for Windows – SAPGUI for Windows is SAPGUI which is installed on Microsoft Windows. According to SAP, this is the best SAPGUI to access all SAP ERP function and tcode. SAP Developer (also called ABAP-er) use this SAPGUI to create all ABAP customer specific program. This SAPGUI can create ALV list, SMARTFORMS, SMARTSTYLES, ABAP OBJECT, etc. The latest SAPGUI for WIndows version 7.10. From my previous post, SAP have already removed this stuff from FTP server so if you want to get it, you need SAP Service Marketplace user ID to download or orde the DVD.
- SAPGUI for Java – SAPGUI for Java are another SAPGUI program. SAP provide SAPGUI for Java for several operating system including Microsoft Windows, Linux, Mac, IBM AIX, HP HP-UX, and SUN Solaris. Prerequirement for this software are your system need to be installed with SUN Java (minimumly version 1.5.0). SAPGUI for Java also have some limitation compared with SAPGUI for Windows. You cannot create SMARTFORMS, SMARTSTYLES using this SAPGUI. You also cannot use Office-integration feature. The latest SAPGUI for Java version are 7.10 rev 6. You still can download this SAPGUI from FTP server (using anonymous access).
- SAPGUI for HTML – This is the last type SAPGUI for HTML. It’s the only one that doesn’t need to be installed because almost every operating system has web browser. The latest mySAP ERP only need to be config so it can be accessed via web.
Ok, that’s all for now. Next time, I’ll explain the detailed about each SAPGUI.
Some friends ask me how to get information about support package level on their current SAP R/3 server. Actually it is very simple. Just follow this next step :
Type SPAM on your SAPGUI command screen.
You this SPAM screen. SPAM program also has its level. You can see it on the top of it. My current SPAM version is 6.20 level 26.
To check other support package level, just press Package level button.
On the left side, you see support package component such as SAP_BASIS (SAP Basis Component), SAP_ABA (Cross Application Component), SAP_APPL (Logistics and Accounting), SAP_HR (Human Resources), etc.
For level package, just check level component. For example, SAP_BASIS has its level 64.
OK, that’s all you need to know about you current support package level. On the next tutorial, I’ll guide you about how to increase your support package level.
By default, SAP R3 4.7 has 6 tablespace. You can check them using tcode DB02. I already show you how to extend tablespace that already exist.
Now I want to show step by step adding new tablespace. I am going to use BRTOOLS, to add new tablespace. Open your MS-DOS prompt using user [sid]adm. Use ora[sid] user for your UNIX box.
To add new tablespace, choose option number 2 Space Management. Then ENTER.
Choose option number 2 to Create Tablespace. Then ENTER.
Enter option number 3 to propose tablespace name. Tablespace name must have prefix PSAPIDS (for my IDES box). Depend on your box. Here, I named it PSAPIDS_REORG (Coz I want to use it later for reorganization purpose).
After that, enter C then ENTER.
Tablespace creation is going to execute. You do not net to shutdown your SAP R3 nor Oracle DB to do this. You can do this online.
Additional information you need to supply such as datafile size, increment size, etc. Then type c to continue.
Tablespace creation is running. Wait for couple minutes.
Tablespace PSAPIDS_REORG has been created successfully. Type C to continue.
Back to Space Management menu. Next step, check the result using DB02 tcode.
You can see that tablespace PSAPIDS_REORG has been added in tablespace list.
Congratulations ! Now, you can continue your coffee break time :D…
I am glad that a lot of Basis visiting my blog, asking me about Basis activity, tips, etc. Based on comments and email about how to extend SAP R/3 tablespace, I try to post this little notes. On this little tutorial, I am using Windows based SAP R/3 and Oracle 9.2. You can do it on UNIX based. Of course using different user. When you using UNIX based R/3 system, you have to use ora[sid] user.
Login to your SAP R/3 DB instance Windows using [sid]adm user. Open your command prompt.
Type BRTOOLS to enter BRTOOLS menu.
Choose menu number 2 by typing 2 and then ENTER.
There are many menus on SPACE Management including Extend tablespace, Create tablespace, etc.
Type 1 to Extend tablespace. To get information about tablespace list, you can use DB02 on your SAPGUI screen. For this tutorial, I want to extend PSAPIDS tablespace.
Type c to continue this step.
On this screen, you can see information about last added tablespace including datafile size, datafile name, etc. I use default (datafile size about 2470 MB). Type C to continue.
If you want to add more datafile, you can specified now by typing y. Right now, I just want to add 1 datafile so I type c.
Extending tablespace process is running.
Tablespace PSAPIDS has been extended successfully. Type c to continue.
Back to BRTOOLS menus. Type 9 and ENTER to exit BRTOOLS program.
To check your new datafile has been added to your tablespace you can use DB02 and then press REFRESH button.
Now, you can extend your tablespace easily and have a nice day.
NB : You don’t need to shutdown your SAP R/3 system or Oracle DB to extend tablespace. You can do this online while your SAP R/3 system and Oracle DB running.
SAP had released the latest SAPGUI for Java. It has 7.10 version. As this 2007, SAPGUI for Java had been improved. Currently, SAPGUI for Java 7.10 had significant update including input history capability had been integrated.
For most SAP End User, this feature (Input History) was very helpful since it’s only available on SAPGUI for Windows. I had been try and test it on my several SAP end user and they said “its awesome”, “very helpful”, etc.
For me as SAP Basis, it’s time for SAP to accelerate this SAPGUI development and improvement because of its multiplatform. Almost all OS user could use it from Windows, Linux, Solaris, AIX, HP-UX, and Mac OS X.
Another SAPGUI for Java feature that had been amazed me is its capability to use frontend printing. Not “F” type as you thought, but “G” access method. If you’re SAP using Basis release 620, just check your SPAM level using SPAM tcode. If you had minimumly on level 52, then you could use this access method (“G”).
Also, i had just mentioned about my new SAPGUI for Java on Linux deployment. I used to deploy SAPGUI for Java on Linux manually. But starting now, I am using remotely and silently method. Its very simple and helpful for such “lazy Basis” like me :D.
Prepare your SAPGUI for Java installer on remote machine. Then, create a simple responfile like this sample on the same directory as your SAPGUI for Java installer :
# Example of a typical installation response file # suppress user interaction disableui=true # install to the default path installpath=default # reinstall gui if already present reinstall=true
And you just type this command on your console :
#java -jar PlatinGUI-Linux-710.jar -i[name_of_your_responfile]
Its very simple, isn’t it ? Happy deploying !! Let me know if you have question.
BRTOOLS is a database tool developed by SAP to help SAP Basis manage his Oracle based SAP R/3 database. In the last tutorial, I had shown you how to check your database through DB13 tcode. DB13 is database independent tcode to manage your database whether you’re using MS SQL, Oracle, DB2, or SAPDB.
Here, I am going to demonstrate how to use BRTOOLS to check your Oracle 9i database. You need to logon to your SAP R/3 server using ORA[SID] user.
Type BRTOOLS on your console and then you’ll have this screen. For your information, I’am using UNIX OS. It might be different when you’re using Windows OS.
Choose number 6 option by typing 6 and then press ENTER.
To check your database choose number 1 option and then press ENTER.
In this screen, you might need to input some information about your database such as your SAP Database profile, your database user and password, database owner, and something you might not want to be checked. For this moment, I am using default properties and press ENTER.
This screen show you BRTOOLS confirmation. Just type C and then press ENTER to proceed to the next step.
Press ENTER to proceed.
Now, you’ll see that database check process is running. Wait until it finished.
Type S to stop and exit from BRTOOLS menu. Now you had learn how to check your SAP R/3 database by using DB13 tcode and BRTOOLS command. In the next tutorial, I’ll show you another tips and trick that might be useful and helpful. Stay there and always connected.
Critics and suggestion are welcomed. Please feel free to contact me on firstname.lastname@example.org.
Most Basis jobs are related with database server. Whether you’re using Microsoft SQL server from Microsoft, Oracle Database from Oracle, DB2 Universal Database from IBM or SAPDB from MySQL AB, all your job are facing with them closely.
SAP are design its database very complex and beatiful. SAP also develop database tools to accompany you as Basis in order free you from complicated and frustated database specific related jobs such as rebuilding index, checking tablespace, checking whole database, updating your database statistic, monitoring your database growth, etc.
I just going to explain about BRTOOLS for Oracle because I only have Oracle database right now. BRTOOLS has numerous tools inside it.
To check your Oracle database, you can go to your SAP screen. Go to DB13 tcode.
Double click on current date.
Choose Check Database.
If you want to run check database command now, just choose Start Immedietly. But if you wan to run it later, just schedule it on appropriate time.
Happy checking your database. Send your suggestion to me on email@example.com.