Menu

SAP Package SADA

Porting and CCMS SAP DB

The package SADA (Porting and CCMS SAP DB) is a standard package in SAP ERP. It belongs to the parent package BASIS.

Technical Information

Package SADA
Short Text Porting and CCMS SAP DB
Parent Package BASIS

Function Groups

SAP Package SADA contains 13 function groups.

SADA SAP DB CCMS
SADB SAP DB: General System Information
SADC SAP DB: DBMRFC Programming Interface
SADD SAP DB: Monitoring of SAP DB Instance
SADE SAP DB: DBA Function Modules (DB13...)
SADF Extended Table Maintenance (Generated)
SADH SAP DB: Connect Information
SADI MaxDB/liveCache: CCMS Function Modules
SADN Starts Niping on LC Server
SADX Existence Test for Database Objects
SADY SAP DB: Evaluation of DB Analyzer Data
SSDBA SDB CCMS: Accesses with ADBC
STD3 SAP DB: Statistics Modules

Transactions

SAP Package SADA contains 4 transactions.

DB11 Create Database Connection
DB50 SAP DB Assistant
DB50N Database Assistant
DB59 MaxDB/liveCache System Overview

Database Tables

SAP Package SADA contains 15 database tables.

ADACACHE Information About SAP DB Cache Access
ADATABSIZE SAP DB: Table Sizes Including Indexes in KB
DB50TDEF SAP DB Assistant: Tree Definition
DBAN Buffer for dban_state
SDBAHSDB SAP DB: DBA History
SDBCCMS MaxDB/liveCache CCMS: Monitoring Data Repository
SDBCTRL SAP DB: CCMS Control Table
SDBDBMRFC SAP DB: DBMRFC Control Table
SDBDBMRFC2 SAP DB: Current DBMRFC Sessions
SDBPAHI SAP DB: Parameter History
SDBSYSTEMS Overview of Integrated SAP DB and liveCache Systems
SDBTREEDEF SAP DB: CCMS Navigation Trees - Node Definition
SDBTREETXT SAP DB: CCMS Navigation Trees - Node Texts
SDBUPDEXCL MaxDB: Exception Table for UPDATE STAT... ESTIMATE
SDBUSRSET User Settings for Transactions LC10 and DB50

Structures

SAP Package SADA contains 66 structures.

ADA_CHIT Structure of Cache Hitrates for SAP DB
ADA_CONF Structure for SYSDBA.CONFIGURATION
ADA_DBINFO Structure for Database Information
ADA_DBSTAT SYSDBA.SERVERDBSTATISTICS
ADA_IO_DET SAP DB: I/O Details
ADA_MOPT SAP DB: Diagnosis Monitor Options
ADA_MSG SYSDBA.MESSAGES
ADA_PARAMS SYSDBA.DBPARAMETER
ADA_RTIME Database: Date and Time of Database Restart
ADA_STATE DOMAIN.SHOW_STAT_STATE
ADA_VTRACE Database Kernel Trace
ADAMONITOR SYSDBA.MONITOR
ADASQLAR Restrictions for Display of SQL Resource Usage
ADASTREE Structure for Working With Tree Control: Simple Tree
ADASYSAN SYSDBA.SYSDATA_ANALYZE and SYSDBA.SYSCMD_ANALYZE
ADASYSMO SYSDBA.SYSMONITOR and Selection From SYSDBA.SYSPARSEID
ALLOCSTAT sysdba.allocatorstatistic
DB50KDEF DB50: Key Definition for Tree Node
DB50NDEF DB50: Node Definition (Without Key)
DBBHISTADA SAP DB Backup History for ALV
DBCHISTADA SAP DB Check History for ALV
DBDEVSDB SAP DB Devspace Information
DBINDXADA SAP DB: Structure for Index Lists
DBMSGSDB SAP DB: Structure of Message File
DBMUTLSDB SAP DB: Structure for File dbm.utl
DBPARSDB Database Parameters: Values and Properties
DBPROC_SDB DB Procedures: SAP DB (liveCache)
DBPROCTREE ALV Tree Structure for SAP DB: Display DB Procedure
DBUHISTADA SAP DB Update Statistics History for ALV
LCAALERTS liveCache Application Alerts
LOCK_L_SDB SAP DB Lock List (Locks and Requests)
LOCK_W_SDB SAP DB Lock Waits
PROCINFSDB Structure for domain.dbprocparaminfo: SAP DB/liveCache
RHPROG_REF Reference to a Statement in an ABAP Program -> PROG_REF
RHRLREF Structure: Line Reference for LOAD REPORT Lang. Elem.->RFREF
SDB_ANSW SAP DB: Response Line from DBM Command
SDB_CASTAT SAP DB Cache Statistics
SDB_DATFID Internal Structure: Date and File ID for Analysis Data
SDB_DBPARAM Structure for GET_ALL_PARAMETERS_EXTENDED
SDB_DEVIO SAP DB: Structure for sysmon_deviothread
SDB_FLAG SAP DB: General Flag
SDB_FLIST SAP DB: DBM file_getlist
SDB_GPARAM Structure for DBM_PARAMSGET
SDB_ISTATE SAP DB: Structure for sysdba.internal_state
SDB_MEDIA SAP DB: Structure for Backup Media
SDB_PAHI SAP DB: Structure for the Parameter History
SDB_PAHIST SAP DB: Structure for the Parameter History (Permanent)
SDB_PPARAM Structure for DBM_PARAMSPUT
SDB_SRVST SAP DB: Structure for serverdbstatistics + Other Fields
SDB_THREAD SAP DB: Structure for sysmon_ukthread
SDB_TNODES SAP DB: Node Keys for Tree Navigation
SDBACTIV SAP DB: General Database Activity
SDBCACHE SAP DB: Cache Configuration and Activity
SDBCMDSTAT SAP DB: sysinfo.commandstatistics (Command Stats Shared SQL)
SDBCOLINFO Column Information (Name, Tooltip, Type, Aggregates)
SDBCOLTABS Table of Tables with Structure SDBCOLINFO (for SDBCCMS)
SDBDBTRACE Database Trace Options/Information
SDBLIN1024 Internal Structure for Text Files (Width 1024)
SDBLINE512 Internal Structure for Text Files
SDBLOCK SAP DB: Lock Activity
SDBLOG SAP DB: Logging Activity
SDBRELINFO SAP DB: Application Release Info
SDBSQL SAP DB: SQL Activity
SDBTABINFO SAP DB Tables with Descriptions
SDBXXLTABS Table of Tables with Line Size 1024 Char
TABSTAT SAP DB: Table Statistics

