This blog describes the steps necessary to configure user-propagation (a.k.a. Single-Sign-On or SSO) between an extension app running on SAP Cloud Platform (SCP) and SAP Hybris Cloud for Customer (C4C) based on the User ID of the user logged in to SCP. SAP Hybris Cloud for Customer supports OAuth 2.0 SAML Bearer Assertion Flow. For more....

Writing this blog has been in my bucket list for a long time now… Thanks to a recent inquiry, finally, I had the opportunity to put my ideas into words. While some of the best practices shared below are specific to C4C OData API, majority also apply to other OData APIs. Thus, I hope they....

Export Business Object Change Logs/ History into Microsoft Excel There are many business scenarios for which you need to be able to see the change history or change logs of a document. Audit purposes is certainly one of the most important. But also for analytical purposes or process/data minings this information is important. How to....

Earlier While creating an OData service, I have gone through multiple blogs which has few steps to create Odata Service that helpIed me to create the service. But for every term, I needed to go and search for the particular term to understand what actually they do. So here in this blog, I am going....

The SAP Build portfolio combines our low code solutions which enable users of all skill levels to easily create and augment business applications. The unified low-code solution portfolio empowers users to create applications, automate tedious processes, and design engaging business sites with drag-and-drop simplicity. What is SAP Build Apps? SAP Build Apps is SAP’s low-code....

If you are creating CDS views and importing it as a reference data source in SEGW, you may face ST22 dump or exception while generating runtime objects. It happens du a very small error in CDS.   The below CDS is created. (incorrect One)   @AbapCatalog.sqlViewName: 'ZAAA' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'CDS'....

Hi Everyone, I am writing this blog for beginners on how to filter the data using function Import in SAP UI5 using OData which will be helpful for both front end and back end developer. Function imports are used to do the GET and POST operations for the requirements , which are not possible by the standard....

News Feed: 23.05.23: ABAP Environment release 2305 23.02.23: DSAG ABAP developer day for Microsoft integrations with SAP’s engineering team Dear community, Building on Frank’s “BTP ABAP Environment on Azure” release announcement we will take you on a journey of various Microsoft integration scenarios with ABAP over the coming weeks. Excited yet?🤩 Using the language flavor “ABAP Cloud” ensures you’re set....

Today I’m going to explain how to Sort, Filter and Group data within a List (sap.m.List) or a  table (sap.m.Table) with the ViewSettingsDialog element in a dynamic form. Filtering data of the example Context The columns and their values to be used to sort, filter and group can be defined statically in the XML view....

This blog shows the gateway project using OData service to obtain an output as a PDF by using Smart form. The objective is to pass the parameter as input and obtain an output as a PDF using Smart Form. Requirement: Pass the Invoice Document number (Belnr) as input and obtain Plant, Purchase document number, Item number,....

Hello again SAP community. I hope you are doing well and that you have had a chance to read my first blog regarding CAP here. Today, I would like to add on that blog regarding building full stack applications in the CAP framework and add a few more Database Artifacts such as calculation views and stored....

Hola de nuevo a la comunidad de SAP. Espero se encuentren bien y que hayan tenido tiempo de leer el primer blog que escribi acerca del CAP aqui. Hoy me gustaria agregarle funcionalidad al blog que hice acerca de las aplicaciones full stack en el framework de CAP. Nuevos artefactos de la base de datos como ....

In the blog Testing SAP SuccessFactors’ API’s: How to use Insomnia to automate the generation of SAML Assertions I’ve followed the instructions provided on SAP documentation Generating a SAML Assertion to generate SAML assertions that could be used in the OAuth 2.0 authentication of SAP SuccessFactors’ API’s. However, during the authentication tests of this method it was possible to....

This blog post describes how you can apply deep filtering in your SAPUI5 application, using CAP and odata V4. This can be used to filter in expanded entities, which has come available in V4. Please note that using an oData V2 model to do this will not work, since this type of filtering is not....

