Understanding ABAP Dictionary

Understanding ABAP Dictionary

by Alex Gonczy

Build your flexible, consistent and reusable SAP database with me through practical exercises. If you want to get familiar with the concept of Domains, Data Elements, Structures, Table Types, Database Tables, Views, Maintenance Dialogs, Two-Level Domain concept, or Foreign Key Relationships, and you want to see them working in a real SAP system, then this course is for you.

  • Level: Beginner
  • Duration: 4h 14m

Who this course is for ?

  • Beginner ABAP Developers
  • Junior ABAP Developers
  • Who has no experience in ABAP Dictionary
    Watch on Pluralsight

Course Outline

Overview

In this module, I will give you a brief introduction about the complete course, I will introduce you the structure of the course, and who this course is for, then at last we will talk about the business example as well.


Clips

  1. Introduction
  2. Who This Course Is for
  3. Business Example
    Watch on Pluralsight

Overview

Using ABAP Dictionary, we get a nice, and user-friendly UI for maintaining our database objects, we get a central meta-data repository, where we can manage our data definitions, we are able to ensure the data integrity and consistency among the different entities, and at last we are able to decrease the implementation and maintenance costs via reusing existing definitions, and thanks to the centralized maintenance. In this module, we are going to talk about the Role of the ABAP Dictionary, its containing elements, and we are going to check each of them in the system as well. At last we are going to take over the development workflow of the course.


Clips

  1. Overview
  2. The Role of the ABAP Dictionary
  3. The Elements of the ABAP Dictionary
  4. Demo: The Elements of the ABAP Dictionary
  5. Development Workflow ABAP Dictionary
  6. Summary
    Watch on Pluralsight

Overview

In this module, I am going to introduce you, the basics of the Two-Level Domain Concept, we are going to talk about how we can decrease the development costs, and how we can ensure data or meta-data consistency with this concept. Next, we will go through on the development workflow, that we are going to follow in the demo section. At last, in the demo section, we are going to create some of the domains together, and the rest of them individually.


Clips

  1. Overview
  2. Two-Level Domain Concept: Domain
  3. Decrease the Maintenance Cost with Domains
  4. Provide Consistency with Domains
  5. Development Workflow: Domain
  6. Group Exercise: Creating ZOSTATUS
  7. Group Exercise: Creating ZDATE
  8. Group Exercise: Creating ZPRICE
  9. Group Exercise: Creating ZEMAIL
  10. Individual Exercises
  11. Summary
    Watch on Pluralsight

Overview

In this module, I am going to introduce you, the other participant of the Two-Level Domain Concept – the Data Elements, and we are going to talk about the development workflow, that we are going to follow in the demo section. Then, in the demo section, reusing the existing domains, that we created in the previous module, we are going to create some data elements together. At last, using your newly acquired knowledge, you are going to create the rest of the data elements individually, with the help of the definition cards.


Clips

  1. Overview
  2. Two-Level Domain Concept: Data Element
  3. Development Workflow: Data Element
  4. Group Exercise: Creating ZHOUSENUM
  5. Group Exercise: Creating ZFSADDR
  6. Group Exercise: Creating ZFBADDR
  7. Individual Exercises
  8. Summary
    Watch on Pluralsight

Overview

In this module, I am going to introduce you, the first complex data type in the ABAP Dictionary, the Structures. Then, we are going to talk about the different type of structures and their specificities. After that, we are going to talk about that should we define our structures locally in our ABAP programs, or globally in the ABAP Dictionary, and we are going to talk about the development workflow, that we are going to follow in the demo section. Then, in the demo section, reusing the existing data elements, that we created in the previous module, we are going to create a structure together, and then, using your newly acquired knowledge, you are going to create the rest of them individually, with the help of these definition cards.


Clips

  1. Overview
  2. Complex Data Types: Structure
  3. Development Workflow: Structure
  4. Group Exercise: Creating ZORDER_STR
  5. Individual Exercises
  6. Summary
    Watch on Pluralsight