Programs

SAP Package SADA contains 51 programs.

_SLD_LIVECACHE SLD DS: Class SAP_LiveCache
ADAXPRA1 XPRA for Enlarging LCHR Fields with Length Between 256 and 2000
INDEXADA Report for Creating ADABAS-Specific Indexes
RSADA850 SAP DB: Overview of DBA Actions
RSADACHT Consistency Check of a Table (Check Table)
RSADACKTAB RSADACKTAB: Checks Whether All Tables in DBSTATC also Exist in DB
RSADADBC SAP DB Assistant
RSADADPR Delete Old Log Entries (DB12 Cleanup)
RSADAENI SAP DB: Reset disable flag of all indexes
RSADARFR Update CNHIST and CNREPRT
RSADAT6M SAP DB: Determine Table and Index Sizes
RSADAUP4 Program RSADAUP4
RSADAXDB Program RSADAXDB
RSDBANAGGR Create Aggregates of Database Analyzer Data and Save in SDBCCMS
RSDBANCOLL RSDBANCOLL Administration of DB Analyzer Data in Table MONI
RSDBANCONTROL Program RSDBANCONTROL
RSDBANDD Display a DB analyzer detailed log (dynamically in ALV grid)
RSDBCONUSR RSDBCONUSR
RSDBMRFC SAP DB: DBMRFC Client
RSDBMSTP SAP DB: Stop the DBMRFC Server
RSDBMTRC SAP DB: Activate/Deactivate DBMRFC Trace
RSLVCPAR Parameter History for liveCaches
RSSDB_CONV_ASCII_TO_UNICODE Conversion of ASCII Tables in a UNICODE System
RSSDBADM SAP DB: DB Planning Calendar
RSSDBCCMSDEL Delete from Table SDBCCMS (Statistics, DB Analyzer, ...)
RSSDBCHECKDBMRFC Program RSSDBCHECKDBMRFC
RSSDBCHT Consistency Check of a Table (Check Table)
RSSDBCON Integration of Database
RSSDBDBC Database Assistant
RSSDBDEL Deletion of DBA History and DBA Action Logs
RSSDBDLY Daily Automatic Actions for MaxDB/liveCache Monitoring Data
RSSDBDSR Display Select Result (Display SELECT Result in ALV Grid)
RSSDBIDX SAP DB: Enable/Disable Indexing of Table
RSSDBLST Program RSSDBLST: SAP DB/liveCache Systems
RSSDBMONACT Daily Automatic Actions for MaxDB/liveCache Monitoring Data
RSSDBPAR SAP DB: Parameter History in Table SDBPAHI
RSSDBREG SAP DB: Creation of TCP/IP Connection for DBMRFC
RSSDBRES SAP DB: Reset DBMRFC (Disconnect All)
RSSDBRTD RSSDBRTD
RSSDBSTRG Correction of CTRL Unicode Problem
RSSDBSTT SAP DB: Switch Table Type from SYSTEM to TABLE
RSSDBUPDSTAT RSSDBUPDSTAT - Create Optimizer Statistics
RSSDBUPDSTATONE Update Optimizer Statistics for a Table
RSSDBWEB Maintain Standard Web DBM Server
RSXPLADA ADABAS-Specific Module for Explain SQL
SDB_UNICODE_CONV_LC Convert Columns from UNICODE to ASCII in LC
SDB1FADA Forms for Database Access to SQL Database
SDB2FADA Forms for Database Access to SQL Database
SDB3FADA FORMS for ADABAS-Specific Objects
SDBCHECKADA ADABAS: Consistency Check DDIC/DB
SINDXADA Report for Starting INDEXADA (ADABAS-Specific Indexes) as Batch

Message Classes

SAP Package SADA contains 1 message classes.

SADA CCMS Portierung/Entwicklung SAP DB