SAP ABAP FOR CLOUD HANA OOPS SQL CDS AMDP BTP ECLIPSE

Define a first ABAP class with definition and implementation blocks, including public, protected, and private sections, and run a runnable hello world example in Eclipse on the BTP ABAP instance.

Explore ABAP data types, including element, complex, and reference categories, and learn how data objects store numeric, character, date, time, and binary values in cloud ABAP.

Explore numeric data types in Web HANA, perform arithmetic operations, understand result type precedence, and apply built-in functions such as abs, sign, round, and sqrt.

Explore character data types in ABAP for cloud HANA, including fixed-length and string types, dates, times, and numeric characters. Learn string operations and functions across descriptive, processing, and predicate categories.

Learn how regular expressions (regex) in ABAP enable pattern-based search and string manipulation. Use PCRE with ABAP functions like match, replace, count, and substring, including email validation.

Explore string templates in ABAP, using pipe-delimited syntax to embed variables and expressions with formatting options for numbers, currency, dates, times, alignment, and case, plus escaping braces.

Learn how ABAP handles constants and literals, use system variables, and apply them to examples like pi, USD, and circle area.

Explore core ABAP control statements including if else, case, do and while loops, exit and continue, and inline checks on internal tables to master flow control.

Learn how hexadecimal data represents binary in ABAP using type X and XString, including fixed versus dynamic lengths and converting between string, XString, and base64.

Learn how ABAP structures group multiple fields into a complex data type, including simple and nested structures, with component selectors to access subfields like employee id, name, and salary.

Master ABAP internal tables as in-memory, non-persistent data structures that handle records with standard, sorted, and hash tables. Perform insert, read, modify, delete, patterns like for in and field symbols.

Explore practical use of standard internal tables in abap, including declaring, inserting, reading by key and index, modifying, deleting, sorting, filtering, and using corresponding statements and mapping.

Understand how sorted internal tables automatically sort by a primary key, enabling faster binary searches and key-based reads, with support for unique or non-unique keys.

Explore hashed internal tables in ABAP, where a unique primary key enables fast key-based access, no duplicates or sorting, and operations like insert, read, and delete are performed via keys.

Discover how ABAP classes define attributes and methods, with global and local scopes, using class definitions and implementations; explore interfaces as contracts and the OADT run as executable entry points.

Define a class and create concrete rectangle instances to show each object has its own attributes. Demonstrate instance methods that use importing, exporting, changing, returning, and raising in ABAP.

Explore class data and class methods, showing how static attributes are shared by all instances, accessed via class name or object, and used for global properties like a counter.

Explore instance and class constructors in oops, showing how instance constructors initialize object state with imported parameters and how class constructors run once before the first access.

Explore inheritance and polymorphism in oops, defining superclass and subclass relationships, method overriding, and downcasting to access subclass features, illustrated with vehicle, car, and supercar scenarios.

Examine inheritance and polymorphism with a vehicle car supercar hierarchy, showing superclass constructors, method overriding, and downcasting through practical object creation and display info in Eclipse.

Explore abstract classes as non-instantiable blueprints with abstract methods, and interfaces as contracts with no implementation; see a concrete class implement and extend them through polymorphism with accelerate and brake.

Master event handling by exploring publisher and subscriber patterns, where order and payment events trigger decoupled notifications through handlers, with dynamic subscribe and unsubscribe.

learn to implement encapsulation by hiding private data, exposing a minimal public api with getters and setters, using constructors, and applying read-only access in practical class examples.

Learn how exception handling in ABAP manages runtime errors using try and catch, distinguishing standard and custom exceptions, and applying cx root as the base for all exceptions.

Understand how ABAP SQL translates to native SQL for SAP HANA via the database interface, with built-in client handling and modern cloud features like CDS and RAP.

Explore the ABAP data dictionary (DDIC) as a metadata repository that bridges ABAP programs and the HANA database, enabling reusable domains, data elements, structures, and transparent tables with CDS views.

Create and manage ABAP database tables in the HANA environment via the ABAP dictionary, defining primary keys, annotations, and client-dependent structures for customer, customer archive, account, and account transaction tables.

Learn how abap open sql handles insert operations, from single-row inserts using a work area to bulk inserts via internal tables, with subqueries and commit handling in SAP HANA.

Master the basics of the SQL select statement to read data from hana tables, including single row fetch, star and specific columns, and loading results into work areas.

Learn to sort results with order by and distinct. Sort by single or multiple columns and combine distinct with order by to produce ordered, unique rows using ascending or descending.

Learn how the where clause filters rows in select statements for reading, updating, deleting, or modifying data. Use operators equal, not equal, between, like, and in, grouping and null handling.

Explore aggregate functions in a select statement, including count, count distinct, sum, average, min, and max, with group by and having to summarize data.

Explore essential string functions in SQL select statements, including lower, upper, concat, left, right, length, replace, and regex-based operations, with practical ABAP examples.

Learn date and time handling in SAP ABAP on SAP HANA, covering date formats, time formats, and functions like extract, add days, add months, and days between for SQL queries.

Learn to perform arithmetic in ABAP SQL select statements using integer, decimal, and floating point types, including plus, minus, multiplication, division, casting as needed, and case when expressions.

Learn how to use inner, left outer, right outer, and full outer joins in sql, with examples across customer, accounts, and transactions, including multi-join and group by aggregation.

Learn how to combine results from multiple selects using set operations like union, union all, intersect, and except, with matching column names and data types, as shown with customer tables.

Learn how to use SQL update and delete statements to modify or remove rows, and master scalar and column subqueries with practical examples.

Explore core data services in SAP, defining semantic data models on the ABAP-HANA stack, and creating CDS views and view entities for ABAP UI5 and OData consumption.

Develop parameterized CDS view entities that accept input parameters to filter data from transparent tables in HANA, enabling reusable views like customer by city and date range for ABAP.

Learn how composite CDS view entities combine data from multiple tables or view entities using inner and left joins and associations to enrich a single view.

AMDB enables sql script based database procedures to run inside HANA, pushing complex logic to the database for high performance, with marker interface and cloud read-only limitations.

Explore CDS table functions implemented by an AMDB class method that ABAP classes call to return a result set through a SQL script, enabling filtered, multi-step data flow.

Learn how windows functions work in sql within abap context, using partition by and order by to compute running totals and rankings with row_number, rank, and dense_rank.

Master aggregate and moving window functions in SAP ABAP for cloud HANA, including sum, average, count, max, running totals, and moving averages with lag and lead.