Friday 25 August 2017

Database Table

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

Domain

A domain describes the technical attributes of a field, such as the data type or the number of positions in a field. The domain defines pri...