BC030_2.04.1

ABAP Dictionary Tables

in Relational Databases

BC030_2.04.2

Objectives

•

The participants will be able to:

–

Describe the different types of tables in
the SAP ABAP Dictionary

–

Explain the technical settings for
optimizing the storage and maintenance
requirements

–

Describe indexing performance benefits

BC030_2.04.3

SAP Table Types

Transparent Table

(TRANSP)

Structure (INTTAB)

Pool Table

Cluster Table

View

BC030_2.04.4

Transparent Tables

Type = TRANSP

Master Data

Master Data

BC030_2.04.5

Table Type TRANSP

in the Database

DB

PROFILE

BC030_2.04.6

Mapping a Table of Type INTTAB

DB

x

x

PROFILE

BC030_2.04.7

Pool and Cluster Tables:

Overview

Pool Table

Cluster Table

Cluster Table

BC030_2.04.8

Master

Transaction

Organization &

Customizing

User

Technical Settings

Data class

Number of data records in
Database storage

Single records,
generic, full, not
buffered

On or off

Size category

Buffering

Log data changes

BC030_2.04.9

Master data

User data

Data Class

Organization and

Customizing data

Transaction data

DB

BC030_2.04.10

Size Categories

BC030_2.04.11

Buffering Type

None

Single Record

Generic

Full

KF1 KF2

KF3 F4 F5 F6 KF1 KF2

KF3 F4 F5 F6

KF1 KF2

KF3 F4 F5 F6

BC030_2.04.12

Logging

BC030_2.04.13

Maintaining Technical Settings

Data Class

Size
Category

Buffering
Type

Logging

BC030_2.04.14

ABAP

ABAP

Diction

ar

Diction

ar

y

y

DB

Database Utility

BC030_2.04.15

Index

BC030_2.04.16

Index

Table

Last Name First Name Pointer

Adams

Anthony

ID

Last Name First Name Salary

Zelkova

Zephyr

Employee Names

Employees

Database Indexes

Burrows

Jones

Furia

Peters

Treske

Gregory

Gerry

Fred

Tim

Jimmy

Beth

Carolin

BC030_2.04.17

The Telephone Book Analogy

BC030_2.04.18

The Telephone Book Analogy

(Continued)

BC030_2.04.19

The Index Range Scan

BC030_2.04.20

The Unique Index Scan

BC030_2.04.21

Evaluating the Various

Types of Scans

Unique Index Scan

Unique Index Scan

Index Range Scan

Index Range Scan

Full Table Scan

Full Table Scan

BC030_2.04.22

Summary

•

The participants should be able to:

–

Describe the different types of tables in
the SAP ABAP Dictionary

–

Explain the technical settings for
optimizing the storage and maintenance
requirements

–

Describe indexing performance benefits