There is a very common problem, that while doing a post request or any kind of update containing empty dates are not allowed by default via SEGW based OData-Services. How to enable this is described here: DateTime field in OData entity – Points to take care when the UI is throwing run-time error. | SAP Blogs....

Export Business Object Change Logs/ History into Microsoft Excel There are many business scenarios for which you need to be able to see the change history or change logs of a document. Audit purposes is certainly one of the most important. But also for analytical purposes or process/data minings this information is important. How to....

In SAP S/4HANA Cloud, there are three fundamental possibilities available for the extensibility of the standard functionality that is available out-of-the-box. These possibilities are: In-App/Key User Extensibility Side-by-Side Extensibility Developer Extensibility/Embedded Steampunk For a high-level understanding of these different options, please refer to the following blog which offers a great overview on this topic. In this blog....

Recently I came across an issue while opening a Standard Fiori App (oData V4 Service Group is not Published). Upon some research & analysis I found the steps to Publish/Activate an Odata V4 service and thought to share with you all 🙂 . Steps: Login to ‘SAP NetWeaver/SAP GUI’ and Execute ‘/n/IWFND/V4_ADMIN’ t-code. Click on ‘Publish Service Groups’. /n/iwfnd/v4_admin  ....

Some time ago  Andre Fischer  wrote a blog post called Support of multiple backend systems – How to use Multi Origin Composition and Routing that explains a cool Netweaver Gateway functionality  regarding oData. Multiple Origin Composition (MOC) is the ability to collect data from different back-end systems, aggregate them in one single service and updating different back-end systems while....

Hi all, here I’m going to discuss about converting OData V4 service to OData V2 with step by step procedure (I will take screenshots from my PC for the reference and few pics from npm.js site). You will get to know the purpose of converting V4 service to V2. Here we have a discussion about....

Cloud Application Programming Model (CAP) is a set of languages, libraries, and tools that are used to create robust services and applications for businesses on SAP Business Technology Platform (BTP). It leads developers down a “golden path” of tried-and-true best practices and a plethora of out-of-the-box solutions to recurring tasks. A CAP application typically provides....

In my previous blog post [Part – 1] Enrich CAP based Services with Behaviors using Annotations, We explored how to enrich CAP based services with access control and input validation related behavioral capabilities using annotations. In this blog post, We will see about Service/API Annotations, Persistence Annotations, OData Annotations to alter behavior of services. Glossary of....

Recently I got a request for getting multiple PDFs from the service that was already in use , and I was already using ‘ GET_STREAM ‘ method to return a single PDF. Facing this request , the most quick and usable solution I thought was why not I am adding multiple PDFs into a single ZIP File....

Since we can do UI5 development with VS Code and deploy our web app to BSP stack on SAP Netweaver. We can do exactly same with any other javascript framework. Personally I am not fun of oData therefore I try alternative ways of building web apps which are hosted on SAP. In my first blog/video....

The Theming of the SAP SuccessFactors system can be managed using the Theme Manager. This Theme manager allows to define own themes or select preselected themes for the product. Customer use this functionality to adapt the look and feel of the product to their corporate colors and logos. When Partner or Customers are building an extension....

This blog shows to integrate AWS S3 Buckets, AWS Lambda Functions and SAP S/4 HANA OData APIs. For those unfamiliar with AWS S3 and Lambda functions, here are descriptions from the AWS websites: AWS (Amazon Web Services) Lambda is a serverless, event-driven service that allows you to execute any type of application logic dynamically without the....

As planning data in SAC is often changed by business users, these changes need to be replicated to the target systems like BW/BPC, S/4 HANA or Data Warehouse Cloud. This is a feature highly demanded by many customers. The Data Export Service API is already GA in Q2.2022 with full data. With SAC QRC4 2022 the Data....

