ABAP · ABAP Cloud
SAP ABAP Cloud: Data Dictionary
The data dictionary is the foundation of every ABAP development: without well-defined domains, data elements and tables there is no solid persistence. This course builds those foundations in ABAP Cloud (data types, database tables, persistence adjustments, lock objects, dynamic cache and table relationships) with a lab and a test in every block.
What you will learn
By the end, you will be able to do this
- Define domains, data elements and structures (nested, INCLUDE and deep)
- Create table types with secondary keys and nested table types
- Design database tables with technical settings and indexes
- Adjust persistence tables with ALTER, data conversion and data deletion
- Implement lock objects and manage concurrent access
- Apply dynamic cache and model foreign key relationships between tables
Syllabus
7 sections · 52 videos
6 labs · 6 tests · assignments with solutions
01 Data types lab test
- Introduction to the Data Dictionary
- Domain: definition
- Domain: intervals and fixed values
- Data element
- Structures: definition
- Nested structures
- INCLUDE structures
- Table type
- Deep structure
- Table type with a secondary key
- Nested table types
+ Documentation · Lab · Assignment · Solution · Test
02 Database tables lab test
- Concepts
- Database table: definition
- Inserting data
- Technical settings
- Enhancement categories and types
- Delivery classes and data maintenance
- Including structures in tables
- Amount and quantity fields
- Indexes
- Global temporary table
- Development utilities
+ Documentation · Lab · Assignment · Solution · Test
03 Adjustments to Persistence Tables lab test
- SQL Script: CREATE COLUMN TABLE
- Adjustments with ALTER
- Adjustment with data deletion
- Adjustment with data conversion
- Activating indirect changes
+ Documentation · Lab · Assignment · Solution · Test
04 Lock Objects lab test
- Concepts
- Lock object: creation
- Requesting a lock
- Releasing a lock
- Simulation with multiple users
+ Documentation · Lab · Assignment · Solution · Test
05 Dynamic Cache lab test
- Concepts
- Business scenario
- Dynamic Cache: definition
- SQL query with Dynamic Cache
+ Documentation · Lab · Assignment · Solution · Test
06 Relationships between Database Tables lab test
- Concepts
- Foreign key relationships
- Semantic attributes
- Structures with foreign keys
- Activating indirect changes
- Relationship explorer
+ Documentation · Lab · Assignment · Solution · Test
07 Final test and Certificate
- Adding the certificate to LinkedIn
- Final test
- Getting your certificate of completion
Who it is for
Is this course for you?
- ABAP developers starting to model persistence in the cloud
- SAP consultants who need to master the data dictionary
- Technicians supporting data structures and tables
Requirements
What you need to get started
- Basic ABAP: syntax and data types
- Notions of relational databases
- The first block introduces the dictionary and shows how to set up your own practice environment from scratch
Your instructor
SAP architect with 20 years of experience on real projects. He shares what he has learned along the way, with day-to-day examples.
Training used by SAP professionals in banking, industry, retail, and the public sector.
Path · ABAP Cloud: Advanced Programming
Other courses in this certification path
Fundamentals
FundamentalsSAP ABAP Cloud SQL
View courseIntermediate
IntermediateSAP ABAP Cloud: Object-Oriented Programming
View courseIntermediate
IntermediateSAP ABAP Cloud CDS: Core Data Services
View courseIntermediate
IntermediateSAP ABAP Cloud ATC and abapGit
View courseAdvanced
AdvancedSAP ABAP Cloud Push Down
View courseFrequently asked questions
How do I get access to this course?
With a Logali Tech subscription (courses are not sold individually). The Free plan opens the first three sections of every course; Standard and Premium unlock the full course. See Pricing.
Do I need my own SAP instance?
Logali Tech does not provide access to SAP systems. In most of the training you do not need your own license: hands-on work is done on a free SAP BTP Trial account that you create, and the course walks you through setting it up step by step. For the On-Premise courses (classic ABAP, Web Dynpro, ALV, Adobe Forms and Fiori administration) you can run the free trial system that SAP makes available (ABAP Cloud Developer Trial) on your own infrastructure, or use the SAP system in your own company environment.
Are there live classes?
Recordings are available 24/7. Live classes and live master programs are included in the Premium plan.
Do I get a certificate?
Yes. When you complete the course you earn a certificate of completion that you can add to your LinkedIn profile.
Start this course today
The first three sections are free. With a subscription you get this full course and the entire SAP catalog.