Create user-defined types, such as data
elements, structures, and table types, for use
in ABAP programs or in interfaces of function
modules, object methods, and so on
Create the database objects such as tables,
indexes, and views in the ABAP Dictionary
Provides a number of services that support
program development. For example, the
ABAP Dictionary supports setting and
releasing locks. defining an input help, and
attaching a field help to a screen field.
Define the tables and database views. the
system creates these tables and views in the
underlying database with the definition in
ABAP Dictionary. Changes to the definition
of a table or database view are also
automatically made in the database.
Define indexes in the ABAP Dictionary to
speed up access to data in a table. the
system also creates these indexes in the
database when the table is activated.
contains a least
one field with a
mechanism exits to
Fragmentation in tables
delete and create the indexes again
to reduce fragmentation you have to convert the table
data that is seldom modified
data that is frequently modified
data you can define when you
customize and install the system
Data that SAP systems need
WARRING: defines which tablespace is
use for a specific table
data modifications LOG (SCU3)
store functionally depend data. the intersection of the key fields of the cluster tables form the key of the
table cluster, knows as the cluster key and stored in the VARDATA field. PAGNO field guarantees the
uniqueness within the table cluster. TIMESTAMP and PAGELG fields contains administrative informtation
stores data records from the tables defined in the ABAP Dictionary that are not dependent on one
another. combine small SAP tables in on database table. TABNAME field is the name of the pooled table.
VARKEY field consists of the concatenation of key fields of the pooled table. DATALN field store the lenght
of the VARDATA. VARDATA stores the non-key.fields of the pooled tables.
input helps for secreen fields
Field help for screen fields
Set and release locks
WARRING: Domains manage the technical
properties of data elements centrally. They cannot
be used directly in programs, tables, and so on
can be used to define tour own global,
complex data types and global constants.
the are obsolete since release 4.5a.
WARRING: the name of the
type group can contain a
maximum of five characters.
STATMENT : Type-POOL and
the name of data types and
constants begins with zmytp_