Today I am going to discuss about the MTA project Integration with GitHub as a source control in Web IDE: HANA XSA. Before perform the steps, I want everybody know the flow and keep the diagram so that you have a clear concept on this migration –   Integration Steps : 1. Open your project....

Issue – The BODS job it was taking only 30 mins to complete by the time when it was go- live, and it is daily job with delta load filter condition. Later on this jobs completion was increasing by 3 mins every day and it reached to 5hrs 33 mins. Basis team raised a concern that....

Today I am going to discuss about the MTA project Integration with GitHub as a source control in SAP Business Application Studio: HANA XSA. earlier I discussed integration with  Web IDE which is slide difference. SAP Business Application studio support  Personal access tokens instead of passwords and to access GitHub repo  in a SAP Business Application Studio....

In this blog, I am going to tell about some Tips and best practices of SAP BW and ECC you can utilize in your work – 1. While transporting a Composite provider after adding one field from underlying ADSO getting the error every time that  the added field (Key) is missing in the CP node....

Data Cleansing and Data Matching with SAP HANA – Smart Data Quality (Source: SAP) Introduction Today, companies leverage data from a variety of internal and external data sources. In order to integrate these successfully, the data must not only fit semantically, but also have a common key in order to be able to merge them....

In this blog, I would like to show you how to download a ZIP package stored on an application server via Odata call in very simple steps. I have tried not to add any additional logic apart from downloading the ZIP package from the Odata service. Steps 1. Table creation. 2. Create an oData service.....

Tracking the changes in datasets is one of the core functionalities of any data warehouse. The most common form of historization is called slowly changing dimension type 2 (SCD2). Instead of simply overwriting changes in a dataset (which is a type 1 historization), validity dates are used to identify the time range in which a....

This blog post shows the steps to create a simple CPI monitoring App using AppGyver. Final App Preview:   Configuration Guide: High level set up guide for AppGyver: Use REST API Direct Integration to connect with API endpoint from SAP API Management, which is in turn connected to SAP CPI. Data Tab Request Schema   ....

In continuation to my first blog on unexplored features in BPMN diagrams, let us now look at Process Diagrams and Interface Diagrams.   Process Diagrams: A process diagram analyzes the sequence flow in a single process in a participant Context Menu in Process Diagram: There are four parts of context menu objects that are available based on....

The purpose of this blog is to show you how to create/modify/delete google sheets via background programs from SAP. Since these are background jobs run by the SAP system, it is not up to a user to authenticate to google since there is no human action. So we cannot choose the methods where the user....

As most of you probably already know, there is the famous Ctrl+Shift+A search in ABAP Development Tools (ADT) to search for development objects in an ABAP system. So, you might wonder, why am I writing about the topic of searching for development objects if there’s a perfectly functioning solution already available? I’m glad you asked!....

Would like to share an idea on how to utilize in full potential the combo Recruiting business rules, Pre-screening questions and quick Apply as a powerful tool to rate candidates in your job requisitions. In order to do that I need you to understand three main features: 1 – Pre-Screening Questions: Roughly speaking, “pre-screening” questions....

The offer management process allows recruiting users to send offers for approval before they are extended to the candidate. The Offer Approval process consists of assembling the details of the offer intended for the candidate and routing it for approval from key stakeholders. Once the offer approval form is generated, it can be routed for approval to....

(January 2023: this material can now be found in the help at Map an SAP HANA Database to another Environment Context | SAP Help Portal, including command-line instructions) SAP Business Technology Platform (BTP) applications looking to store their data in SAP HANA Cloud typically do so using a HANA Cloud schema or HDI container, which is....

This blog is to share the knowledge of Integration via SAP BTP CPI. During my learning phase of CPI, I’ve gone through an uncountable number of articles to better understand CPI and its various features which is a bit irritating when you have to search online and struggle a lot just to get any particular....

