SAP Package SADA
Porting and CCMS SAP DB
Unsere Literaturempfehlung
SAP – Der technische Einstieg: SAP-Technologien und Konzepte
Sind Sie neu in der SAP-Welt und möchten schnell mitreden? Mit diesem Buch finden Sie sich erfolgreich im SAP-Umfeld zurecht! Sie steigen direkt in die Konzepte und Technologien der SAP-Software ein und lernen die unterschiedlichen Systeme und Prozesse kennen. Schritt für Schritt zeigen die Autoren Ihnen die wichtigsten technischen Aufgaben und die Zusammenhänge zwischen den Objekten. Dank der vielen Beispiele und Abbildungen finden Sie sich schnell im SAP-Umfeld zurecht und können direkt in SAP ERP oder SAP S/4HANA anfangen.
Bei amazon.de ansehen →
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 |
|---|