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