SAP ABAP, BTP CAPM, RAP, OData, ABAP on Hana, UI5 Fiori BAS

Learn the basics of HTML, a markup language for web pages. Explore the doctype, html root, head and body, and tags like title, p, center, bold, h1-h6, and a href.

This session covers forms in HTML, building a form with labels and inputs for username and password, a submit button, and posting to a target page URL.

Explore the fundamentals of CSS, including inline, internal, and external styling, and learn how selectors such as id and class control styling across HTML elements with practical examples.

Explore the document object model and how JavaScript embeds in HTML to manipulate content. Learn to identify element references with ID, class, and tag selectors and update DOM using innerHTML.

Learn how to define and call user defined functions in JavaScript, including internal and external functions loaded via script tags, with parameters and return values.

Explore manipulation of the document object model elements, create dynamic and static buttons, and handle onload and onclick events to dynamically add and remove list items.

Validate html form data by enforcing mandatory username and password on submit, and store the username in local storage via a custom.js for display on the home page.

Explore predefined Java objects, focusing on arrays and dates, and apply properties and functions like push, length, sort, indexOf, splice, get day, get month, and get full year.

Explore creating user defined JavaScript objects in three procedures: using new with properties and getters/setters; using object literals; and inline object with getter and setter methods.

Create a user defined prototype to show how JavaScript objects inherit properties and functions from a prototype, and how to add properties and getter/setter methods.

Explore regular expressions in JavaScript to validate html form inputs, learn pattern syntax with anchors and slashes, and test practical examples like username, mobile, and email validations.

Learn jQuery, a predefined JavaScript library that follows write less and do more, and see how to hide an h1 on click with a single line.

Learn to set up a SAP BTP trial account, authenticate via universal ID, access the BTP cockpit, launch SAP Business Application Studio, and create a dev space for application development.

Create your first SAP UI5 freestyle app by using a template-based setup, configure a Northwind OData destination, and scaffold a project with a home view and manifest.

Explore how to start using UI5 controls in a custom app by leveraging SAP demo kit components, copying source code, and binding an OData service to an object list item.

Demonstrates using the UI5 layout editor to drag and drop controls, switch from the text editor, bind a list to the customer entity set, and customize title, description, and icon.

Learn to make use of multiple libraries' controls using alias, declare aliases, prefix controls with the alias, and verify whether source code uses the alias rather than hardcoded library names.

Learn to build a SAP UI5 simple form with placeholders, buttons, and drop-down fields bound by i18n. Explore alias usage, layout editor, and hardcoded versus backend populated dropdowns.

Explore the mvc design pattern—model stores data, view renders the UI, and controller handles input and business logic with data binding across XML, JS, or JSON views.

Identify suitable model types, including client side JSON, XML, and resource models, and the server side OData model, then instantiate, load data, and bind to controls.

Explore the four SAP UI5 view types—XML, JSON, JS, and HTML—showing how each defines the UI structure and layout and separates presentation from business logic.

Master the controller lifecycle hooks, on init, on before rendering, on after rendering, on exit, on before show, and on after show, and their roles in setup, rendering, and cleanup.

Learn data binding modes and types, and master the path rules to derive data addresses by converting curly braces to slashes and suffixing arrays with indices.

Fetch orders data from the Northwind OData service into a JSON model in the controller on init, and bind it to the XML view to display the orders.

Learn how formatters format data before UI display in SAP UI5. Create formatter functions in the controller or utils/formatter.js and bind them to views for dates and currencies.

Explore standard CSS classes, custom CSS classes, and individual CSS in SAP UI5 apps, attach custom styles via style.css to labels and controls, and preview runtime updates.

Make input fields mandatory in a SAP ABAP on cloud RAP UI5 app by enabling the required property at the label, validating with a save press, and trimming spaces.

Learn to implement a message box in the application, using alert, confirm, error, info, warning, and success messages that appear in the middle of the screen based on field validation.

Attach F4 value help to an input field using a fragment in SAP UI5, display a customer ID select dialog, and handle value help requests via a fragment-based dialog.

Develop a real-time SAP ABAP on Cloud RAP app with OData service, deep insert for vendor and product data, and filter and sort capabilities along with essential UI features.

