
How Is the Database Space Information Calculated?
In write programs, the Archive Development Kit (ADK) automatically collects statistics. In delete, read, and reload programs, you must use ARCHIVE_GIVE_STATISTICS to pass statistical information to ADK. The statistics collected by ARCHIVE_GIVE_STATISTICS can be displayed as described in
Statistics.This function module can accept data for any of the six ABAP Dictionary object types:
ADK calculates the database space according to the relevant ABAP Dictionary object type and uses the function module DDIF_TABL_GET to get the width of the relevant object.
You should note, however, that this width is not necessarily identical with the database space occupied by the object. If, for example, you are using a Unicode database with UTF-16 coding, then, n characters (width = n) in a character-type field occupy at least 2n bytes in the database.
After calculating the database space, ADK assigns each result to one of the following database space categories. These categories correspond to the categories in the Statistics function in Archive Administration. The DB Space is the sum of these four categories.
DB Table Space
|
ABAP Dictionary Object Type |
Table Space = |
|
TRANSP |
width * number of records |
|
POOL |
width * number of records |
|
VIEW |
width * number of records |
DB Index Space
|
ABAP Dictionary Object Type |
Index Space = |
|
TRANSP |
(width of primary key fields + width of all secondary key fields) * number of records |
|
POOL |
width of primary key fields * number of records |
|
VIEW |
width of primary key fields * number of records |
|
CLUSTER |
width of primary key fields * number of records |
DB Cluster Space
|
ABAP Dictionary Object Type |
Cluster Space = |
|
CLUSTER |
width * number of records |
DB Structure Space
|
ABAP Dictionary Object Type |
Structure Space = |
|
INTTAB |
width * number of records |
|
APPEND |
width * number of records |
See Also
Function module documentation for ARCHIVE_GIVE_STATISTICS