This blog shows the gateway project data model to obtain the data from the PDF file by implementing the ‘GET_STREAM’ method. The objective is to pass the Smart form Name as an attribute of the entity set and get the PDF file. Requirement: That all kinds of mail format are stored in smart form like Conformation mail, Dunning mail etc. and that the format required in frontend.   Below structure to be used as the source of our project data model.   Here are two different smart forms created....

This article is mainly for SAP Commissions users/customers/partners to know & understand available OData API endpoints for your development or building web applications out of it. Introduction   OData is the current default way to communicate with an SAP backend, be it for an (SAPUI5) frontend or any other integration scenario. The goal of this document....

In this blog post i want to show how to connect Microsoft Power BI to SAP data using OData services. Mircosoft Power BI In the Microsoft Power BI desktop app an OData-Feed must be added as a datasource. The app will ask for the URL. The URL should include the entityset-name and filter-options when necessary....

In this blog post, we are going to showcase how to update an existing application to version 4 of the SAP Cloud SDK. The new major version has just been released and comes with a lot of under-the-hood improvements as well as some new features. Since updating a dependency – even to a new major version –....

This blog post provides an example on consuming ABAP RESTful application programming model OData services in asynchronous mode through SAP Gateway. Example Step 1: HTTP POST Request to ABAP RESTful application programming model OData service in asynchronous mode The calling platform can initiate an HTTP POST Request through an ABAP RESTful application programming model business....

Recently I was working in a POC to integrate ODATA in AIF. We already have SAP blogs available on how to integrate ODATA in AIF. So I think there is no benefit in sharing the same again.   However during the implementation of the same, I have faced an issue and I couldn’t find any....

When dealing with Instances that have Onboarding and Employee Central implemented, it is common for the clients to have some types of information that are required in the Additional Data Collection Step of the Onboarding process and might be reutilised in the Employee Profile when the onboardee is converted to a employee in Employee Central.To....

Introduction In this new world of BTP, I was wondering whether I can run python applications in the cloud foundry & perform several things like the followings: accessing the data of different systems(S4H On-Premise, ECC, BTP CAP OData services, etc.) via destinations. running python flask applications having multiple functionalities/pages. I have checked a few places....

In order to enable multiple odata services for fiori apps in S4 Hana. There is a requirement to activate multiple odata service in a single step instead of doing it one by one. In this blog I will explain steps to activate multiple ODATA services in single transaction. Step 1: Go to tcode STC01. Enter task....

This blog post shares my experience about a particular issue I encountered working with an OData service created using ABAP Restful Application Programming model and one possible resolution. The case is associated with an amount field in an CDS entity was exposed as an entity in the service definition. Amount and currency fields in CDS....

This blog is based on the knowledge from this blog. But providing a more streamlined approach, when you want to test your OData services on the BTP ABAP environment from Postman. It may be somewhat tricky to setup authentication for your service calls in Postman against the BTP ABAP environment, but I will show how it....

Welcome to this short blog post showing you everything you need to add an attachment to an object in S/4HANA Cloud by using the Attachments API and Postman. I wanted to write this blog post as I couldn’t find an easy to follow blog post on how to use this API to create a pdf attachment for....

This blog post is about automatic documentation of OData entities. As I already explain in my previous blogs, I don’t like wasting time on tasks that can be done automatically (and in a more efficient way) by some tools. On another side, I really like, when I use some OData entities, to see a nice....

Part 02 – ECC / Abap flavor This blog post is the second par of this one: Previous blog (part 01) In this part, I’ll show you how to get the PlantUml schema definition of an OData entity defined on the Abap stack (on-premise system for example). Thanks to the transaction SEGW, you can define and....

Motivation Recently I had to map a custom message type to a defined S/4HANA OData service. What sounds like a simple task might not be so easy if you are a beginner with SAP Integration Suite. If this tutorial can save you some hours of research work, it has already served its purpose! I will....

In a Data Warehousing scenario, integrating complex models to analytics solutions is vital to empower business planning and decision making. The SAP Data Warehouse Cloud Public OData APIs empower customers by enabling programmatical data consumption as plain relational data or even complex analytical models. Such scenario extends the existing integration capabilities with SAP Analytics Cloud....