Create a database table in ABAP dictionary and expose it as an OData service. Register the service in the SAP gateway and review the metadata and runtime artifacts.

Link the BTP cockpit front end to the on-premise OData service via Cloud Connector, then configure sub account, virtual mapping, destination, and authentication data to enable secure calls.

Learn how to consume an OData service in BAS, from gateway metadata to implementing vendor set get entity set in ABAP, and binding data to a UI5 Fiori table.

Compare the OData model and JSON model, including when to fetch data from the backend versus storing it in browser memory, and how to bind entity sets.

Process data at the UI level with a JSON model, reading from the entity set and adding a concatenated vendor name and product type column before binding to the UI.

Enable vertical and horizontal scrolling by wrapping the table in a scroll container and enabling the scroll properties. Adjust column widths with rem-based settings for a responsive table.

Switch from json to odata models for ui data, implement a formatter in formatter.js, bind to the vendor set, and prefix vendor names with miss.

Color text in a SAP UI5 table based on a status column using object status and path formatter; display vendor IDs in green when active and red when not active.

Explore date time formatting with the standard SAP UI core date format class, using getDateTimeInstance and format to produce patterns like weekday, month, date, year, with locale settings.

Learn to implement a rating indicator in SAP UI5 by binding its value to an OData model, and setting max value, tooltips, and icon size for flexible ratings.

Design a SAP UI5 table with checkboxes for multi-select, add a download button, and export the selected rows to an excel file using workbook, data source, and spreadsheet library.

Build a range-based filter for vendor data in a SAP ABAP on cloud RAP app, using min and max inputs, gateway filtering, and a UI5 app with search and clear.

Learn to implement multi-criteria filters using comparison operators in ABAP on cloud RAP, with OData services and a UI5 Fiori app, applying vendor id and turnover conditions together.

Learn to implement date-based filtering from gateway to frontend by adding a start date filter, using GE operator, and converting to UTC to resolve time zone issues.

Explore sorting in SAP ABAP on Cloud RAP with UI5 Fiori: design front-end controls for sort field and order, and implement multi-field order by on the backend.

Learn to navigate between two views in a UI5 app, transfer a selected record from view one to view two, and display vendor details using an OData service.

Navigate between views following a route pattern, transfer data, and dynamically toggle fields to display-only or editable, with the vendor id as non-editable primary key in create and edit flows.

Learn to implement route pattern mode by adding an edit button and routing to an edit view. Keep the vendor id read-only while making other fields editable.

Explore the route pattern mode create, guiding navigation to a second view with blank, editable fields. Learn to clear data before create and enable proper binding, ensuring the form opens fresh and ready for input.

Enable the show navigation button on the second view and wire its press event to return to the first view using the router, replacing the browser back button.

Bind the edit and delete button visibility to a JSON model, showing them only in display mode, and trigger navigation to edit mode with the vendor id via the edit button.

Create operation in a SAP UI5 app: enforce mandatory vendor id, collect inputs, send a create request to the vendor set, format start date for backend, and handle responses.

Implement status validation in a SAP UI5 form using a dropdown to enforce uppercase active or not active, binding the selection with the selected key to OData.

Apply email validation on the email ID field using a regular expression pattern, integrate it into the save flow, and show a warning if the input is invalid.

Implement on-save phone number validation that accepts only digits, enforces exactly ten characters, and uses a start-to-end anchored regex with digits, triggering a clear error message when invalid.

Master dynamic title changes in a UI5 Fiori app by mode: display, edit, and create, updating the toolbar title to show the vendor ID or create new vendor text.

Enable the table growing feature to display the first five records and show more in batches, by setting growing to true and adjusting the growing threshold.

Explore the update operation in SAP ABAP on cloud RAP with OData and UI5, implementing mode-based save for create or update and comparing existing with updated data.

Debug and implement pattern matched update checks for an SAP UI5 OData app. Ensure date formatting uses ISO and detects unchanged records.

Implement a delete operation in a SAP UI5 Fiori app by wiring the delete button, confirming with a dialog, and sending a backend remove request using the vendor id.

Learn to prevent duplicate records in sap abap on cloud rap by validating vendor id on the frontend using OData checks before create, and warn users when a match exists.

Learn to delete multiple selected records in a single batch by reading selection, forming a deferred batch group, confirming actions, and submitting batch deletes to the back end.

