What are the different transaction codes related to client operations in SAP ?

What are the different transaction codes related to client operations in SAP ?

SCC4 : It is used to list all the clients that are present in the SAP system. This also includes details like :
Last changed date of the client
Last changed by
Logical system name associated with the client
Client role

Using this transaction, a new client details can be maintained as below :

i)   Press change icon to be in change mode
ii)  Click on “new entries” push button to create new client details

All the client details that are available in SCC4 are present in the T000 table in the backend.


SCC5  :  This transaction is used to delete a client from an SAP system

SCCL  : This transaction is used to perform local client copy in  SAP system

SCC9  : This transaction is used to perform remote client copy in SAP system

SCC3  : This transaction is used to monitor client copy progress

SCC8   : This transaction is used for client export

SCC7   : This transaction is used to perform client import post processing  activities

Important Tables With Description

Important Tables With Description

User Administration Related Tables

USR01 User master
USR02 Logon data
USR03 User address data
USR04 User master authorizations
USR05    Parametes assigned to users; These values you can see in parameters tab in su01
USRSTAMP Last modification time to user. Eg. profile assignment, password change etc.
USR11 User Master Texts for Profiles (USR10)
UST12 User master: Authorizations
USR12 User master authorization values
USR13 Short Texts for Authorizations
USR40 Prohibited passwords
TOBJ Objects
TOBC Authorization Object Classes
TPRPROF Profile Name for Activity Group
DEVACCESS Table for development user
UST04 User profiles (multiple rows per user)
USR10 Authorisation profiles (i.e. &_SAP_ALL)
UST10C Composite profiles (i.e. profile has sub profile)
USR11 Text for authorisation profiles
USR40 Table for illegal passwords
USGRP User groups
USGRPT Text table for USGRP
USH02 Change history for logon data
USER_ADDR Address Data for users

SAP Security

AGR1251         Authorization data for the activity group
AGR1252         Organizational elements for authorizations ( this table gives only organizational data)
AGR_DEFINE    Role definition
AGR_USERS    Rolese assigned to users
AGR_AGRS     Roles in Composite Roles
TOBJ                Authorization Objects
TDDAT              Maintenance Areas for Tables
TSTC                SAP Transaction Codes
TPGP               ABAP/4 Authorization Groups
USOBT            Relation transaction > authorization object
USOBX            Check table for table USOBT
USOBT_C         Relation Transaction   > Auth. Object (Customer)
USOBX_C        Check Table for Table USOBT_C

Transport Management System

E070 Give Request number, status, target client and Desrcription
E071    Request ID and Object Name
E070A  Idenity TR based as per sap note
E070USE Use of Current requests by Users
E070DEP Dependencies of requests
E070CREATE Change & transport System & creation date
E070TC  Client-Specific Imports
v_e071  Generated Table for View. Addresses
E070    Stores transport headers
E071    The names of the objects of a transport request is stored in table.
E070C   stores information for client specific tarnsports

Client Administration

T000        Logical System description. Gives details from TCode SCC4.

Spool Administration

TST01           TemSe: List of objects and parts
TST02           TemSe: Protection rules
TST03           TemSe data

System Component Version

UVERS          Deployed component version
CVERS           Detailed deployed component version
SVERS           Kernel Release Number

Other Useful Tables

SMEN_BUFFC         To know end users favorite list of transaction codes

Change documents
CDHDR Change Document Header
CDPOS Change document positioned
JCDS Change Documents for System/User Statuses (Table JEST)

Reporting tree table

SERPTREE Reporting: tree structure LIS structure/control tables
TMC4 Global Control Elements: LIS Info Structure

Data dictionary tables

DD02L Tables in SAP
DD02T Tables description
DD03L Field names in SAP
DD03T Field description in SAP

Workbench

TADIR Directory of R/3 Repository Objects
TRDIR System table TRDIR
TFDIR Function Module
TLIBG Person responsible for function class
TLIBT Function Group Short Texts
TFTIT Function Module Short Text
TSTC Transaction codes in SAP
TSTCT Transaction Codes Texts
T100 Message text (vb e000)
VARID Variant data
D020T Screen texts
TDEVC Development class
TDEVCT Texts for development classes