Overview

In this module, we are going to talk about the Table Types, but in order to understand the role of the table type in the ABAP Dictionary, first I’m going to introduce you the runtime object, called Internal Table. Then we are going to discuss, that how we can define the line type of a table type, what’s the differences among the various access modes, and how we can define the keys for a table type. Then to summarize that we have learned up to now, we are going to talk about how to use the different data types, like data element, structure, and table type in our ABAP programs. Next, we will go through the development workflow, and talk about what kind of objects, we are going to create in the demo section. Then in the demo section, first we are going to create an Orders, and at last an Order Items table type.


Clips

  1. Overview
  2. Complex Data Types: Table Type
  3. Development Workflow: Table Type
  4. Group Exercise: Creating ZORDER_TT
  5. Group Exercise: Creating ZORDERITEM_TT
  6. Summary
    Watch on Pluralsight

Overview

In this module, we will talk about what we have already done in our ABAP Dictionary, and what is ahead of us in the future modules, I will give you a brief introduction about the logic behind database tables in the ABAP Dictionary, and we will go through and talk about the attributes of the database tables. We will go through the different development workflows, then in the demo sections, we will create some database tables, set some value tables for domains, and then set some foreign key relationships for database tables together.


Clips

  1. Overview
  2. Database Objects: Database Table
  3. Development Workflow: Database Table
  4. Group Exercise: Creating ZAUTHOR
  5. Group Exercise: Creating ZORDER
  6. Individual Exercise: Creating Database Tables
  7. Value Table
  8. Group Exercise: Set Value Table for ZCUSTOMERID
  9. Individual Exercise: Set Value Tables for Domains
  10. Foreign Key Relationship
  11. Group Exercise: Set Foreign Key Relationships for ZORDERITEM
  12. Individual Exercise: Set Foreign Key Relationships
  13. Summary
    Watch on Pluralsight

Overview

In this module, first I will introduce you what the Views are, then we will go through their attributes one by one, next we will check what type of Views we have in our ABAP Dictionary, and then we will talk about the Development Workflow. In the demo section, first we will create a database view together, for displaying the Orders of our Customers, then using this knowledge, you will create another view individually in the system, for displaying the different Addresses.


Clips

  1. Overview
  2. Database Objects: View
  3. Type of Views
  4. Development Workflow: View
  5. Group Exercise: Creating ZORDER_V
  6. Individual Exercise: Creating Views
  7. Summary
    Watch on Pluralsight

Overview

In our closing module, we will talk about a very useful tool, named Table Maintenance Generator, then we will go through on its Modification options one by one. In the first demo section, we will generate a Maintenance Dialog together for the table, Author. Then, in the second demo section, I will show you the transaction, where we can maintain our tables, and we will fill up the table, Author together with sample data.


Clips

  1. Overview
  2. Maintain Database Tables in an Easy Way
  3. Development Workflow: Maintenance Dialog
  4. Group Exercise: Creating Maintenance Dialog for ZAUTHOR
  5. Individual Exercise: Creating Maintenance Dialogs
  6. Group Exercise: Fill ZAUTHOR Up via Maintenance Dialog
  7. Individual Exercise: Fill Tables Up via Maintenance Dialogs
  8. Summary
  9. Course Summary
    Watch on Pluralsight

Bonus Content

We need your request...

What is a Bonus Content ?

Once our course, Understanding ABAP Dictionary is published, we don't stop working on it. Based on your feedback in Pluralsight and comments in the Discussion Board, we collect all of the important tools and additional resources that can be necessary and helpful for you before or after watching this course. That's what we call Bonus Content.

The access to the content is FREE. You need to give your email address so that we can send them to you, as soon as a piece of the content is ready.

Comment below and suggest a Bonus Content

Subscribe for the first content update

Discussion Board