Learn to create multiple records by uploading an Excel file in a SAP UI5 app, using a dialog, file uploader, mime types, and back-end batch processing.

Add instruction text to the file uploader dialog to guide users to verify the Excel date format before uploading.

Learn to define an association between vendor and product with one-to-many cardinality and implement navigation properties on the principal vendor to access its products in an OData service.

Display product details from a dependent entity using a navigation property, binding a ui5 table dynamically to the selected vendor ID via the odata model.

Navigate vendor list to product details in a SAP UI5 app, fix lazy loading by binding data on first load, and pass vendor and product IDs to a third view.

Upload pdf files from a UI5 front end to a RAP OData service, creating a pdf file entity in a backend database table linked to vendor and product.

Display pdf files stored in the backend by reading them via an odata read operation in a UI5 Fiori app, showing file id, name, size, and a download option.

Download uploaded pdfs to your local system using pure JavaScript: identify the clicked row, decode base64 to binary, and trigger a blob-based download.

Create deep entities up to three levels in SAP OData with a single request that creates a vendor, its products, and PDF files using a UI5 table and JSON model.

Continue deep entity creation to three levels by implementing the on save flow to collect form data, multiple products, and PDF files, then send an OData payload to the backend.

Explore implementing create_deep_entity in ABAP back end for SAP ABAP on Cloud RAP, handling nested vendor, product, and file data via OData and UI5 integration.

Enforce validations for deep insert: mandatory vendor id, at least one product, and matching vendor ids across the main form and product rows, using every, some, and map.

Apply the sixth validation by checking for an existing vendor ID before create, reading the backend with the model, filtering by vendor ID, and creating only if no record exists.

Re-enables update after deep insert by revising on save to support create and update modes, adding create-only validations, and implementing an internal update of vendor details via OData path.

Learn to update dependent product data in a SAP ABAP on cloud RAP app, linking vendors to products and navigating to view three with vendor and product keys.

Delete dependent records when deleting a vendor, so products and PDF files are removed with the parent by cascading the delete in the backend using the vendor ID.

Create vendor records with multiple products by uploading an Excel file, validating vendor and product IDs, and using a deep insert payload with batch submission.

Learn to download selected vendor records along with their dependent products into an Excel file using a recursive fetch, handling vendors with or without products.

Explore implementing a busy indicator and a progress counter in an SAP UI5 app, providing visual feedback during long tasks like data reads and Excel exports to prevent double clicks.

Implement a password visibility button in a SAP UI5 app, toggling the password input between masked and text and updating the icon and tooltip.

Copy to clipboard button in a web app reads input text and uses navigator.clipboard.writeText to copy to the system clipboard, with user feedback.

Learn to add a header toggle button in a SAP Fiori UI5 app to switch between light and dark modes by reading the toggle state and applying themes.

Design a font size slider from 0.5 to 2.0 with live change, applying new sizes via rem units to text and UI elements across the page.

Learn to consume a third party api in a sap application by fetching weather data from openweathermap for a clicked location and displaying it.

Explore ABAP on HANA fundamentals, prerequisites, and course content covering HANA database objects, ADBC, ALV with IDA, CDS views, and ABAP on HANA development.

Compare data-to-code versus code-to-data and show how HANA executes business logic at the database level, leveraging CDS views and MDPs and features like in-memory processing, multi-core performance, and data compression.

Explore the differences between row storage and column storage in SAP HANA, including when to use each, memory efficiency, data compression, and indexing for analytics and updates.

Explore the Hana Studio overview, connect to the Hana database, switch between development, ABAP, and debugger perspectives, and use the SQL console to create tables and manage schemas.

Create, drop, and insert data into HANA tables using HANA Studio's SQL console; explore column store vs row store and practical table definitions with pincode and city name.

Examine local and global temporary tables in ABAP: learn their lifetimes, session scope, and accessibility, including creating local with hash prefix, inserting data, and structure persistence.

Master sorting data with the order by clause in SAP ABAP on HANA, using single or multiple fields, ascending or descending, and avoiding column positions.

Learn to filter data with the where clause and comparison operators in ABAP, including equal to, not equal to, and between, and combine with order by to sort results.