Batch input queue

APQD Data Definition Queue
APQI Queue Info Definition

Job Processing

TBTCO Job status overview table
TBTCP Batch job step overview

A – Cancelled
F – Completed
P – Scheduled
R – Active
S – Released

Spool

TSP02 Spool: Print requests

Runtime errors

SNAP Runtime errors

Message control

TNAPR Processing Programs for Output
NAST Message status
NACH Printer determination

Change documents

CDHDR Change Document Header
CDPOS Change document positioned
JCDS Change Documents for System/User Statuses (Table JEST)

Reporting tree table

SERPTREE Reporting: tree structure

Important Tcodes In SAP

Important Tcodes In SAP

My General Tcodes:

AL01  SAP Alert Monitor
AL02  Database alert monitor
AL03  Operating system alert monitor
AL04  Monitor call distribution
AL05  Monitor current workload
AL06  Performance: Upload/Download
AL07  EarlyWatch Report
AL08  Users Logged On
AL09  Data for database expertise
AL10  Download to Early Watch
AL11  Display SAP Directories
AL12  Display table buffer (Exp. session)
AL13  Display Shared Memory (Expert mode)
AL15  Customize SAPOSCOL destination
AL16  Local Alert Monitor for Operat.Syst.
AL17  Remote Alert Monitor for Operat. Syst.
AL18  Local File System Monitor
AL19  Remote File System Monitor
AL20  EarlyWatch Data Collector List
AL21  ABAP Program analysis
AL22  Dependent objects display
CREF  Cross-reference
BSVW  Linkage Status Update-Workflow Event
CMOD  Enhancements
DB01  Analyze exclusive lock waits
DB02  Analyze tables and indexes
DB03  Parameter changes in database
DB11  Early Watch Profile Maintenance
DB12  Overview of Backup Logs
DB13  Database administration calendar
DB14  Show SAPDBA Action Logs
DB15  Data Archiving: Database Tables
DB16  DB System Check: Monitor
DB17  DB System Check: Configuration
DMIG  Start Transaction for Data Migration
DB2   Select Database Activities
DB20  DB Cost-Based Optimizer: Tab. Stats
DB21  DB Cost-Based Optimizer: Config.
DB24  Database Operations Monitor
DB26  DB Profile:Monitor and Configuration
DB2J  Manage JCL jobs for OS/390
DBCO  Database Connection Maintenance
FILE  Cross-Client File Names/Paths
NACE  WFMC: Initial Customizing Screen
OAA1  SAP ArchiveLink: Maint.user st.syst
OAA3  SAP ArchiveLink protocols
OAA4  SAP ArchiveLink applic.maintenance
OAAD  ArchiveLink Administration Documents
OAC2  SAP ArchiveLink: Globaldoc. types
OAC5  SAP ArchiveLink: Bar code entry
OACA  SAP ArchiveLink workflow parameters
OAD0  SAP ArchiveLink: Objectlinks
OAD2  SAP ArchiveLink document classes
OAD3  SAP ArchiveLink: Link tables
OAD4  SAP ArchiveLink: Bar code types
OAD5  SAP ArchiveLink: Customizing Wizard
OADR  SAP ArchiveLink: Print list search
OAM1  SAP ArchiveLink: Monitoring
OAOR  SAP ArchiveLink: Storeddocuments
OARE  SAP ArchiveLink:St.syst.return codes
OS01  LAN check with ping
OS03  O/S Parameter changes
OS04  Local System Configuration
OS05  Remote System Cconfiguration
OS06  Local Operating System Activity
OS07  Remote Operating SystemActivity
OSS1  Logon to Online ServiceSystem
OY18  Table history
OY08  Development Class Overview
PFCG  Activity Group
PFUD  Authorization Profile comparison
RLOG  Data migration logging
RZ01  Job Scheduling Monitor
RZ02  Network Graphics for SAP Instances
RZ03  Presentation, Control SAP Instances
RZ04  Maintain SAP Instances
RZ06  Alerts Thresholds Maintenance
RZ08  SAP Alert Monitor
RZ10  Maintenance of profile parameters
RZ11  Profile parameter maintenance
RZ12  Maintain RFC Server Group Assignment
RZ20  CCMS Monitoring
RZ21  Customize CCMS Alert Monitor
SA38  ABAP/4 Reporting
SAD0  Address Management call
SADC  Address: Maint. communication types
SALE  Display ALE Customizing
SAINT Plug-in Installation
SARI  Archive Information System
SAR3  Customizing Archiving
SAR4  Define Archiving Class
SAR5  Assign Archiving Class
SAR6  Archiving Time Generator
SARA  Archive management
SARL  Call of ArchiveLink Monitor
SARP  Reporting (Tree Structure): Execute
SART  Display Reporting Tree
SB01  Business Navigator – Component View
SB02  Business Navigator – Process flow vw
SBAS  Assignments to Process Model Elemts
SC38  Start Report Immediately
SCAT  Computer Aided Test Tool
SCC0  Client Copy
SCC1  Client Copy – Special Selections
SCC2  Client transport
SCC3  Client Copy Log
SCC4  Client administration
SCC5  Client Delete
SCC6  Client Import
SCC7  Client Import – Post Processing
SCC8  Client Export
SCC9  Remote Client Copy
SCCL  Local Client Copy
SCDO  Display Change DocumentObjects
SCMP  View / Table Comparison
SCOM  SAPcomm: Configuration
SCON  SAPconnect – Administration
SCPF  Generate enterprise IMG
SCPR1 Customizing Profiles : Maintenance Tool
SCPR2 Comparing Customizing profiles
SCUA  Central User Administration : Distribution Model Assigment
SCUG  Central User Administration Structure Display
SCUM  Central User Administration Field Selection
SCU0  Table Analyses And Comparison
SCU1  Table Comparison – Export to Tape
SCU2  Table Comparison Against Tape
SCU3  Table History
SD11  Data Modeler
SDBE  Explain an SQL Statement
SECR  Audit Information System
SE01  Transport and Correction System
SE02  Environment Analyzer
SE03  Transport Utilities
SE06  Set up Workbench Organizer
SE07  Transport System Status Display
SE09  Workbench Organizer (Initial Screen)
SE10  Customizing Organizer
SE11  Data Dictionary Maintenance
SE12  Data Dictionary Display
SE13  Maintain Technical Settings (Tables)
SE14  Convert Data Dictionary tables on Database Level
SE15  Repository Info System
SE16  Display Table Content
SE17  Generate Table Display
SE30  ABAP Objects Runtime Analysis
SE32  ABAP Text Element Maintenance
SE33  Context Builder
SE35  ABAP/4 Dialog Modules
SE36  Logical databases
SE37  ABAP Function Modules
SE38  ABAP Editor
SE39  Splitscreen Editor: Program Compare
SE40  MP: Standards Maint. and Translation
SE41  Menu Painter
SE43  Maintain Area Menu
SE51  Screen Painter
SE52  Parameterized screenpainter call
SE54  Generate table view
SE55  Internal table view maintenance call
SE56  internal call: display table view
SE57  internal delete table view call
SE61  R/3 Documentation
SE62  Industry Utilities
SE63  Translation: Initial Screen
SE71  SAPscript form
SE72  SAPscript Styles
SE73  SAPscript font maintenance (revised)
SE74  SAPscript format conversion
SE75  SAPscript Settings
SE76  SAPscript: Form Translation
SE77  SAPscript Translation Styles
SE78  SAPscript: Graphics administration
SE80  Object Navigator
SE81  Application Hierarchy
SE82  Application Hierarchy
SE84  R/3 Repository Information System
SE85  ABAP/4 Repository Information System
SE86  ABAP Repository Information System
SE88  Development Coordination Info System
SE89  Maintain Trees in Information System
SE91  Maintain Messages
SE92  New SysLog Msg Maintenance as of 46A
SE93  Maintain Transaction Codes
SE94  Customer enhancement simulation
SE95  Modification Browser
SEPS  SAP Electronic Parcel Service
SERP  Reporting: Change Tree Structure
SEU   Repository Browser
SF01  Client-Specific File Names
SFAW  Field Selection Maintenance
SIAC1 Web Object Administration
SHDB  Record Batch Input
SICK  Installation Check
SIN1  SAPBPT: Inbox
SINA  SAPBPT: Maintain Standard Config.
SLG0  Application Log: ObjectMaintenance
SLIN  ABAP: Extended Program Check
SM01  Lock Transactions
SM02  System Messages
SM04  User Overview
SM12  Display and Delete Locks
SM13  Display Update Records
SM14  Update Program Administration
SM21  System log
SM23  System Log Analysis
SM28  Installation Check
SM29  Model Transfer for Tables
SM30  Call Up View Maintenance
SM31  Table maintenance
SM31_OLD  Old Table Maintenance
SM32  Maintain Table Parameter ID TAB
SM33  Display Table ParameterID TAB
SM34  Viewcluster maintenancecall
SM35  Batch Input Monitoring
SM36  Batch request
SM37  Background job overview
SM38  Queue Maintenance Transaction
SM39  Job analysis
SM49  Execute Logical Commands
SM50  Work Process Overview
SM51  List of SAP Servers
SM54  TXCOM maintenance
SM55  THOST maintenance
SM56  Number Range Buffer
SM58  Asynchronous RFC Error Log
SM59  RFC Destinations (Display/Maintain)
SM60  Borrow/Return Objects
SM63  Display/Maintain Operating Mode Sets
SM64  Release of an event
SM65  Background Processing Analysis Tool
SM66  System-wide Work Process Overview
SM67  Job scheduling
SM68  Job administration
SM69  Display/Maintain Logical Commands
SMEN  Dynamic menu
SMGW  Gateway Monitor
SMLG  Maintain Logon Group
SMLI  Language import utility
SMLT  Language transport utility
SMOD  SAP Enhancement Management
SMT1  Trusted Systems (Display Maint.)
SMT2  Trusting systems (Display Maint.)
SMW0  SAP Web Repository
SMX   Display Own Jobs
SNRO  Number Range Objects
SO02  SAPoffice: Outbox
SO03  SAPoffice: Private Folders
SO04  SAPoffice: Shared Folders
SO05  SAPoffice: Private Trash
SO06  SAPoffice: Substitutionon/off
SO07  SAPoffice: Resubmission
SO10  SAPscript: Standard Texts
SO12  SAPoffice: User Master
SO13  SAPoffice: Substitute
SO15  SAPoffice: DistributionLists
SO16  SAPoffice: Profile
SO17  SAPoffice: Delete Shared Trash
SO18  SAPoffice: Shared Trash
SO19  SAPoffice: Default Documents
SO21  Maintain PC Work Directory
SO22  SAPoffice: Delete PC Temp. Files
SO23  SAPoffice: DistributionLists
SO24  SAPoffice: Maintenance of default PC
SO28  Maintain SOGR
SO30  SAPoffice: Reorg.
SO31  Reorganization (daily)
SO36  Create Automatic Forwarding
SO38  SAPoffice: Synchr. of Folder Auths.
SO40  SAPoffice: Cust. LayoutSet MAIL
SO41  SAPoffice: Cust. LayoutSet TELEFAX
SO42  SAPoffice: Cust.Layout Set TELEFAX_K
SO43  SAPoffice: Cust.Layout Set TELEFAX_M
SO44  SAPoffice: Cust. LayoutSet TELEX
SO70  Hypertext: Display/Maint. Structure
SO71  Test plan management
SO72  Maintain Hypertext Module
SO73  Import graphic into SAPfind
SO80  SAPfind: Free Text Retrieval Dialog
SO81  SAPfind: Free Text Indexing (Test)
SO82  SAPfind: Free Text Retrieval Batch
SO95  Pregenerated Search Queries – Selec.
SO99  Put Information System
SOA0  ArchiveLink Workflow document types
SOBJ  Attribute Maintenance Objects
SOLE  OLE Applications
SOLI  Load OLE type info
SOPE  Exclude Document Classes
SOTD  SAPoffice: Maintain Object Types
SOY1  SAPoffice: Mass Maint. Users
SOY2  SAPoffice: Statistics data collect.
SOY3  SAPoffice: Statistics Evaluation
SOY4  SAPoffice: Access overview
SOY5  SAPoffice: Inbox overview
SOY6  SAPoffice: Document overview
SOY7  SAPoffice: Folder overview
SOY8  SAPoffice: Mass Archiving
SOY9  SAPoffice: Inbox Reorg.
SOYA  SAPoffice: Change folder owner
SP00  Spool and Relate Area
SP01  Spool Control
SP02  Display output Requests
SP03  Spool: Load Formats
SP11  TemSe Contents
SP12  TemSe Administration
SPAD  Spool Management
SPAM  SAP Patch Manager (SPAM)
SPAU  Display Modified DE Objects
SPCC  Spool Consistency check
SPDD  Display Modified DDIC objects
SPHA  Telephony administration
SPIC  Spool : Installation Check
SPRM  Current Customizing
SPRO  Customizing
SQ01  SAP Query: Maintain queries
SQ02  SAP Query: Maintain funct. areas
SQ03  SAP Query: Maintain user groups
SQ07  SAP Query: Language comparison
SQVI  QuickViewer
SSAA  System Administration Assistant
SSCA  Appointment Diary: Administration
SRZL  CCMS
SSM1  Session Manager generation call
SSM5  Create Activity Group
ST01  System Trace
ST02  Setups/Tune Buffers
ST03  Performance, SAP Statistics, Workload
ST04  Select activity of the databases
ST05  SQL Trace
ST06  Operating System Monitor
ST07  Application monitor
ST08  Network Monitor
ST09  Network Alert Monitor
ST10  Table Call Statistics
ST11  Display Developer Traces
ST12  Application Monitor
ST14  Application Analysis
ST22  ABAP Runtime Error Analysis
ST22  ABAP/4 Runtime Error Analysis
ST62  Create industry short texts
STAT  Local transaction statistics
STMS  Transport Management System
STUN  Performance Monitoring
STW1  Test Workbench: Test catalog
STW2  Test workbench: Test plan
STW3  Test workbench: Test package
STW4  Test Workbench: Edit test package
STW5  C maintenance table TTPLA
STZAC Maintain time zone act.in client
STZAD Disp.time zone activat.in client
SUMM  Global User Manager
SU01  Maintain User
SU01D Display users
SU02  Maintain Authorization Profiles
SU03  Maintain Authorizations
SU05  Maintain Internet Users
SU10  Mass changes to User Master
SU11  Maintain Authorizations
SU12  Mass Changes to User Master Records
SU2   Maintain User Parameter
SU20  Maintain Authorization Fields
SU21  Maintain Authorization Objects
SU22  Auth. object usage in transactions
SU24  Disables Authorization Checks
SU25  Imports SAP Check Indicators defaults
SU26  Adjust Authorization checks
SU30  Total checks in the area of auth.
SU52  Maintain own user parameters
SU53  Display check values
SU54  List for Session Manager
SU56  Analyze User Buffer
SUPC  Profiles for activity groups
SUPF  Integrated User Maintenance
SUPO  Maintain Organization Levels
SUIM  Repository Info System
SWDC  Workflow Definition
SXDA  Data Transfer Workbench
TU02  Display Active Parameters
USMM  Customer measurement

