BC030_App. 6.1

Data Modeling

•

What is data modeling?

•

Entities, attributes, and entity types

•

Data modeling vs. ABAP Dictionary terminology

•

Relationships and relationship types

–

Cardinality

–

Optionality

–

Category

•

Data model hierarchies

•

Linking a data model to dictionary objects

BC030_App. 6.2

Data Dictionary

Real World

Data

Data

Dictionary

Dictionary

Data Model

What is Data Modeling?

BC030_App. 6.3

Uses of a Data Model

BC030_App. 6.4

Entity Type

Order

Basic Components of a Data

Model

Entity

Customer

Attribute

30 S. 17th St.

BC030_App. 6.5

Entity

Customer

Order

Product

BC030_App. 6.6

Attribute

J. Elkins

Customer

30 S. 17th St.

30 S. 17th St.

215-555-8000

215-555-8000

BC030_App. 6.7

Entity Type

Order

Customer

Product

BC030_App. 6.8

Data Modeler/

ABAP Dictionary Terminology

Dictionary

Data Modeler ABAP

Customer:

entity

record

Customer address:

attribute

field

Customers:

entity type

table

BC030_App. 6.9

Customer

Order

Relationships Between Entities

BC030_App. 6.10

Cardinality

One - to - Many

Many - to - Many

One - to - One

BC030_App. 6.11

Order

Order Lines

1 1 A26

Order #

Qty

Part #

1 3

C589

2 1 A26

Many-to-Many Relationships

Primary Key: Order Number

Primary Key: Product Number

Primary Keys: Order Number

Product Number

BC030_App. 6.12

?

Customer

Order

?

Customer

Optionality

BC030_App. 6.13

Dependent Entity Type

Referenced Entity Type

Customer ID

Name

Address

. . .

Order ID

Date of Order

Customer ID

. . .

Customer

Order

Referenced

Dependent

Referenced and Dependent

Entity Types

BC030_App. 6.14

SAP Graphic Notation

BC030_App. 6.15

Customers

Orders

Example Using Graphic

Notation

BC030_App. 6.16

Professors

Students

Practice Using Graphic Notation

I

BC030_App. 6.17

Practice Using Graphic Notation

II

Professors

Students

BC030_App. 6.18

Students

Enrollment

Records

Courses

Practice Using Graphic Notation

III

BC030_App. 6.19

1

C

N

CN

SAP Graphic Notation

with Text Notation

BC030_App. 6.20

1

C

N

CN

1

C

N

CN

1

C

1

C

n

n

:

:

m

m

n

n

:

:

m

m

SAP Text Notation

BC030_App. 6.21

Customers

Orders

1

CN

:

Example Using Text Notation

BC030_App. 6.22

Practice Using Text Notation I

:

Students

Professors

BC030_App. 6.23

Practice Using Text Notation II

:

Students

Professors

BC030_App. 6.24

Students

Enrollment

Records

Courses

:

Practice Using Text Notation III

BC030_App. 6.25

Referential

Hierarchical

Aggregating

?

Conditional-Referential

Specialisation

Category

BC030_App. 6.26

Relationship Category:

Hierarchical

Department

Key:

Department Number

Course

Key:

Department Number

Course Number

BC030_App. 6.27

Student

Key:

Student ID Number

Enrollment Record

Key:

Student ID Number

Course Number

Course

Key:

Course Number

Relationship Category:

Aggregating

BC030_App. 6.28

Department

Key:

Department Number

Professor

Key:

Professor Number

Relationship Category:

Referential

BC030_App. 6.29

Relationship Category:

Conditional-Referential

Department

Key:

Department Number

Professor

Key:

Professor Number

BC030_App. 6.30

Business Customer

Key:

ID Number

Customer

Key:

ID Number

Relationship Category:

Specialisation

BC030_App. 6.31

General

Accounting

Chart of

Accounts

Currency

FI

. . .

.

.

.

.

.

.

Data Model Hierarchies and the

SAP EDM

BC030_App. 6.32

Data

Data

Dictionary

Dictionary

Data Model

Linking a Data Model to ABAP

Dictionary Objects