Dictionary Chapter 04

background image

BC030_2.04.1

ABAP Dictionary Tables

in Relational Databases

background image

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

background image

BC030_2.04.3

SAP Table Types

Transparent Table

(TRANSP)

Structure (INTTAB)

Pool Table

Cluster Table

View

background image

BC030_2.04.4

Transparent Tables

Type = TRANSP

Master Data

Master Data

background image

BC030_2.04.5

Table Type TRANSP

in the Database

DB

PROFILE

background image

BC030_2.04.6

Mapping a Table of Type INTTAB

DB

x

x

PROFILE

background image

BC030_2.04.7

Pool and Cluster Tables:

Overview

Pool Table

Cluster Table

Cluster Table

background image

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

background image

BC030_2.04.9

Master data

User data

Data Class

Organization and

Customizing data

Transaction data

DB

background image

BC030_2.04.10

Size Categories

background image

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

background image

BC030_2.04.12

Logging

background image

BC030_2.04.13

Maintaining Technical Settings

Data Class

Size
Category

Buffering
Type

Logging

background image

BC030_2.04.14

ABAP

ABAP

Diction

ar

Diction

ar

y

y

DB

Database Utility

background image

BC030_2.04.15

Index

background image

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

background image

BC030_2.04.17

The Telephone Book Analogy

background image

BC030_2.04.18

The Telephone Book Analogy

(Continued)

background image

BC030_2.04.19

The Index Range Scan

background image

BC030_2.04.20

The Unique Index Scan

background image

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

background image

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


Document Outline


Wyszukiwarka

Podobne podstrony:
Dictionary Chapter 07
Feynman Lectures on Physics Volume 1 Chapter 04
Dictionary ChapterExercise
Dictionary ChapterExercise
Dictionary ChapterExercise
Dictionary Chapter 02
Dictionary ChapterExercise
Dictionary Chapter 03
Dictionary ChapterExercise
Dictionary Chapter 01
Dictionary Chapter 08

więcej podobnych podstron