Client Administration:

Checking Client Copy Log (SCC3)
Client Administration (SCC4)
Client Delete (SCC5)
Client Import Post-Processing (SCC7)
Client Export (SCC8)
Local Client Copy (SCCL)
Remote client copy (SCC9)

User Administration:

User Maintenance (SU01)
User Display (SU01D)
Maintain Authorization Profiles (SU02)
Maintain Authorizations (SU03)
Maintain Internet users (SU05)
User Mass Maintenance (SU10)
Maintain Logon Group (SMLG)
Profiles for activity groups (SUPC)
Info system Authorizations (SUIM)
Profile Generator (PFCG)
User Master Data Reconciliation (PFUD)

Database Administration:

Analyze exclusive lock waits (DB01)
Analyze tables and indexes (DB02)
DB Backup Monitor (DB12)
DBA Planning Calendar (DB13)
Data Archiving: Database Tables (DB15)

Background Jobs Administration:

Define Background Job (SM36)
Background Job Overview (SM37)
Job Analysis (SM39)
Execute External OS commands (SM49)
Maintain Events (SM62)
Release of an Event (SM64)
Background Processing Analysis Tool (SM65)
Maintain External OS Commands (SM69)

Spool Administration:

Output Controller (SP01)
TemSe directory (SP11)
TemSe Administration (SP12)
Spool Administration (SPAD)