Learn to filter data with the where clause using and or, manage precedence with parentheses, combine city type and state name, and apply order by for metro and semi metro.

Learn to filter data with in and not in operators in ABAP, using select statements and dynamic where clauses to retrieve or exclude multiple state numbers.

Filter data using the like operator with percent and underscore wildcards to match patterns in city names and pin codes, starting with k and at specific positions, noting performance considerations.

Learn about the dummy table, a temporary SAP runtime table created and deleted automatically, used to store intermediate results for testing queries and calculations with flexible structure and no persistence.

Learn to include calculated and derived columns alongside physical table columns. Use math expressions and concatenation, such as updated_state_number and concatenated city name and state name.

Learn to create a calculated column using a case expression to classify total amount in a sales data table, returning no approval needed, approval needed from manager, or from GM.

Learn to use subqueries in a single select statement to fetch employee data with the department name from the dept table, using an inner select on department number.

Demonstrates update and upsert in SAP ABAP with an emp ten table, showing update with where and upsert inserting when missing and updating on match.

Learn how to delete specific records with delete from where id is three, and how drop table removes the entire table, demonstrated on a test table.

learn how to apply a not null constraint in a database table by making the pincode column not null, preventing null values during inserts of city data and surfacing errors.

Learn how the primary key constraint combines not null and unique rules to prevent nulls and duplicates, shown by declaring pin code as the primary key.

Create custom schemas and manage where objects are stored, using create schema, set schema, and schema-qualified names in the SQL console, with India schema as an example.

Learn to drop not null and primary key constraints in SAP HANA by identifying the constraint name via constraints view, then apply alter table drop constraint or drop primary key.

Learn to re-impose a primary key constraint on an existing table with alter table add constraint after removing nulls and duplicates via delete statements, and verify constraints in system views.

Learn how a unique constraint in SAP HANA enforces non-duplication while allowing nulls, contrasts with the primary key, and demonstrates adding, dropping, and inspecting constraints in the Hana studio.

Implement a check constraint on the budget column by using alter table to add the constraint, then verify enforcement with update and insert operations that demonstrate constraint violations.

Learn to define a composite primary key across multiple columns, create and alter tables to enforce composite primary key constraints, and verify the constraint using system views.

Import data from a local Excel or CSV file into the sales data table using SAP Hana quick view, mapping product id, product name, quantity, and total.

Apply the string_aggregate function to group and concatenate employee names by department number, using a comma separator, demonstrated with the EMP table.

Explore the replace underscore regular expression function in ABAP to clean pincode data by removing braces, hyphens, spaces, and other unwanted symbols.

Explore the avg and coalesce functions using a sample ABC two table to compute budget averages and show how coalesce treats null values as zero.

Demonstrates two_underscore_decimal to restrict decimals to two places and uses round to explicitly round values in ABAP, showing a budget example and implicit versus explicit rounding.

Learn how to use intersect and except set operators to retrieve common and exclusive records between two similarly structured tables in ABAP on cloud RAP.

Learn how to rename a column and add comments on columns and tables using the gateway sql console and schema in SAP ABAP on Cloud RAP.

Demonstrate foreign key constraints in a relational setup, linking parent and child tables, and explore on delete cascade, update restrict, and referential constraint details with practical examples.

Learn how to enforce referential integrity without foreign keys in SAP HANA by using triggers, including before insert checks on parent and child tables and user-defined exceptions.

Maintain referential integrity without foreign keys by using triggers to prevent deleting a parent row when child records exist, raising a user-defined exception.

Explore SAP HANA database views in ABAP on cloud, learning how virtual views project and select data from one or more tables at runtime for secure access.

Explore how an instead of trigger enables DML on a view built from city and state tables, routing inserts to the base tables and validating results in HANA.

Alter database views to rename and add columns, then enforce constraints with check option, demonstrating creation, querying, and restricted inserts.

Learn to implement multiple data manipulation statements in a trigger before insert or update. Use new row and old row references to enforce state number rules and raise errors.

Explore joins in Hana, including inner, left outer, right outer, full outer, referential, and text joins, with examples using customer and sales order tables.

Explore creating a SAP HANA table using the user interface, including naming, schema selection, column definitions, and primary key options, and compare with SQL console creation, plus UI editing drawbacks.

