BASIS lesson 6

SYSTEM ADMINISTRATION

/nsm01 LOCK/UNLOCK tcode
/nsm02 SYSTEM MESSAGES to announce to all users
/nsm04 USER LIST (active)
/nsm13 UPDATE REQUEST
/nsm14 UPDATE PROGRAM ADMINISTRATION
/nsm21 SYSTEM LOG
/nsm28 SAP INITIAL CONSISTENCY CHECK (after the first installation, update)
/nsm35 BATCH INPUT : SESSION OVERVIEW (check upload activities)
/nsm36 DEFINE BACKGROUND JOB to run a scheduled ABAP program.
Important button [Start Condition] and [Step]
/nsm37 SIMPLE JOB SELECTION to see all background job, including DBA maintenance
/nsm49 EXTERNAL OPERATING SYSTEM COMMANDS
/nsm50 PROCESS OVERVIEW

BASIS lesson 5

How to maintain the database ?

/ndb02 Database Management (beware, it takes a lot of time)
in my system which uses ORACLE, contains more than 40.000 tables with the size of more than 38 GB.

on Tab "Tables and indexes", press the button [Detailed analysis], Then continue to see a sample table LFA1 (Vendor Master) with the total size 750 kB.
on Tab "Tables and indexes", press the button [Space Statistics] to see the growth in month, day, year basis.

/ndb13 Database Administrator (DBA) Planning Calendar for Oracle Database to plan backup and archieve

DATABASE LOG

/ndb12 DATABASE BACKUP LOG

/ndb14 DISPLAY DBA OPERATIONS LOG (give options)

/ndb24 LOGS FOR ADMINISTRATIVE DATABASE OPERATIONS (show all)

DATABASE CHECK

/ndb16 DATABASE CHECK, display warnings and errors when you run /ndb13

/ndb17 ALL DATABASE CHECK CONDITIONS

PARAMETERS CHANGE

/ndb03 PARAMETERS CHANGES IN DATABASE

/ndb26 ALL DATABASE PROFILE PARAMETERS

BASIS lesson 4

How to turn off a process that run endlessly and make the system slow ?
/nsm50 PROCESS OVERVIEW
goto menu [Process] and [Cancel with core] to cancel all related process or [Cancel without core] to cancel only the process

BASIS lesson 3

How to find which clients in the system ?
/nse11 ABAP Dictionary, and display table T000
Find field 'ccategory' and display the contents by pressing Ctrl-Shift-F10.
Find the corresponding clients that you want to use for practice.
Please note : clients 000 is system default, contains no data.

BASIS lesson 2

How to create and display user's Logon data and reset password ?
/nsu01 User maintenance

BASIS lesson 1

How to know who are login to the SAP and which TCode he is using ?
/nse37 and Run Function TH_DISPLAY_USER_LIST

SAP Netweaver

Do you want to practice your ABAP ? Follow the basic lessons of ABAP in this blog and practice it using SAP Netweaver. You may download the official Netweaver from this this address https://www.sdn.sap.com/irj/scn/nw-downloads
Try the LINUX platform of SAP Netweaver. It will give you more nuances on different OS platform though the functionalities is the same compared to Windows platform.

MM - Purchasing Master Table

Understanding table relations is essential, especially when you use ABAP for updating tables. You need to familiarize yourself with the table names too. For example, in SAP MM Purchasing, the basic master tables are MAKT (Material Description), MARA (Material Master), and MARM (Units of Measure). The relations between tables explain the dependancies of tables in the same module (in MM only) and across different modules (with FI for example). So, happy exploring the tables !

LSMW vs RFC

LSWM (Legation Systems Migration Workbench) is an activity to read external data and save it in SAP systems while RFC (Remote Function Call) is an activity to read SAP data by external non-SAP system and save it in external non-SAP system.