Daily monitoring TCodes:

Current Active Users (AL08)
Display and Delete Locks (SM12)
Display Update Records (SM13)
System Log (SM21)
Work Process Overview (SM50)
List of SAP Servers (SM51)
System Wide Work Process Overview (SM66)
ABAP/4 Runtime Error Analysi(ST22)
System Trace (ST01)
Setups/Tune Buffers (ST02)
Select DB activities (ST04)
Performance trace (ST05)
Operating System Monitor (ST06)
Table call statistics (ST10)
Performance, SAP Statistics, Workload (ST03)
Analyze User Buffer (SU56)

Alert Monitoring T-codes:

SAP Alert Monitor (AL01)
Database alert monitor (AL02)
Monitor call distribution (AL04)
Monitor current workload (AL05)
Local Alert Monitor for Operat.System (AL16)
Local File System Monitor (AL18)
CCMS Monitoring (RZ20)

Configuration T-codes:

Maintain Operation Modes and Instances (RZ04)
Maintenance of Profile Parameters (RZ10)
Profile parameter maintenance (RZ11)
Maintain Transaction Codes (SE93)
Display/Maintain Operating Mode Sets (SM63)
Customizing: Initial Screen (SPRO)
Consistency check: Customizing (SWU3)

Transport Management System:

Client Copy - Special Selections (SCC1)
Transport Management System (STMS)
Transport and Correction System (SE01)
Set Up Workbench Organizer (SE06)
CTS Status Display (SE07)
Workbench Organizer (SE09)
Customizing Organizer (SE10)
ABAP/4 Dictionary Maintenance (SE11)
Data Browser (SE16)
Repository Browser (SE80)
Call View Maintenance (SM30)
Table Maintenance (SM31)

