SAP Tutorials

I work in a company using SAP as its ERP application. As a SAP Basis Administrator (person handle on SAP Basis module), I don’t have lots of knowledge about it. But I just wanna try to share some overview about what Basis is in SAP.

Knowledge about Operating System (further known as OS) and Database is a must if we wanna be a Basis Administrator (further known as ‘Basis’ only).
A much knowledge about hardware (server, PCs, storage, tape, etc) is also needed to strengthen the above knowledge.

Knowledge about hardware is usually related with OS knowledge:
- hardware sizing –> decision to choose server type, capacity, speed, power, etc
- hardware landscape –> knowledge about system development, QA and production
- hardware monitoring, performance –> monitor the CPU and memory consumption
- hardware clustering –> server clustering, storage clustering, SAN, etc
- backup & recovery strategy–> manage the usage of tape / disk as backup destination

Knowledge about OS is like:
- maintain file system (UNIX) or drive (windows)
- basic command in OS, such as dir, copy (windows) or ls, cp (unix)
- schedule cron job (unix), schedule on windows

Here’s some of SAP tutorials i’ve been collected. If you interested, just mail me or leave your comment here for requesting.

1. Homogeneous and Heterogeneous System Copy for SAP Systems based on WebAS Java 640 SR1
2. SAP Enterprise Portal SSL Configuration
3. SAPGUI 710 Installation Server
4. SAP Solution Manager Overview
5. SAP Solution Manager 4 Installation
   
6. Setting SAP Library
7. SAP R/3 Handbook published by McGraw Hill
8. IDES mySAP ERP 2005 Installation
9. J2EE Start-Up Issues
10. Data Management Guide
11. How to configure mail connection using SMTP
12. How to configure SMS connection using HTTP
13. How to configure UDC to JDBC
14. How to fine tune Enterprise Portal 6
15. Memory management
16. Activating EWA on Solution Manager 7
    

…..
will be updated soon.

For SALE: SONY Handycam DCR-HC38E (bought on May 2007)

Asking price: Rp 2.500.000,- (negotiable)
Contact person: ASFAN (08179925414)
Detailed link: http://www.sony.co.id/product/dcr-hc38e/sku/dcr-hc38e%2B%2B%2Be35?site=hp_en_ID_i
Brochure link: http://www.sony.co.id/product/resources/en_ID/images/Brochure/Camcorder/MiniDV_Handycam_Brochure.pdf

Features:

• 40x (Optical) 80/2000x (Digital) Zoom
• Carl Zeiss Vario-Tessar Lens
• 1/6″ (3mm) CCD with Advanced HAD Technology
• 2.5″ Touch Panel LCD Screen
• InfoLITHIUM™ Battery System
• Battery Info Display
• Easy Handycam® Button
• Display Guide
• Start/Stop/Zoom Button on LCD Frame
• Spot Focus and Spot Metering
• NightShot Plus Infrared System
• Super SteadyShot Stabilization System
• i.LINK DV Interface
• USB Streaming
• Picture Motion Browser Software

Specifications:

• Recording Format = DV
• Video Codec = DV
• Media Storage Type = MiniDV
• Image Sensor Type = 1/6″ 800K (PAL) / 680K (NTSC) Advanced HAD CCD
• Audio Format = Dolby Digital Stereo (2ch.)
• Carl Zeiss Lens / Filter Diameter = Vario-Tessar / 30mm
• Optical / Digital Zoom = 40x / 2000x
• Image Stabiliser = Super SteadyShot (Electronic)
• LCD Screen Size & Type = 2.5″ Wide (4:3) LCD Screen with Touch Panel
• Record Start / Stop & Zoom Buttons on LCD Frame = Yes
• NightShot Mode = NightShot Plus
• USB Terminal = Yes
• i.LINK = Yes
• Multi AV Out = Yes
• Dimensions (W x H x D) = 63 x 85 x 114mm
• Mass (w/o Tape, Battery, etc.) = Approx. 390g

Bonus:

• Handycam Bag

testing embedded mp3

IDES MySAP ERP 2005 Installation

Hi all,

I’ve just finished my IDES installation.
I installed the IDES of MySAP ERP 2005 (ERP 6.0) in this technical spec:
Server : HP ProLiant DL580 G2
CPU : 8 x 2794 MHz clock speed
Physical RAM : 8 GB
OS : Windows Server 2003 Enterprise Edition SP2
Database : Oracle 10.2.0.2
Disk size : around 1.2 TeraByte divided into 10 disk drive but only 300 GB required.

Should you need the step-by-step of the installation, just leave your email address here in the comment. I will send you the document.

“BR0989W Unknown tablespace” dbcheck warning in DB13

Actually, I met this problem few years ago. I face this problem again right now after I did the SAP IDES ERP 2005 fresh installation. When I run action “Check database” in transaction DB13, I found below warnings:

It looks like the SAP system does not recognize the mentioned tablespace.

I found many solutions on this warning.

Solution 1: Update the mentioned table, SAPSR3.TAORA and IAORA, from database level

Just connect to the database using user <sid>adm.

sqlplus /nologSQL> connect /as sysdba

Change the mentioned tablespace (PSAPES30BD, PSAPEL30BD, etc) with the standard-known tablespace, such as PSAPSR3 (it depends on the SAP version).

I use IDES of ERP 2005. So the standard-known tablespace is currently PSAPSR3.

SQL> update SAPSR3.TAORA set TABSPACE=’PSAPSR3’ where TABSPACE=’PSAPES30BD’;SQL> update SAPSR3.TAORA set TABSPACE=’PSAPSR3’ where TABSPACE=’PSAPEL30BD’;

Do also on table IAORA.

Solution 2: Update the mentioned table, SAPSR3.TAORA and IAORA, from ABAP

Solution 1 above is quite technically easy to do. But that is not something RECOMMENDED by SAP.

There’s probability to have inconsistencies between database and ABAP side.

So, I recommend updating those 2 tables from ABAP side, which can be done via transaction SE16.

Make sure we have authorization to do that.

Just go to transaction SE16 and fill the table TAORA.

Click the “Table Contents” and execute.

Select the related entry, i.e. TABART=USER2 and TABSPACE=PSAPES30BD.

Click “Change”.

Change the field TABSPACE with PSAPSR3 (depends on the SAP version).

Click “Save” and go back.

Do the above step for other tablespace and for table IAORA.