Create views with the UI in SAP ABAP on Hana, building single- and multi-table views with synonyms, and configuring inner and left outer joins to surface data.

Learn how HANA sequences auto generate numbers, with start, increment, and max values, attach to tables, and monitor current values using SQL console or UI, including cache and cycle behavior.

Explore how SAP HANA indexes optimize data retrieval, focusing on primary and secondary indexes, and creating unique, B-tree, and CP-B-tree variants.

Understand B-tree and CPB tree indexes in SAP ABAP, including how binary search builds a tree and how unique indexes differ from B-tree indexes by constraints and data types.

Learn how a SAP HANA procedure is a reusable database object of SQL statements with in and out parameters, and how to create, call, and consume it in ABAP.

Learn to use a cursor in a Hana ABAP procedure to update metro budgets by 5% and non-metro budgets by 10%, populating CB_metro and CB_non-metro.

explains cursor for loop usage in abap to update city budget by state, increasing by 10% when budget is under 15000, otherwise 5%, using input state number and output tab.

Explore table type as an internal table structure at the database level and its use as a procedure return type, database table or table type, with sql and ui creation.

Create a table type using UI by navigating to tables, selecting table type, naming the type, adding columns such as pin code and name, and executing to confirm creation.

Demonstrate a table type example in SAP ABAP on Hana, returning five columns including education budget via a procedure with a table type out parameter and state number based budgeting.

Learn how the handler block enables exception handling in ABAP Hana procedures, using input and output parameters to insert data, return meaningful messages, and manage duplicate key errors.

Explore arrays in ABAP on HANA: compare arrays with internal tables, and learn to use array_aggregate to convert a table column into an array, with index behavior and practical demonstrations.

Learn how unnest converts one or more arrays into an internal table and how cardinality returns the highest index, with ABAP examples using internal tables and arrays.

Learn to create a column view on top of a procedure, returning 11-column data via a table type out parameter, including concatenating customer names and extracting order date components.

Create a stored procedure in a standard way within a package and store it in sis schema. Then create a database procedure proxy and consume it from ABAP report.

Explore HANA synonyms as alias names for tables, views, procedures, and sequences, including public and private types, with examples of creating, using, and dropping them to simplify queries.

Understand the differences between procedures and functions in hana, including read-only function calls versus read-write procedures, and the scalar and table udf variants.

Explore scalar user defined functions in SAP ABAP on cloud, mastering function creation, in parameters, returns, and calling with select statements to retrieve single or multiple results.

Learn to implement a table user defined function that returns a table type, call it from a procedure, and manipulate with arrays before upserting and inserting into tables.

Explore AMDP, ABAP managed database procedures, and compare bottom-up vs top-down approaches for SAP Hana, including licensing and 7.4 recommendations.

This lecture introduces amdp classes and methods, contrasts them with normal ABAP classes, and explains the required HDB marker interface and ADT studio usage.

Create an amdp class implementing hdb marker interface with cust_loan_mtd to fetch gd_loan and compute interest by days between loan date and due date, mapping priority to low, medium, high.

Demonstrates building an ABAP MDP class and MDP method, invoking Hana database stored procedures, and retrieving data from VB and VBAP tables via parameter passing for optimized performance.

Convert the select option to a string, pass it to an amdp method, and fetch data from VB and VBAP with an inner join for a report.

Learn how an AMDP method can return multiple result sets from two tables, using importing and exporting parameters, table types, and consuming the class in ABAP.

Learn to call an AMDP method from another method within the same class in ABAP, passing an importing id and handling results in internal tables.

Learn client handling in an amdp method, noting platform does not enforce client scope by default. Use session_context or pass an mdt parameter to limit data to the logged-in client.

Learn how to implement create and read operations with the AMDP method in SAP ABAP, contrasting it with CDS views, including internal table usage, DML execution, and returning updated data.

Learn to handle exceptions when calling an AMDP method in ABAP: use try and catch, manage unique constraint violations, and display custom or standard messages from the exception class.

Demonstrates update and delete operations using the AMDP method, showing simple update and delete statements on the g_woman table with the key Radha and verifying results.

Learn to use adbc in SAP ABAP to run HANA queries and procedures, set up connections, execute selects, bind parameters, process result sets, and close connections via eight essential steps.