General Tcodes:

Operating system monitor (STO6/OS06)
Check database alertlogs and performance(ST04)
Check for excessive swapping (ST02)
Show all active work process status SM50 for global w.p (SM66)
Activer connection (OSS1)
Language administration (SMLT)
To check SAP directories (AL11)
Check backgroundjob-settings (SM65)
Show background jobs (SM37)
Operation mode calendar (SM63)
To check SAP active servers (SM51)
To check startuplog (ST11)
To monitoring OS (ST06)
Transaction lock/unlock (SM01)
To check active users overview (SM04)
To findout the SQL data operation activities on a table (ST10)
To check database tables/indexes (DB02)
To monitor OS and Database and SAP System (ST03)
To check for Database locks (DB01)
To allows you to set a trace per-user, transaction, program or process-id (ST05)

Shortcut Commands Tcodes Window:

/h Turning on the debugging mode
/n New command
/o New session

SAP Tools:

dpmon:
This tool allows you to check SAP’s processes and to find out which one is killing the performance. Especially
useful when it is not possible anymore to log on to your system.

gwmon:
This tool allows you to check if the gateway is running. It is an addition to transaction SMGW.

How to create a java thread dump?

How to create a java thread dump?

-Start the SAP Management Console.
-Navigate to AS Java process table under respective server node
-Select the process for which you want to create a stack dump in the java process table ( Process can be SDM / dispatcher / server0)
-Right click on the process and from the context menu, choose “Dump stack trace”

