Unit 3

Video Lesson 3.5: ABAP Exercise – Airline Relational Data Model

Learn ABAP

You should now be able to model your data and create transparent tables in the ABAP dictionary to add, edit and delete data. This lesson is an example of an Airline Data Model and how it was created in SAP.

Your assignment is to:

  • Create a relational data model for an airline company that needs to store data from the passengers such as Name, ID, Address and Flight ; data from the flights such as ID, Origin and Destination; and data from the airline company such as ID, Airline Name and Flight numbers assigned to it.
  • Create transparent tables in the ABAP Dictionary to represent your relational model.

Flight Information Relational Data Model

  • ONE Airline can have MANY Flights (1-N)
  • ONE Passenger can have MANY Flights
  • ONE Flight can have MANY Passengers

Video Lesson 3.4: View The Data In Your Table

Learn ABAP

Video Lesson 3.4: View The Data In Your Table

In this lesson you will learn how to view all the data stored in a database table.

In this lesson you will learn how to create transparent tables to model your data.

  • In the ABAP Dictionary, a transparent table is an implemented description of the corresponding database table that contains the actual application data.
  • The fields of the transparent table form the identically-named columns of the corresponding database table.
  • Usually, a structure in the ABAP Dictionary is used to centrally describe structure variables that are to contain the fields of various tables.
  • You can then use these dictionary structures in the ABAP program to define data objects (concrete structure variables) that either serve as temporary data storage in the program or as an interface for the field transport between the screen and ABAP program.
  • With structures however, we refer to component and component type as opposed to field and data element, it is posible to have a structure as the component of another structure.




Video Lesson 3.3: Table Maintenance Generator

Learn ABAP

Video Lesson 3.3: Table Maintenance Generator

You will learn how to create a maintenance generator for your custom tables. The maintenance generator is used to add, edit and delete table entries.

Table Maintenance Generator is a tool used to customize the tables created by end users and can be changed as required, such as making an entry to that table, deleting an entry etc.
In other words, table maintenance generator is a user interface tool which is used to change the entry of the table or delete an entry from the table or create an entry for the table.




Video Lesson 3.2: How to create Tables

Learn ABAP

Video Lesson 3.2: How to create Tables

In this lesson you will learn how to create transparent tables to model your data.

  • In the ABAP Dictionary, a transparent table is an implemented description of the corresponding database table that contains the actual application data.
  • The fields of the transparent table form the identically-named columns of the corresponding database table.
  • Usually, a structure in the ABAP Dictionary is used to centrally describe structure variables that are to contain the fields of various tables.
  • You can then use these dictionary structures in the ABAP program to define data objects (concrete structure variables) that either serve as temporary data storage in the program or as an interface for the field transport between the screen and ABAP program.
  • With structures however, we refer to component and component type as opposed to field and data element, it is posible to have a structure as the component of another structure.




Video Lesson 3.1: Data Modeling and ABAP Dictionary

Learn ABAP

Video Lesson 3.1: Data Modeling and ABAP Dictionary

In this lesson you will get an overview of data modeling, which has to be done
before the application development. Furthermore, you will learn about the basic
descriptive elements in the ABAP Dictionary.

Data Modeling and Descriptive Elements in the
ABAP Dictionary

  • In this lesson you will get an overview of data modeling, which has to be done before the application development. Furthermore, you will learn about the basic descriptive elements in the ABAP Dictionary.
  • You will also find out when and why it is appropriate to use data types (data descriptions) from the ABAP Dictionary.

Data Modeling

  • In the development of business application software, parts of the real world must be represented in data form.
  • We refer to an Entity Relationship Model (ERM).
  • You use this data model as the basis for implementing appropriate table definitions (transparent tables) including their relationships with each other in the ABAP Dictionary.

 

I will build the website you need

Github-alt Linkedin Youtube Envelope
Terms of Business
Ⓒ 2019 Carlos M. Dubon