Learn how to bind input parameters in a select query using ADBC in SAP ABAP, including preparing the where clause, registering parameters, executing native SQL, and handling the result set.

Learn how to consume a stored procedure in SAP HANA using the ODBC framework and the ADBC framework, with parameter binding and invoking execute_procedure in a configured HANA schema.

Learn to execute DDL and DML statements using the ODBC framework in ABAP, including creating, dropping, and inserting data into a Hana database via a selection-screen interface.

Learn about alv ida, the integrated data access variant of the abap list viewer, and its database level processing and performance advantages over classical alv, via three steps.

Learn to set a custom ALV report title and enable the alternating zebra row pattern using the display option interface and its instance methods in ABAP.

Explore retrieving data from multiple tables by creating a database view over two tables and feeding its name to the ALV IDA framework for read-only display of the selected fields.

Manipulate the field catalog in the lv id framework to customize column headers, such as customer first name, and disable sort and filter in the alv context menu.

Learn to add custom calculated fields to an ALV report by implementing the interface methods get_calculated_field_structure, get_required_field, and calculate_line, and integrating a custom class.

Learn how to manipulate the alv toolbar in abap by using the standard_function interface to disable print, excel export, and filter buttons with set_print_active, set_export_active, and set_filter_active.

Learn how to hide the complete ALV live toolbar by using the if_slv_gi_toolbar_id interface and its hide_all_standard_functions method, retrieving the toolbar object and applying it.

Learn how to add a custom button to the ALV toolbar, configure its function code, icon, and quick info, and wire an event handler to show a message when clicked.

Learn to fetch ALV data via select options by creating a selection screen with a customer range, generating a range table with CL_SALV_RANGE_TAB_COLLECTOR, and using set_select_options to display Hana results.

Explore interactive reporting in ALV Ida, linking selection options to customer data. Learn to handle double click events, extract the customer number, and display the corresponding sales orders from VBA.

Explore CDS views and compare them with ABAP dictionary views, highlighting code pushdown to the HANA database, single result set, and advanced calculations, joins, and nested views.

Create a simple CDS view on a single table, define projection fields, and use a case expression to map country codes to names, then test with data preview.

Discover how to consume a CDS view in an ABAP report with open SQL, including using the CDS view instead of the generated SQL view and selecting fields.

Learn to consume a CDS view with the ALV IDA framework by obtaining the LV reference and displaying the view, after validating against table-based approaches.

Create a CDS view with a single parameter using the define view with parameter template, specify the data source and projection, add a where clause using the parameter, and test.

Learn to consume a CDS view with a single parameter using new open SQL statements in ABAP, binding the parameter and fetching results into an internal table.

Create a CDS view with multiple parameters and apply the built-in currency conversion function to convert net values from the source to the target currency using an exchange date.

Consume a CDS view with multiple parameters by declaring and binding p_sales, p_date, and p_key. Fetch, loop, and display sales, creation date, net value, currency, and conversion details.

Explore CDS view with aggregate functions such as sum, max, and min, and apply group by and having clauses to compute totals and statistics.

Explore currency conversion in ABAP: convert a source currency to a target currency using exchange rate date from a database table, specifying amount and currencies.

Master unit conversion by converting distances from miles to kilometers using three parameters—quantity, source unit, and target unit—while handling distance IDs and semantics.

Learn to extend a CDS view by appending fields or by creating a view extension, using the extend view template, with examples like seats max and seats occupied.

Master the concat and concat_with_space functions in SAP ABAP on Cloud RAP, learning to concatenate variables with and without separators and preview results in hana studio.

Explore essential string functions in ABAP: length, instr, left, right, lower, upper, lpad, rpad, ltrim, rtrim, and replace, with practical examples.

Learn numeric functions in sap abap on cloud rap, including abs, div, division, floor, round, and mod, with practical examples and data previews.

Explore two cds annotations, end user text and quick info, and learn how header annotations control labels and tooltips in cds views, including alias handling, data preview, and abap reporting.

Explore how the preserve key annotation governs CDS view key fields, comparing true and false, with MDT, ID, and flight date as examples.

Learn how buffering annotation preserves master data at the application layer by selecting between single-record, generic-area, or fully buffered types, with status options and CDS or ABAP catalog annotations.