Systems are not adequately configured or updated to restrict system access to properly authorized and appropriate users. Control Description Access is authenticated through unique user IDs and passwords or other methods as a mechanism for validating that user are authorized to gain access to the system. Password parameters meet company and/or industry standards (e.g., password....

SAP Profitability and Performance Management 3.0 in its upcoming Support Package 20 provides additional enhancements which can also be found in the official site: What’s new section – SP20 Support Package section in PaPM’s Help Portal. Here is what we have in store for this release: Export Environment Additional consistency checks are enabled during extraction of environments....

This blog covers latest information and known issues for the SAP S/4HANA 2022 Fully-Activated Appliance, delivered via SAP Cloud Appliance Library (SAP CAL). The overview blog for the appliance can be found here. The known issues for older appliance releases are here: 2021 / 2020 / 1909 If you would like to ask a support question, please do so in the SAP....

This blog lists the detailed steps that have to be performed for successful creation of an SAP Fieldglass type of connection in your SAP Data Warehouse Cloud (DWC) tenant.   Pre-requisites: Configuration Manager of SAP Fieldglass SAP DWC administrator has connected SAP HANA SDI – Data Provisioning Agent and registered the CloudDataIntegrationAdapter. Please note that....

SAP BTP Developer onboarding for SAP Build Apps. Pre-requisites, how to configure, and how to create an example project that accesses a back-end LoB system via a SAP BTP destination. Tutorial video embedded with references and additional information. For the main article, see SAP BTP Developer Onboarding | Hands-on Video Tutorials Anything to add? Leave....

SAP BTP Developer onboarding for SAP HANA Cloud. Entitlements, provisioning, configure instance mappings and create HDI containers in the Cloud Foundry and Kyma environments. Tutorial video embedded with references and additional information. For the main article, see SAP BTP Developer Onboarding | Hands-on Video Tutorials Anything to add? Leave a comment below. Useful? Give us....

In this blog, we will learn, how to generate Access Token Via REST API with Body of type Form using ABSL Code in SAP Cloud Application Studio. We will at first show how we can do the same using Postman and afterwards go to the details of sending this request using ABSL Code. 2. Sending....

Beside the option to start and schedule application jobs from within the Application Job App there might be the need to start an application job from within an application based on a RAP business object. Scheduling an application job using the API’s provided by the underlying ABAP platform framework can be tricky when doing so....

Today I am going to discuss about the Transport and Deployment of Artifacts in WEB IDE : HANA XSA. In the below diagram I am going to discuss about the different deployment option for MTA  Application.       Now describe each and every Application Artifact’s deployment process in Details : 1. Artifact Deployment using....

This blog explains down payment requests; down payment invoices are not supported in SAP Business ByDesign, but down payment requests are. For more information about the down payment process and business background, refer, Down Payments Received in Financials. The workaround described in this document was created/designed based on project experience in Bosnia, Croatia, and Slovenia, countries/regions....

This Blog will cover End-End cycle including Important Configurations and Demo for PS Easy Cost Planning ( ECP ) Integration with S/4HANA Financial Planning As of Version 2022 FPS 00, SAP has provided out-of-box Integration of Project based cost planning integration with Financial Planning for Easy Cost Planning and Network Costing Before above mentioned version,....

Hello, How is everyone doing? I hope all are in good health and always driving towards leanings new things or expanding your horizons. Today I will be discussing a walkthrough of the project cycle for the S/4HANA conversion project. Sometimes while working on a particular role we miss the bigger picture. I will be explaining....

The following blog will guide you to deploy a UI5 application on AWS S3 with Dynamo DB as backend database, Lambda as the business logic layer and API gateway which acts as a connection between the client(UI) and Lambda.   Architecture Now lets tackle these layers one by one. Amazon S3: Head over to your....

SAP CPI Message mapping Flat Structure to Tree structure which has been briefly explained by Eaksiri Sontisirikul in on the blog. It is a great blog. Thanks Eaksiri. I was trying expand the payload bit complex and came up with some additional mapping steps. So I decided to share those information below. Request payload. <CompoundEmployee> <Person> <Manager_ID>1000</Manager_ID> <Manager_Name>Manager....

このブログポストでは、SAP Analytics Cloudの2022/Q3リリースでサポートされた、マスタデータの多言語対応についての下記トピックについて紹介します。 多言語対応の機能について 多言語の有効化と言語の追加・マニュアルによるデータ更新 ファイルインポートによるデータアップロード SAP S/4HANAからSAP BW(SAP BW/4HANAを含む)接続を使用してデータアップロード 本機能とは別機能となるSAP Analytics Cloudオブジェクトの翻訳機能については、以下のブログポストに記載されていますので、そちらを参照ください。 SAPブログポスト：SAP Analytics Cloudのビジネスコンテンツの利用   ●多言語対応の機能について SAP Analytics Cloudマスタデータの多言語対応の機能は、公開ディメンジョンで使用可能であり、最大49言語まで対応しています。個々の言語は、マニュアルで更新するか、マスタデータアップロードで更新することができます。表示される言語は、プロファイル設定のデータアクセス言語にしたがって導出されます。   ●多言語対応の有効化と言語の追加・マニュアルによるデータ更新 多言語対応の機能の有効化から新しく登録する言語の追加・マニュアルによるデータ更新といった一連の設定の流れを紹介します。 対象の公開ディメンジョンを開き、ディメンジョンの詳細パネルで言語と翻訳セクションまでスクロールし、[多言語を有効化]トグルをオンにします。その後、設定を保存します。 ツールバー[翻訳アイコン]をクリックしドロップダウンメニューを開き、追加したい言語（English）を選択します。 説明ラベルの(ja)が(en)に変わり、各ディメンジョンメンバーの説明セルが未入力の画面が表示されます。 ディメンジョンメンバーごとに翻訳された説明を登録します。 登録が完了したら設定を保存します。   多言語対応の機能を有効化した公開ディメンジョンをモデルに組み込み、ストーリーを作成・参照するとプロファイル設定にしたがった言語でデータが表示されます。 ●ファイルインポートによるデータアップロード 多言語対応の機能を有効化した公開ディメンジョンに、データのインポート機能を使用し、ファイルからデータアップロードすることもできます。        ・データアップロード手順 対象の公開ディメンジョンを開き、ワークスペースのドロップダウンからデータ管理を選択します。 データのインポートアイコンからファイルを選択し、アップロードするファイルを指定、インポートします。 マッピング画面で各項目について設定し、マッピング終了を押すとデータがアップロードされます。   ファイルからデータをインポートする場合、ドラフトデータアップロード後に項目マッピングの画面が表示されます。言語ID(Language ID)のマッピング項目がありますが、この項目について特に設定しなければ、公開ディメンジョンのデフォルト言語にしたがいデータがインポートされます。複数言語を登録する場合、意図しないデータのインポートを防ぐため、インポートするファイルに言語IDの項目を用意したほうが管理するうえで便利です。   複数言語をまとめて登録することもできます。例えば、日本語と英語のメンバーをまとめて登録したい場合は、下記のような複数の言語IDを含んだファイルを作成して、インポートします。 (注記)言語IDが、大文字または不明文字列の場合、マッピングエラーとなります。データアップロードは実行できますが、データのインポートはされません。公開ディメンジョンの説明列のカッコ内の文字に合わせて必要があります。   ●SAP S/4HANAからSAP BW(SAP BW/4HANAを含む)接続を使用してデータアップロード SAP Analytics Cloudの接続を使用し、SAP S/4HANAからデータを公開ディメンジョンへアップロードすることもできます。ジョブ化もできるため、非常に便利です。ここではSAP....

At its core, Kyma is an open-source project that was initially launched in July 2018 by SAP. The basic premise of this project was to provide an enterprise-grade developer experience (DX) on the Kubernetes platform so that they can build extensions to other enterprise applications. Kyma is a runtime that comes standard with building blocks....

SAP build is a combination of different intelligent tools such as SAP Build Apps, SAP Build Process Automation, and SAP Build Work Zone advanced edition which helps organizations to create/roll out enterprise applications in no time. SAP Build Work Zone which helps to create business sites is combined as a package with other tools.  SAP Work....

Updated 6th January 2023. For all those who are more visually stimulated, I have updated the blog post with a video posted on the SAP Developers YouTube channel on how to use the app. Updated 23 February 2023. Release 2302 What it is, in a nutshell Are you a newbie in the world of ABAP CDS, SAP....

Please note that this post was first published at https://medium.com/@yagubovafatima/enhancement-for-fiori-finding-the-places-for-enhancement-getting-custom-error-message-4a6272fb7daa. I am working as a SAP ABAP Developer in a Consulting company and during the worktime we face different kind of problems especially in adding custom functionalties to SAP standards. In this blog, I am going to explain one these problems and its solution. The problem:....

Ho-ho-ho! Christmas is coming, and surprisingly, I have something interesting to share. In short: The SEN Workflow Approver extension has an exciting new function called the Extended Feedback. The SEN Workflow Approver extension is now known under a new name: SEN Content Review Wizard, as it is no longer only about workflows. What is this Extended Feedback....

本ブログはこちらのブログの日本語版になります。 はじめに 本ブログでは SAP Data Warehouse Cloud BW bridge(以下、BW bridge)への リモートコンバージョンの概要をご紹介します。さらに詳しい情報は SAP Data Warehouse Cloud, SAP BW bridge Runbookをご覧ください。こちらのRunbookには事例や、実際の導入プロジェクトの際のTipsなどが含まれています。 概要 リモートコンバージョンを使うと、既存のオンプレミスBWシステムからターゲットとなるBWシステムへメタデータとビジネスデータを同時に移行することができます。ターゲットシステムはレシーバシステムとも呼ばれ、BW/4HANAやBW bridgeが想定されます。BW/4HANAへのリモートコンバージョンは2017年から提供されており、現在ではSAP Data Warehouse Cloud(以下、DWC)内の BW bridgeへのデータ転送も可能になりました。 メタデータのみの移行はシェルコンバージョンとして提供されています。(詳しくはShell Conversion Guideをご覧ください) メタデータの移行はリモートコンバージョンのプロセスの一部なので、シェルコンバージョンはリモートコンバージョンに含まれているといえます。どちらの方法で移行を行うかは、オブジェクトの数やデータボリュームなどの要素によって決まります。 DWCのBW bridgeではBWのアーティファクトをDWC内で再利用することができます。DWCにはBWのモデリングが行われるABAPテナントが搭載され、独自のスペースが作成されます。アドバンストDSO(以下、ADSO)やInfoObjectなどのABAPテナントのテーブルはDWC内のBW bridgeスペースでリモートテーブルとして表示され、他のスペースに共有することで利用ができます。 BW bridge専用スペースはリモートテーブルの表示と、他のスペースへの共有のためのスペースなので、機能は制限されています。例えば、データフローやビューの作成は、BW bridgeからリモートテーブルを共有した他のスペースで行うことになります。   シェルコンバージョンとリモートコンバージョンは、メタデータ転送の際のスコープコレクションロジックに違いがあります。特に依頼管理の依存関係によるものです。リモートコンバージョンを使用する際は、データと依頼情報はセンダーシステムからレシーバーシステムへコピーされ転送される必要があります（依頼IDからTSNへ）。つまり、データ依頼に関連するすべてのオブジェクトは、一貫性を担保するためにスコープコレクションに含める必要があります。 メタデータ転送はオブジェクトタイプを変換します (TLOGO) 。 例えば、クラシックDSO(以下、DSO)とインフォキューブをADSOに、PSAをADSOに(データフローに依りますが、これは任意の場合と必須の場合があります)、インフォパッケージをDTPに変換します。 前提条件 DWCのBW bridgeへのリモートコンバージョンは BW 7.3(SP10以降)以降 と、BW/4HANA 2021(SP00以降)以降で使用できます。また、DMISアドオンのインストールが必要です (こちらはシェルコンバージョンでは必要ありません) 。 詳細な前提条件についてはSAP Note  3141688 – Conversion from....

One of the requirements we can have in projects when implementing SAP Business Network solutions is the inclusion of custom pricing details on the invoice created in SAP Business Network and sent to the SAP system. Once the pricing conditions are implemented and available in the SAP Business Network, it is imperative to consider the....

Summary: In my previous blog, I explained how to enable the GOS toolbar on the CRM billing document in SAP  GUI screen. In this blog, I’ll capture the need to display the GOS toolbar’s data and PDF attachments in the CRM Web-UI screen for improved user experience.   First step is the enhancement of standard BSP....

In this blog , will be demonstrating how to use SAP Standard API in SPA. This approach helps us in avoiding fetching X-CSFR token manually in the automation steps where first GET call is required to get token and later the token is used in POST Call. It will also avoid maintaining User/Password in SPA....

During the last weeks of the year, I usually go through my tools to do some cleanup work and compile an annual review. When I did so, I remembered a security vulnerability that kept the whole IT world busy in December 2021 and early 2022. Now that some months have passed by, I thought it....

Yes, it’s not a typo, it says SAP R/3 2.1D… released in 1994 🙂 Usually I write about the latest tech trends, but this year is SAP’s 50th anniversary so to celebrate this significant milestone I wanted to do something special. I am a collector of old computers and software and have a passion for these....

This is part of the Easy way to write algorithms in ABAP: Series 01. For more algorithms, please check the main blog-post. Problem Given an integer array nums, find the subarray which has the largest sum and return its sum. Example 1: Input: nums = [-2,1,-3,4,-1,2,1,-5,4] Output: 6 Explanation: [4,-1,2,1] has the largest sum =....

For a long time, I didn’t find many blog posts regarding writing algorithms in ABAP where as in case of GPLs it is quite popular. So, I am starting a series on this topic for practice & education purposes.   Please feel free to comment & have a happy learning experience. 🙂   Algorithms Easy way....

How can we easy and fast way to build machine learning applications? And how can we share the application to other people? This is the prototype application for today’s goal. The example video is simple image classification web app using machine learning to detect banana ripeness. Let’s find the solution with SAP BTP Kyma and....

Summary : This blog will cover to make hyperlink on specific field and display PDF document on CRM webUI screen in a popup window. To achieve this functionality, we need to redefine P-method of the attribute with below code logic. I’ll take an example of below technical objects to demonstrate the solution. BSP component :....

In the previous Blog Post: Workforce integration from SAP SuccessFactors to Master Data Integration service – Part1 I have described how to integrate Workforce data from SAP SuccessFactors to Master Data Integration. This blog post I will provide the steps required to integrate Workforce data from SAP Master Data Integration to SAP S/4HANA Cloud.   Process: Step1:....

Those of you who have attended the SAP BC400 training course, which is the introduction to ABAP development, will start by writing a program that acts as a simple calculator. It is based on ABAP PARAMETERS for inputs, ABAP WRITE statements for outputs , and is designed to show the basic constructs of most programming....

This blogs explains the communication between Dispatcher of an ABAP application server instance to the Message server of the central ASCS instance. Many customers want to use additional hostnames on Windows to separate SAP TCP/IP communication from other traffic. This blog shows  how to configure this. The following picture shows the communication of an ABAP....

NSE Implementation Experience ** All the screenshots are taken by me from one of our HANA implementations. Introduction: NSE is a fully functional warm data store on HANA database, which we can leverage to move less frequently accessed data without loading fully into memory. This is a very good feature, where we can avoid increasing....

This blog post describes the Two-Tier scenario of MRP Visibility between headquarters and subsidiary which run on two different instances of SAP. Headquarters are expected to gain better visibility on the MRP results generated at Subsidiary end and vice versa. With this analytics scenario the much-required capability with Two-Tier integration to check the status of....

We all know the world is evolving. So is SAP. 🙂 In the era of SAP ECC, there used to be Workflow builder (Transaction Code – SWDD) which ties together all the workflow component and the approval cycle very tightly with all the building blocks. SAP HANA came up with yet better solution design for generalized....

Clean code is a term used to describe software that is easy to read, understand, maintain and test. In this blog I want to summarize some important principles and provide an entry into the topic for beginners. Besides, the blog shall connect to the style guide repository, the books and current initiatives where experts can....

Transporting only changed / modified / created holidays and holiday calendars from development to quality and production system. Transporting holiday and holiday calendar changes are not like transporting any other SAP HR configurations. Reason: SAP have not provided any option to transport only holidays or holiday calendars you have created / changed / modified. If....

In this blog we will learn how we can filter our data in SAP AppGyver using Data entity. For this blog I will be using Northwind oData for my backend and how we can filter the data in our UI application. Introduction AppGyver is a low-code/no-code (LCNC) platform designed to streamline app development. AppGyver’s core feature,....

Use Case – Need to propagate technical user to the on premise S4 system using methodology of principal propagation. Authenticated applications running on BTP Cloud Foundry, can now propagate technical user utilizing SAP-Connectivity-Technical-Authentication header. We recently had a requirement where we would need to propagate the Technical user but did not want to use Basic Auth as....

Recently I was working on multiple conversion projects where we had a requirement from the client that he is unable to get the select screen parameters after selecting Z variants. After system conversion or upgrade, if we do not get select screen parameters in existing Z variants. we can adjust the invalidated report variants. In....

The purpose of this blog is for Country Classifications based on M49 Coding for UN Agencies   Step1: Develop a customized report on MKVZ and include country classification based on M49 coding. This classification will ensure alignment with (High-Level Committee on Management) HLCM Standardization across the UN. In the SAP system country, wise global parameters....

SAP Build came out last month, and most of the focus is on the individual products, but I wanted to take a look at the SAP Build lobby, the one part that really unites all the products – and give you a few tips so you can use it efficiently and effectively. In an SAP....

I’m sure you often have the situation that you are implementing a method in ABAP with ADT and you need information about the signature and the types that are used in the signature. The standard answer for this is the Element info (Shortcut F2) on the method name. Unfortunately, the element info is displayed in....

ABAP Cloud has been announced at SAP TechEd 2022 and was part of Juergen Mueller’s day 1 and Philipp Herzig’s day 2 keynote. After SAP TechEd, we provided more details regarding ABAP Cloud in an SAP developer community session and in the keynote of the ABAPConf (in German). In this blog post, we summarize the basics of ABAP Cloud. At the....

The ABAPers journey is incomplete without where we need to process Excel file data for further processing. In my experience, it is mostly for BAPI development i.e. getting the data from an Excel file and converting it to a suitable form. Earlier I was using Loop, Endloop statements, and CONVERSION_EXIT_ALPHA_INPUT function module for the same.....

This Blog post is regarding Activating Standard Fiori Application process. Introduction: In this blog post, I would like to work on the process of activating standard fiori application and show that application in fiori launchpad after it got activated. For that we have to follow the process which includes steps as follows….   Step1: We should....

In a recent assignment, I had the opportunity to use the Cloud Application Programming Model and Fiori Elements to design and create an enterprise-ready application. I used a few concepts like dynamic expressions, side effects, and custom actions on object pages. However, finding appropriate material or references with examples and understanding the concepts required a lot....

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....

In my blog Download And View PDF document From BTP Document Management Service In SAPUI5.   I have demo how to view PDF document from BTP Document Management Service(BTP CMIS) . But customers need to realize other requirements like query, create and delete documents in BTP CMIS in SAPUI5.  To query documents, we can use cmis query.( Text....

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....

SAP SuccessFactors solutions are cloud-based HCM software applications that support core HR and payroll, talent management, HR analytics and workforce planning, and employee experience management. SuccessFactors solutions are used by over 235+ million users in more than 200 countries and territories around the world. SAP SuccessFactors Intelligent Services Events SuccessFactors already comes with Intelligent Services....

This is part of the Easy way to write algorithms in ABAP: Series 01. For more algorithms, please check the main blog-post. Problem You are given an array prices where prices[i] is the price of a given stock on the ith day. You want to maximize your profit by choosing a single day to buy one stock and choosing a different day in the future to....

In the blog SAP Print Service, Markus Berg has introduce BTP SAP Print Service. In my following 2 blogs, I will introduce how to configure, how to test, and how to use it in UI5 . There is mission Add Printing Label to Your User Experience for SAP S/4HANA Cloud.in which a S4Hana Cloud side by side extension for....

In this blog I am going to propose you a technical solution that I used on my last project to maintain “transports” between multiple environment packages in the same SAP Cloud Integration tenant. The problem, often found in projects, comes when a SAP Cloud Integration tenant need to support multiple environments. There are situations when,....

In my blog Test BTP SAP Print Service With Postman, I have explained how to SAP Print Service with postman. In this blog, I will explain how to use it to print document in an UI5 application deployed in BTP cloud foundry run time. To use a PDF document, I will combine the code with my blog Render....

このブログポストではSAP Product Footprint Management（PFM）のビジネスコンテンツのインポートおよび利用方法を紹介します。また、本ブログは2022.08バージョンでの内容を記載しており、今後機能追加により、アップデートされる可能性があります。 SAP Analytics CloudとSAP Product Footprint Managementの接続概要 コンテンツパッケージユーザガイドでPFMのビジネスコンテンツの内容を確認することが可能です。 以下はヘルプから抜粋したPFMのビジネスコンテンツの概要となります。 ODataサービスを利用して、PFMからフットプリントのデータを抽出し、SACのインポートモデルにデータを格納します。製品ごとの温室効果ガス（GHG）のフットプリント計算はPFMで実行し、SACは製品ごとのフットプリントの計算結果を分析するためのストーリーを提供しています。PFMのコンセプトについては、オンラインヘルプを参照してください。 2022年12月現在、PFMのビジネスコンテンツはサプライチェーン排出量Scope3のカテゴリ１（購入した製品・サービス）のみを対象としています。PFMで計算された購入した製品および製造した製品のフットプリントを期間/製品/サプライヤまたはプラントなどで分析することが可能です。 PFMでは輸送フットプリントの計算も可能となっていますが、PFMのビジネスコンテンツにはまだ反映されていません。 PFMおよびSACで提供される最新情報はブログで定期的に更新されているので、参考にしてください。 SAP Product Footprint Management: Q1-22 Updates & Highlights SAP Product Footprint Management: Q2-22 Updates & Highlights SAP Product Footprint Management: Q3-22 Updates & Highlights SAP Product Footprint Management: Q4-22 Updates & Highlights   以下の順番でPFMのビジネスコンテンツを説明します。 PFMのビジネスコンテンツのインポート SACとPFMの接続 データの更新 ビジネスコンテンツで提供されているストーリーの概要 ビジネスコンテンツで提供されているモデルとサンプルデータの概要....

In this blog, I wish to discuss the high-level technical details on ZDO upgrades/updates that can be performed by any basis expert who has completed the learning journey and assessment ADM330. If you want to have a quick overview on what this assessment is about, do check out my other blog =>”Why should a basis....

はじめに このブログポストでは、最近Premium Engagementなどのサービスを通じて、多くのBW/4HANA導入を支援してきた中で多く見られるモデリングについて共有したいと考えています。以下に記載している内容は、実際のアセスメントの際に指摘させていただいた内容となっておりますので、BW/4HANAのモデリングをする際のご参考となれば、幸いです。   最近よく見るBW/4HANAのモデリングの特長 最近の日本のお客様のBW/4HANAのモデリングの特長は以下の図の通りです。どこに問題があるかわかるでしょうか？ もちろん、私たちSAPサービスがすべてのお客様に関わっているわけではないのですが、私たちがPremium EngagementやProfessional Serviceとして関わらせていただいたお客様のBW/4HANAのモデリングとして、HANAレイヤ（HANA View）を利用するモデリングが多いと感じています。技術的には、HANAレイヤ（HANA View）を利用することはもちろん可能なのですが、サポートされていない方法で実装されていたり、クエリパフォーマンスの観点で最適でない実装がされていたり、BW/4HANAの特長が活かされず、モデルと管理が複雑化しているケースもあります。 ここからは実際にアセスメントの際に指摘させていただいた内容をいくつかご紹介します。   サポートされていない方法で実装されている HANAのCalculation Viewの定義時にBWのマスタデータ（/BIC/Pxxxx）やトランザクションデータの格納されたテーブル（/BIC/Axxxx）を直接参照しているケースがありますが、この実装方法はサポート対象外となります。 以下のノートにあるように、BWアプリケーションが生成するマスタやADSOの透過テーブルを直接Calculation View内で参照されることはサポートされていません。エクスターナルビュー経由で参照するように定義を変更してください。 1682131 – SAP BW tables in SAP HANA Information Views and ABAP CDS Views not supported 2723506 – External SAP HANA SQL View with SAP BW/4HANA 2.0   エクスターナルビューから階層データを利用する場合にはBWクエリと同様の機能が動作しない場合があるので、事前に以下のオンラインヘルプやノートをご確認ください。 SAP HANA Views for Hierarchies 2317197 – External....

Intelligent Situation Automation (ISA) is an extension of Situation Handling in SAP S/4HANA Cloud on the SAP Business Technology Platform (SAP BTP). If you aren’t familiar with Situation Handling yet, read this blog post to find out more. Intelligent Situation Automation enables us to make Situation Handling even more intelligent and integrate cutting-edge technologies, such as Machine Learning and Knowledge Graphs.  In this blog post, I want to introduce you to the Situation Knowledge Graph – it’s the basis of the Explore Related Situations....

Ever since I came across ChatGPT, I’m in complete awe. For those of you who don’t know what it is is, ChatGPT, which stands for Chat Generative Pre-trained Transformer, is a chatbot developed by OpenAI. ChatGPT is built on top of OpenAI’s GPT-3.5 family of large language models, and is fine-tuned with both supervised and reinforcement....

このブログポストでは、クラウドオファリング「RISE with SAP – S/4HANA Private Cloud Edition(PCE)」を採用されたお客様を対象にSAP S/4HANAとSAP Analytics Cloudを接続する方法を紹介します。本ブログポストを参考に、まずは開発環境でSAP S/4HANAとSAP Analytics Cloudの接続設定を実施・確認いただき、その後、品証・本番環境へ横展開していただければと思います。 また、設定作業を実施するにあたり、SAP HANA Enterprise Cloudを管理する担当者へ問い合わせ(サービスリクエスト)を起票する必要がありますが、起票の仕方についても紹介します。 RISE with SAP – S/4HANA Private Cloud Edition(PCE)で提供される環境について 作業タスクについて 設定作業前に事前に入手しておく作業環境および情報 サーバ構築関連の作業 インポート接続 ライブ接続   ●RISE with SAP – S/4HANA Private Cloud Edition(PCE)で提供される環境について 「RISE with SAP – S/4HANA Private Cloud Edition(PCE)」では、必要なシステムが構築された状態で提供されます。ただし、SAP S/4HANAとSAP Analytics Cloudとの接続で必要な一部設定については実施する必要があります。   ●作業タスクについて 下記表に示した作業タスクを上から順に実施していくことが一般的です。作業タスクを管理する場合は、こちらを参考にしてください。サービスリクエストの起票が必要な作業タスクには、表左列に「〇」を記載しています。この作業タスクは、サービスリクエストの起票し作業依頼する必要があります。詳細は、後述の該当作業タスクの説明を参照してください。 作業タスクについては並行で実施できるものあるため、内容を確認して実施いただけると設定作業の効率化も可能です。....

We want to simplify our SAP Business Planning and Consolidation (BPC) customers’ transition journey to xP&A and to SAP Analytics Cloud (SAC) by allowing them to move at their own pace progressively, without disruption of their planning processes. To facilitate the MOVE of SAP BPC customers to SAP Analytics Cloud, we changed our commercial policy....

SAP S/4HANA を拡張する方法として新たに登場した「開発者拡張 (Developer extensibility)」が、SAP S/4HANA Cloud, private editionおよび SAP S/4HANA (オンプレミスを意味します)でも利用可能になったことをご存じでしょうか？ SAP S/4HANA Cloud, public edition: 2208 リリースから使用可能 SAP S/4HANA Cloud, private edition および SAP S/4HANA: SAP S/4HANA 2022 リリースから使用可能 これで SAP S/4HANA 全てのABAPプラットフォームで開発者拡張が使用できるようになり、SAP S/4HANA Cloud, public editionと同じ拡張手法を使用することができます。 このブログ投稿では、SAP S/4HANA (オンプレミス)における開発者拡張とその使いどころについてご紹介します。なお、SAP S/4HANA Cloud, private editionでも状況は同じです。 開発者拡張の概要についてはこちらのブログ投稿で紹介していますので、ご参照ください。   オンプレミスにおける開発者拡張の実装ルール ABAPクラウド開発モデルとは？ SAP S/4HANA で開発者拡張が一般リリースとなりましたが、開発者拡張の実装ルールは SAP S/4HANA....

皆さん、こんにちは。今回はHANA CloudとSAP Analytics Cloud (以下、SAC) を使って、HANAのデータに行レベルでデータアクセス制限をかける方法についてご紹介します。 SACのユーザーとHANA Cloudのアクセスユーザーは別々に各システムで設定し、HANA Cloudでユーザーテーブルを作成しマッピング作業が必要なことに注意しましょう。 前提条件 ブログの手順に沿ってSACとのSSOを設定したユーザーを作成 データの入ったテーブル T1と、T1をSACから見るためのCalculation Viewとして、CV_T1_second を事前にHANA Cloudに作成。T1 は下記のようなテーブルです。IDは日本の都道府県コードが入っています。 手順 ①BASでHANA Cloudプロジェクトを作成 プロジェクトの作成方法についてはこちらのブログを参考にしてください。 ②ユーザーテーブルを作成 HANA Cloud Database Explorerを使って、ユーザーテーブル USERSを作成します。運用上の観点から、ユーザーテーブルはBASのプロジェクト作成時に自動生成されるHDIコンテナとは異なる HDIコンテナの中にUSERSテーブルを作成しすることにしました。BAS ProjectのHDIコンテナと異なる場所にあるテーブルのデータへアクセスする方法はこちらのチュートリアルを参考にしながら、ユーザーテーブルへアクセス権があるユーザーに対してのUser Provided Serviceを作成してください。 USERSテーブル ②プロシージャを作成 BASのテンプレートを使用してプロシージャ Test_row_HDI.hdbprocedure を作成し、下記のように変更します。３行目の権限がDEFINERになっているか確認してください。 PROCEDURE "Test_row_HDI"( OUT sql_expr NVARCHAR(50)) LANGUAGE SQLSCRIPT SQL SECURITY DEFINER --DEFAULT SCHEMA <default_schema_name> READS SQL DATA AS BEGIN SELECT....

This is a series of blogs written by SAP subject matter experts to prepare you for your journey to SAP S/4HANA. Ready? Let’s go! Topic #13 is how to accelerate your rollout with test automation Did you know that you can access automated testing capabilities for SAP S/4HANA and other SAP solutions as part of....

This is a series of blogs written by SAP subject matter experts to prepare you for your journey to SAP S/4HANA. Ready? Let’s go! Topic #14 is about the SAP Fiori design system and its role in accessing SAP S/4HANA innovations SAP Fiori is the go-to user interface of SAP S/4HANA. SAP Fiori launchpad offers a....

This is a series of blogs written by SAP subject matter experts to prepare you for your journey to SAP S/4HANA. Ready? Let’s go! Topic #15 is about the integration analysis in SAP Readiness Check For the transition to SAP S/4HANA, a selection of follow-up activities in the area of integration is required due to....

The new year is almost here and so is the most wonderful time of the year! This holiday season I decided to learn something new and this blog post is all about that journey! Enjoy the blog post with a cup of hot coffee in this cold weather 🙂 Introduction Ready to revolutionize the way you....

The focus of the blog is to help you understand and analyze all the HTTP errors that happen during the connection from your sender system to your Cloud Integration (inbound). Also, this blog will provide some troubleshooting tips which will help better understand where exactly is the problem and how to avoid/prevent it in the....

本ブログはこちらのブログの日本語版になります。SAP Data Warehouse Cloudによるメール通知機能ついて解説しています。   コンテンツ 概要 前提 SAP Data Warehouse Cloud Viewsのセットアップ 通知テンプレート 設定: サービスインスタンス SAP Business Application Studioを使用したデプロイメント スケジューリング テストとメッセージ   1. 概要 2022年現在、SAP Data Warehouse Cloudは標準機能によるメールでの通知機能は提供されていません。本ブログでは、お客様がSAP Data Warehouse Cloud内の通知に対してメールでの通知機能を設定できるようにする方法を解説します。   2. 前提 以下を使用します。お客様のIT環境で使用可能かご確認ください。 @sap/hana-client ^2.10.13 express ^4.17.1 node-json2html ^2.1.0 nodemailer ^6.6.5 nodemailer-smtp-transport ^2.7.4 sap-cf-mailer 0.0.5 また、SAP Data Warehouse Cloud テナントと SAP BTP....

Recently I had a requirement to send cXML message with multiple attachments to Ariba network as MIME multipart. Below is the detailed requirement. Overview: The source is a zip file with xml and attachments (pdf, word, excel, txt). I had to create a cXML file from xml and send cXML message (attachments filenames need to....

To send ‘.XLSX’ file type with multiple sheets in single excel file as attachment via E-mail Context Using OLE logic, we can achieve this requirement and the attachment will be an ‘.XLS’ file. But our client system has some trust center setting enabled in their system which exempts them from opening .XLS file. So, we....

With the aim of making workflow configuration simpler, SAP S/4HANA developed a brand-new concept called Flexible Workflow. It is advised that we make use of S/4HANA’s new Flexible Workflow feature. The preset workflow scenarios and tasks form the foundation of the flexible workflow. This gives users the ability to specify condition-based workflow for various system....

In the tutorial Create Multi-Cloud Application Consuming Object Store Service , the method consuming Object Store Service on AWS with Java has been  introduced in detail .  In help portal the method in Java also  has been introduced. In the blog Connecting to SAP BTP Object Store running on Microsoft Azure Platform using NodeJS,Ujala Kumar Panda has introduce use nodejs to....

本ブログシリーズはSAP Graph Multi-Part Tutorial: Information Mapの日本語翻訳です。簡潔な翻訳のために、いくつかの細かいニュアンスは削ぎ落としています。最新の正しい情報は翻訳元やWhat’s New for SAP Graphをご参照ください。 ブログシリーズ一覧 インフォメーションマップ：SAP Graphチュートリアルシリーズ（日本語翻訳版）（オリジナル英語版） パート1：SAP Graphのイントロダクション（日本語翻訳版）（オリジナル英語版）  パート2：はじめてのSAP Graphアプリ開発（日本語翻訳版）（オリジナル英語版） <-このブログ パート3：SAP Graphにおける認証認可の実装（日本語翻訳版）（オリジナル英語版） パート4：SAP Graphとプロトコル（日本語翻訳版）（オリジナル英語版） パート5：SAP Graphと自前のデータの用意（日本語翻訳版）（オリジナル英語版） パート6：SAP GraphでBusiness Data Graphを作成（日本語翻訳版）（オリジナル英語版） パート7：SAP Graphにおけるキーマッピング(日本語翻訳版)（オリジナル英語版） Thanks Stephanie Lewellen and Chaim Bendelac for your cool blogs and for allowing me to translate!   日本語訳 こんにちは！ このブログはSAP Graphチュートリアルシリーズの２つ目のブログです。 SAP Graphの紹介はこのチュートリアルシリーズのパート1、チュートリアルシリーズ全体の紹介はインフォメーションマップを参照してください。 このチュートリアルシリーズのパート3では、古典的かつ初歩的なエンタープライズ拡張のWebアプリである下図の様なlist-details-navigate applicationを開発します。 本ブログであるパート２では基本的なHello Worldアプリケーションを通じて要点を掴んで頂く事を目的としています。このチュートリアルでは予備知識は必要なく、SAP Graph開発者になるために必要なことは全てこのブログの中に書いてあります。ブログ中ではパート１でも利用したSAP API Business....

Summary: This blog post will demonstrate how to handle incoming email with PDF attachments and save them against any transaction in SAP. We will use GOS functionality to save the document but same kind of logiccan be used to save/process the attachments in the SAP system. I am taking an example of CRM billing document here.....

I am writing this blog post to demonstrate how we can structure an ABAP report in a OOP way that helps us solve a real life problem. I want to state firstly that I don’t think that my example entails all the OOP best practices, but it’s a honest attempt of a procedural ABAPer to....

Summary : In my previous blog I have covered, how to process/save pdf documents (can have multiple) which are received in e-mail into SAP. In this blog, we will see how we can enable auto print functionality for PDF documents on dedicated physical printer or on local printer (LP01) in spool. Additional Business requirement : All the PDF....

In case of S/4 HANA On premise where connection is secured using VPN, this error generally occurs while running the bot. As per the SAP Note 3251797 – Internet Proxy Type does not automatically mean that the invocation goes through the public internet before reaching its target **All the images are captured from SAP Trail Account for BTP....

This blog post shows the set up configurations of Slack adapter in Cloud Integration. Implementation Guide: Configuration at Slack: Create an app at https://api.slack.com In ‘Permissions’, add ‘Bot Token Scope’ as ‘chat:write’. Click on ‘Install to Workspace’ and then allow. This will generate ‘Bot User OAuth Token’. Add the app into the slack channel. Configuration....

In this session I am going to discuss about the implementation of delta mechanism in SAP BODS. But before that we will go through few Transformations which is required for implement Delta Mechanism both for master data and transaction data flow. These major transformations  are given below – 1. Table Comparison : Used to compare data between....

The invention of OS-level virtualization to deliver software in packages called containers was one of the first steps toward modernizing the development process of cloud-based applications.  In the pre-container world, Developers had to configure applications specific to physical or virtual machines, creating install packages in unique versions for the operating system and machine variants, often....

ABC & XYZ segmentation are used for grouping planning objects based on their revenue/sales generating capacity & ease of forecasting. Detailed documentation can be found here- ABC Segmentation | SAP Help Portal.  While information provided at the link is easy to understand, the behavior of the system when the cumulative percentages do not exactly add up to the....

When you have to support SAP Financial Consolidation (FC), you need to keep in mind that some tips. Environment: SAP Financial Consolidation 10.1 Windows Server SAP HANA 2.0 Tip 1: CT_LOG table has to be cleaned periodically. If the trace function is on, it grows very quickly and becomes huge. SAP FC logs How to....

This blogpost intends to show you in a (hopefully) super easy way how to build and deploy proper mta archives in your SAP BTP Cloud Foundry Environment in the context of an SAPUI5 freestyle application. With minor adjustments it will also work fine for any other HTML5 apps as well. It’ll provide you with a....

In a recent assignment I needed to securely store a secret key that we had received from a third party for HMAC calculation. As it was of utmost importance that the secret key would never be retrieved even by individuals with debug authorization on the system it was not an option to save it in a table....

As enterprise e-commerce platform, SAP Commerce Cloud provides solid support for marketing, such as coupon management, promotion rule, personalization etc. Unfortunately, although SAP commerce has implemented a demo in B2C/B2B accelerator to distribute coupon by using free coupon action in promotion rule, it’s far from enough to meet the complex scenarios in real projects, such....

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....

Great Day, Hope everyone are doing good!!! Problem Statement: In order to enhance the initial screen by adding custom button with popup table in the fragment here I am using request maintenance F1511(Standard App). Adaptation Project: Adaptation is a feature of SAPUI5 flexibility that allows to make UI changes for all users. By using SAP....

I was searching for different blogs for this F4 help but unfortunately couldn’t find a detailed blog on this. So, I felt to start writing the same for all technical developers. For creation of CDS view we have 3 main interface view to be created. Step 1. First create a CDS view for Text table.....

Recently I have been working on a POC in HANA Cloud & S/4HANA for one of the product client, I got an opportunity to explore this new feature of SDI flowgraph and I like to share few interesting information on the same. The conventional way to create a subscription is navigating to the Data Source....

Using istio gateways, gardener dns and kyma dashboard components This brief is to demonstrate how SAP BTP, Kyma runtime makes it easy to set up an istio gateway with a wildcard public custom domain. Pre-requisistes: access to a registrar with a registered public domain you own access to one of SAP BTP, Kyma runtime-supported DNS providers.  cluster-admin access to SAP BTP, Kyma Runtime (SKR)....

With reference to my last blog for creating a Barcode scanner, got one complex business requirement to post it back to SAP for further processing. I have feeling that for many of our SAP community friends in EWM/ SD/ MM we may have same kind of solution required. this can also be achieved in a way in....

So, you want to transfer group reporting transaction data from SAP S/4HANA Cloud to SAP Analytics Cloud? The good news is that you can do exactly this with the API Transaction Data for Group Reporting – Read (Version 2). But before you do this, you first need to create an Odata connection in SAP Analytics Cloud.....

In this blog post I would like to share my experience on How to setup SAP Automation Pilot on SAP BTP . As  SAP Automation Pilot  service now available in SAP BTP trial account 🎉 How to get a Free Account on SAP BTP Trial understand the difference SAP BTP free tier vs SAP BTP trial account.   here   Introduction SAP BTP Automation....

Hello Community! This blog tells about OData service creation using Core Data Services[SAP ABAP CDS for SAP S/4 HANA] at the same time here we going to explore two methods for creating OData service one is SADL and another one with CDS annotation. Let’s start with an exact definition of OData: OData can be defined as a....

Note: This blog post is the sixth part of a tutorial series. If you arrived here without reading the first part, please do so before you continue, and then come back here again. Part I explains the key concepts and technology standards for principal propagation in the context of calling a simple Web Service deployed on SAP Business Technology Platform (BTP)....

It is the purpose of this blog to describe the Git Terminal Application in SAP Data Intelligence Cloud that is included in release 2022.08 mid of August 2022 (see the What’s New Blog of my colleague Eduardo Schmidt Haussen) Here is the table of contents for this blog. Introduction Prerequisites and Resources The SAP Data Intelligence Cloud....

A few days ago, tipped off on twitter by Jakob Marius Kjær and Volker Buzek I created an extension to run WDIO tests (including WDI5) in vscode Still lacks a lot of features like support for cucumber and typescript configurations, but does work for basic cases See an example run here: As I mostly do backend, I only tested it on a couple....

The legacy VDT will be, after co-existing with the new VDT in stories for some time, deprecated in SAP Analytics Cloud. The planned deprecation timeline will be as follow: Legacy VDT: 2022 QRC4: Can be opened, viewed, and executed in VDT designer Can no longer be created, copied, or edited, but will remain functional in....

Once the Value help view is created and released then go back to Fiori “DDIC Extensibility Group”. Refer blog: Create CDS Value Help or F4 help for In App Field Custom Fields | SAP Blogs Open the tile Custom Fields or Custom Fields and Logic Then click on the ” + “symbol to create. Here we will add custom field in Purchase....

As part of the effort to provide high availability (HA) for the SAP BTP Kyma runtime (AWS, Azure, GCP service plans), we have enabled multi-availability-zone worker groups for the Kyma runtime. Note: The Zone here refers to hyperscalers availability zone. E.g. Azure Availability Zones The worker nodes(Virtual Machines) with the provided machine type and autoscaler parameters will....

词云(WordCloud)的概念，据网络上搜索到的资料，最早由美国一位新闻学专业的副教授提出，对文本中出现频率较高的关键词予以视觉上的突出，一般采取“出现频次越高，关键词渲染尺寸越大”的规则。由这些尺寸不一的关键词形成类似云状的彩色图形，能帮助浏览者一眼扫过图形，就能领略该词云背后文本的主旨。 比如周杰伦《双截棍》歌词的词云如下： 其中出现频率排前三位的词高亮如下： 词云除了广泛应用在互联网前端外，在SAP领域也能发挥其优势。比如Jerry 曾经做过的一个原型开发项目，通过微信小程序收集用户和 SAP Conversation AI 的聊天记录，然后使用词云显示出这些聊天记录里的关键词。 起初Jerry在Github找了一些生成词云的开源工具，有JavaScript也有Python实现： https://www.npmjs.com/package/tag-cloud https://github.com/amueller/word_cloud 后来了解到SAP Analytics Cloud 自身就支持使用R的开发包 wordclound 生成词云：   所以我就想尝试着用SAP Analytics Cloud来实现。 要使用SAP Analytics Cloud上的wordcloud的开发包，需要通过配置将其连接到一个可用的R运行环境。R语言是一种编程语言，在统计分析和各种图表展示领域里特别具有优势。 在System配置里，可以选择使用SAP Analytics Cloud集成的R运行环境或者远程连接到一个部署在第三方的R运行环境。 绘制词云的数据源由下面这个csv文件提供：某地区每个超市每个月不同产品的销售数量。我设定的词云绘制规则比较简单，销售量越大(字段QuantitySold)的产品，其产品名称出现在词云中的尺寸越大。   上述Excel文件可以从SAP官网下载： https://www.sapanalytics.cloud/wp-content/uploads/2018/02/BestRun.xlsx 我对其作了大幅简化，上传到SAP Analytics Cloud之后基于该文件创建一个新的Model取名BestRunJerry, 将QuantitySold列设置成Measure. 将Product的Description设置为ProductName，这样稍后用R绘制出的词云，显示的是可读性更好的Product Name，而不是产品ID. 基于建好的Model创建一个新的Story，插入一个新的R Visualization，这是一个UI控件，负责显示渲染的词云： 将Product设置为Rows的一个成员： 而QuantitySold设置成Columns的一员，这样接下来的R编辑器里，可以通过访问Product和QuantitySold两个变量，获取模型里存储的对应数据。 现在开始添加R脚本： 四行脚本搞定： 点击Execute，看到执行效果： 最后生成的效果图： 4行R脚本的含义： (1) library(wordcloud):加载SAP Analytics Cloud的R开发包wordcloud； (2) words <- BestRunJerryQuantitySold：用产品QuantitySold字段的值模拟关键词出现的频率，存储到变量frequency里； (4)....

When it comes to the SAP Cloud Identity Services, some of the most common questions raised in implementation projects revolve around: “What would be the best option for us out of all available ones?”. This blog will explain what those options are and how to choose among them. So let’s start from the beginning! What....

SAP released a new SAP Cloud ALM scenario in 2022 that is pretty similar to what you would find in SAP Solution Manager (User Experience Monitoring) and Focused Run (Advanced User Monitoring). This new “Synthetic User Monitoring” (SUM) is essentially a lightweight alternative to bulkier but much more powerful solutions for continuous performance monitoring, such....

Spend reporting is an important AP requirement that helps companies better understand and control their expenses. Traditionally, companies that run SAP approach Spend reporting with BW solutions. When it comes to Spend reporting BW gives little to no advantage compared to S/4HANA Embedded Analytics due to rigid extraction process and need of complex transformations and....

Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions related....

In this Blog we are going to see How to create CDS view In Rise with SAP Public Cloud 2208 Introduction- SAP Create Custom CDS View SAP Create Custom CDS View can be used to generate the user’s own data access, in case they require access to data in the ERP system which is either....

This blog starts by providing a comprehensive understanding of revenue recognition runs that recognize revenue for Sales Order based on the Accrual Method assigned to them. Audience Consultants/Business Users/Beginners Purpose Understand the concept of Revenue Recognition for Sale Order Based on Accrual Method. Revenue recognition: Amounts received from customers could or might not be thought of as accomplished revenue....

In this blog post,  Dr. Arnal Dayaratna, Research Vice President, Software Development at IDC, discusses the critical role that Low-Code technologies play in helping organizations to improve collaboration and accelerate development to amplify the digital transformation within organizations Date: 11/1/2022 Guest IDC Blogger: Arnal Dayaratna Sponsored by: SAP One of the important attributes of low-code development tools is....

In this 30 minutes recording we look at how to handle the following requirement in Variable Pay : for employees who were rehired only a few weeks or months after they left the company only use the active record(s) after the Rehire event to calculate a prorated bonus for them. It took about 40 hours....

Tax Decision Tree is a feature which helps in creating custom rules for the automatic determination of the tax code. It uses a tree-like model of decisions and their possible consequences to determine the tax code. This blog explains how to create a tax decision tree using SAP Cloud Applications Studio. Prerequisites You have installed....

Business Network for logistics(BN4L) has integration to certain list of the B2B carriers and visibility partners. This document will describe the step by step on how to setup the connection from your account to network partner B2B Carrier – Is nothing but a carrier in your system. Carrier Business users instead of using LBN Web....

This blog explains the typical issues developers have trying enable Time Variance charts in SAP Analytics Cloud (SAC) based on CDS-Views and how to solve this by adding additional fields and annotations to the Cube and Query   Baseline CDS View: Every CDS which is built to do reporting in SAC, will have at least....

Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions related....

This blog post shows how to do client-credentials flow with IAS using “identity” service in SAP BTP. We create a minimalistic sample app2app scenario where 2 application communicate with each other while authentication is done with the OAuth flow called “client-credentials”. Used technologies: SAP Business Technology Platform (SAP BTP), Cloud Foundry Environment, SAP Cloud Identity....

The first step to check if the adaptation project is loading correctly is to verify if the adaptation is available on the front-end server. To check the availability use, the SAP Gui report started in transaction se38: /UI5/DEL_ADAPTATION_PROJECT. The search help available with F4 will show you all deployed adaptation projects. The report is available starting....

Scenario: If there is a requirement to move ECC on DB2 – AIX (on-premises) to ECC on DB2-Linux(AWS) or any DB2 heterogeneous migrations to cloud, this blog address issues with Export data dump transfer delays to cloud and better manage Cloud migration using parallel Export/Import process, reducing downtime. Caveat: This method helps if you have limitations in....

Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions related....

In this blog, I am going to explain How to Create Custom SAP Launchpad Theme using UI Theme Design. Introduction: UI theme designer is used to adapt the visual appearance of applications. You can upload your company logo, change font color, change background color, and so on. Prerequisite: Subscribe to the SAP Launchpad Service by going....

This blog describes how to set up the XML structure to successfully call a Function Module or BAPI remotely from SAP Cloud Integration. It shows how the different parameter types like tables, structures and input parameters need to be build in the XML structure. Furthermore, it will be shown how to configure the root element....

In our last blog we went through SAP BODS ETL tool snapshot, you can check that out on below link https://blogs.sap.com/2022/10/02/sap-data-service…ap-bods-snapshot/ ‎ Today, in this blog i will cover the most commonly used platform transforms in SAP BODS during whole Extraction, Transformation and Load process. What’s in it for you? This blog focuses on giving....

Dear Community, like I felt the need of collecting terms and abbreviations and their meanings in the huge and complex area of security, I feel like I should share the list with you, as you might have the same need. It is like: -> Read ABC anywhere -> forgot the meaning (again) -> look it....

I’m writing this post since many developers and service owners especially in the globe haven’t had this problem before and see it as a blocking issue. So, I will show you some workarounds to solve the problem of installing node packages. Symptom When locally installing packages for your projects or deploying your applications to Cloud....

The requirement for the business continuity of a modern-day tool is implicit and very essential. Nowadays, customers have zero tolerance for downtime. For business-critical applications, a failure, even of the tiniest amount, could have adverse effects. One such service that could be adversely affected by an outage is SAP Build Work Zone, standard edition. The Build....

Before Driving deep into Technical details . let me give some brief about why we need to do this ABAP Development Tool (ADT) is an Eclipse  based tool provided by SAP, You will need ADT if you have to work on the ABAP CDS views. Even though,CDS views are emdedded into the ABAP Dictionary, there....

With more than 233K stars on Github combined, Vue.js is currently the trendiest Javascript front-end framework, beating its largest competitor React and Angular in Github star count. The model-view-view model (MVVM) Javascript framework, was built to be lightweight and provides great flexibility. Vue.js’s single-file components are loosely coupled, which improves code reuse and decreases development....

This document will help functional consultant to create screen variant/transaction variant and achieve the business requirement without the support of technical team. This document aims to identify and describe all steps associated with the screen variant & transaction varaints. In addition, This document will help functional consultant who want to explore the possibility by screen....

SAP Analytics Cloud（SAP分析云，简称SAC）作为SAP全新一代的战略绩效云平台，其不仅仅只是传统的BI商务智能分析，而是整合了“商务分析”、“智能预测”、“全面预算”为一体的全新数据应用与分析的一体化平台，它既能支持业务用户进行敏捷自助化的数据分析，也能支持技术用户设计复杂的应用场景。 SAC为用户提供了“敏捷可视化”、“决策推演”、“预算编制”、“智能预测”、“专业分析应用”以及“数字董事会”等强大的功能。同时SAC也提供了多种数据连接方式，支持不同数据源的连接，支持便捷的数据处理和数据建模。SAC预置了强大的系统管理功能，支持细化到单元格的权限管理，支持用户对系统使用情况、报告访问情况、报告加载效率等进行监控和分析，以提供端到端的DevOps解决方案。 SAC于2017年落地中国，五年来，随着SAC在国内的快速发展，很多企业已经采用了SAC作为其企业级的分析平台，赋能国内的千行百业。 在SAC产品落地中国的过程中，我们国内的客户、合作伙伴都希望对SAC有更加深入、更加全面的了解。为此，SAP BTP售前团队结合SAC的应用场景和技术特点，整理了一套中文版的《SAP分析云操作培训文档》，内容涉及SAC总览、模型构建、BI分析、计划预算、分析应用、智能预测、数据连接和系统管理等多个方面。 我们希望这样一套贴近实战的操作培训文档能够为客户和合作伙伴带来实实在在的技术收益，为推动SAC分析云在中国的应用提供些许助力，也欢迎大家针对文档中的错误和纰漏提出宝贵的意见和建议。   操作培训的材料请从以下链接下载（因SAC系统不断更新，本系列文档个别内容如有与最新SAP在线帮助文档不一致之处，请以最新SAP在线帮助文档为准）。 1、 SAC 分析云操作培训_总览 2、 SAC 分析云操作培训_附1_构建模型 3、 SAC 分析云操作培训_附2_BI分析 4、 SAC 分析云操作培训_附3_计划预算 5、 SAC 分析云操作培训_附4_分析应用 6、 SAC 分析云操作培训_附5_智能预测 7、 SAC 分析云操作培训_附6_数据连接 8、 SAC 分析云操作培训_附7_系统管理

This blog would help you as an Architect to speed-up the migration process for your On-Prem / SAP Commerce from CCv1 (SAP Commerce Cloud on SAP Infrastructure) to CCv2 (SAP Commerce Cloud on Microsoft Azure Cloud). We will also see the difference between CCv1, On-Prem, and CCv2 and then look into detailed solutions for Data....

Quick blog just to share something I think it’s AWESOME and haven’t seen people using yet. You may have used Draw.io (now called Diagrams.net) to create architecture/solution diagrams, flowcharts, mockups, UML, etc. The good news is that a good soul has created a Draw.io library with the SAP BTP icons! It’s the first result on Google when you....

从版本 2022.15(2022 QRC3) 开始，SAP Analytics Cloud分析云 (SAC) 支持使用安全网络通信 (Secure Network Communication, 即SNC) 创建到 SAP BW 的导入数据连接，以加密Cloud Agent和 SAP BW 之间的通信。在 SAP Note 3234061 中，您可以查看关于该配置的简要步骤。 本篇博客是记录我在内部测试SAC系统、Cloud Agent和BW中如何实现该功能的详细步骤。整个场景假定ABAP服务器端已经启用了SNC。如果没有，建议您先参考KBA 2979858在ABAP端完成前置配置。 此外，以下所有步骤目前仅在内部系统中进行验证。其中一些将来可能会更改，您可能需要根据不同的系统条件进行调整。 免责声明：所有屏幕截图、命令和其他信息均来自示例测试系统，不代表实际数据（任何相似之处纯属巧合）。 让我们一起开始配置吧！   步骤一：设置本地SAP Crypto Libraries 首先，我们需要在运行 Cloud Agent 的机器上准备 SAP Crypto Libraries。 按照本指南将 Cloud Agent更新到最新版本。 通过以下两种方法之一获取 SAP Crypto Libraries 文件： 您可以在从上面下载的 Cloud Agent 压缩包中提取到的文件夹中找到它们。相对路径为C4AAGENT355_0-80000881win64_x64tp.sap.cryptolib。 按照 KBA 1954305 下载 SAP Crypto 库。....

之所以写这篇文章，是因为许多开发人员和服务所有者（SO，尤其是国外的）以前没有遇到过这个问题，无法正常部署应用和上线服务。因此，我将罗列一些可以解决该问题的方法，供大家使用和参考。 遇到的问题 当你在本地安装Node.js依赖，或将Node.js应用部署到Cloud Foundry环境时，遇到了超时等错误（例如，如下所示），你尝试ping NPM registry来测试连接性，也失败了： -----> Building dependencies Prebuild detected (node_modules already exists) Rebuilding any native modules rebuilt dependencies successfully Installing any new modules (package.json) Error staging application sbf-sample: timed out after 15 minute(s) 默认情况下，Node.js依赖都是从https://registry.npmjs.org库中下载的，这是一个最常用的公开的NPM registry。当这个NPM registry因为任何理由不可访问和连接时，我们可以通过一些配置来解决这个问题。这属于Node.js相关的开发问题，更多说明可通过谷歌来了解。 变通方法 变通方法 1：实现项目自包含（Self-contained） 在将应用程序部署到Cloud Foundry运行时等云环境时，如果你发现从容器中安装依赖时会出现网络不稳定的情况，则可以尝试实现项目的自包含。这意味着你需要预先将所有依赖下载到本地，然后将它们与你的代码代码一起推到Cloud。 在package.json同一目录下， 执行以下命令将所有依赖项安装到node_modules文件夹中: npm i 然后，你再尝试把项目推至云端。 更多详细信息参考：Vendoring App Dependencies 变通方法 2：切换NPM Registry 当然，你可以直接通过切换NPM....

Let’s start with three questions about the existing ABAP code: Features: Can I add them easily without breaking anything? Bugs: can I fix them without breaking anything? Users ask a query on custom development: can I explain the functionality after reading the code?   Businesses/SI/AMS partners who are in multiple ongoing SAP projects focus on....

In this post, I explain creating a PowerShell script for auto-login to the Cloud Foundry Command Line Interface (CLI). The Cloud Foundry Command Line Interface (CLI) basically allows you to connect different Cloud Foundry environments for managing subaccounts, such as creating orgs and spaces, managing quota, etc.. from the comfort of the command line. Logging....

SAP Cloud Application Programming Model (CAP) is being used vastly as a preferred way of development approach while working with SAP BTP. Developers who used to work as an ABAPers earlier, might have realized that while working with ABAP it was really easy when it comes to consuming Database Tables across applications/object. But in case....

This is a series of blogs written by SAP subject matter experts to prepare you for your journey to SAP S/4HANA. Ready? Let’s go! Topic #4 is building custom extensions. For modern enterprise systems, a clean digital core is the way to cope with the accelerating speed of business. Our “clean digital core” paradigm is....

This is a series of blogs written by SAP subject matter experts to prepare you for your journey to SAP S/4HANA. Ready? Let’s go! Topic #5 is compatibility packs.   When we introduced SAP S/4HANA, we had two goals: delivering a modern, disruptively new ERP suite that takes our customers through the next decades while....

This blog post shows how to do client-credentials flow with IAS using “identity” service in SAP BTP. We create a minimalistic sample app2app scenario where 2 application communicate with each other while authentication is done with the OAuth flow called “client-credentials”. The difference to previous tutorial is that this time we’re using a client certificate in order....

Motivation: This blog post provides prescriptive guidance to Product Owners, Solution Architects and Consultants ability to leverage SAP S/4HANA and SAP Business Technology Platform digitizing, optimizing business processes both by adopting Standard and Extending business logic to scale, innovate and deploy at speed. We come across SAP Business Technology Platform as next go to place....

Goal of this blog post In this blog, we will link 2 dashboards (overview and details) with a contextual navigation between Projects and Tasks entities managed by SAP Cloud ALM with the SAP ALM Grafana plugin. The details dashboard is parametrised with two variables for project and scope. The overview dashboard uses a url link to navigate to the target dashboard passing....

This blog post will give you an overview of how you can replicate information from SAP SuccessFactors to SAP Commissions using REST API. Sounds pretty basic right? How about we by leverage SAP’s Conversational AI and also use Speech-To-Text to accomplish our goal? Sounds interesting? Let us get started.     Requirements: Create an account....

Uninstall SHINE XSA from SAP HANA, express edition (version: 2.00.057) before upgrade to (version: 2.00.061). Reason of the Article During the upgrade the following error message appeared. hxeadm@hxehost:/usr/sap/HXE/HDB90> /usr/sap/HXE/home/bin/HXECheckUpdate_linux.bin -a Installed SAP HANA, express edition version : 2.00.057.00.20211207.1 Connecting to download server... Newer SAP HANA, express edition version 2.00.061.00.20220519.1 is available. Found XS Advanced +....

Introduction: Hello everyone!! In this blog, I am going to explain how the next due date of Maintenance plan can be updated with the implementation of BADI “BADI_EAM_EXIT_IPRM002“. What is Usage Decision:   In QM, Usage Decision is used to decide whether you want to accept or reject the goods in the inspection lot based on....

With my background in EDI business I was always wondering how Cloud Integration Suite can be used in big EDI scenarios. Since SAP introduced the graphical interface for communication agreements of the Trading Partner Management, it is time to check how the Integration Suite can be used as B2B/EDI platform. So I started to implement....

I wanted to user RAP based API in sap cloud in my workflow service task to get/update the data from BTP Workflow to S4 public cloud. When I was trying with service URL with direct basic authentication as destination in BTP, it wasn’t giving me the result as authentication which comes when we try from....

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....

My name is Nhat Doan. I am currently in SAP Student Training and Rotation (STAR) Program. In my first rotation, I have a chance to join CoE Mobile & UX team. I have learned a lot of things especially about current developments in mobile technology. Today, smartphones become essential for daily life. Businesses are using....

Objective of this blog is to give some background information about SAP Business Connector and some guidance for replacing it with a more contemporary platform.   What is SAP Business Connector? SAP Business Connector (SBC) is a middleware or integration platform offered by SAP to connect SAP-systems to non-SAP partner systems. SAP Business Connector was....

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....

We publish the SAP Fiori development every other month to share new information with developers in the SAP ecosystem about SAPUI5, SAP Fiori elements, SAP Fiori tools, and SAP Business Application Studio. The editorial team that curates the articles includes Oliver Graeff, Raz Korn, as well as Peter Spielvogel. To receive this content in your inbox, please subscribe to....

Symptom: Message no. SO865 (An error occurred during transmission – return code: <NF_ADR>) popups when using BCS to send emails. Reason: All the errors during BCS processing will be caught by cx_bcs and collected into BCS exceptions like the below: data bcs_exception type ref to cx_bcs. Try. catch cx_bcs into bcs_exception. message i865(so) with bcs_exception->error_type. endtry.....

Hi guys, it’s me again with another script that solves an SAP Enable Now Cloud issue when the SSO account is not automatically deactivated after the employee left the company (and obviously doesn’t need SAP Enable Now license any longer). This desynchronization leads to incorrect license consumption numbers, unnecessary questions during the license audit, and,....

A UI5 Control exists out of two parts, the control logic (including metadata) and the renderer. This last one defines the visualization of the control by writing JavaScript and will generate HTML at runtime. Writing the HTML by using JavaScript function is not straight forward in case of complex UI5 Controls. Although UI5 is going....

The latest releases of SAP Business Application Studio comes with many user experience improvements that will speed up your productivity 🎉. In this article I would like to share with you some highlights of the latest releases SAP Business Application Studio now uses Code-OSS, the open source used for building Visual Studio Code. From Now onwards you....

RAP Extensibility has been released with ABAP release 7.57 (OP). SAP-delivered RAP BOs can be extended by customers. Customers can add extension fields (field extensibility), behavior (behavior extensibility) and extension nodes (node extensibility) to RAP BOs by means of developer extensibility. This blog post is about C0 developer extensibility for CDS behavior definitions (BDEFs). It....

Improvement proposal open for voting Add an overview of trashed blogs and an option to recover from trash SAP Blogs platform is based on the renowned and proven WordPress backbone. It gives an option to move blogs to the trash. It is a nice feature to get rid of not needed articles. However SAP Blogs....

My name is Nhat Doan. I am currently in SAP Student Training and Rotation (STAR) Program. In my first rotation, I have a chance to join CoE Mobile & UX team. I have learned a lot of things especially about current developments in mobile technology. Today, smartphones become essential for daily life. Businesses are using....

This article is available in German and in French languages. Overview The email abuse technique called “list bombing” or “email bomb” has been occurring more frequently for the last couple of years. Any brand which collects email addresses with web forms is vulnerable to list bombing. This type of attack can harm your deliverability and can lead to the....

As, we have feature to use Multi-Select of Position to hire Multiple Candidates on different positions by creating only One Job Requisition. In this blog I am sharing end-to-end step to Configure the Multi-Select Feature and the limitation And also my experience when I got the requirement, which is common but not feasible in standard....

During my daily work I’ve got a task to implement a call of another Fiori App from my Fiori Elements App. In order to achieve that I have found three possible ways to implement it (but only one of them was working for me): Intent-based Navigation as RAP CDS Association Intent-based Navigation as ABAP Call....

In this blog post, I will describe the steps I have followed to create an extension for the basic type INVOIC01. I will also illustrate the actual business requirement and what was requested. First, I know that there are a lot of materials out there for how to create an IDoc extension and I won’t....

Overview This article will explain how you can integrate SAP Commerce and Emarsys through CPI. This post can be helpful for things like Customer Register or any Item Type of SAP Commerce. We will show an approach with the out-of-the-box (OOTB) features. This blog was built in 3 parts: Requirement – SAP Commerce set up with information from CPI; Integration....

In this Blog Series, I will guide you through how you can leverage oData Services to load data into SAP Signavio Process Intelligence to investigate your Business Processes. As an example, we use S/4HANA Cloud as a source system and load data via oData Connector from SAP Signavio Process Intelligence. The steps will be split....

With the new release SAP BTP SDK for iOS 9.0 and SAP BTP SDK for Android 5.1 earlier this month, customers now have the opportunity to easily apply their corporate branding to all their mobile enterprise applications, built with the SDKs. This allows companies to provide a consistent user experience to their employees and using the native SDKs, new....

Hello, In this beginner blog post we are going to see how we can use Side Effects in ABAP Restful Application Programming Model.   Ref: https://help.sap.com/docs/ABAP_PLATFORM/468a97775123488ab3345a0c48cadd8f/18b17bdd49d1436fa9172cbb01e26544.html     What is Side Effects : When user makes a change to a field on UI, and this change effect the content of other field, this behavior is called....

This blog focuses on the usability of the Output Section within an Action of the Action Project that can be maintained using the Actions Editor. The Output parameters help to describe and maintain the response structure of the API. The Actions Project and the Action Editor are generally available from 18th October 2022. Parent Blog:....

In this blog post you will find some personal insights about how to get certified as Certified Kubernetes Application Developer (CKAD) by the CNCF and Linux Academy. For insights about the other CNCF certifications, see Get Certified: Cloud Foundry Certified Developer (CFCD) Get Certified: Certified Kubernetes Administrator (CKA) Get Certified: Certified Kubernetes Application Developer (CKAD)....

本文将描述如何基于JSONModel数据模型，在前端对数以十万计的列表数据进行分页操作，给使用者营造出流畅的UI交互体验。 背景介绍 前端子项目基于SAP UI5框架进行开发，作为一个微服务部署在SAP Business Technology Platform。通用设计为List Page采用OData数据传输协议，Object Page采用RESTful API进行数据交互。在Object Page中，有一张列表包含着数以几十万计的Transmissions。为了防止页面崩溃，需要在前后端对列表数据进行分页操作。 需求分析 JSONModel作为一种客户端数据模型，将后端传来的所有数据绑定在页面View上，通过设置growing属性，点击load more表下按钮即可实现前端数据的懒加载。本功能需求是后端也要进行分页读取操作，并不能一次性将所有数据返回到前端，因此无法触发load more按钮的事件监听。解决思路是后台返回所有数据的总条数，来改写JSONModel的totalCount参数，从而触发load more按钮的事件监听。  代码实践 新建一个GrowingJSONModel类 sap.ui.define(['sap/ui/model/json/JSONListBinding'], function (JSONListBinding) { 'use strict'; /** * PagingJSONListBinding * @class * @extends sap.ui.model.json.JSONListBinding */ return JSONListBinding.extend('archiving-variants.javascript.GrowingJSONListBinding', { getLength: function () { return this.getModel()._totalCount; } }); });​ sap.ui.define( ['archiving-variants/javascript/GrowingJSONListBinding', 'sap/ui/model/json/JSONModel'], function (GrowingListBinding, JSONModel) { 'use strict'; /**....

Good news for the SAP architect! Packt just published Architecting Solutions with SAP Business Technology Platform, an architectural guide to integrating, extending, and innovating enterprise solutions using SAP BTP (October, 2022). In this post, a brief review. === Like to get your book published too? For a road map, see SAP PRESS Authors Survival Guide |....

Hello fellow SAP developers, this will a short one but I think it might be helpful to other developers. We had the problem, that the READ requests from our SAPUI5 application took a very long time to process in the S4/HANA backend system but were actually returning fine. Somewhere in SAPUI5 app, the CAP middleware,....

SAP has two powerful frameworks to support a functional consultant. These are: BRFplus SAP Adhoc query. In this blog I would like to share my experience in calling a BRFplus function within an SAP Adhoc query. This I hope with help in extending the reach that BRFplus and SAP Adhoc query can provide for your....

  To best follow this post and try things out yourself, you should: Have some basic knowledge of the Python programming language (PySpark) Have a Data Lake instance provisioned and configured. configure the HANA Data Lake File Container. Have the Instance ID for your Data Lake Instance. Have access to a Jupyter notebook (io).   Overview:....

Introduction A very common use case that we experience while designing an application is the necessity to switch databases on the fly based on region or read/write activity in order to reduce latency and boost availability. Consider a geo-distributed app, which spans many geographic locations to ensure high availability, resiliency, compliance, and performance. The application....

Use cases of Microsoft Dynamics CRM Adapter in a S/4HANA Implementation project might sound commonplace especially when we mention them in the same breath as Salesforce and SugarCRM adapters. However, it wouldn’t be a stretch of imagination to call them a rarity. In this article, I will elucidate the scenario of implementing the MSD CRM....

When visualizing and working with data over a time perspective there are at least 3 scenarios: non-temporal: We only want to analyze the latest data available. This is the default approach when building presentations. It gives us the opportunity to quickly model data and build reports on top of it. temporal (no monitoring): We want to....

Hi SAP S/4HANA migration cockpit users, we had a session on Development News SAP S/4HANA migration cockpit in SAP S/4HANA 2022 Main topics: File/Staging: Use of CSV template files to populate staging tables, incl. Demo Direct Transfer: Show filter values in LTMOM, how can selection be influenced Migration objects: New objects, how to find relevant information Please check to get the latest updates. Sybille....

What is Rete? The Rete algorithm is a pattern matching algorithm designed by Dr Charles L. Forgy of Carnegie Mellon University. Rete is a  Latin word which means net [1]. It is a very efficient algorithm for matching facts against the patterns in rules. Understanding of the Rete algorithm will make one easier to understand why writing rules one....

This blog post shows how to do client-credentials flow with IAS using 2 different instances of  “identity” service in SAP BTP. We create a minimalistic sample app2app scenario where 2 application communicate with each other. Today, both apps are bound to a different instance of identity service. Used technologies: SAP Business Technology Platform (SAP BTP),....

本ブログはSAP標準のアップグレードツールである、Software Update Manager (通称SUM)を使ったアップグレードおよびコンバージョンプロジェクトのダウンタイム削減について紹介するページとなります。   ブログは以下3回を予定しており、本ブログはその２回目となります。 1．SUMダウンタイム削減概要 2．SUMダウンタイム削減（計画編）　←　ここ 3．SUMダウンタイム削減（分析編）   記事の目的 前回のブログではコンバージョンやアップグレードにおけるSUMのダウンタイム削減概要について紹介しました。本ブログではプロジェクト計画時に、ダウンタイム削減の観点で考慮が必要な事項の紹介を目的としています。   対象読者 本記事の対象読者は前回のブログと同様、SAPのアップグレードやコンバージョンプロジェクトに関わることとなったSAP Basis担当者またプロジェクト管理者を想定しています。   SUMの実行時間削減の大前提 前回のブログでご紹介した通り、SUMが提供するダウンタイム削減手法はいずれもTechnical Downtimeの削減を目指した手法となります。 図：SUMフェーズにおけるUptimeとDowntimeの分類について   そのため、Shadow Systemによって本番業務処理とSUMのコンバージョン・アップグレード処理が並行で実施されるUptimeフェーズを、業務ユーザがシステムアクセスができない状態としてしまうと、SUMの処理全体がシステムダウンとなり、SUMが提供するダウンタイム削減手法の効果が得られなくなります。このような状況となる具体的なケースは SAP S/4HANA コンバージョンの前提であるシステムのユニコード化が未実施のため、SUMの実行前にシステムコピーによるユニコードコンバージョンが必要 OS、DBのバージョンアップをSUMの実行と同じタイミングで行うため、SUMの実行前にOS、DBのバージョンアップが必要 コンバージョンやアップグレードの実施に合わせて、システムをクラウドにマイグレーションをするため、SUM実行前にシステムコピーが必要 などが考えれます。 いずれも、SUMの実行の前にシステムダウンが必要な処理があるため、SUMの開始時点から業務ユーザへのシステム解放を制限する方式となっています。 このような状態を回避するには、ユニコードコンバージョンやOS、DBのアップグレード、システムコピーなどの作業をSUMの実行とは別日に計画し、事前に完了させておく等の検討が必要となります。こうなると、SUMによるコンバージョン・アップグレードの他にもシステム停止日を設ける必要があるため、複数回の短いシステム停止日が取得しやすいのか、長いシステム停止が可能だが1度のシステム停止にする必要があるか、などを事前にシステムオーナーとご検討いただく必要があります。   SUMの実行時間短縮に最も効果のある方法 SUMの実行時間の短縮に最も効果のある方法は、強力なハードウェアを使用してSUM実行時のプロセス数を高く設定することになります。 SUMの処理では、ABAPプロセス、SQLプロセス、R3Transプロセス、R3Loadプロセス で処理がなされますが、それぞれの並列度はSUMのConfigurationフェーズで指定することが可能です。 図：Configurationフェーズで設定するプロセス数について それぞれのプロセスがSUM処理におけるどのような処理を担当するのか、また並列度の設定は何を元に決定すれば良いのかについては、以下のSAP Noteに記載されています。 SAP Note 1616401 – Parallelism in the Upgrades, EhPs and Support Packages implementations たとえば、R3TransプロセスはSUMの処理の中でも、サポートパッケージのインポート処理に使用され、DDIC_UPG、SHADOW_IMPORT、TABIM_UPGといった処理で使用されるプロセスになります。 R3transプロセスの並列度の推奨値はCPUの数と同じ数となるため、なるべくCPUの数が多い強力なハードウェアを用いて並列度を高く設定することが推奨されます。これにより、R3Transプロセスを使うSUM処理の実行時間削減が可能です。その他のプロセスについても、同SAP....

Over the years SAP have introduced a number of different frameworks to support transactional processing, for example Business Object Layer(BOL), Business Object Processing Framework(BOPF) and the ABAP Restful Application Framework(RAP). While the new frameworks have introduced enhanced capabilities and greater flexibility to integrate with newer technologies they share some of the basic fundamental design principles....

本ブログはSAP標準のアップグレードツールである、Software Update Manager (通称SUM)を使ったアップグレードおよびコンバージョンプロジェクトのダウンタイム削減について紹介するページとなります。   ブログは以下3回を予定しており、本ブログはその3回目となります。 1．SUMダウンタイム削減概要 2．SUMダウンタイム削減（計画編） 3．SUMダウンタイム削減（分析編） ←　ここ   記事の目的 前回のブログではコンバージョンやアップグレードのプロジェクト計画時に、ダウンタイム削減の観点で考慮が必要な点を紹介しました。本ブログではSUMの実行が完了した後、SUMが出力するアップグレード分析ファイルをもとに、ダウンタイム削減の余地を分析する手法について紹介します。   対象読者 本記事の対象読者は前回のブログと同様、SAPのアップグレードやコンバージョンプロジェクトに関わることとなったSAP Basis担当者またプロジェクト管理者を想定しています。   SUMのアップグレード分析ファイル（UPGANA.xml） SUMによるコンバージョンやアップグレード処理が正常終了すると、SUM実行の分析レポートが利用可能となります。レポートはUPGANA.xmlという名称のファイルで、<SUM directory>/abap/doc/analysis 配下に格納されます。このレポートでは次に示すような情報を確認でき、次回のSUM実行に向けたチューニングポイントを確認するための情報を提供しています。   ソフトウェアバージョンやデータベースサイズ情報 選択したダウンタイム削減手法やプロセス数 SUMの処理実行時間 各ステップで要した時間 大きなデータベーステーブル   UPGANA.xmlを使ったSUMの実行時間削減の分析 SUMの実行時間を削減するためには、SUM処理の中でも時間を要しているフェーズや処理にフォーカスして、処理時間短縮を行う必要があります。UPGANA.xmlではRoadmap Stepsというセクタを展開して表示すると、SUMにおける詳細な処理ステップ単位での実行時間を確認することが可能です。 例えば、下の図のようにExecutionフェーズでは合計で18時間45分の処理時間を要しており、その中でもXPRAS_AIMMRGという処理に11時間22分の処理時間を要しているということが確認できます。 このようにSUM処理の中でも長時間の実行時間を要している処理を見つけ、その改善方法を探索し、解決策を実装することでSUM処理の実行時間を削減が可能となります。 SUM処理の中でも長時間実行される処理は多くのお客様で共通しているため、改善方法はSAP Noteで提供されているケースが多いです。そのため、まずは改善したい処理名称でSAP Note検索を行ってください。   ここからは、良く参照される処理名とSAP Noteをいくつか紹介いたします。   EU_CLONE_MIG_DT_RUN この処理はNon HANAのソースDBからターゲットのHANA DBにデータをマイグレーションする処理で、R3loadプロセスが使われる処理となります。SUMのDatabase Migration Option（通称DMO）を使用した時に実行される処理になります。 本処理のパフォーマンスの分析方法はSAP Note 2597701 – Performance analysis for EU_CLONE_MIG_DT_RUN....

This blog is about an important principle for improving the quality of documentation. It can also help to improve decision making, collaboration and more effectively use meeting time by leveraging written asynchronous communication. Documentation (e.g. Architecture Documentation, Good Practices and Product Documentation) should be treated as code, which means that it is: placed under version control very simple syntax changes undergo reviews....

In this Blog we are going to see How to validate MYSAPSSO2 cookies with SAP Cloud Integration Introduction Recently, as part of an integration project in one of our clients, I was faced with the challenge of validating MYSAPSSO2 cookies with SAP BTP. After some research I was able to come up with 2 different....