coauthor: Ralf Handl SAP Fiori Elements Object Page Floorplan Draft Scenario Displaying an Error Message   OData Error Message Introduction When building applications with the SAP Cloud Application Programming Model (CAP), generic service providers significantly shorten the service development time by providing many out-of-the-box solutions to recurring tasks allowing you to focus on the specific business logic of your application,....

The employee should be terminated when the contract end date is expired. Contract end date field is in the job information section of the employee profile. Options explored Off cycle batch event – can’t use when more than one entity are involved. Integration center – success. Solution The solution is developed using Integration center. 1.....

Problem Statement: With the Fiori List Reporting Framework it is always expected to have a navigation using the Smart links from one application to another application . How can the smart links be implemented using different Annotation possibilities :   Navigation to a single Custom application  There are two ways to  navigate to a single....

With S/4HAHA and Fiori, OData and APIs have become an integral part of almost all our solutions. And while working with them, we always encounter one or the other new issue and with that eventually we end up with new learning. In this blog i am going to share my learnings on handling date and....

Whats the ODATA and REST API’s and why we need that? Combination of different software system is sometimes need, sometimes mandatory in our modern IT world. The question is that how these systems have to communicate and exchange Datas. A number of standards and protocols have been discovered to facilitate communication between different systems. If....

I haven’t used the OData v4 model in UI5 Freestyle apps a lot. I had the idea that I would lose the flexibility of  the Odata v2 model (in combination with a JSON model) and this would block me at some point developing UI5 apps. My main concern was the possibility to create a custom....

SAP社が提供するノーコードツール SAP AppGyver を使ったアプリの作成例を3回に分けて ご紹介します。本ブログは第2回目となります。 SAP HANA Cloudからセッション情報などを取得したり、問合せ内容の登録ができる イベントガイドアプリをノーコーディングで作成しました。 SAP AppGyver上の操作をステップバイステップで記載していますので是非ご参考にしてください。 1.全体概要・準備・SAP AppGyverでのアプリ作成(画面遷移・データ参照) 2.SAP AppGyverでのアプリ作成(データ登録)←本ブログ★ 3.チャットボット機能の導入 Index 1.はじめに 2.アプリケーションの構成図、利用サービス 3.準備 4.SAP AppGyverでのアプリ作成(OData連携~データ登録~) 5.終わりに   1.はじめに 本ブログでは SAP Inside Track Tokyo というコミュニティイベントのスマートフォン向け イベントガイドアプリをSAP AppGyverで作成しています。 このアプリでできることは以下となり、今回記載する内容は「問合せ機能」となります。 イベント情報の参照 イベントの概要 セッション情報 イベントの動画・投影資料 参加者ブログ FAQ イベントの参加登録 すぐにつぶやける(Twitterでハッシュタグ付き) 問合せ機能 チャットボットでセッション情報を参照する 「問合せ機能」、「チャットボット機能」以外は第一弾のブログにて記載しています。 第一弾のブログはこちら:SAP AppGyverで作る SIT イベントガイドアプリ(Part1)   2.アプリケーションの構成図、利用サービス このアプリの構成の内、今回紹介する部分は以下となります。 (他のAPIサービスなどを利用される場合はODataサービスの作成は不要です) SAP BTP, Cloud Foundry environment Node.js....

Introduction The SAP Gateway OData V4 framework does not support to perform a deep update. This is also true for the OData V2 framework. And as a result also RAP based services do currently not support deep updates. However today I learned about the need of such a support for an integration scenario where the....

When you implement My Inbox fiori app you can face one issue in which user is receiving duplicate work items in his My inbox fiori app. If you check total workflow tasks in inbox from SBWP . Workflow is showing total 7 items. Total 7 workitems   If you login to My inbox fiori app....

