Docstoc

SAPABAPDATADictionaryData Modeling

Document Sample
SAPABAPDATADictionaryData Modeling Powered By Docstoc
					                       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.1
                 What is Data Modeling?



         Real World




                 Data Model        Data Dictionary
BC030_App. 6.2
                 Uses of a Data Model




BC030_App. 6.3
  Basic Components of a Data Model

                  Customer
                             Entity



                                                         Attribute


                                        30 S. 17th St.

                 Order
                                      Entity Type



BC030_App. 6.4
                            Entity

                 Customer            Product




                     Order




BC030_App. 6.5
                            Attribute


                                         30 S. 17th St.
                 Customer




                             J. Elkins



                                         215-555-8000


BC030_App. 6.6
                       Entity Type
                 Customer      Product




                     Order




BC030_App. 6.7
               Data Modeler/
         ABAP Dictionary Terminology

             Dictionary   Data Modeler    ABAP


      Customer:           entity         record
      Customer address:   attribute      field
      Customers:          entity type    table




BC030_App. 6.8
        Relationships Between Entities

                 Customer




                            Order




BC030_App. 6.9
                        Cardinality




     One - to - Many




     Many - to - Many                 One - to - One
BC030_App. 6.10
           Many-to-Many Relationships
                                       Order Lines
                                 Order # Qty Part #
  Order                           1        1     A26
                                   1       3    C589
                                   2        1    A26
                               Primary Keys: Order Number
Primary Key: Order Number                 Product Number




BC030_App. 6.11
                            Primary Key: Product Number
                             Optionality

                  Customer                 Order




                  Customer                         ?


                  ?

BC030_App. 6.12
    Referenced and Dependent Entity
                Types
                                                Referenced Entity Type

Dependent Entity Type




Customer
Customer ID       Name            Address          ...     Referenced
Order
Order ID          Date of Order   Customer ID      ...     Dependent

BC030_App. 6.13
                  SAP Graphic Notation




BC030_App. 6.14
     Example Using Graphic Notation




        Customers            Orders




BC030_App. 6.15
     Practice Using Graphic Notation I



          Professors




                              Students




BC030_App. 6.16
    Practice Using Graphic Notation II



          Professors




                             Students




BC030_App. 6.17
   Practice Using Graphic Notation III


                            Enrollment
            Students
                             Records




                             Courses




BC030_App. 6.18
                  SAP Graphic Notation
                   with Text Notation

                    1


                    C


                    N


                    CN
BC030_App. 6.19
                  SAP Text Notation


                    n : m
                    1         1

                    C         C

                              N

                             CN

BC030_App. 6.20
          Example Using Text Notation



        Customers                Orders




                    1   :   CN
BC030_App. 6.21
         Practice Using Text Notation I


          Professors




                                Students




                       :
BC030_App. 6.22
        Practice Using Text Notation II


          Professors




                                Students




                       :
BC030_App. 6.23
        Practice Using Text Notation III

                                Enrollment
            Students
                                 Records




                                 Courses




BC030_App. 6.24
                       :
                    Category

                                             ?

     Hierarchical                  Conditional-Referential



                     Referential




     Aggregating                      Specialisation

BC030_App. 6.25
  Relationship Category: Hierarchical




  Department              Course

  Key:                    Key:
  Department Number       Department Number
                          Course Number




BC030_App. 6.26
  Relationship Category: Aggregating


Student

Key:
Student ID Number     Enrollment Record

                      Key:
                      Student ID Number
Course                Course Number
Key:
Course Number



BC030_App. 6.27
    Relationship Category: Referential


Professor

Key:
Professor Number



                            Department

                            Key:
                            Department Number




 BC030_App. 6.28
                   Relationship Category:
                   Conditional-Referential

Professor

Key:
Professor Number



                                      Department

                                      Key:
                                      Department Number




 BC030_App. 6.29
                   Relationship Category:
                       Specialisation

Customer
Key:
ID Number



                                    Business Customer
                                    Key:
                                    ID Number




 BC030_App. 6.30
       Data Model Hierarchies and the
                SAP EDM

                              FI




            General
                                        . . .
           Accounting

                              .    .
                              .    .
                              .    .
Chart of
                   Currency
Accounts


BC030_App. 6.31
         Linking a Data Model to ABAP
               Dictionary Objects




         Data Model




BC030_App. 6.32

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:1/13/2013
language:English
pages:32
About