What is SAPOSCOL and its functions ?

What is SAPOSCOL and its functions ?

SAPOSCOL is an operating system collector. It is a standalone program that runs in operating system background. SAPOSCOL collects data about operating system resources like:

CPU Utilization
Usage of Physical Memory
Usage of Virtual Memory
Usage of filesytems
Usage of Physical disks
Usage of running processes

SAPOSCOL runs exactly once per host and runs independently of the sap system.

By default, SAPOSCOL collects data every 10seconds and records it. It also records the hourly average statistics for the last 24hours in shared memory. This data will be fetched by background job “SAP_COLLECTOR_FOR_PERFORMANCE” and writes it to the MONI performance database table.

Steps of adding datafiles(oracle) in SAP

Steps of adding datafiles(oracle) in SAP

What is BRTOOLS?

BRTOOLS is the database administration tool supported by SAP for oracle database.

How to access BRTOOLS ?

BRTOOLS can be accessed by logging into database host as ora<sid> user and calling brtools at the command prompt.

How to add or extend datafiles in sap system based on oracle database?

Once brtools is called at command prompt, following menu will be displayed

BR*Tools main menu

1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
======================================
Select option 2 - Space management from the above query and press c to continue.

It displays another screen as below :

Database space management

1 = Extend tablespace
2 - Create tablespace
3 - Drop tablespace
4 - Alter tablespace
5 - Alter data file
6 - Move data file
7 - Additional space functions
8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
=============================================
Select Option 1- Extend tablespace and press continue.