Today I want to tell you a funny topic. The topic is ‘$Batch operation on the Gateway Services with CDS’. In Odata, generally we use deep entity method for implementing table or header-item relationship. But sometimes we do not want to implement deep structure methodology, we want to send data in just one request or....

Lately, question of why smart controls, are not part of OpenUI5 started coming to our team on a regular basis. So, we started wondering if all smart controls need to be part of OpenUI5 or just some of them? Therefore, I’d like to reach out to you and open discussion in the SAP Community Coffee....

Hello ABAPPERS, Today’s topic is very interesting . The aim is send Adobeform pdf with oData, also we can send Smartform as well.  This is very easy thing for  implementation. I will explain details step by step. Prerequests -Knowledge about adobeform or smartform -Basic knowledge about oData -SAP Gateway usage   First of all,  We create....

Businesses are unique, and so are their challenges. Evora designs, builds, and implements custom-tailored solutions based on modern technologies and best practices. As a long-time SAP partner, we have extensive experience in developing custom apps and connecting them to SAP backend systems. I spoke to my colleague Frederic Pollmann about his project experience so I could share....

Welcome to the Eight episode (Not the last) of the Series: SAP CAPM Full Stack UI5 Application with CRUD Operations. Till now we have created Development Space in BAS with project structure for development, created entities, exposed Odata services and done Update & Delete Operation. In this episode, we will do Edit Operation in the created table. Assumption(OR....

Based on the following question RAP: Key As Segment capability support posted by Geert-Jan Klaps I found that I missed to blog about a nice “out-of-the-box” feature available for OData V4 services that lets a consumer use an alternate convention for addressing entities by appending a segment containing the unquoted key value to the URL. This feature is described....

The SAP Application Interface Framework enables you to develop and monitor interfaces as well as execute error handling in a single framework residing in your SAP back end system. It enables you to monitor interfaces across technologies centrally and configure alerts for the errors, mass error handling, and most importantly, empower business users. If there....

In my last blogs I used Basic Authentication method to call SuccessFactors OData APIs.  Calling SuccessFactors OData APIs via iRPA 2.0 Let’s call iRPA 2.0 bot from CAI chatbot to update SuccessFactors I decided to invest time in changing this to OAuth 2.0 Authentication method. What makes oAuth 2.0 with SAML more secure than Basic....

In S4HANA Cloud, you want to expose your custom CDS View as an OData Service but because there are mandatory parameters linked to it, it’s throwing up an error while forming your web service query. If this sounds familiar, this small little blog is going to help you find the way. There are some powerful....

So, in the last blog post, we created a health check endpoint in our Java application. In this one, we will introduce our entity relation model and build the OData service with help of the Olingo framework. We have a simple entity relation model, which consists of three entities: Mother, Child, and Father. Obviously, a child....

In  part-1 of this blog series we will add a custom field Smart Number to SAP S/4HANA Manage Purchase Order SAP Fiori app and also make it editable so that data will persist in Database. Manage Purchase Order is Created using below principles:   Backend SAP Fiori Elements on CDS for UI annotations Reference Data Source to enable OData....

I recently got in touch with OData in connection with the ABAP Programing Model for SAP Fiori. However, there is more than only this one programing mode. There is SEGW, there is RAP and CAP… I’m aware of the fact that various documents/blogs have been published on the topic of OData already, but for sake....

How to find if a ODATA service is created using a RAP Model from Fiori app library in a standard application : Open the Fiori app Library and select your desired application : https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F0702A’)/S21OP Applications with the Versions 2021 will be created using the RAP Model In the below examples you can see the Odata....

Hello,   While creating Odata services, I had gone through multiple blogs post and found that there are few steps which are not self explanatory and hence at the end of creating an odata service we get bad HTTP response . This is mainly due to missing explanation for how to load meta data and....

Customers would like to access and extract Key Performance Indicator (KPI’s) data using OData service to extract data from SAP Business ByDesign. It will help customers to perform analytics in external tools like SAP Analytics Cloud or any 3rd party tools like Excel. the Blog and Video Demo covers the following aspects: Customer Scenario using KPI OData service Demo....

