Database Table
It helps in create and maintain the tables, table should begin with letter Y or Z and length up to 16 characters.
Tables are defined in the ABAP Dictionary independently of the database. From this table definition follows the creation of the table with the same structure in the underlying database.
Internal Table
An Internal table
is a temporary table gets created in the memory of application server during
program execution and gets destroyed once the program ends. It is used to hold
data temporarily or manipulate the data. It contains one or more rows with same
structure.
Transparent Tables
It contains a single table, used to
store master data.
It has one to one relationship with a
table in database.
For each transparent table there is
one associated table in database.
Pool Tables
They are used to hold a large no. of
very small table(stores customise and system data).
It has many to one relationship with
a table in database.
It is stored in other pool table in a
single table called table pool.
Cluster Tables
They are used to hold data from few
no. of large tables(stores system data).
It has many to one relationship with
table in the database called a table cluster.
It contain less table than table
pools.
No comments:
Post a Comment