SAP ABAP Masterclass: Reports, ALV, Forms, APIs & More

Learn to create and run your first ABAP program in the SAP ABAP editor, follow naming conventions with z or y, and perform syntax checks, activation, and transition code setup.

This lecture explains creating a first abap program part 2, showing how to add comments, print consultant details with fixed positions, and draw vertical and horizontal lines using ci vline.

Explore how to apply color coding in classic ABAP reports by using color numbers, format color, and options like intensified, inverse, and field versus line level coloring.

Explore the ABAP data dictionary as the central repository for database objects, covering standard and custom objects, and the creation of transparent, pool, and cluster tables.

Explore the SAP Mara database table in the data dictionary, covering fields, key fields, data elements, domains, and how labels appear before creating a custom table.

Create a custom abap table zemployee_master in the sap data dictionary, defining nine fields with data elements and domains, and set delivery class and client mandator.

create and configure the zemployee_master part 2 table in sap abap by defining delta domain and multiple domains and data elements, setting value ranges, and wiring currency and department fields.

Set up the technical settings for the custom table zemployee_master by selecting the data class (master data or transaction data) and size category, then activate and manage records.

Create a second database table zemployee_com for employee communication details, using existing data elements and address fields, and configure domains, address tables, and maintenance settings.

Create a foreign key relationship between z_employee_master and z_employee_comm to validate employee IDs against the check table and enforce data integrity.

Explore how structures and append structures work in ABAP, including using a structure as a work area and including it into database tables or other structures.

Learn to create and attach an append structure to standard or custom SAP tables to add fields, understanding its 1-to-1 relationship and non-reusability across tables, and activation.

Create a table maintenance generator to enable end users to maintain data via sm30. Access it through ac11 utilities, build a tmg for zemployee_master, and assign a transaction code.

Explore creating a table maintenance generator for the employee master table in SAP, choosing one-step or two-step maintenance, generating programs and screens, and assigning a transaction code for direct access.

Learn how the table maintenance generator responds to adding a new field and apply two methods to refresh the screen in z mp zero one so the new field appears.

Customize the SAP ABAP table maintenance generator by adjusting screen layout, adding a field via dictionary, and updating flow logic with the third regeneration method.

This lecture demonstrates implementing a 'create new entry' event in the table maintenance generator to auto populate created by, created on, and created time fields using a form routine.

Implement update events in the table maintenance generator to auto-set created by, created on, created time, and before saving data to database set change by, change on, change time.

Implement the update event in TMG by looping the internal table with a field symbol, casting records, and setting change by, change on, and change time for updated entries.

Explore delete event in TMG using DMG and the zero three event to prevent deletion by raising an error and setting the inactive flag, while learning create and update events.

Discover how SAP ABAP database views act as logical tables that retrieve runtime data from multiple tables without storing it, and learn database, projection, maintenance, and help views.

Create a projection view on a single table to display only selected columns, such as employee id, first name, last name, date of joining, and department, with read-only access.

Learn to create and use a maintenance view to update data across multiple related tables in ABAP, enforce 1-to-1 cardinality, configure foreign keys, and generate the table maintenance generator.

Explore creating the help view in SAP, using search helps, joining tables, and exploring database, production, maintenance, and help views.

Create an elementary search help in SAP ABAP to serve as the F4 input help, displaying matching values in a dialog and binding it to a field like z_employee_master.

Create and tailor an elementary search help in ABAP by configuring selection methods, import/export fields, and dialog behavior, including fuzzy search for multi-column matching.

Explore elementary and collective search helps in SAP ABAP by configuring default values, modifiable data elements, and display restrictions to tailor employee ID and surname selections.

Learn to build a collective search help by combining two elementary search helps, mp_master and department, for multi-tab lookups on the z_employee_master table and map employee_id with data elements.

Learn how the SAP transport organization records, manages, and moves ABAP developments and configurations across development, quality, and production systems using transport requests, workbench and customizing requests, and packages.

Discover how to create a package and a transport request in sap abap, assign objects to the same transport, and manage release and cross-client movement from development to quality.

Release the transport request in development and import it into the quality system. Use version management to compare TRs, adjust the import queue, and verify the program in quality.

Create a customizing request and import it from source client 100 to target client 110, demonstrating client-dependent customization and cross-system transport using test mode.

Learn how to assign a local SAP ABAP object to a transport request and move it to the quality or production system, using workbench requests and version management.

Learn how to delete an object from an existing transport request, merge multiple requests under a single transport request, and change the owner when needed.

Change a transport request's status from release to modifiable using change mode after creating and modifying the TR in development; only if not imported into the quality system.

Learn how to declare and use variables, constants, and system fields in ABAP, including fixed and variable length types, data elements, and system variables like sy-datum.

Explore how ABAP handles variables of type I and type N, showing integer storage, string length, and the effects of length, leading zeros, and decimal handling in reports.

Explore printing values with ABAP types in this lesson, focusing on type I, type N, and type P, handling negatives, decimals, and auto rounding for currency and amounts.

Assign variables with predefined types, data elements, and table-name-field syntax to map fields like name one and name two from the customer master table using the delta element.

Learn to use constants and variables in ABAP, including a fixed tax percentage. Explore system fields, such as login user and date and time, and use breakpoints to inspect them.

Explore internal tables in ABAP, including the work area and temporary runtime tables, then declare and manipulate standard, hash, and sorted tables with append, insert, loop, read, and sort.

Learn to manage ABAP internal tables using append and insert, clear the work area, and debug with breakpoints to see how records populate index and standard tables.

Explore internal table operations in ABAP by looping through records, printing fields, and using modify to update entries, with a where clause and selective transporting.

Learn to sort abap internal tables by one or more keys and read a single record with read, using options for ascending, descending, binary search, and index.

Learn how clear resets variables, fields, and internal table bodies in sap abap, how refresh frees memory for internal tables, and how free releases memory for objects.

Learn how the collect statement in ABAP sums CTC by department by iterating an internal table, adding new records for new departments, and accumulating CTC for existing ones.

Learn to use the collect statement in ABAP to sum numeric fields by non-numeric keys like company code and department, and compare it to append.

This lecture extends sorted internal table concepts by comparing unique and non-unique keys, showing how duplicates are controlled and when to use binary search for fast lookups.

Explore hashed internal tables, driven by a hash algorithm for fast lookup using unique keys; insert remains used, no index access, and performance surpasses standard and sorted tables.

Explore how ABAP conditional statements control program flow using if, else, and case, with practical salary and bonus examples and multiple conditions.

Explore advanced conditional logic in ABAP with if-else and nested ifs, using multiple else if branches and combined salary and experience conditions to calculate bonuses.

Learn how the abap case statement replaces multiple if blocks by checking a single variable, with when and others, end case, and compare performance and flexibility with if else.

Explore abap loops using do enddo and while, learn how to control iterations with conditions, exit and continue statements, and apply subroutines to demonstrate loop termination in practical examples.

Master ABAP loop control by using do and while constructs, learn to apply exit and continue to skip iterations, adjust conditions, and print records conditionally.

Learn string operations in SAP ABAP, including concatenate, split, and substring, through practical examples. Master splitting into variables or tables and applying find, replace, and case conversions.

Explore string operations in ABAP, including splitting CSV strings into internal tables and variables, using delimiters, extracting substrings, and measuring string length with debugging tips.

Explore advanced string operations in ABAP, including condense, shift, find (first and all occurrences), replace, and translate for case conversions, with practical SAP ABAP programming examples.

Explore ABAP control break statements used to manipulate internal tables in loops, with at first, at last, at new, and at end of scenarios illustrated via purchase order data.

Master ABAP control break statements, using at new and at last to print per purchase order headers and line items, and sum values in an internal table.

Explore database operations using open SQL in SAP ABAP, including select, insert, update, delete, and modify, and see how a uniform syntax works across Oracle, DB2, MySQL, Hana DB.

Build a basic ABAP program that uses a selection screen and select star into an internal table from a customer table, then prints key fields and tests with variants.

Explore ABAP select queries by building a limited-column structure and using into vs into corresponding fields. Map data by position or by name.

Demonstrate ABAP select basics: fetch into a work area or internal table, loop and print, then cover select single, select up to one row, and select distinct.

Explore ABAP select with joins, including inner, left outer, and right outer joins between Mara and Marc tables, learn join conditions, and compare legacy and new syntax.

Master the inner join of more than two tables in ABAP, combining mara, makt, and marc to fetch material and model descriptions across languages.

Learn how to insert records into ABAP database tables using the insert statement, from work area or internal tables, with z_employee_master, handling duplicates with accept duplicate keys and reporting results.

Learn update, modify, and delete operations on ABAP database tables. Use where clauses and work areas to update specific records, insert or modify, and delete by key or condition.

Learn the new, modern ABAP syntax from release 7.4. Discover inline declarations, table expressions, read table syntax, and updated operators and queries, while preserving old syntax.

This lecture introduces inline declaration in ABAP, showing how to declare internal tables and variables at the usage point with the new syntax, including selective and full field selects.

Demonstrates the inline declaration with the new syntax and removing data declarations. Shows selecting limited or all columns into internal table or work area using direct signs for host variables.

Explore inline declaration for looping internal tables and reading with read statements. Compare old syntax with new ABAP runtime declarations and robust error handling with try-catch.

Explore ABAP read statements and looping over internal tables, reading full work areas or specific fields like company code, and using for all entries and index-based reads.

Learn to concatenate in ABAP using old syntax and the 7.4+ new syntax, with inline declarations, pipe signs, and ampersands, to build accounting key strings and formatted outputs.

Master alpha formatting in ABAP by removing or adding leading zeros with alpha output and alpha input, then switch to the new one-line syntax using pipe expressions.

Explore the value operator as a constructor for a defined type, enabling inline declarations to initialize a work area or internal table and append records.

