Tag: sap
-
How to use table functions with CDS views?
In this short tutorial, I want to showcase you, how to use table functions. Table functions allows you to simply define a CDS structure and later a view to be consumed by other CDS views or custom ABAP logic. The underlaying data acquisition differs from the normal CDS view entities. It can refer to a…
-
The different CDS data definition types
There are a couple of different CDS view entity types, which can be used in ABAP Cloud to define selections on database tables and other existing data definitions. When we want to create a such data definitions, we have a various of options to choose from. Most of them are really just templates with extended…
-
How to show a table of sub positions in ABAP CDS metadata extension definition?
Let’s assume we have a data model, where we have shares, and each share has its own transaction history. For that we use an association [0..*] from the one share to the x transactions. Now what we want to achieve is to display all these transactions inside the identification view. To add this table, which…
-
How to use the connected fields in ABAP CDS definition?
It took me a long time to figure out, how to use exactly the connected fields annotation in ABAP CDS definition. In CAP CDS it was somehow clearer to unterstand, how to combine two fields in a template and then getting these values in a sub annotation. There is an active SAP Help page to…
-
Using table comprehensions and reductions
I recently came across to useful features in the new ABAP syntax. These two functions relay on internal tables, where you can do some quick operations on it. Table comprehension The first example loads initially a table or a view to the variable lt_connections. The lt_connections contain later the fields, which are in the work…
-
How to assert an exception message in ABAP Unit test
How may have the requirement to assert in a unit test an exception, which has been thrown. To properly test, if the thrown message is equal to the expected message, we can check the message ID. So first, let’s assume that we have a method, which throws a custom exception. Our exception class contains some…
-
Setup a PFCG compatible access control for CDS views
In a previous blog post, we have learned how to setup a simple access control, which has a fixed value set. This is cool for demo cases, but it is of course not usable for productive systems. In the old SAP GUI, we have used authorization objects and fields in combination with AUTHORIZATION-CHECK in our…
-
Setup a simple access control for your CDS View
When we define a CDS view with our ADT tools, we provide a useful tool to query data from database tables and more. Since may your data has to been protected, we can use the access control to set the visibility of our data, who can access it and exactly what data can be queried.…
-
How to add a determination for your SAP RAP application?
With a determination, you can modify an entry via the Entity Manipulation Language to fill out automatically the necessary fields needed. For example, when you type a username inside a field, you may want to extend that in the database as well as in the view with the full name, so that it can be…
-
How to enable a value help in a CDS view for Fiori Elements?
In this short tutorial, I would like to show you how to simply apply a value help to your CDS fields by simply annotate them with another database table. First of all, we need a simple database table, that already contains some information. We have here a table (ZAIRORTS) containing two entries with airport id…