In the next screen, you will be prompted to enter tablespace name, size/location of new datafile to be added, initial filesize, maximum filesize, autoextend (yes/no). Please provide all the relevant details and you can see an SQL query is being built based on the inputs given by you.

Once all the inputs are provided, press continue to execute the command and the datafile will be added.

Checking database, tablespace sizes in SAP

Checking database, tablespace sizes in SAP

How to check the database size ?

Goto transaction DB02  and navigate to Space -> Space overview to view

Database name
Database system
Size
Free size
Used percentage
Number of database users
Number of tablespaces
Number of tables and size
Number of indexes and size
In DB02, navigate to Space -> Space overview to find all the above mentioned details

How to check  the users that are present in database at SAP level ?

In DB02, navigate to Space -> Users -> Overview as below

How to check various tablespaces in SAP and their sizes ?

In DB02, navigate to Space -> Table spaces -> Overview to view tablespaces details as below.

Basis Architecture

Basis Architecture 

Sap system comprises of 3 different tiers:

1. SAP application tier.
2. SAP database tier.
3. SAP presentation tier.

1. SAP application tier addressed as central instance or dialog instance, where central and dialog instances have all the ability to process all the users requests, executed by the users from their GUI. The CI & dialog instance comprises of work processes and services which are responsible for processing users request.

2. SAP database tier of SAP system comprises of 4 major components.

-ABAP component
-BASIS component
-HR component
-LOGISTICS & ACCOUNT components (sd,mm,pp,fi etc)

These major components makes the SAP database and also gives helps to process the GUI.

3. SAP presentation tier has to be loaded on every desktops/laptops of an end-users, through which users can access SAP application and database.

Note:

- Any sap system is built upon a 3 tier architecture, where presentation layer is considered as a GUI.
- Central instance or dialog instances are considered as SAP application.

What is central instance architecture ?

Architecture of central instance is designed to process all the users request. They consist of work processes, services and a dispatcher.

- A dispatcher has the ability to accept the work from a user GUI, and trigger it to the right and free work process depending on the task executed by the user.

- Services of SAP system are responsible for communication via dedicated port numbers, where message service is responsible for communicating b/w SAP applications and central database.

- SAP applications context are: central and dialog instances.

- Message server port number is 3600

- Gateway service is responsible for communication b/w SAP to SAP and SAP to NON SAP systems via dedicated port numbers.

- Gateway server port number is 3300.

What is work process?

In any central instance of an R/3 system one can find 5 work processes, they are:

1. Dialog work process
2. Background work process
3. Update or V1/V2 work process
4. Spool work process
5. Enqueue work process

1. Dialog work process is responsible for on-line transactions, they are represented as "DIA".

2. Background work process is responsible for processing long-running or off-line tasks without a direct user interaction, they are represented as "BTC" or "BGD".

3. Update work process is responsible for saving the data in the database tables. There are 2 types of updates represented as "UPD" and "UP2". They can also be represented as synchronous and asynchronous V1/V2 again or critical and less critical respectively.

* UPD ---> synchronous ---> V1 ---> critical
* UP2 ---> asynchronous ---> V2 ---> less critical

4. Spool work process are represented as "SPO" and are responsible for printing in SAP system.

5. Enqueue work process is represented as "ENQ" and it is responsible for locking mechanism, ENQ prevents deadlocks over database tables, by processing user request in "Q"(fifo) fashion.

The central instance is represented as "DVEBMGS"

