SAP ADATABSIZE SAP DB: Table Sizes Including Indexes in KB Table

Overview

ADATABSIZE is a standard SAP S/4HANA table that stores SAP DB: Table Sizes Including Indexes in KB data. There are total 12 fields in the ADATABSIZE table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ADATABSIZE belongs to MaxDB (BC-DB-SDB) module and is located in the package Porting and CCMS SAP DB (SADA).

In addition, following links provide an overview of foreign key relationships, if any, that link ADATABSIZE to other SAP tables and standard CDS views available based on ADATABSIZE table in S/4HANA 2020.

Techincal Settings of ADATABSIZE

Below are technical details of the table ADATABSIZE

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ADATABSIZE Fields

The following table gives you an overview of the fields available in ADATABSIZE

FieldDescriptionData ElementCheck TableData TypeLength
TABNAMEName of the ABAP Dictionary objectOBJECTNAMECHAR30
INDEXNAMEName of the ABAP Dictionary objectOBJECTNAMECHAR30
LFLAGSAP DB: Indicator of Whether Table Has Long ColumnsADA_LFLAGCHAR1
AFLAGSAP DB: Indicator of Whether Table Has Long ColumnsADA_LFLAGCHAR1
OSIZESAP DB: Object Size in KBADA_OSIZEDEC20
SUM_LEAFSAP DB: Size of all Leaf Pages in KB in the B* TreeADA_SLEAFDEC20
SUM_LONGSAP DB: Size of Short Long Column Files in KB in B* TreeADA_SLONGDEC20
SUM_GROWTHSAP DB: Table Growth in KBADA_GROWTHDEC20
ADATESAP DB: Analysis DateADA_ADATEDATS8
ATIMESAP DB: Analysis TimeADA_ATIMETIMS6
EDATESAP DB: Analysis DateADA_ADATEDATS8
ETIMESAP DB: Analysis TimeADA_ATIMETIMS6

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADATABSIZE

Other References