Explore cds annotations view enhancement category and data maintenance, revealing how default restricted data maintenance affects cds views and how projection list, group by, and union options influence usage.

Learn how the cds annotation accessControl.authorizationCheck enforces data-level authorization on cds views by attaching cds roles, exploring not required, check, not allowed, and privileged access behaviors.

Learn how the CDS annotation objectModel.usageType enhances performance, using data class, size category, and service quality to prioritize CDS views and optimize memory usage.

Learn to create a cds view with joins in Hana, using country and city tables, explore inner, left outer, right outer, and cross joins, and preview results.

Create a CDS view on three standard tables with joins and use the coalesce function to display material descriptions in the selected language.

Learn to create a cds view with association and use a lazy association to return left-hand side data by default, with on-demand right-hand side data via follow association.

Explore ad hoc association in cds views, contrasting it with lazy association on request, and learn to define, activate, and consume cds views with ad hoc associations.

Create a cds view with association on top of three tables (sp fly, s flight, and s airport) and consume it in an abap report.

Create a cds view with an association to an existing cds view, test nested associations with data preview, and consume the view in an abap report.

Explore client handling in CDS views, including client dependent, cross client, and the inherited default. Use the at rate client handling dot type annotation to manage data access.

Explore how union and union all work in CDS views by combining two data sources: union removes duplicates, while union all preserves duplicates.

Learn how the virtual data model (VDM) standardizes CDS views, detailing basic, composite, and consumption views and their data category annotations for easy maintenance and front-end exposure.

Implement the virtual data model by building three basic views, a composite view, and a consumption view, then expose an odata service for sap abap on hana.

Learn to integrate CDS views with AMDP by implementing a define table function in ABAP, returning airline id, airline name, and concatenated operational cities using an MDP method.

Expose a cds view as an odata service using the at the rate odata publish annotation, then register and activate the service in gateway and verify metadata.

Create a simple fpm app based on a cds view using the fem_wb wizard, configure a data service, and preview a search page with airline id.

learn hana modeling basics by creating information and external views, using attribute, analytic, and calculation views; calculation view replaces deprecated ones, with measures derived from analytic and calculation views.

Create an attribute view in the SAP HANA modular perspective to expose master data, then build an external view with joined tables and a calculated column for ABAP report consumption.

Learn to design analytic views with measures and attributes using star joins, a data foundation, and attribute views, then add calculated or restricted columns and consume via an external view.

Create a graphical calculation view in SAP HANA, add projections and joins, expose an external view, and consume it from an ABAP report for integrated analytics.

Learn to create a sql script based calculation view in SAP HANA, using semantic mode, define input parameters, join VB table with VB app, and preview results.

learn to implement a table function in SAP HANA, and integrate it with a calculation view to centralize business logic and enable reuse across multiple views.

Discover the SAP RAP RESTful application programming model for cloud ABAP development, detailing CDS data models, behavior definitions, projection views, and OData or Web API service provisioning.

Explore managed and unmanaged scenarios within the rapid development model, comparing greenfield and brownfield implementations, and learn how the RFP framework handles create, update, delete operations.

Install eclipse and add the abap development tool (adt) plugin for cloud abap. Create a sap btp trial account, generate a service key, and link eclipse to the abap environment.

Embark on the hands-on creation of a CRUD app using the managed RAP scenario: build a database table, CDS root view, projections, metadata, and OData service, then publish and test.

Explore value help from a domain in ABAP on cloud RAP by creating a country domain, a CDS view, an association, and using additional binding to display descriptive values.

Model vendor and purchase order data with rap in a cloud ABAP app, linking via associations to display purchase orders on a vendor object page using odata services.

Learn to impose a validation rule on vendor number in ABAP on cloud RAP and display a custom error message on create and update in a UI5 Fiori app.

Generate abap repository objects from a database table using the repository objects generator, producing cds data definitions, behavior, metadata extension, and odata ui service with a service binding.

Learn how determination rules in SAP ABAP RAP automate field updates, with on modify and on save triggers; see how changing vendor number can auto-set country values and calculate totals.

Learn to build a three-level composition app on standard SAP travel tables using the RFP framework, creating root view entities, consumption views, and OData-enabled UI5 interfaces.

