I am going to explain, how to add new fields in standard search help and make it available as fuzzy search help in dictionary(SE11) level and as well as report level.
Step1:
Go to tcode SE11 and Create a custom table with the following fields, here I want to add a new field PO text to be displayed in the search help so added a field for PO text.
Every so often a developer needs to involve code related to dates in their work. I have come across some “interesting” and “creative” approaches to this which might work under some conditions, but do provide a risk. Let’s talk dates in ABAP. I’ll explain how they work, common mistakes and my suggestion for consistent handling… Please let me know if you have other suggestions!
There is a predefined data type DATS which you declare just as you would expect:
DATA lv_date type dats.
To assign it the value of todays date, which always is available in the sy-datum field:
A common functionality in SAP TM can be to send the email with the attachment to a particular receiver or a set of them when an action is executed in Output Management. This can be achieved manually by adding the email id into the Communication Tab and executing the action but checking the email checkbox.
But the requirements can be like, the receiver should be auto-populated based on certain conditions and add into the receiver table in the Output Management tab whenever the action is executed.
We come across situations where we need to edit values in standard/custom tables. There could be many reasons why you want to edit values in standard/custom tables, some reasons are listed below.
1. You are performing testing, and want to simulate a test scenario without changing a lot of test data
2. You do not have a table maintenance transaction available to edit table value
3. You have found a data inconsistency and want to change table value to fix it
Stored Procedure are frequently used Objects in SAP HANA. Stored Procedures allows to group the SQL statement into a single block and can return data in the form of output parameters.
In Mixed modelling Scenario calling a Stored Procedure from SAP Application can also be a good approach. Below is one Scenario we have faced in our Project.
Scenario: We had created a S/4HANA Report based on a Transient Provider and when checking for InfoProvider report gives a System Generated Tech name 2H*.
In this blog I’ll demonstrate how to configure an integration between the SAP Cloud Platform Launchpad service and a Fiori application deployed in the the ABAP environment. Below is the setup with both the ABAP environment and the Launchpad service sitting in the same subaccount. The steps shown will also work across separate subaccounts.
Working with BOPF in SAP TM is tricky and many times the developers struggle to find help online.
This blog is just an effort to reduce the burden by providing an easier way to traverse the delegated node for Transportation Charge From the Freight Order Root and how the update the Delegated Node fields.
Hoping that the reader has an idea about basic terms like Business Object, Node, Association etc, I move forward with the explanation.
We had an interesting requirement to combine multiple orders (belonging to a single ship-to party) into a single delivery note. This can be achieved using standard transaction ‘VL10’ but the custom requirement was to only be able to combine the orders that had a similar payment type. Payment type is a custom field in the Sales Order (in our case VBAK-ZPAYM_TYPE) which can be either Cash, Credit Card, Debit Card or so on.
In this blog post, I’ll show how I used ALV tree for displaying orders belonging to Ship-to in a hierarchical form.
This blog post will give the basic overview about OAuth2.0 Configuration and use case from SAP ABAP program.
The OAuth 2.0 server (AS ABAP) protects resources you want to use, and the OAuth 2.0 client enables you to access services and resources that are offered by a service provider.
Authentication with OAuth 2.0 protection between an SAP NetWeaver Application Server for ABAP and an external service provider such as, for example, SAP HANA Cloud Platform, Google Cloud Platform, or Microsoft Azure, requires a dedicated OAuth 2.0 client. You can configure and register this OAuth 2.0 client in the OAuth 2.0 server (AS ABAP).
Performance optimization of analytical app is crucial in S/4HANA as it causes additional system load as well as performance of analytics itself. This is great impact on business users.
This blog is about the CDS View performance optimization with Dynamic Cache in S/4HANA. With the Dynamic Result Cache, as the aggregated cached data is accessed instead of data in the source table, thus the runtime could be optimized. The cached data is updated when the data in the source is updated. Dynamic Cache can be created for a table in S/4HANA.
The purpose of this blog is to show the created CDS view entities including Analytic Query, Extended entity, Annotate Entity in the system.
◉ S/4HANA On premise 2020 Initial shipment stack
◉ ABAP Platform Initial shipment stack (SAP_BASIS 755/0000 with SAP Kernel 781 patch19).
The intent of this blog post is to provide some initial insight in extending the standard SAP Fiori – My Inbox application. Specifically, this will deal with the SAP Fiori app: My Inbox – Approve Purchase Requisition (F0401A). Take note that this will not go into the details of setting up the SAP Business Workflow that will be using this, but only extending the SAP Fiori app itself. Fortunately, once set-up properly, we only need look at the ABAP Core Data Services (CDS) views to modify the front-end output.
This time we’re going to make a report using the CL_SALV_TABLE class to create a grid with data.
This object is very useful and easy to use that you could make reports preparing first the data and finally exporting it to CL_SALV_TABLE.
It is also possible to it color la cells, rows and columns and it is even possible to make editable cells to enter data.
CL_SALV_TABLE includes toolbar and events where you can make calculations, save date and make a very interactive report.
Regular expressions have been part of the ABAP programming language for quite some time now. From the beginning, more than a decade ago, there has been only one regular expression flavor, defined by POSIX standard 1003.2 and implemented by the Boost Regex library version 1.31.
These regular expressions can be applied in a variety of ways throughout the ABAP language:
◉ using built-in functions like find, replace, count, matches, etc.
◉ using the ABAP statements FIND and REPLACE with the addition REGEX
◉ and, for the most amount of control, using classes CL_ABAP_REGEX and CL_ABAP_MATCHER
Description: The Blog Post is about how to create determination and test it in BOPF framework.
Prerequisite: To know The Steps Of Creating BO Object in BOPF And Also To add Node And Necessary Structures Required For Creating BOBF Application.
Introduction: A determination is an entity of a business object node that is used to provide functions that are automatically executed as soon as a certain trigger condition is fulfilled. A determination is triggered internally on the basis of changes made to the node instance of a business object.
Examples For Determination: Generation Of ID Automatically Via SNRO.
In every Project or Customer you worked for, you will have the scenario where some Master Data will not be extended to Company Code/Purchase organization and in those scenarios you have to send an email to that Team and wait when this will get extended so that you can create your Business Document. In this Blog we are considering a case where a Vendor/Supplier is not extended to a Purchase Organization. We will show how we can create a Simple Workflow for the Approval of this Master Data Extension and it is Auditable as everything is inside SAP. This will help you achieve the following Business Goals
Entity Manipulation Language (EML) is a part of the ABAP language. It means that there are new syntaxes available in ABAP to
◉ control the business object’s behavior in the context of ABAP RESTful programming model, using ABAP code user can manipulate Business Object created using ABAP RAP model
◉ provides a type-save read and modifying access to data in transactional development scenarios.
Most of the time in SAP the answer for many things come from a lot of sources. The QR code implementation in SAP is an example of it.
But then I realized that even if I use that code I had to deal with the fact that I should be aware that the QR code had to be generated from a Google API. That could be a problem because in my case I needed to use that feature internally, so it was not ok to access the internet to get the image. On the other hand, this site could be at any moment be closed or shutdown.
So, the thing is that I had to make my own webservice to get that image, and having a background of C# I found it logical to make my own webservice. So I began to investigate how to generate the QR and when I got it then I proceeded to code it. There are a lot of open source solutions out there and in my case, I just had to grab one of them and use it. I found a couple and the ZXing.Net implementation seemed to be the best in this case.
You have a PM notification under which you want to create a child (subsequent or follow up) notification.
I wanted to create a subsequent PM notification under a parent notification and could not found any concrete solution for the same which inspired me to write this blog to help fellow developers who are facing a similar problem.
After working with SAP for more than 15 years and travelling across the Globe for SAP Projects one issue I always use to have how can I keep track of all the SAP Tables/Views associated with different Modules. If you are working as a SAP ABAP Consultant you need to keep the name of tables/views in your Fingertips. Sometimes this you know from other Experts and sometimes you have to dig it out.
After exploring I found a very easy way to know the Tables that contains all the four fields or Data Element in the same Views and has data in it.
In SAP most of the time when we create a ABAP Query report we do it to download it to our Local file and then we need to send it to a bunch of Recipient. This Blog will help you in taking some of this Steps reduced by Sending email directly from the ABAP Query Report.
First we go to Transaction Code SQVI.
Select your ABAP Query.
Classes are fundamental structures that we need to understand and master to model entities.
A class can represent anything; a document, a vehicle, animal, or anything that has traits and behaviours.
Classes in ABAP are coded in two steps: first of all, you code the definition part and then the implementation part.
The definition part is the place where you define all the data and methods that are going to be used in the class.
In this blog will see how to consume RAPM (ABAP RESTful Application Programming Model) service in SAP UI5 App through SAP Business Application Studio (BAS).
Step 1: Required SAP Cloud Platform Trial account. Refer below link to create.
https://developers.sap.com/tutorials/hcp-create-trial-account.html
Step 2: Considering we have ABAP RESTful Application Programming Model (RAP) service developed in SAP Cloud Platform ABAP Environment. To create one you can follow OpenSAP course Building Apps with the ABAP RESTful Application Programming Model
Recently I had an opportunity to work on SAP Flexible Workflow for Purchase Order approvals.
Flexible Workflow is a Fiori integrated solution for creation of document approval processes. Its main strength, ease of use, comes from little or zero need for programming interference. Basic scenarios can be created using configuration only. If you have a more complex situation, you can use one of the available BAdIs – for example the MMPUR_WORKFLOW_AGENTS_V2 BAdI, which allows for customer specific approval step agent determination logic.
As I am forcing myself to write more Unit-Tests for my development classes, I was struggling a bit to set up the test-scenarios since the needed value statements may become big and boring to type in.
I know in ADT is a tool included in the SQL-Console to translate the select-output to a file including the value statements, but still, it took me some effort because not any table can be constructed via sql select (or the type of the target structure/table does not correspond to the db-table type…).
I proposed using an abstract class for the parts of a unit test that do not differ among the various test cases. I also suggested creating a separate class for each test case.
Based on this approach, I now want to describe a technique for separating the test data creation from the test data usage in test doubles.
Note that this approach is especially useful for classes where you put to the test a public method and cover the other methods by the calls of the public one. Classes that respect the single responsibility principle often are made like this.
This blog is about the locking concept in SAP Gateway odata for update deep method. As there are already many blogs on optimistic and pessimistic locking mechanism. And in Gateway Odata there are different ways to implement optimistic lock for concurrency control. below are the ways which I am trying to categorizing
1.) Using Timestamp for E-tag
2.) Using Hash for E-tag
This Blog is about to set the delimit button for custom table. Before doing that I will explain about the delimit functionality and when we will use this concept.
We generally use this concept in any module as per their business requirements in SAP. If they want to see/track the business data into single custom table. Then we will enable the delimit button of particular custom table.
When a purchase order is created in the system, and if there is a need of Inbound Delivery Creation, we use to go to VL31N to create it Manually, but when it comes to a Technical scenario, it would require a BAPI to get that Created. But there is no specific/Direct BAPI for this requirement, we need to use Standard BAPI GN_DELIVERY_CREATE to proceed. Here in this Blog post i created an OData service for the same.
Usually, for a workflow with multiple steps in Approval process, the Work item initiator is the user who processed the previous step/ created the current step and sometimes, technically it is shown as “WF-BATCH” which is technical workflow system user.
I came across this situation where my client wants to see the User who triggered/initiated the workflow in his FIORI MY-INBOX, instead of the user who created the current step ( i.e, who processed previous step/ Work-Item initiator ) which in my case was being shown as “WF-BATCH”.
Recently, I have came across a scenario where one of the standard FIORI application- ‘My Inbox’ was implemented but the default landing page was different than the default page of My Inbox. Also, there was no semantic object mentioned in its tile to locate the standard application. The requirement was to add some custom code in that tile but I didn’t find any link as to where I can add the code as I was not aware of the corresponding application.
After reading some articles on internet, I was able to map the tile using the Roles assigned to my user but sometimes, developer has no Authorization to access the Roles.
It is a common requirement to build custom reports base on MB5L transaction data (List of Stock Values: Balances). There is no CDS view equivalent to get this data. SAP offers C_StockQuantityCurrentValue (Current Stock Quantity and Value) CDS view, but it is lacking Company Code and Account details. In my blog I explain how to add missing details to SAP standard CDS view.
UI Apps development is getting simplified with the evolution of ABAP. In my experience when UI5 was released i had to learn JavaScript ,jQuery concepts and use them to create even a simple UI App ,and then with the advent of ABAP Programming model for Fiori it changed the approach, since using BOPF with annotations we can easily create simple Transactional UI app’s with minimal frontend code. Now with ABAP RAP programming which is an evolution of latter, it further simplified and made flexible for UI App development.
This blog post has been drafted together with my colleague Rabindra Prasad regarding QR code display for GST INDIA E-Invoicing on Script and Smart Forms as many developers are facing problems to display proper QR code.
Please follow below steps to display it as expected.
In most of the cases, existing form will be altered to accommodate the QR code and other IRN details. This blog post is to fulfil the above requirement.
This blog post shows how to mass-activate multiple objects (in the background) and where to find the logs for the activation.
Since SAP decided to discontinue the IS-Media solution, we often have the requirement to add custom fields to MARA or similar tables in the S/4 HANA migration project I currently work on. Unfortunately, the current extension concept does not meet all our requirements and we get the change requests to add new fields or change existing fields only little by little, which means that we have to repeat this step every few weeks.
API stands for Application Programming Interface, and comprises a set of standards that allow two applications to talk to each other. REST APIs are a certain pattern of building APIs. They are based on the HTTP protocol, sending and receiving JSON or XML data through URIs (uniform resource identifier). JSON-based REST APIs are prevalent. We will also be using such one in this tutorial.
OData, which is very popular in the SAP world, is itself a REST API. There is a lot of information out there on how to provide a REST API from ABAP (i.e., to publish an OData service). But there isn’t much on how to consume an external API in ABAP. And from what little there is, it includes non-whitelisted ABAP APIs, i.e., they cannot be used with Cloud ABAP. So, I decided to write this tutorial on consuming REST APIs using Cloud ABAP.
In the on-premise ABAP world, lifecycle and quality processes can be controlled by the ABAP systems themselves. Think of transport routes and jobs to execute different checks. In the SAP Cloud Platform ABAP Environment aka Steampunk, this is no longer possible. Steampunk systems are independent of each other, and source code is “transported” with git-based solutions: gCTS and abapGit. While different systems in one global account are connected to the same repositories (read: “software components”), they do not know of each other. Due to this, the driver of lifecycle and quality processes needs to shift from the ABAP system itself to an external driver – for example: a classic Continuous Integration / Continuous Delivery (CI/CD) server like Jenkins. Of course, the Steampunk systems need to expose the functionality via APIs so that a CI/CD server can control those processes.
In this blog we will learn how to use query option $skiptoken in gateway OData service.
To achieve server-side paging we will use $skiptoken.
It is the process of restricting the number of entries sent to the application. This also helps to increase the performance if a huge number of entries requested. This is of two types Server-side paging and Client-side paging.
Most of us have faced this problem when designing a selection screen with a lot of fields. For example consider the scenario where you have to design selection screen for an ABAP Report which includes multiple Radio Buttons and accordingly the selection criteria i.e., select option or parameter should be made visible and hidden and also some radio can have authority object attached to it.
So in this blog post you will learn how you can reduce the complexity of Selection Screen Field visiblility inside the statement LOOP AT SCREEN.
This blog post contains code templates for adding ZCX_RETURN2 exception raising code.
◉ CREATE_BY_SYSTEM_MESSAGE (without MESSAGE statement)
◉ CREATE_BY_SYSTEM_MESSAGE (with MESSAGE statement for custom message)
◉ CREATE_BY_BAPIRETURN_STRUC
◉ CREATE_BY_BAPIRETURN_TABLE
◉ CREATE_BY_BAPIRET1_TABLE
◉ CREATE_BY_BAPIRET2_STRUC
◉ CREATE_BY_BAPIRET2_TABLE
◉ CREATE_BY_BDC_MESSAGE_TABLE
◉ CREATE_BY_EXCEPTION_OBJECT – catch for example CX_ROOT
In this blog I’ll try to explain my initial thoughts and are hoping for your feedback.
So briefly the intention is to build a feature switch framework that would enable an organisation to quickly turn off new code changes that has been brought in via transports if proven buggy. This buys the organisation time to provide a proper fix. I can vouch for this where i’m at currently as there is a very lengthy governance process.
The other part of it would be to enable new development to be rolled out gradually instead of always a big bang release when the code hits production. This enables you to run beta program and early releases to get the feedback from your end users earlier than otherwise as they can get their hands dirty.
Initially our client was using the pay slips designed in Sap Script to display the results in the off-cycle workbench of payroll. However a new requirement was raised, where the client wanted to replace the Sap Script pay slip format (that looks like an sap script) with PDF forms. After much research, I have suggested the solution to be implemented with the use of HRFORMS which allows us to implement the solution by providing an interface that provides the payroll data to design the forms using Adobe forms or Smartforms platforms.
Measuring system for real world objects and code is different. Virtual system measuring metrices evolved over the years. But are they fit for today’s world?
Code measuring systems and metrices rely on quality and syntax of written code.
Usage of standard functions in custom code is not something new, and in my experience standard functions are one of most used artefacts in customer code.
When using standard functions release status is one of the most important topics that come up quite frequently.
At the end of this blog you should be able to identify whether a standard function is ok to use in customer code or not. Also, what can be the implications / risks introduced by using such an object.
Take a look at this:
Mr. Enfield returned: "But I happen to have noticed his address;
he lives in some square or other".
"And you never asked about the—place with the door?"
Mr. Enfield's reply was: "No, sir;
If you are an ABAPer you must be using the TAB key in your keyboard a lot to Auto Fill Keyword Commands. Last year Google have taken this TAB Key concept in writing emails which is awesome. This Blog will help in saving Code Templates that you can use in any ABAP Program.
I always felt like something is missing in all the FE Object Page apps when there is no avatar displayed in the header. I mean, just check the below image, and see how beautiful it looks with the avatar control on the object page.
◉ BRF+ stands for Business Rule Framework Plus which provides a comprehensive application programming interface and user interface for defining business rules
◉ It enables you to define business rules without the need of wiring ABAP code.
◉ The generated Business Rules can be incorporated into other SAP programs or Substitution/Validation rules.
Ever wondered how to transfer your existing FPM applications to a mobile environment? Have a look at the example below for a quick look at how to do just that using the new FPM Mobile Enabler.
I’m using an FPM test application that uses a Search GUIBB and a List ATS GUIBB to display hardware products. The list contains quite an extensive number of columns. Underneath the list a Chart GUIBB shows the products by supplier.
We are building our own App for SAP S4HANA 1909. The frontend is built in a Microsoft based tool. We integrated the App to S4HANA using OData protocol.
One of the requirement is to lock the object, once the user clicks on edit in the App. So that nobody else can edit, either from the app, or in SAP GUI.
Talking about lock in SAP NetWeaver Gateway-OData(on-premise), till date I could not find any solution which will behave similar way as in SAP GUI because of rest property(as rest is stateless) so cant store the state there.
With ABAP code versioned in git, it is possible to clone ABAP projects as files to the local PC. And like other files, these can be edited with your favorite editor.
To help the developer, I’ve been working on a standalone setup for editing ABAP files based on LSP and vscode.
Below shows some of the features currently implemented,
In this blog post, we will see how we can get QR code and Digital signature on Adobe Form without using Job profiles. We will basically convert the QR code into the image (BMP) and then Digitally sign the form via ADS Server.
Before implementing the solution please check if you have SAP note 2790500 implemented in your system so that we can use class CL_RSTX_BARCODE_RENDERER. Go to SE24 and check if you have the above class in your system. If not then implement the given note for the same.
Throughout all my years with ABAP development, modifying IDocs in an easy to understand, elegant way has always been a struggle. First, the issue of making changes to the segments, second, the issue of correct sequence of the IDoc’s segments.
In this blog post, I will show how to easily perform the create, read, update and delete (CRUD) operations on IDoc segments, thanks to the use of ABAP Object Oriented Programming.
This blog covers:
◉ Enable HANA service in SAP Cloud Platform(Neo)
◉ Creation of HANA database in Cloud Platform Cockpit
◉ Access the HANA DB
◉ Creation of live connection in SAC for Cloud Platform
◉ Creation of model and simple story in SAC
When we use openSQL, filtering data from parameters and select-option is too easy. With AMDP or CDS, we can only filter data with parameters. Some case, we want to filter both
select-option and parameters, So how can do it?
Additionally, AMDP is only a method, so if we have more AMDP methods, how can we call another AMDP inside the AMDP method?
