0% found this document useful (0 votes)

260 views3 pages

SAP ABAP Database Tables Guide

SAP ABAP database tables are collections of fields organized into columns and rows to store data. There are three main types: transparent tables which have a direct one-to-one relationship with database tables, pool tables which have a one-to-many relationship and are used for internal data, and cluster tables which have a many-to-one relationship and use linear searching. Database tables can be created and managed in SAP using transaction code SE11.

Uploaded by

Henry Santiago Collasos

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

260 views3 pages

SAP ABAP Database Tables Guide

Uploaded by

Henry Santiago Collasos

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 3

SAP ABAP Database Tables

SAP ABAP database tables are collection of fields, in which fields are made up of columns and rows. In SAP
more than 8000 tables are defined. When table is created, its columns are named and data type is supplied for
each columns. There can be only one data value in each column of each row in a table.

To define tables in ABAP dictionary, you need to define fields first, so to define a field, you need to specify
data type, length and description.

Field = Data Element +

Domain

Domain = Data type +

Length
Field = Data Element + Domain
Data Element =
Description
Domain = Data type + Length

Data Element = Description

Types of ABAP database tables

1. Transparent tables
2. Pool Tables
3. Cluster tables

Transparent tables

Transparent tables are used to stare the application’s master data and transaction data.It is a one to one
relationship with the tables in database (SAP database, SQL, Oracle, etc) i.e. the name of table, field names
and the number of fields are similar in both DDIC and database (DB). In real time, an organization mostly
works with transparent tables.
Pool tables

Pools tables are one to many relationship with the database tables. The system follows binary search while
accessing the pool tables. These pool tables are used to store the internal controlling information.

Cluster tables

Cluster tables are many to on relationship with the database tables. The system follows linear search while
accessing the cluster tables.

What is binary search and linear search?

Binary search : – The system divides total records into two equal parts, then the system starts searching in
second half, if the record in not found in second half the system starts searching in first half.

Linear search : – The system starts searching the record from 1st record until the required record in found.
Once the system finds the record, it stops the search.

You can create database tables in SAP ABAP using transaction code SE11.
SAP ABAP

⊩ SAP ABAP Tutorial

SAP ABAP Basics

⊩ SAP ABAP Overview

⊩ SAP ABAP operators

⊩ SAP ABAP Keywords

⊩ SAP ABAP Program structure

⊩ SAP ABAP Syntax

⊩ SAP ABAP WorkBench

SAP ABAP Dictionary

⊩ SAP ABAP data dictionary overivew

⊩ SAP ABAP Views

⊩ SAP ABAP data types