Hello Everyone, In this Blog post, we will see how to create SAP UI5 application in Visual studio code. Before we Start, I just want to highlight one thing, SAP Business Application Studio(BAS) does not require any kind of installation on your system, as its all on the cloud, but in case of Visual Studio....

Hi All, I had gone through multiple blogs post for post Odata service. In those documents it was given very high level steps. For beginner, its difficult to know how exactly these steps has been executed. In my previous blog Post , We had learn about how to create a Odata service and test the....

SAP HANAデータベースにあるデータを外部に公開するユースケースではODataを使用することを推奨しています。 2019年からSAP では数々のプロジェクトで得た経験に基づいて、統一されたクラウドアプリケーションの開発手法Cloud Application Programming model (CAP)を構築し、提供しています。CAPは、サービス及びアプリケーションを構築するための言語、ライブラリ、ツールのフレームワークです。ベストプラクティスを凝縮し「ゴールデンパス」を提供しています。開発過程で繰り返し発生する作業に対して、すぐに使える豊富なソリューションに沿って開発者をガイドします。 CAPのプロジェクトでは、技術的な分野を掘り下げずに、ドメインに重点を置いて開発を進めることができます。 このブログでは、SAP Cloud Application Programming Modelを使用してSAPHANA Cloudにテーブルを作成し、そのテーブルをODataサービスとして公開します。この方法では、ODatav4.0を使用してデータを公開します。 ODatav2.0を使用してデータを公開する従来のxsodataメソッドとは対照的です。 参考リンク:Building hana-opensap-cloud-2020SAP Experience academy (SAP Internal)CAP Getting started guide 前提 SAP Business Technology PlatformアカウントでSAP HANA Cloudインスタンスを作成(トライアルでも可能) 開発環境の準備 HANA Cloudインスタンスがセットアップされ、開始する準備ができたら、サブアカウントでサブスクリプションを開き、SAP Business ApplicationStudioをクリックします。 新しいDev Spaceを作成します。 SAP Cloud Business Application テンプレートを選択し、開発スペース名を指定します。 ステータスが「開始中」から「実行中」に変わったら、開発スペース名の付いたタイルをクリックします。バックグラウンドで、Dev Spaceには、CAPアプリケーションの開発に必要なコンポーネントが用意されています。たとえば、ノードJSやCDSなど。Business Application Studioで開発すると、ローカルPCに何もインストールする必要がありません。 テンプレートからプロジェクトを作成 これで、Business Application Studioが起動、構成され、使用できるようになりました。 Welcomeタブで、[テンプレートからプロジェクトを作成]をクリックします。 @sap/capテンプレートを選択します。 プロジェクトにSAP HANA関連の機能を含めるには、[hana]チェックボックスをオンにします。....

Starting the release of CDS Graphical Modeler 2105, you can not only create entities and projections but also the CDS Graphical Modeler would allow you to create structured types, enums and named aspects as well. In this blog post, we’ll demonstrate how to create structured types, enums and aspects using the CDS Graphical Modeler. Creating....

Odata is a widely used protocol to query data from cloud or on-premise hosted application in a secure manner. In this blog, I am trying to showcase the steps that can be used to enabled OData access for SAP IBP application.  Once OData configuration is done, this can be used to query any Master and....

Good day Today I have a use case that builds on my previous blog, Create a custom MDF Object with multiple records.  To build on this use case, I have a new requirement that should allow attachments to be automatically added to the record that already exists. I first want to mention this blog as the input for....

Hi All Over the past months, customers were interested on how to get file Job status  Success/failed/awaiting for the files been pushed to GoAnywhere Dropbox(sFTP)..The Only way was through logging through SAP Commission Portal > Commission Data Loader > Job Status. The purpose of this article is to demonstrate and explain how it works through API and....