-DIALOG
-V2
-ENQUEUE
-BACKGROUND
-MESSAGE
-GATEWAY
-SPOOL

What is SAP business suite? ERP, CRM, SRM, SCM, PLM & HCM

What is SAP business suite? ERP, CRM, SRM, SCM, PLM & HCM

In order to integrate end to end business process in an organization, SAP offers a number of applications which can be seamlessly integrated with each other to maximize the benefit of using SAP. SAP offers below applications which are collectively referred as sap business suite.

SAP Enterprise Resource Planning (ERP)
SAP Customer Relationship Management (CRM)
SAP Supplier Relationship Management (SRM)
SAP Supply Chain Management (SCM)
SAP Product Lifecycle Management (PLM)
SAP Human Capital Management (HCM)

SAP business suite 7 is the latest version which enables running applications on cloud.
 

-SAP Customer Relationship Management (CRM):

Consider the sales process in an organization. Marketing department collects data about prospects from various sources, sales representatives meet prospects and collect more information about prospects which help them generate sales lead, finally sales is executed and after sales service is provided.  It’s important for organization that customer data should be available as and when required hence customer data has to be stored at central database. Sales process also involves several level of approval even cross department approval as well hence software system should enable approval process as well. SAP CRM addresses these issues by storing customer information at central database and standardizing sales process (for example approval process) by enabling workflow. This helps in faster business by reducing sales cycle time.

SAP CRM also helps in measuring, monitoring and improving effectiveness of marketing activities. The SAP CRM focuses on entire sales process mainly presale and post-sale whereas SAP SD merely focuses on sales order processing.
 

-SAP Supplier Relationship Management (SRM):

In order to serve the customer faster while keeping inventory low, organizations need to work in close coordination with suppliers.

A big organization may have thousands of suppliers and hence managing becomes a challenge. Organization need to categorize suppliers into low importance, medium importance and strategically important and accordingly relationship should be valued.

There are different people on organization and supplier side and these people may be spread across different part of the organization, different departments, different function and different geography. For faster interaction between these people and remove duplication of effort, a system is needed which can enable close coordination to overcome this challenge.


-SAP Supply Chain Management (SCM):

Supply chain management involves demand forecast & planning, inventory management and execution of various interdependent tasks to be performed by different people spread across department/ geography.

Challenge in demand forecast is to put together all relevant data and analyse them considering various variables which might have an impact on demand. This process of extracting meaningful information from huge volume of data (big data) is called data analytics.

SAP SCM overcomes the challenge of demand forecast & planning by providing data analytic capability. SAP SCM also provides workflow functionality which streamlines activities (to be performed by various people) by establishing a well-defined structure of who will perform what task along with dependency between tasks. A person/ team are responsible for completion of respective assigned task. Work flow functionality enables faster completion of activities.


-SAP Product Lifecycle Management (PLM):

Product planning team comes up with an idea (idea of a product is born).  Product design team spread across geography/ discipline work in coordination. During product manufacturing organization has to work in close coordination with suppliers, contractors, transporters etc. For distribution of product, organization has to work with logistics partner.

During the entire process huge amount of data is generated and moreover this data is distributed. Manager needs a holistic view to make decisions. Challenge is to put together all data so that a holistic view can be generated. Manager needs to know the impact of any change in existing design/ production process on product cost.

SAP PLM overcomes these challenges by collecting all data centrally for a holistic view, enabling information sharing for proper coordination between various parties like product design team, engineering team, manufacturing team, suppliers, finance and others.


-SAP Human Capital Management (HCM):

HR department is involved in various processes like recruitment, on boarding, training & development, time recording, promotion, role change, payroll, separation, full & final settlement. With each event information like employee’s personal details, role, reporting manager, salary details etc. needs to be recorded and updated.

When number of employees in the organization is large and spread across geography then managing huge amount of data centrally becomes a challenge. HR department has to work in close coordination with finance department.

SAP HR overcomes these challenges by managing all data centrally and integrating HR processes. SAP HR is highly integrated with SAP FI.

Example: When an employee gets promoted, information like role, band, salary, reporting manager etc. need to be updated. Hence an event can have multiple impacts. SAP HR can be utilized for maintenance and updating of various data originating from an event.