TYPES OF TABLES IN SAP ABAP.

TYPES OF TABLES IN SAP ABAP. 

There are three types of tables.

1. Transparent Tables

2. Clustered Tables

3. Pooled Tables.

TRANSPARENT TABLES:-  For every table created in Data dictionary (DDIC) there will be table created in database with same name, same no of fields, fields having same names and the order of the fields will be same. That means for every same replica of table or mirror image will be created in Data base. That means it is having one to one relation. By default every table created will be Transparent Table.

CLUSTERED TABLES:- Many tables created in DDIC are stored in single table in data base called table cluster. That means it is having many to one relation. All the tables present in table cluster will have primary key in common.

POOLED TABLES:- In  case also many tables created in DDIC are stored in single table in database called table pool. Hence it also  having many to one relation. Here the tables present in table pool many have primary key in common.

SE11 T-Code is used to create  data base objects which includes tables.

A table can be client dependent or client independent. Table data only client dependent or client independent, but table structure is client independent.

CLIENT:- Client is SAP specific which contains its own master data and its own set of  records. All SE38 programs are client independent programs. That means if a program is written in one client it can be seen all the clients present in the system.

To see all the clients present in a system T-code is SCC4.

If first field of the table is MANDT the table becomes client dependent table, otherwise it becomes client independent table. If the table is client dependent table the data that you enter in one client can not be seen in other clients. If the table is client independent table the data that is entered in one client can be seen all other clients. That means if the table is client independent all table in all clients contain same data.

Every table should have at least one primary key or foreign key. All primary key fields and foreign key fields of a table should be declared first.

Every table field should have DATA ELEMENT and DOMAIN. 

DATA ELEMENT:-  It gives semantic attributes of table field.

Eg:- Short description of table field.

DOMAIN:-   It gives technical attributes of the table fields. Domain is the more reusable component than data element.

Eg:- Type of data it is going to hold.