SAP AMDS (Effective size of tables and indexes in the database) Table & Fields

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


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

FieldNoteData ElementDomain
ANDATAnalysis date for application monitorAM_ANDATSYDATS
ACTIVActivation flag Application monitorAM_ACTIVSAM_ACTIVS
AMETHAnalysis Method for Collecting StatisticsAM_AMETHAM_AMETH
OPTIOSample Size for Collection of StatisticsAM_OPTIOCHAR5
NROWSNumber of rows in a tableOROWSDEC15
OCCBLUsed blocks of an Oracle tableOU_BLOCKSDEC11
EMPBLEmpty blocks allocated for an Oracle tableOE_BLOCKSDEC11
AFREEAvg. freespace in a used data base blockOAVG_BFREEINT4
CHAINNumber of rows requiring block chainingOCHAINEDDEC15
AROWLAverage row length (Oracle result)OAVG_ROW_LDEC7_S
INDBLAllocated blocks for an Oracle indexOIND_ALLBLDEC11
INDBSTotal space allocated in the B tree (ORACLE)OBTREE_SPCDEC15
INDUSTotal space used in B tree (ORACLE)OBTREE_USEDEC15

AMDS related tables

AMDSEffective size of tables and indexes in the database
AMDTControl Table for Application Monitor / DB Storage
AMRHApplication Monitor: Hierarchy acc. to TCODE/REPORT
AMSKSQL trace header info in application monitor
AMSPSQL trace position info in application monitor
BUFCHECKException table of tables that cannot be buffered
DBSTAIHADAActual size of indices on the database (history)
DBSTAIHORAActual size of indices on the database (history)
DBSTATHADAActual size of tables on the database (history)
DBSTATHORAActual size of tables on the database (history)
DBSTATIADAActual size of indices on the database
DBSTATIORAActual size of indices on the database
DBSTATTADAActual size of tables on the database
DBSTATTORAActual size of tables on the database
DBVSETable for Oracle DB Snapshots of V$SYSTEM_EVENT
EARLYMonitor table MONI
EWJOBSCHEDScheduling parameters for EarlyWatch background jobs
EWOSSTechnical settings for transaction OSS1
EWTABBTable for EarlyWatch Report
GST04SRVRSList of all R/3 instances with DB

SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site is not affiliated with SAP AG.