Learn to use the UI dot header info annotation to display table header and object page details. Configure type name, type name plural, title, and value binding for travel ID.

Learn to attach value help with the Consumption.valueHelpDefinition annotation in ABAP on cloud RAP, pulling agency name, customer first name, and overall status from related entities.

Explore how the UI facet and UI dataPoint annotations customize header level displays with a target qualifier and data point references in SAP ABAP on cloud RAP.

Learn how the objectModel annotation controls data presentation in the front end of RAP consumption views, using the text property to attach descriptions and display status text from associations.

Design a collection facet that acts as a container for identification reference and field group reference child facets, using parent IDs, positions, and ui annotations.

Learn to implement the line item reference facet in SAP ABAP on Cloud RAP, display booking details in a tabular format via line item annotation and target element.

Explore behavior definition and projection to enable crud operations on a root travel entity with related booking and booking supplement, detailing ABAP class implementation, mapping, and UI exposure.

We updated code and metadata to improve look and feel, removing agency and customer names. We added agency ID and customer ID value help, currency code, airports, and carrier details.

Create new records in child entities within a travel booking flow. Apply additional binding and value helps to map key fields and related data across bookings.

Learn how to implement optimistic concurrency control using ETag in SAP ABAP on cloud RAP with OData services to prevent data conflicts when multiple users edit the same record.

Explore early numbering to generate the travel ID as a framework-controlled primary key, keeping it read-only in edits and creation. Use number range objects and content ID for unique IDs.

Learn to implement early numbering for travel, booking, and booking supplements in RAP by reading travel data, generating next IDs, and handling cases with or without existing bookings.

Explore factory versus non-factory data actions in RAP, detailing how factory actions create new instances with prefilled values and how non-factory actions update existing ones.

Explore instance bound factory actions in ABAP RAP to copy travel instances, with front-end buttons, metadata extension, and logic to duplicate bookings and booking supplements while updating dates and status.

Implement instance bound non factory actions to set travel status via accept or reject buttons, update the backend, and refresh the front end accordingly.

Explore determination on modify in SAP ABAP on cloud RAP, showing how to recalculate travel price by summing booking fee, flight price, and supplements when currency or prices change.

Explore how side effects in SAP ABAP on cloud RAP UI5 apps reload affected data and recalculate totals through behavior definitions and field targets.

Apply validations to enforce data consistency in SAP ABAP on Cloud RAP by validating agency id and customer id during create or update, with error messages and field highlighting.

Implement validations in SAP ABAP on Cloud RAP to ensure travel begin date is not in the past and end date is after begin date during create and edit.

Define static and dynamic feature controls in SAP Fiori UI to manage field visibility, read-only and mandatory states, and to enable or disable actions like delete or create.

Explore the additional save concept within the transactional lifecycle of SAP ABAP on Cloud RAP, and learn to log deletions and updates during the save sequence via a log table.

Explore unmanaged save in SAP ABAP on cloud RAP, implementing custom create, update, and delete logic for booking supplement with legacy code integration.

Explore the unmanaged sap abap on cloud rap scenario, where you write pure abap for two-level root and child entities, create repository artifacts, and implement crud with a transactional lifecycle.

Discover the create operation for the root order entity in an unmanaged scenario using ABAP, generating the order number and persisting data via the transactional buffer.

Implement an update operation in an unmanaged ABAP scenario by comparing updated data with existing records, using a work area and a buffer to update the database.

Learn to implement a delete operation in an unmanaged scenario using ABAP, handling only key fields to delete records by order number from the GDS_order table.

Implement create by association for a child item under an order, generating item numbers, binding each item to its parent order, and persisting data via the buffer.

Explore the update operation in a child entity within a SAP ABAP on cloud RAP app, detailing two update methods and how to persist changes via the buffer.

Learn to implement delete operations for a child item in the ABAP RAP setup, including deleting individual items and cascading delete of item records when an order is removed.

Explore instance bound non-factory actions and dynamic instance feature control in an unmanaged SAP ABAP on cloud RAP scenario, implementing accept order actions with CRUD operations and front-end behavior projection.

Create bulk orders by uploading data from an Excel file using SAP ABAP and UI5 Fiori BAS, leveraging OData on Hana to streamline import and processing.