AMDS is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of AMDS in SAP.
- Table description : Effective size of tables and indexes in the database
- Module : BC-CCM-MON-TUN
- Parent Module : BC
- Package : STUN
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP AMDS Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| TNAME | Table name | TNAME | AS4TAB |
| ANDAT | Analysis date for application monitor | AM_ANDAT | SYDATS |
| ACTIV | Activation flag Application monitor | AM_ACTIVS | AM_ACTIVS |
| AMETH | Analysis Method for Collecting Statistics | AM_AMETH | AM_AMETH |
| OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR5 |
| NROWS | Number of rows in a table | OROWS | DEC15 |
| OCCBL | Used blocks of an Oracle table | OU_BLOCKS | DEC11 |
| EMPBL | Empty blocks allocated for an Oracle table | OE_BLOCKS | DEC11 |
| AFREE | Avg. freespace in a used data base block | OAVG_BFREE | INT4 |
| CHAIN | Number of rows requiring block chaining | OCHAINED | DEC15 |
| AROWL | Average row length (Oracle result) | OAVG_ROW_L | DEC7_S |
| INDBL | Allocated blocks for an Oracle index | OIND_ALLBL | DEC11 |
| INDBS | Total space allocated in the B tree (ORACLE) | OBTREE_SPC | DEC15 |
| INDUS | Total space used in B tree (ORACLE) | OBTREE_USE | DEC15 |
AMDS related tables
| Table | Note |
|---|---|
| AMDS | Effective size of tables and indexes in the database |
| DBSTATHADA | Actual size of tables on the database (history) |
| DBSTATHORA | Actual size of tables on the database (history) |
| DBSTATTADA | Actual size of tables on the database |
| DBSTATTORA | Actual size of tables on the database |
| DB2DB02IXDYN | Tx DB02: Dynamics of the size of indexes |
| BBPD_TREX_INDEX | BBP TREX Indexes: Assign Business Object -> TREX Indexes |
| STRX_LPIXS | Assignment of Physical Indexes to Logical Indexes |
| DDSPAR | Storage clause for tables and indexes |
| DDSPAR1 | Storage clause for tables and indexes |
| DDSPAR2 | Storage clause for tables and indexes |
| DDSTORAGE | Storage clause for tables and indexes |
| DDSTORAGE1 | Storage clause for tables and indexes |
| DDSTORAGE2 | Storage clause for tables and indexes |
| MSSSTORAGE | MSSQL-Specific Storage Parameters for Tables and Indexes |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP