In our previous tutorial, we learned how to create CDS views where we can define data model and views and today we will learn how to create data procedure in SAP HANA database called AMDP (ABAP Managed Data Procedures). What you will learn? 1. Create AMDP using Eclipse 2. Execute AMDP using ABAP program Prerequisites…
Before proceeding, ensure you have completed our previous lesson on creating basic CDS views. Additionally, you may want to explore how to publish your CDS views as an OData service. What you will learn? 1. Create a CDS With Parameters 2. Execute the CDS using ABAP program Prerequisites 1. SAP System Access: Developer role, SE38…
OData is a web protocol, so it uses HTTP as its communication layer between different systems to perform query or manipulate data using RESTful APIs and it’s currently being used as the standard communication protocol between SAP and Non SAP systems. What does OData have to do with CDS? Well, you can instantly publish a…
CDS (Core Data Services) is a powerful tool in SAP that enables the creation of virtual data models by defining structured views on top of SAP HANA tables. It provides a high-level, declarative way to work with data, allowing you to define complex queries without having to manually write low level SQL. The queries are…
When you create a class object using Transaction Code SE24, the class is stored in the ABAP repository and becomes reusable by other developers across various programs. These classes object are part of the global class pool. However, what happens to classes that are defined locally within an ABAP program? Local classes are restricted to…
After months of crafting your ABAP skills, refining your resume, and applying to countless ABAP job opportunities, the moment you’ve been waiting for has finally arrived! That long awaited job interview invitation has landed in your inbox! You’ve been invited to interview for a job as an ABAP Developer! Excitement and nerves collide as you…
When you want to update records of an internal table using LOOP ENDLOOP. The most common practice would be copying each row into a working are (INTO DATA) and modify the internal table afterwards. Many developers still unaware of the performance issues caused by this technique. In this tutorial, we’ll do a comparation between INTO…
When processing header and details records, we often used NESTED LOOP to update certain records from inside the loop. Unfortunately this technique will lead to significant performance issues, especially when dealing with large datasets. This method (NESTED LOOP) slows down your program and impacts efficiency and that’s why we will learn how to implement another…
Tutorial Objectives 1. Able to upload and download formatted EXCEL template using ABAP 2. Present the user with a nice looking Excel Template Prerequisites SAP System Access: SAP GUI, ECC Authorization: Developer role, TCODE: SE38 In a previous project I worked on, the user requested functionality to download a template from SAP so they can…
When sensitive information is frequently shared electronically, then protecting the confidentiality, integrity, and authenticity of documents is very crucial. Having said that, Password Encrypted PDFs play a pivotal role in securing digital information. Strangely, there is no direct way to perform file encryption using ABAP, so we have to rely on third-party software (PDFtk Server,…