Explain the conversion operator in ABAP, showing how to inline convert a value to a target type without helper variables, using function modules and data elements.

Master the reduce operator and a case statement in select queries to sum internal table columns and adjust credit and debit signs, avoiding nested loops in ABAP reports.

Discover how to use the filter operator in the new ABAP syntax to filter internal tables by document type, including single and multiple values, and improve performance over loops.

Explore ABAP's new conditional operators cond and switch, replacing if else and case with improved readability and performance in 7.4 and later.

Explore union and union all in ABAP open SQL, combining two internal tables, using the new syntax, and adding a case-driven sign for amounts.

Explore the new loop at group by syntax in ABAP 7.4 to extract unique values from an internal table and print grouped purchase orders and items with two loops.

Explore ABAP 7.4's select query features and code push down, performing concatenation, arithmetic, and case logic at the database level. See how this streamlines reporting with header and item data.

Learn to write a select query with aggregate functions, minimum and maximum, using group by user id and date and order by clause to derive time in and time out.

Learn to use ceil and floor in ABAP SQL to round numbers, embed character and numeric literals, and capture system variables in a single select query.

Explore window expressions in abap to partition query results using over and partition by, enabling project- and building-level counts, sums, min, and max without loops.

Learn to write a select query with window lead and lag to compare current, previous, and next agreement values within partitions by project ID and building.

Learn to use the new syntax to fill selection options and range tables directly from a select query in ABAP, replacing internal-table loops and boosting performance.

Learn field symbols in ABAP: placeholders that point to data objects in memory, with typed and generic forms, enabling dynamic reading and modifying internal tables while avoiding memory overhead.

Learn to modify internal tables efficiently with field symbols in ABAP, using old and inline new syntax, demonstrating field symbol assignment, avoiding work areas, and improving performance.

Explore how to manipulate internal tables with field symbols in ABAP, using inline declarations, assign syntax, and read and modify operations, including appending new records.

Learn to design ABAP selection screens to collect inputs, using parameters for single values and select options for ranges, and configure radio buttons, checkboxes, list boxes, and set default values.

Design a selection screen with select options in ABAP, adding fields such as customer, company code, and cpu date, and explore low/high, sign, and between values.

Design a selection screen with select options part 2 by making fields mandatory, setting default values from system date and system date minus 30 days, and controlling intervals and extension.

Design a selection screen with select options and parameters, set defaults, and compare the in operator for select options with the equal sign for parameters in the where clause.

learn to create radio button groups on a selection screen, set default selections, and detect which radio button is selected to drive ABAP logic, with a contrast to check boxes.

Design a selection screen with checkboxes, creating three checkboxes and contrasting with radio buttons. Set default x and display messages for normal, special GL, and noted line items.

Learn to create a drop down list on a selection screen by turning country fields into list boxes and populate them with vrm_set_values, then build dependent region dropdown from t005u.

Explore the two major ABAP report types—classical and ALV—showing how classical reports display data with write statements, while ALV enables download, sorting, filtering, and interactive navigation.

Explore modularization in ABAP through include programs, subroutines, function modules, and macros to create readable, maintainable code with reusable blocks and reduced redundancy.

Explore function modules and RFCs in ABAP, including function groups, top includes, and importing exporting changing and table parameters for reusable logic.

Create a custom function module within a function group. Consume it in an ABAP program using importing and exporting parameters such as customer ID, name, mobile, and email.

Create and use a global structure in an ABAP function module, passing data via exporting parameters. Build standard and custom table types and debug in SC38.

Create a function model with a screen popup to capture payment information using a function group, with radio button options for stamp duty, maintenance, and other charges.

Develop a screen in a function module and call it from a simple ABAP program, using a selection screen to drive payment type logic and update payments.

Learn how to create a remote-enabled function module (RFC) in SAP ABAP, insert records into custom tables, configure importing and exporting tables, and handle errors with try/catch and messages.

Develop an ABAP program to call an RFC, pass sales order header, items, and schedule data, and handle RFC exceptions with messages to confirm updates.

Learn to call RFCs in SAP, decide destination none or real destination, and compare synchronous versus asynchronous RFC behavior, including testing and signature matching for importing parameters.

Create and copy an RFC in the HANA system, then configure an ABAP destination in ECC with SM59, test the connection, and prepare to call the RFC from ECC.

Create an ECC program to call an RFC from a S4HANA system by defining matching internal tables, passing data in the same format, and handling input, output, and exceptions.

Learn to call an RFC from ECC to a S4HANA system by creating a destination, writing a function module call in synchronous mode, and debugging with external breakpoints.

Learn how the update function module works by marking a function model as update, scheduling inserts, updates, and deletes in an update task, and committing or rolling back changes.

Learn how to create and consume an update function module in SAP ABAP, demonstrating asynchronous update tasks, all-or-none data consistency across header, items, and schedule tables.

Learn to create and consume an update function module and compare set update task local versus normal update task, including impact on commit work, delay, and error visibility.