In the lifetime of a Focused Build Implementation Project, there will be test & migration clients used for different test purposes. Some of them remain in the system, but some of them shall be deleted when they are not used any more. Before that deletion the client should be removed from the Focused Build Release.....

TL;DR: Explicit authorizations are your best bet for limiting the values in filters of SAP Fiori apps. You can identify which AuthObjects to set from the authorization proposals of the related OData Services, i.e. the OData Services are listed against the SAP Fiori app in the SAP Fiori apps library. Where authorizations are not applied, you....

As per SAP Help on Telegram Repetition and Channel Check Synchronization means that after a connection was established by SAP EWM, the programmable logic controller (PLC) was given the opportunity to send all messages that accumulated during the period of disconnection. PLC Sim emulator does not send telegrams if SAP EWM MFS communication channel is not started....

Following the blog series of enterprise event enablement and the possible ways to produce and consume an event in SAP BTP ABAP Environment and SAP S/4 HANA Cloud, here I would like to show you how you can create RAP Business Events in an OP system. With the release 2022, SAP supports the native exposure and consumption of business events for on-premise systems....

Als SAP BW Berater weiß man die Vorzüge eines ad-hoc-Reportings zu schätzen. SAP S/4HANA Embedded Analytics führt ein breites Spektrum an CDS-Views mit sich. Daneben lassen sich mit selbst erstellten CDS-Views vielfältige, unternehmerische Anforderungen abdecken. Wie aber lassen sich solche CDS-Views möglichst einfach in einem ad-hoc-Reporting nutzen? SAP S/4HANA Embedded Analytics nutzt dabei das SAP....

From S4HANA system we are extracting data to SAC using HANA CDS Views: S4HANA—  HANA CDS Views— SAC Core Data Service (CDS) Views: are virtual data models of SAP HANA which allows direct access to underlying tables of the HANA database. SAP CDS Views came into being with SAP’s new programming model. SAP CDS Viewsaim to push....

User experience has become a critical part of a successful implementation of SuccessFactors projects. One way to help customers increase the user experience is by enhancing alert messages and message definitions. These two functionalities are used to throw error messages, warning messages, or info messages during HR Transactions. Alert messages are highly used to remind....

The aim of this blog is to show how to do real-time replication from one SAP HANA Cloud instance to another. With applying of the latest development technologies, I will build an interesting scenario that will integrate between two cloud instances in such a way that when the data in the original table located in....

SAP Master Data Integration has been described as a multi-tenant cloud service for master data integration. It provides a consistent view on master data across a hybrid landscape. It is a part of the SAP Cloud Integration Strategy. But what does it mean? It means it will bring uniformity for master data objects across different SAP....

           I would like to share the subject related to the Archiving setup in SAP MES. We are all familiar with the Standard Archiving setup in the SAP ME system. But sometimes based on the business requirement, we have to archive the custom tables. From this blog, you will get the business logic to archive the....

With this series of blogs, we want to keep you informed on the latest news and what is important in the area of SAP ALM APIs and integration for SAP Cloud ALM, SAP Focused Run and SAP Solution Manager.   Motivation Today, ALM practice must connect different teams from different locations, platforms, solutions and tools....

This blog covers some ideas and approaches on routing of messages based on a particular XPath condition in SAP CPI. Requirement : Flow : SAP S4 HANA –> CPI –> 3rd party SFTP Source : IDOC, Target : External Definition IDOCs having no /ZCUSTOM_ZINVOIC02_INV/IDOC/E1EDP01/ZCUSTOM_E1EDP01_SUBITEM/ZFLAG=”A” need to be terminated in CPI and not sent to target....

Large Companies set up Global Supply Chain Network for Operational Efficiency, Cost Benefits, and optimum resource usage. With three quarters (or more) of all business-to-business transactions globally taking place between parties that are related to or affiliated with one another (i.e.one subsidiary sells a product to another, or a parent company provides services to a....

Comparing SAP S/4HANA Cloud, public edition, with SAP S/4HANA on premise, several differences in its IT audit capabilities become obvious. This blog post is part of a series of articles where we compare the audit process of SAP S/4HANA Cloud, public edition, with the audit process for SAP S/4HANA on Premise. To summarize the most....

Fields hidden by SAP in Standard BW Data Sources Many a times you would have observed that there are a few fields present in the extract structure of the SAP BW datasource but are not available in RSA6 or the data source which is replicated in BW. This blog talks about all steps as to....

Blog post series [Part-1] ‘Events-to-Business Actions’: An event-driven architecture on SAP BTP to implement Industry 4.0 scenarios with Microsoft Azure Services (click here) [Part-2] Understand the details of “Events-To-Business Actions” framework (click here) [Part-3] SAP Integration Suite’s upcoming event bridging functionality for outbound scenario (click here) [Part-4] Try out ‘Events to Business Actions Framework’ for SAP Service Cloud scenario....

With the current pace of SAP S/4HANA transformations it looks like not a lot of companies might make the 2027 deadline. Is there a standard way to speed them up? Yes, you can use project tracks, everyone knows that, right? Why are they not that common then? How can companies run 3-5 rollouts at the....

Clean Code – From Contribution to Decision Clean code is a term used to describe software that is easy to read, understand, maintain and test. With the adoption of the clean code style guide by thousands of teams, changes to the style guide can have a large potential impact on developers (e.g. through new static code checks for new rules). While there is....

Technical Requirement – Accessing Cloud Integration (CI) APIs through Client ID and Secret (in Neo). There is slight difference in the way we generate these keys in Cloud Foundry environment. Following below steps we will see an end-to-end scenario. What will we do here? Adding new Client ID & Secret Adding user Creating dummy HTTPs i-flow....

Clean Code: Wartbar, Lesbar und Testbar Clean Code ist ein Begriff, der Software beschreibt, die einfach zu lesen, zu verstehen, zu warten und zu testen ist. In diesem Blog möchte ich einige wichtige Prinzipien zusammenfassen, um Anfängern einen Einstieg in das Thema zu ermöglichen. Außerdem soll der Blog eine Verbindung zum Style Guide Repository, den....

Imagine a river. The Nile. The Yangtze. The Ganges. The Rio Grande. Take your pick. Now, what if you had to map the course of one of these vital tributaries knowing only its depth, width, and velocity of current? What if you had to plot the exact location of the river’s source and mouth based....

The January 2023 release of SAP Integration Suite now provides a feature in the Cloud Integration capability (6.35.*) to semi-automate the migration of integration scenarios from SAP Process Orchestration to SAP Integration Suite. New with SAP Cloud Integration capability release (6.37.x) of SAP Integration Suite The March 2023 release of Cloud Integration in SAP Integration Suite now....

“Events-to-Business Actions” architecture is an event-driven framework based on SAP Business Technology Platform (SAP BTP) to respond to and integrate with events generated from industrial production processes in plants, warehouses, and logistics into enterprise business systems, triggering associated business processes to enhance enterprise operations and enable rapid decision-making. The framework can integrate with events processed via....

This post is part of a series sharing service implementation experience and possible applications of SAP Private Link Service on Azure. Find the table of contents and my curated news regarding series updates here. Find the associated GitHub repos here. Dear community, Continuing with the implementation journey of SAP Private Link Service (PLS) for Azure we will have a closer....

As per new feature in CPI, we can create Message Mapping as Artifact and deploy before using in any integration flow.  There are already few blogs , where you can see how to create Message Mapping as Artifact and the limitations. SAP Cloud Integration – Message Mapping as Artifact | SAP Blogs In this blog,....

Blog post series [Part-1] ‘Events-to-Business Actions’: An event-driven architecture on SAP BTP to implement Industry 4.0 scenarios with Microsoft Azure Services (click here) [Part-2] Understand the details of “Events-To-Business Actions” framework (click here) [Part-3] SAP Integration Suite’s upcoming event bridging functionality for outbound scenario (click here) [Part-4] Try out ‘Events to Business Actions Framework’ for SAP Service Cloud scenario....

the request is to extract the absence days and target days from SuccessFactors for every employee for several month and year. It is realised with the an IFlow in the Integration Suite. The content should be deliver in CSV format. It should be looks like: PersNo,Year,Month,TargetDays,AbsenceDays 200112,”2021″,”12″,”20.00″,”3.00″ 200112,”2022″,”01″,”21.00″,”1.00″ 200112,”2022″,”02″,”19.00″,”2.00″ 200112,”2022″,”03″,”19.00″,”2.00″ 200112,”2022″,”04″,”20.00″,”0.00″ 200126,”2021″,”12″,”20.00″,”0.00″ 200126,”2022″,”01″,”20.00″,”4.00″ 200126,”2022″,”02″,”20.00″,”0.00″ 200126,”2022″,”03″,”20.00″,”1.00″....

During a workshop, I asked the contestants to refactor the sources of the Ski Lift Price Kata by Dominik Panzer. We made three rounds with about 45 minutes per round and 15 skilled and experienced developers tried to identify, what the code does, write sensible unit tests and refactor the code to make it better to read and....

Now a days it is becoming mandatory to print storage bin labels to verify the storage bins while confirming put away and removal tasks, so in this short blog I am going to show how to print the storage bins label in SAP-EWM   The T-Code used to print the storage bins is /N/SCWM/PRBIN Standard....

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

As an Integration consultant I come across scenarios where I have a complex WSDL at hand with deeply nested structures and multiple schema definitions like the one below for Business Partner Replication. Working with WSDL’s is all good and cool until you come across a requirement where you have to extract the XSD out of....

We all have come across scenarios where while Integrating between SAP and third party systems we have to convert from JSON to XML – So that SAP understands the JSON data being sent by the third party or from XML to JSON -so that the third party system that understands(or prefers to Understand) only JSON....

In this blog post, I will try to give you some insights into the scrap value, cut-off value, and memo value in Fixed Asset accounting. In certain countries it is a legal requirement that assets must not be fully depreciated; depreciation should stop when a certain net book value is reached. There are various options....

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

This brief is to demonstrate how one can leverage selected SAP BTP Kyma runtime serverless features. This instalment covers:  how to override a base function image Requirements and Disclaimers: https://github.com/SAP-samples/kyma-runtime-extension-samples/tree/main/kyma-serverless#requirements-and-disclaimers Sample code: Power of serverless with SAP BTP, Kyma runtime code sample hana-cloud gist Putting it all together. SAP BTP, Kyma runtime is SAP’s fully....

This is the continuation of my previous blog, where I started with the concepts of event driven architecture and integrated event mesh with CAP project. In this blog I continue the journey by creating a consumer API and integrating an end to end use case starting from CAP project (REST API) – SAP Event Mesh –....

In this blog post, I will share details on how to create custom responses and debug python 🐍 functions locally using Visual Studio Code. As the requirements of a function increase in complexity… it is likely that you will need to handle errors, return different status codes, and return different types of payloads. This is to better....

In SAP S/4HANA Cloud system, you can use batch determination in production and process orders and run schedule headers to find suitable material components for the product to be produced, and to pick these from stock. In this Blog, we will learn the process of setting up batch determination in production orders. And the same....

While I am checking on sap.ui.comp.filterbar.FilterBar control in SAP UI5 SDK, I have noticed that code has to be updated with new aggregations. For further clarifications, go on reading more. SAP UI5 Control: https://ui5.sap.com/sdk/#/entity/sap.ui.comp.filterbar.FilterBar/sample/sap.ui.comp.sample.filterbar.DynamicPageListReport sap.ui.comp.filterbar.FilterBar sample in SAP UI5 SDK view.xml: filterItems and FilterItem aggregations The above aggregations got deprecated since SAP UI5 version 1.48.0 and instead we can use filterGroupItems &....

In 2022 we finished another round of SAP Customer Connect for: Process Management 2021 for SAP Solution Manager incl. Focused Build. Test Suite 2021 for SAP Solution Manager incl. Focused Build Change & Release Management 2021 for SAP Solution Manager incl. Focused Build With this blog we like to introduce all the remaining improvement request....

In the business configuration of the SAP Business ByDesign system, you can configure the taxation parameters for SAP country/region versions in the fine-tuning activity, Tax on Goods and Services. You can configure the taxation parameters only for SAP country/region versions. This blog describes how to use the SAP Cloud Applications Studio to configure tax types, tax....

This is part of a series on exploring the SAP Analytics Cloud (SAC) data export API. When the series is complete, it will also be available as a single tutorial mission.  The completed export API wrapper can be found on github. We’ve taken a tour of SAC’s Model Export API and began constructing our Python API wrapper. We’ve marked out....

SAP has published a report called PP_MRP_SUPPORT (Note 3199068), which can assist in analyzing issues that may arise in the MRP environment. The report provides access to: MRP-relevant material master data, Sourcing Master data for in-house and external replenishment Implemented User Exits and BAdI’s(w/o AMDP BAdI’s) The ability to navigate to customizing settings MRP Background Jobs MRP....

This blog post will insights on how to export the application from SAP Demo kit and import the application to our Business Application Studio(BAS) environment and make custom changes as per our need/requirement. Here, I would like to explain how I achieved this task with simple steps. Introduction: If there is any Business demo in Business Application....

In this blog post, you will learn ‘How to create User Provided Services’ in  SAP HANA Cloud Business Application Studio. In recent years, after introduction of Business Application Studio(BAS) for HANA cloud modelling, developers are struggling to create a ‘User provided services’ to access the underlying tables persisted in any schema (post replication) or any....

In this article, I provide an overview of debugging in SAP systems. I discuss the importance of the skills, tools, and intuition needed as well as provide tips for analyzing and collecting relevant information. In essence, I cover all the things I do before setting the first breakpoint in code. Solving the Complex Puzzle of ERP....

A few months ago we were working in a CAP development where after the CAP SAPUI5 application was implemented, one of the requirements that we had was generating a PDF document with Forms Service API using the document details opened with the Object Page UI5 Element. Since the requirement was to have a button on....

I have just published a new version of my openSource project called the RAP Generator. The main new features are that I have added an option that allows you to delete the objects that have been generated using the RAP Generator. This option becomes handy when you have generated your objects in a package that....

With SAP BTP, Kyma Runtime, you can now expose your custom domain through an API Rule using an istio Gateway. Steps to expose your custom domain Hold the certificate of your custom domain Create on istio-system namespace a TLS Secret holding the certificate’s data Create your new namespace (eg: dev) Create a new istio Gateway that....

This blog represents the last part, part 6, of the 6-part series ‘Create Tax Content for Non-Localized Countries/Regions in SAP Cloud Applications Studio’.   Steps of Configuration We will understand the various steps of configuration in the following blogs : Overview Part 1 : Configure Tax Types Configure Tax Calculation Procedure (Optional) Part 2 : Configure Tax....

This blog represents part 5 of the 6-part series ‘Create Tax Content for Non-Localized Countries/Regions in SAP Cloud Applications Studio’.   Steps of Configuration We will understand the various steps of configuration in the following blogs : Overview Part 1 : Configure Tax Types Configure Tax Calculation Procedure (Optional) Part 2 : Configure Tax Event Configure Accounting....

This blog represents part 4 of the 6-part series ‘Create Tax Content for Non-Localized Countries/Regions in SAP Cloud Applications Studio’.   Steps of Configuration We will understand the various steps of configuration in the following blogs : Overview Part 1 : Configure Tax Types Configure Tax Calculation Procedure (Optional) Part 2 : Configure Tax Event Configure Accounting....

Hello, welcome to my blog post! I’m super excited to say that this blog is going to help Ariba consultants, enablement managers, customers and suppliers to accelerate their punchout catalog enablement project and complete it successfully within the targeted time. Introduction The punchout catalog is a supplier hosted catalog. Supplier manages the content of their catalog....

(Jana Subramanian serves as the APJ Principal Cybersecurity Advisor for Cloud Security. He is a Fellow of Information Privacy (FIP), awarded by the International Association of Privacy Professionals (IAPP). In this role, Jana supports strategic customer engagements on cybersecurity, data privacy, multi-cloud security integration architecture, contractual assurance, audit, and compliance.) Introduction When organizations adopt RISE....

Introduce the basic functionality of batch management in S/4HANA Public Cloud. Batch Master Batch Definition Batch Management Indicator: To activate batch management for certain material/product, the batch management indicator should be ticked on. The batch management indicator can be set in the material/product master via the following apps: Manage Product Master Data In ‘Plants’ tab....

The query optimizer uses statistics to select the best query plan. The query optimizer may be unable to choose the best query plan if certain statistics are missing. If database statistics for HANA Virtual Tables have not yet been created, query performance on BW Providers using Smart Data Access may not be at its best.....

“Get closer than ever to your customers. So close that you tell them what they need well before they realise it themselves.” — Steve Jobs   ‘Telporter’ is a smart watch company which serves customers across various parts of the world. Recently they kicked off the process of improving their customer experience. In this effort they....

Over the last few months, Sanraj Mitra, Shetty Vriddhi and myself have been working on a product inspection solution combining SAP solutions with external technologies. Product inspection is a key part of quality assurance where goods are assessed for compliance with the company’s standards. Due to the wide range of checklists for each product, this often is a complex procedure.....

SAP ME (Manufacturing Execution) and MII (Manufacturing Integration and Intelligence) are niche tools given by SAP to connect shop floor systems like PLCs, / SCADA / Historians / Third-party systems to ERP (SAP ECC / SAP S/4 HANA). Here, in this article, I am describing the steps involved in connecting such a third-party shop floor....

When you set up your SAP S/4HANA Cloud system for the first time, there’s a number of decisions you need to make regarding the settings that’ll be valid for the whole system. Among other things, you’re deciding how many and which ledgers you’re going to use. This is a big decision that depends on your....

As modern enterprise landscape is evolving and becoming more and more cloud oriented, we have seen direct impact of this evolution on the way SAP customers run and deploy their mission critical applications. SAP customers are adopting SAP Business Technology platform to achieve their journey into cloud world. Without compromising security one of the key....

Introduction: We might come across data in Access Control and Process Control applications which are relatively old or obsolete in nature and need to be archived to avoid system performance issues when the data volume rises. The archiving function provides the choice to store away unneeded historical data so that the different features/applications will be able....

Goal of this blog post In this blog, we will create a simple panel displaying analytics for Health Monitoring data managed by SAP Cloud ALM with the ALM Grafana plugin. This plug-in lets you extend your analytics solutions for application life-cycle management. This plugin is based on the SAP ALM analytics API. The main concepts of the SAP ALM Analytics API....

Dear All, In this blog, we’ll take a look at how you can utilize SAP Analytics Cloud APIs (also for Embedded Analytics) and understand all the endpoints for you to automate or to get some insights from the data which is modeled from report or story. By the end of this tutorial, you will know all different....

Using a planning enabled SAC model, users can comment on data – typically this done by clicking on a table and accessing the contextual menu to add a data point comment. From a UX/UI perspective this got me thinking that there must be a more obvious way for users to read/add comments – particularly if....

As part of the risk-based authentication concept, the Identity Authentication service (IAS) offers various options for multi-factor authentication. One of the alternatives is to use hardware security keys for strong phishing resistant access protection combined with ease-of-use for the end user. In this blog I will explain – jointly with Mr. Rolf Steinbrück from Yubico....

In this series of blog we will focus on integrating the SAP Cloud ALM API with a SAP Build application to demonstrate how to extend SAP Cloud ALM with custom functionality. This blog describes how to setup your SAP Build environment and the connectivity to your SAP Cloud ALM tenant: SAP Build Apps environment setup Connect your SAP Build....

I enjoyed meeting customers face-to-face at SAP TechEd 2022 a couple of weeks ago. Being back in person in Las Vegas was great, supporting hands-on lab sessions, and promoting our SAP BTP Use Cases. One of our featured use cases, which you can try out with SAP BTP free tier service plans, is Create simple, connected experiences....

The SAP Task Center service enables integration with various SAP applications to provide a single entry point for end users to access all their assigned approval tasks. The tasks can be accessed by end users through the SAP Task Center Web application This blog details integration of Task Center in BTP with S/4HANA on-premise. Prerequisites:....

The 23Q1 release of the “Transition to SAP S/4HANA” (on premise) road map has been published, and here are the most important things we have changed for you: As always, accelerators have been updated throughout the road map, to link you to newest information on SAP S/4HANA release 2022 FPS00 (e.g. release notes, feature scope description etc.).....

This blog post discusses customer tolerances:  when a customer short pays an invoice, what happens to the difference and how can it be controlled. Key concepts: Line item tolerances Tolerances for payment advices   Overview When a customer short pays their invoices, the differences need to be reconciled.  Typically, the differences are either written off....

This post discusses some other components of the tolerance configuration that need to be taken into consideration and supplements my other blog post Managing Payment Differences with Tolerances for Lockbox Cash Application There are a few other components of customer tolerances that should be taken into consideration that will impact cash application.  Refer to Figure 1.....

This blog post is written in Japanese. SAP Data Warehouse Cloud (以下、DWC) のテーブルを作成したときに、列名の技術名とビジネス名は同じものがデフォルトで入力されます。Data Warehouse Cloudの機能では一括でビジネス名を変更することはできず、手作業でビジネス名を変更していただく必要があります。 このブログではDWCのCSN/JSONファイルエクスポート/インポート機能を使って、Pythonでビジネス名を一括変更する方法をご紹介します。 ※JSONを扱えるライブラリがあるJavascriptでも同様に行えるかと思います。 手順は３つです。 ①CSN/JSON ファイルをエクスポート ②Pythonで書き換える ③DWCに書き換えたファイルをインポート 今回はCUSTOMERというテーブルのビジネス名を日本語にしたいと思います。 詳しい手順についてご紹介します。 ①CSN/JSON ファイルをエクスポート DWCから目的のテーブルをCSN/JSON ファイルとしてエクスポートします。 ②Pythonで書き換える Pythonで下記コードを実行します。 import json # カラムの技術名とビジネス名のマッピング table_mapping = {'CUSTOMER':'こきゃく'} # カラムの技術名とビジネス名のマッピング（DB等から取得する必要があるのであればコードを取得するためのコードを記述する） column_mapping = {'COUNTRY':'くに' , 'FULLNAME':'なまえ', 'TITLE':'たいとる' , 'COMPANY':'かいしゃ', 'ADDRESS1':'じゅうしょ1' , 'ADDRESS2':'じゅうしょ2', 'ADDRESS3':'じゅうしょ3' , 'CITY':'とし', 'STATE':'しゅう' ,....

A frequent use case in hybrid data warehousing scenarios is to enrich existing data models in SAP BW/4HANA with analytical data models from SAP Data Warehouse Cloud. Data from SAP Data Warehouse Cloud is to be transferred to SAP BW/4HANA to enrich the existing data flow in the on-premise system with public cloud data. The....

Starting with SAP Landscape Management (LaMa) Support Package (SP) 21 the cluster integration for the SUSE Linux Enterprise high availability extension was implemented. Now with LaMa SP25 it also integrates with Red Hat Enterprise Linux High Availability Clusters, which means that the pacemaker support is completed for all SAP HANA database environments. This blog describes....

Realignment is one of the processes available in IBP to move/copy data. It is generally used to accommodate for changes in Master data within Supply Chain. Along with the change of Master Data, realignment also helps in copying key figure data from old planning objects to new ones. Realignment also provides option to get rid....

Batch derivation is always active in SAP S/4HANA Cloud. During this blog, we will learn the process of setting up the batch derivation. Overview Set up a sample of batch derivation in Production Process. Prerequisite Batch management materials need to be created, there should at least be finished and raw materials with MRP views and the....

This blog post describes the case of  CSV File to N IDocs conversion in SAP CI and a strong case, when a specific set of rows identified by unique value in the CSV File are to be converted into  individual IDoc, it requires conversion of grouped rows(by unique value)  into  individual messages before conversion into....

B2B users have different levels of requirements for data exchange starting from the different kinds of communication protocols such as AS2, SFTP, etc. to the usage of different types of B2B standards such as ASC X12 or UN/EDIFACT or APIs. Trading Partner Management (TPM) helps you effectively manage B2B relationships with multiple trading partners. The....

This blog shows how to find TCP ports used or reserved by applications on Windows. It is not related to specific SAP applications. Problem: An application cannot start, because the port it wants to use, is in use by another application (or components of the operating system). How can we found out which application uses....

Expiring TLS certificates create maintenance efforts all over the place and pose a security risk if not taken care of in time. Especially if the underlying private key was at risk. Furthermore, security guidelines advocate for shorter lifecycles. GobalSign, DigiCert and other official Certificate Authorities (CA) enforced a maximum of 13 months in 2020. However, most people want....

We are now down to the last quarter of the year 2022 and we are releasing another SAP note for Visual Modeler enhancements and fixes.  Now, allow me to introduce this newly released SAP note 3245200 – FS-PER Rel. 3.0 SP20 Visual Modeler Screens Enhancements and Fixes (2) that includes new features, enhancements, and improvements to the users for....

To help you better understand the structure of generic payment formats CGI_CT and CGI_DD, we have created an excel file that covers the mapping of all reference fields in the generic and country-specific CGI trees. Reference fields are used to extend the capabilities of the standard fields. You can find the excel file in this SAP....

At BP transaction in your S/4HANA system you might notice that some descriptions of tabs, sections etc. are not correct or missing. That could happen in some cases where you convert your ECC system into a S/4HANA system. Another case could be after setting up a new client. SAP offers a comparison tool to compare....

In my previous blog Use SAP Cloud Application Lifecycle Management (CALM) System to Monitor Your SAP S/4HANA Cloud 3-System Landscape Systems – Part 1: Setup, I detailed the steps to set up CALM for a 3-system landscape systems.  It discussed the special handling of different errors which are usually not documented in SAP Help Portal documentations.....

Hello everyone. The purpose of this document is to shed some light on the process to call Adobe Forms Service API (for Cloud Foundry environment) from ABAP cloud. It sometimes becomes very confusing because of the different components involved especially when you are implementing the ABAP part. Let’s begin with the prerequires first. We need:....

In past, I have already written a blog on Direct ODO creation from EWM which creates replenishment delivery and corresponding STO PO between 2 Plants. The current blog is an attempt to explain how DirODO can be integrated with Shipping and Receiving functionality with Pallets build up at Production supply Area using Advanced Production Integration with RF....

We are familiar with getting data from a table using AMDP procedure or AMDP table function. But, how about CDS View, I tried a case and got the following error Basically, AMDP will get data from database, and it will get all client (assume your system have several clients), that is a reason why you....

In previous article, we have experienced by using CDS View inside CDS Table function. And now, we will try with AMDP procedure Like as CDS table function, with AMDP Procedure, we will also catch an error Because this CDS View which we used in this article is a client specific. But AMDP is not. Basically, AMDP....

この記事は SAP Advent Calendar 2022 の12月4日分の記事として執筆しています。 日本語のCAP情報が不足していると感じたため、本記事ではCAP初心者向けのTipsや参考情報を紹介したいと思います。 CAPについて SAP Cloud Application Programing Modelとは、サーバサイドアプリケーションを作成するためのフレームワークであり、簡単にODataサービスを作成することができます。 Fiori ElementsやUI5の相棒として使われます。 なお、CAPはNode.jsで開発するか、Javaで開発するかを選択することができますが、本記事ではNode.jsを選択することとします。 CAPの使い方(基本) CAPの最もオーソドックスな使い方は、HANA Cloud内のテーブルを読み書きするためのODataサービスを作成する。 ということになります。 下記の記事やチュートリアルを参考にすると良いでしょう。 https://qiita.com/tami/items/d1b69a93da14e288faf2 https://developers.sap.com/tutorials/appstudio-cap-app.html 外部APIを呼び出す 外部のOData APIを呼び出すケースも考えられます。 例えばS/4HANAの拡張アプリケーションをUI5+CAPで作成する場合には、アプリからはHANA Cloudの読み書きができるだけでは不十分で、S/4HANAのAPIも呼び出す必要があるでしょう。 下記のチュートリアルが参考になります。 https://developers.sap.com/tutorials/btp-app-ext-service-add-consumption.html Expressを利用する Node.jsでWebアプリケーションを作成するときに最もよく使われるフレームワークがExpressです。 そもそもCAPはExpress上で動いているのですが、素のExpressを利用したくなることがあります。 CAPの標準機能だけではどのように実装すれば良いかわからない場合があったとしても、ExpressはWeb上にサンプルコードや参考情報が非常に多く、大抵のことはできるようになるでしょう。 例えばエクセルやCSVをアップロードして、サーバ側で処理してDBに格納するなどもExpressであれば簡単です。 Expressを利用するには、server.jsという名前でファイル作成し、srv直下に置くだけで利用できます。 中身は下記のようにして下さい。 https://<ホスト名>/endpoint や https://<ホスト名>/endpoint2にブラウザでアクセスすると、Expressのルーティングが有効になっていることを確認できます。 もちろん、server.jsのソースコード上部で必要なモジュールをどんどんrequireし、様々なNode.js向けのモジュール(ライブラリ)を活用した複雑な処理を実装することが可能です。 const cds = require('@sap/cds'); cds.on('bootstrap', app => { app.post('/endpoint', function(req, res, next) { // express handler....

In our last blog we went through some commonly used platform transforms in bods, you can check that out on below link https://blogs.sap.com/2022/11/04/sap-bods-commonly-used-platform-transforms/ Today, in this blog i will cover the data integration transform Table comparison with Map operation  in SAP BODS which is widely used to handle many data management scenarios. What’s in it....

This article has been written assuming the reader has fair amount of HCM knowledge about Pay ranges. I will not focus on Pay range as an object but will talk more about scenarios around it in SuccessFactors (SF) Employee central (EC). I realized that some information related to this topic is available in bits and....

Process Controls as a concept is about providing a centralized controls and compliance management solution. It is designed to assess, document, evaluate, monitor and report the effectiveness of internal controls. One of the core component of Process Control is Continuous Control Monitoring (CCM). This component monitors the ERP systems based on Business Rule logic and....

This is the continuation of my previous blog, where I explained how to create entity relationships in CAP/CDS with a working example of a very useful scenario observed in enterprise applications. In this blog, I will take the same use case further by enhancing and integrating it SAP Event Mesh. What is Event-Driven-Architecture (EDA) and Why....

SAP Build combines Apps, Process Automation and Workzone to empower users, both professional and citizens developers, to build applications, automate processes and design customised dashboards with simple drag-and-drop options, integrate smoothy with SAP and non-SAP systems and collaborate effectively between business and developers. With SAP Build Apps gaining popularity among the community as an intuitive no-code....

This information applies to both plain Kubernetes as it does to SAP BTP Kyma. I wrote it because I found the information not in one piece and hope it saves you some time! Pulling images into Kyma to run them as containers in pods is one of the wonderful things using Kubernetes. While we often leverage....

While investigating on a custom solution for SAC widget , I realized there is still a lot of Mist around Custom Widget , primarily towards its hosting as well as creating a basic working version of a custom widget. The aim of this blog is to demystify the basics around custom widget and navigate through....

In a previous blog, Use cases for choosing the different types of Higher Duty or Temporary Assignment, we outlined the different responsibility types you could choose for that assignment. The employee or manager or administrator can initiate or create the higher duty or temporary assignment process. There are standard workflows to edit, and approve the higher....

写在前面：本篇博客为翻译作品，希望帮助使用中文的客户通过更好地理解 SAP S/4HANA Cloud 更新/升级中所能使用的特性、功能和限制，帮助您更好地计划业务，整体提高使用产品的效率。 同时也感谢 Vincent Zhu （Vincent Zhu）在本篇翻译过程中所提供的建议！   原作者是： Akshay Sharma (Akshay Sharma) 原文发布在：https://blogs.sap.com/?p=1648480?source=email-global-notification-mod   如今，客户希望云解决方案能够提供持续可用性，无需等待计划维护事件。他们期待软件部署不再中断其业务。这正是蓝绿部署（Blue-Green Deployment）方法帮助 SAP S/4HANA Cloud 实现的成果。 随着当前蓝绿部署能够支持基于 ABAP 的云系统的更新（hotfix 热修复）和升级（新版本发布），SAP S/4HANA Cloud 的停机时间为 5 分钟或更短。这一数字将计划进一步减少，直至到0。 本博客旨在向您介绍 SAP S/4HANA Cloud 更新/升级中使用的蓝绿部署方法，并讨论即使正在运行更新/升级，用户也可以使用的所有特性和功能。下面，我们开始吧！   什么是蓝绿部署？ 蓝色和绿色仅指不同版本的两个运行时（runtimes）。如下图所示，蓝色是当前正在使用的生产运行版本，绿色是更新/升级之后的版本，最终将替换蓝色版本。 蓝绿部署   蓝绿部署的工作方式如下：使用者使用蓝色版本时；绿色版本将被并行部署。然后，当使用者切换为使用绿色版本时，蓝色版本将被移除。在上图中，“准备 V2”（“Preparing V2”）和“切换到 V2”（“Switching to V2”）阶段代表更新/升级阶段。 就是这样简单！ 这意味着更新/升级所需要做的更改都会在尽可能不影响用户的情况下被部署。在后台执行大部分更新/升级相关任务后，系统即切换到更新的版本，而更新后的系统即刻变为可用。因此，用户遇到的不允许登录系统的停机时间通过蓝绿部署将大大减少。 目前，SAP S/4HANA Cloud 中的所有....

This blog describes the differences between classic ABAP programming and ABAP Cloud programming with regards to the SAP Logical Unit of Work (SAP LUW) [1] and the ABAP RESTful application programming model (RAP). It helps to understand how database updates work and what developers must consider avoiding data inconsistencies during database updates. Classic ABAP Programming In typical....

In one of my earlier blogs, I put a spotlight on BW Transformations in HANA Runtime from ODP sources. The trigger came from lessons learned during an in-place conversion to SAP BW/4HANA were my team ran into situations causing some headaches. The reason was, that there is no HANA Runtime for transformations on ODP sources in....

写在前面：本篇博客为翻译作品，希望帮助使用中文的客户通过更好地理解 SAP S/4HANA Cloud 更新/升级中所能使用的特性、功能和限制，帮助您更好地计划业务，整体提高使用产品的效率。   原作者是： Rodrigo Fagundes (Rodrigo Fagundes) 原文发布在：https://blogs.sap.com/2022/12/01/understanding-how-the-file-size-displayed-in-migration-cockpit-ui-is-calculated./   LTMC 或 迁移你的数据App中显示的文件大小计算如下： 对于每个工作表，每个字段的大小之和，单位为字节，(80+80+60+…)，然后获取每行的大小 然后（每行大小）* 行计数 = 每个工作表的大小。 而文件大小 = 总和（每个工作表的大小）。 通常，以此方式计算的文件大小应大于本地磁盘的大小。因为即使单元格为空，也会计算大小。 如果结构具有大量列，则无论是否在文件中填充字段，计算的大小都会更高。根据源结构定义，不同迁移对象的 100Mb 文件将具有不同的计算大小。 要检查文件是否过大，可以在 LTMC 中上载文件或 迁移数据 应用。如果文件概览中的大小大于 800mb，则文件过大，无法处理。   有关文件大小限制的详细信息，请参阅以下知识库文章： 2719524 – SAP S/4HANA 迁移主控室：XML 模板大小限制

写在前面：本篇博客为翻译作品，希望帮助使用中文的客户通过更好地理解 SAP S/4HANA Cloud 更新/升级中所能使用的特性、功能和限制，帮助您更好地计划业务，整体提高使用产品的效率。   原作者是： Sybille Lackermeier (Sybille Lackermeier) 原文发布在：https://blogs.sap.com/2022/11/28/sap-s-4hana-migration-cockpit-how-to-overcome-file-size-limitation-when-uploading-xml-files/   SAP S/4HANA 迁移主控室Migration Cockpit的用户们， 如果使用 XML 文件为暂存表填充数据 – 您可能会在文档中遇到提示： 每个文件的大小限制为 100 MB。您可以使用 zip 文件一次上载多个 XML 文件。请注意，要添加到 zip 文件的所有 XML 文件的组合大小不得超过 160MB。zip 文件允许的最大大小为 100MB。 我们为文件拆分器工具准备了一个示例代码，可以帮助拆分大型 xml 文件。 请注意，这只是示例代码！ 在 Git Hub https://github.com/SAP-samples/s4hana-mc-xml-file-splitter 中查找所有详细信息。  

With the new evolving modern methodologies around many SAP applications and database technology, i am trying to contribute with some idea that can be helpful or spark a new idea for others. The thought is … What if we can create HANA docker container with database filesystems mounted to the container using NFS filesystems from....

In this blog, I want to share the details about the CRUD Operation by using RFC function module. RFC stands for ‘Remote Function Call’-It can be called across the server and can access the data from SAP and Non SAP also. In RFC we always use pass by value mode. Basically, this functionality includes the....

Recently I have got chance to work on BTP cloud security below use-case in a cloud application   1) Display BTP Role Collection in UI Picker :Show all role collections, roles ,which exist within the current sub  account created for specific XSUAA APP Programmatically 2) Validate whether role collection exist at BTP sub account 3)....

In this blog post, I will be sharing an automated design concept for Spot Award Budget calculation and how to configure it. About Spot Awards A Spot Award is a non-recurring, compensation event that is based on a specific contribution or performance. It can be cash or stock and is generally subject to budget and....

This blog outlines Configuring Legal ID in Cloud Application Studio at detailed level over the existing model in SAP Business ByDesign. Configuration of Legal ID in SAP Business ByDesign solution is outlined as following. The Fine-Tuning activity to maintain “Document Numbering Formats for Customer Invoicing” is accessible in the SAP Business ByDesign, Business Configuration WorkCentre....

For a great user experience, it is very important that users can enter data quickly, fluently, and efficiently – even on a slow network. This is particularly relevant for power users, i.e., users who spend significant time with data entry, often using keyboard shortcuts to move from field to field. In this post, we will....

Unsurprisingly, every business is looking to reinvent its digital strategy and rapid ERP implementation approach, fueled by agile implementation methodologies like SAP Activate. SAP project Implementations or the implementation of an Enterprise application has historically been considered a complex and time-consuming process. To accelerate the implementation process, SAP Activate Methodology provides handy tools and guidelines at....

Recently checked a few remediations of ancient SAP Script forms, and encounter the command line being too long that even 2 lines are not enough to accommodate. Seniors could think ‘/=’ or ‘=’ for wrapped lines will do but actually, it will not. Please find below my testing results for various approaches to deal with....

By now we are aware of Data Access Control (DAC) in SAP DWC which allows the row level security for data access. However, in this blog I would like to bring a new approach on the same. Introduction: The Data Access Control is primarily setup to restrict the access to Business data in a report....

In the last week, Archana Shukla and Chaitanya Priya Puvvada wrote very comprehensive blogs (Start Process from SAP Build Apps using APIs and Integrate SAP Build Apps and SAP Build Process Automation using SAP BTP Destinations) on creating triggers in SAP Build Process Automation so you can trigger your process via API, for example, from SAP Build Apps. Both take advantage....

In pursuit of making ABAP Unit Test less dependent and more independent 😊, today I have decided to write on an interesting but less explored topic which is removing function module dependency in ABAP Unit Test using TDF. This is one of the less discussed topics in abap unit test double framework.After implementing some of them....

In this blog you will learn how to hide statuses from the graphical status overview section (roadmap) of your ChaRM transaction in case they are unused/undesired for some reason. The requirement from a process point of view If you are working with SAP ChaRM on the SAP Solution Manager, usually the current status of a....

I could see that most of WIKI link and existing blogs, SAP Community Q&A, are referring BPCA in SolMan 7.1, I just wanted to write this blog for those users who are planning to setup BPCA in Solution Manager 7.2 with relevant screenshots. Come let’s go into the topics in detail Why is Change Impact....

There‘s a popular internet meme out there: “One does not simply …”. It comes from the statement “One does not simply walk into Mordor” made by Boromir, a member of the fellowship in the first Lord of the Rings movie, who is doubtful about the mission‘s prospects of success regarding the destruction of the one ring in Mount Doom –....

(Note: Enterprise Messaging doesn’t exist anymore within the context of Integration Suite but one can use SAP Event Mesh service from BTP for similar demands)   This blog post is an attempt to explore different integration capabilities within SAP Business Technology Platform (BTP) focusing on scenarios for customers and partners who are building integrations on....

Today I`m here to present some options of solutions to handle an error for Item Connector – “Cannot specify a NULL Key value for reference entity REV_DTE in Item Connector”- used to upload massive courses into SAP SuccessFactors LMS. Before to start, go understand the whole import process. The import or upload process in LMS....

有客户提出需求，在销售订单出库交货过账后，不允许修改销售订单的价格。因为如果交货过账后修改了订单中的价格，在开票的初始界面，金额还是更改之前的价格，只有模拟开票后才会更新，这对于财务的一些计算会带来困难。本文即对该问题展开分析，探索解决方案。 解决方案： 尝试通过自定义逻辑，写一个 BAdI 来满足需求。 分析步骤： 1. 首先，我们需要在 SAP S/4HANA Cloud 系统的应用 – 自定义逻辑里，新建增强实施。根据业务场景，选择下图中的业务上下文以及业务加载项描述，填写好实施描述以及实施标识。 新增增强措施 2. 在自定义逻辑里根据本问题涉及业务上下文完成新建增强实施后，我们需要找到字段获取销售订单的价格。此外，还需要获取销售订单的发货状态和过账状态，作为判断条件帮助我们判别一个销售订单是否已经出库交货过账。我们需要在 CDS Views 里进行查找和检索。I_SALESDOCUMENT 这个 CDS View 包含了销售订单的字段信息，查看检索字段描述，字段 TOTALNETAMOUNT 可以帮助我们获取销售订单的净值。同时在该 CDS View 里，字段 OVERALLTOTALDELIVERYSTATUS 代表总体交货状态。如图所示，该字段为 A 代表未交货，为 C 代表已全部交货。 销售订单交货状态 我们还需要获取销售订单的过账状态。当销售订单处于可过账发货状态时，字段 GOODSMOVEMENTSTATUS 即货物移动状态的值为 A 。在完成发货过账后，该字段的值变为 C 。因此，我们在 I_DELIVERYDOCUMENTITEM 这个 CDS View 里使用该字段来获取销售订单对应的过账状态。 完成过账的出库单，货物移动变更为 C 现在我们已经找到了针对该问题的 BAdI 所需要用到的字段，接下来就是要确保我们在 CDS Views 里取到对应销售订单字段的值。在 I_DELIVERYDOCUMENTITEM 里字段 REFERENCESDDOCUMENT 表示参考凭证的凭证编号，即出库单对应的销售订单号。因此，我们在调取 I_DELIVERYDOCUMENTITEM 中数据时的匹配条件即是” REFERENCESDDOCUMENT = SALESDOCUMENT-SALESDOCUMENT “，这样就能正确取到销售订单对应出库单的字段数据。 3. 根据以上分析过程，实现 BAdI ，具体代码如下。 if SALESDOCUMENT-OVERALLTOTALDELIVERYSTATUS = 'C'. select single * from I_SALESDOCUMENT with privileged....

This blog aims to assist and complement the understanding of the Data Builder on a high level and is based on my personal learnings. SAP Data Warehouse Cloud’s Data Builder allows for technical personas to model underlying relationships of data from various sources and levels of granularity. It provides the ability of leveraging graphical interfaces....

This blog intends to provide an overview about the end-to-end process of the Remote Conversion to SAP Data Warehouse Cloud, BW bridge. For a deep dive into the details of all activities involved, check our SAP Data Warehouse Cloud, SAP BW bridge Runbook which contains practical examples, tips and recommendations based on experience with real customer projects.  ....

SAP offers RISE with SAP to enable customers in becoming Intelligent and Sustainable Enterprises (IES). RISE with SAP offers customers a flexible solution combining Cloud ERP, Industry best practices, Analytics and more, under a single contract. Behind the scenes, SAP’s powering technology is responsible for making this happen. In this blog, I would like to....

Product Costing is the tool used in SAP for planning costs and establishing material prices. It helps in estimating the Cost of goods sold for each product unit. Product Cost planning involves planning the costs for materials without reference to orders and set prices for materials and other cost accounting objects. It consists of creation....

本篇博客汇总了目前已发布的所有中文版本的引导解决决策树，以下是所有的话题/业务线。作为新的中文知识库的一部分，希望赋能所有使用S/4HANA Cloud的中国客户。 以下是所有“树”的链接，以及每棵树当中您可能想要了解的包含的关键词，您可以选择感兴趣的话题点击对应的链接来浏览。 总账会计 应付会计 应收会计（也可查看该博客） 成本会计（也可查看该博客） 固定资产（也可查看该博客） 计划到生产 智能机器人用例 财务博客（具体可查看该合集） 集成决策树 中央业务配置平台 嵌入式分析 寻源和采购   汇总 总账会计 https://ga.support.sap.com/dtp/viewer/#/tree/2937/actions/43198   删除公司代码 功能货币 银行科目被强制拆分 账套设置 凭证分割 重分类应收、应付客户 SSCUI 仓库收发货货物移动 会计科目配置点 税码须知   一次性把所有科目从现有公司扩充新公司代码 会计科目表 允许新增？ 快速批量创建 会计科目到生产系统 修改总账科目 未清项管理   会计年度变式？自动开关账期？ 已交易货币显示科目余额 APP？ 开具供应商发票 采购订单行项目超过999行？ 显示 APP 管理过账期间的操作日志 过账（含清账） 应收、应付、预付款 往来账户调整 清账   年结 余额结账 账期结转 同时多个公司代码开启/关闭过账期间....

On December 2nd, 2022, IBM i 7.5 TR1 was released along with Db2 for i PTF Group SF99950 Level 3, as well as IBM i 7.4 TR 7 along with Db2 for i PTF Group SF99704 Level 23. You can get a quick overview over the enhancements for IBM i 7.5 at https://www.ibm.com/support/pages/ibm-i-75-tr1-enhancements and for IBM i....

Cumulative sum, running total, accumulative sum, running sum… Yes, we have many ways to call this calculation: A summation of a sequence of numbers across a certain period or dimension. No matter the name, it always gives us a headache: You have many ways to calculate it but it seems you can never fit your....

In an SAP S/4HANA (and SAP ERP) System you typically maintain address information for Business partners (like Vendors and Customers). One of the important fields within an address is the region code which belongs to a country. An example is the region “Hessen” which belongs to the country “Germany”. In an S/4HANA System the region....

Welcome to this blog post series where we interview SAP Cloud Integration practitioners, developers, architects and enthusiasts about what their favourite feature of the platform is. To see all the posts in the series so far, click here. Let’s get started! Could you introduce yourself briefly, please? Sure, happy to! My name is Morten Wittrock and....

Background By default, business users have unrestricted authorizations for maintaining standard prices. Flexible Workflow is part of SAP Business Workflow and will allow you to set up and manage simple workflow scenarios in different lines of business, such as SAP S/4HANA Finance, Procurement, Human Resources, Manufacturing, and now SAP S/4HANA Sales. In this blog, we....

SAP keep releasing newer versions for SAP ANALYTICS CLOUD KIT. It is always good to upgrade it to the latest package. While upgrading using Power shell script it to the latest version we faced the below error. Error while upgrading SAP ANALYTICS CLOUD KIT   Apache Tomcat and SAC cloud connector is failing to start....

I am so excited to write this blog on BPMN Diagram features in SAP Solution Manager 7.2 that are almost unknown and unexplored by many of us. I got a chance to explore and unwind the features & capabilities of the in-built BPMN editor in SAP SolMan 7.2 system. Come, let us see about each....

In this blog post, I want to talk about Extensibility in 3-System Landscapes in a simplified way, so that you understand what each tenant is for and how to use it correctly for each feature.   Depending on your installation, your SAP S/4HANA Cloud system is based on a 2-System Landscape or on a 3-System....

SAP Business Process automation Error Free 10 steps to work on ‘TRIAL VERSION’. Purpose – This blog post serves how to setup your SAP BTP Trial account and use Business Process Automation ( Featured for Low Code No Code ). Introduction – What is LCNC ( Low Code No Code ) ? Low code no code is an....

SAP Customer Data Platform (CDP) has a vast number of connectors available for integration with different types of applications, as a source or destination of data. Despite of this, we may face some cases the client has applications that still do not have an OTB(Out-of-the-box) CDP connector, or the application version is not compatible with....

In my blog Upload rendered PDF document into BTP document manangement service in SAPUI5 Application , the PDF document has been uploaded into  BTP Document Management Service(CMIS). If the user want to download and view the PDF document later, how to realize it in SAPUI5 application?  Today I will explain the precedure in detailed steps. Prerequisite: 1,....

In this beginner blog post we are going to see how we can use Authorizations (Instance Authorization) in ABAP Restful Application Programming Model.   Ref: https://help.sap.com/docs/BTP/923180ddb98240829d935862025004d6/2f888de9d96e44acbfde2936d2c8bf24.html     Instance Authorization Instance authorization is used for all authorization checks, in addition to the user role. With instance authorization, you can define authorization on a field or operation....

Many of our customers apply their own themes to SAP applications, to adapt the visual appearance of the apps to transport their corporate brand identity. To do so, SAP provides a single tool for theming and branding SAP’s key user interfaces – the UI theme designer. With the UI theme designer, you can apply your corporate branding....

At the end of 2020 Apple released Macintosh computers with a dramatic shift in hardware, leaving behind the Intel x86 based CPU’s and using their own in house M1 arm based CPU’s. This shift meant software had to be recompiled or rearchitected to run natively on the M1 processor. While some x86 based apps will....

In this blog I would like to demonstrate to you how you can make use of the calculation fields and subtotals in the output of the payment accompanying sheet. This feature is only localized for the Netherlands, and it will not be automatically available in your system as of SAP S/4HANA Cloud 2208.1 but requires that you....

SAP’s TechEds are annual events where you can find out about the latest in SAP technology and innovation. The 2022 SAP TechEd was hosted Nov 15-16 and covered a lot of interesting topics, including a talk from SAP’s Global Head of AI, Fei Yu, on “Realising your business potential with SAP AI Solutions”. One of the latest....

SAP HANA Cloud provides several built-in algorithms to process data. Custom logic can be implemented in SQL script and executed in procedures or functions. Apart from that, procedures and can leverage more advanced capabilities from the so called Advanced Processing Engines (like the Machine Learning, Graph and Spatial engines). How can a procedure be exposed....

While developing enterprise ready cloud applications using Cloud Application Application programming model (CAP), you can define / model custom operations specific to business entity or process via functions or actions in addition to CRUD operations. Actions are used for operations, which add or modify data via POST request. Functions are used to only retrieve data via GET....

During the registration process of a user in SAP Customer Data Cloud (CDC), the standard out-of-box feature validates the duplicate user based on the e-mail address or user name supplied by the end user. However, it does not consider any of the Identification fields (E.g. National Id, Passport number, Social security number, Aadhaar number), or....

In this short article, I would like to show how to configure SAP S/4HANA so that you can launch Create Maintenance Request (Fiori app) from within Asset Viewer (WebDynpro app). We use transaction LPD_CUST for configuration; as such, the information in this article pertains to SAP S/4HANA Cloud, private edition as well as the on-premise system of SAP S/4HANA. This article....

Interested to get SAP BTP certified? Here is a video tutorial series from the SAP HANA Academy to help you reach your goal.  Get Certified – SAP Analytics Cloud << this article Get Certified – SAP Integration Suite Get Certified – SAP BTP Extension Developer (Extension Suite) Get Certified – SAP HANA Cloud Development Get Certified....

This is Article 1 in a three-part blog series by Daniel Howard (see bio below) on data management covering the then and now, the anatomy of a data management platform, and making data management work for you. Data management has always been in constant flux. While individual data technologies can, occasionally, become stagnant – or even die out –....

This is Article 2 in a three-part blog series by Daniel Howard (see bio below) on data management covering the then and now, the anatomy of a data management platform, and making data management work for you. Following on from our previous blog on the recent trends within the data management space, this blog will introduce some of the....

This is Article 3 in a three-part blog series by Daniel Howard (see bio below) on data management covering the then and now, the anatomy of a data management platform, and making data management work for you. Previous blogs in this series have discussed the state of data management and described the most important capabilities for a data management....

A few customers with large numbers of employees in compensation worksheets (15k+) have reached out to SAP Professional Services recently to try to find a solution to a persistent issue impacting their review cycle : when first applying their eligibility rules or when running the daily “Mass Update Worksheets” job it takes 10+ hours for....

This topic demonstrates how you can extend the original CDS view with a view extension to provide some additional fields. Problem: Our customer asked us to add some fields that are in the “EBAN” table but not in the Manage Purchase Requisition Professional Fiori application(F2229). Solution: I created this example to show how those who....

有客户提出需求，通过自定义的增强，达到采购订单收货后就不允许更改价格。本文即对该问题展开分析，探索解决方案。 解决方案： 尝试通过自定义逻辑，写一个 BAdI 来满足需求。 分析步骤： 1. 首先，我们需要在 SAP S/4HANA Cloud 系统的应用 – 自定义逻辑里，新建增强实施。根据业务场景，选择下图中的业务上下文以及业务加载项描述，填写好实施描述以及实施标识。 新增增强措施 2. 在自定义逻辑里根据本问题涉及业务上下文完成新建增强实施后，我们需要找到字段获取采购订单的价格。此外，根据问题中的需求，我们还需要获取采购订单的发货状态。 通过在 CDS Views 里的检索，没有能够找到一个字段可以帮助我们直接获取采购订单的发货状态。但是，我们可以通过 I_PURCHASEORDERHISTORYAPI01 这个 CDS View 来间接帮助我们判断一个采购订单是否已经发货。如果一张采购订单有 item 已经发货，该 CDS View 里会对该采购订单的对应的 item 生成一条记录。那么只要我们使用采购订单的单号在该 CDS View 里进行检索，如果返回的记录数不为 0 ，则代表采购订单已经有发货。那么，我们可以写出我们关于采购条件发货状态的判断语句。 select count(*) from I_PurchaseOrderHistoryAPI01 with privileged access where PURCHASEORDER = @PURCHASEORDER-PURCHASEORDER into @data(ls_PO_NUM) . if ls_PO_NUM ne '0'. ... endif. 接下来就是获取价格，以及完成数据的匹配。由于采购订单的价格存储在行项目里，而相关增强针对的业务上下文是采购凭证，因此我们需要使用 loop 语句循环读取 PURCHASEORDERITEM 表，从中获取采购订单行项目的价格，对应字段为 NETAMOUNT 。与销售订单不同的是，并没有一个字段可以表示整个采购订单的净值，我们只能获得每个 item....

SAP HANA has well known Row and Document Stores, allowing us to store relational data in Tables and process that data using HANA’s various engines including graph and spatial SAP HANA actually offers a third store – the JSON Document Store. With the SAP HANA Cloud Document Store (DocStore), we can store JSON Documents in Collections within HANA itself, then process that data using the same SAP HANA engines....

Within SAP HANA Cloud, we have the ability to activate the JSON Document Store (covered here). In this blog post, we’re going to walk through some of the technical details around how we interact with the SAP HANA DocStore   JSON Collections While the Column and Row Stores use Tables to store data, the Document Store uses a JSON Collection Just like Tables, our Collections are created within a given schema. There are no Document Store specific....

In previous blog posts, we showed you how you can access CDS view entities in an ABAP system using SQL via Open Database Connectivity (ODBC). The ODBC interface has the advantage that it allows unrestricted SQL access to all exposed ABAP CDS view entities. Data from different entities can be joined in an ad-hoc fashion....

Demand planning is the procedure of forecasting the demand for a product or service. So, it can be produced and delivered more proficiently and to the satisfaction of clients. Demand planning is considered a necessary step in supply chain and enables a company to project future demand planning and successfully customize the company’s output in....

In diesem Blog befassen wir uns mit dem Thema des Business Builder in der SAP Data Warehouse Cloud. Um Ihnen einen kleinen Überblick über die Vorgehensweise und die verschiedenen Funktionen des Business Builder näher zu bringen, versuche ich Ihnen Schritt für Schritt ein kleines Tutorial bereitzustellen, damit Sie als Nutzer der Data Warehouse Cloud für....

For SAP Business Technology Platform (BTP), the btp command-line interface (CLI) is the alternative to the SAP BTP Cockpit for all users who like to work in a terminal or want to automate operations using scripts. With the btp CLI you can execute both account management operations and service management operations. The btp CLI documentation provides details and there....

Currently we document creating an Always-on (HADR) environment for Custom and Business Suite applications HADR Users Guide and adding a 3rd node DR to a Business Suite Application HADR System with DR Node Users Guide, but in the latter document there is no section on “Adding a DR Node to an Existing Custom HA System”. My intention is....

Dropping the DR node Dropping the DR node can be done in 3 steps from the primary RMA: Drop database replication to DR: 1> sap_disable_replication Toronto, Offsite, tpcc 2> go TASKNAME TYPE VALUE ------------------- ----------------- --------------------------------------------------------------------------------------------------------------------------------------------------------- Disable Replication Start Time Thu Dec 08 21:54:47 UTC 2022 Disable Replication Elapsed Time 00:00:45 DisableReplication Task Name Disable....

Adding a database to the HADR cluster Existing databases can be added to the HADR cluster for replication in one of 2 ways: Using the setuphadr response file to create the devices and database. Using the RMA command ‘sap_update_replication’ and ‘sap_materialize’ commands. The first method has already been demonstrated in Part 1 using the response....

Welcome Back! In my first blog post(click here), we tried to understand the advantages of private registries over public registries. Additionally, we understand how to choose the best container registry based on customers’ needs and compare the leading container registries available in the market. One of the top registries in the current market is Amazon Elastic....

 (Jana Subramanian serves as APJ Principal Cybersecurity Advisor for Cloud Security and a Fellow of Information Privacy (FIP), awarded by the International Association of Privacy Professionals (IAPP). In this role, Jana supports strategic customer engagements on cybersecurity, data privacy, multi-cloud security integration architecture, contractual assurance, audit, and compliance.) Introduction SAP customers host their business critical....

累计总和，移动总计，滚动总计，累计总和……是的，我们有很多种方式来称呼这种计算：计算某个时间段或维度上的一系列数字的总和。 不管叫什么名字，它总是让我们很头疼：当你要进行某种总和计算时，你好像有很多种计算方法，但似乎永远无法满足你的定制需求。这个计算在商业智能软件中非常频繁的出现，以至于我们可以看到“如何在XX中的计算滚动/累计总计？” 因此，我想写一篇关于在 SAP 分析云中计算“累计和”的不同方法的“累计”博客。 如果它帮助您获得想要的“累计金额”，请给它一个赞！ 如果你还是无法得到你的“和”，请在评论中描述你的问题，让我们一起来看看吧！ 如果你有其他计算“累计和”的绝妙方法，请在评论中分享，我会持续更新博客！ 让我们开始吧！   基本上，SAP 分析云中，有两种方法可以将累积计算添加到您的故事中： 在故事Story 中创建实时计算 在建模器Modeler中创建计算，然后在您的故事中使用它 根据您想添加计算的位置和您使用的模型类型，我们下面分类列出您的多种选择： 除非另有说明，否则以下所有操作均在优化的故事体验模式下执行。阅读此博客以了解更多信息。   1.故事层面 1.1 从图表创建累积和 您有一个导入的模型并使用 DATE 类型维度作为时间维度 或者你有一个具有“扩展时间维度”的 Live Hana 模型 你想计算跨时间的累计总和，例如 YOY、YTD、PY等 如果是这种情况，您可以单击该度量并使用“添加时间计算”作为快捷方式来创建与时间相关的累计和并直接在图表上显示。   这相当于使用每个度量（帐户）的“添加计算”功能在生成器面板中手动创建这个与时间相关的累计和。   1.2 从计算或表中创建累积和 添加跨时间累计计算最方便的方法是使用与度量关联的“添加计算”功能。但是，根据您使用的模型类型，存在一些限制。 1.2.1导入模型：添加计算⇒受限账户，与以下项的差 你有一个导入模型 你使用了一个DATE类型的维度作为时间维度来计算跨时间累计和 在这种情况下，只需单击帐户的三个点并使用添加计算来添加 YOY、YTD 和 PY 计算。   今年迄今为止：YTD 上一年：PY YOY：   1.2.2导入模型：Resultlookup函数 你有一个导入模型 您希望首先聚合一个维度的度量（例如，获取三年内每季度售出的数量），然后计算滚动总计。 这种情况下，我们会使用“添加计算”功能中的计算账户来完成一系列的计算来实现它。需要一些手动工作。我们将以这个“每季度销售的 3....

n this blog I would like to draw your attention to a new version of the Floorplan Manager Adaptation Guide, which is valid for SAP_UI 7.57 (delivered with ABAP Platform 2022 as part of SAP S/4HANA 2022). In this guide, you will get an overview of the different possibilities that Floorplan Manager provides for customer adaptations and....

In this post I would like to show you how create a Vue.js app with VS Code and how to deploy it SAP Netweaver. As you probably already know, you can do Fiori development with Visual Studio Code and you can easily deploy it to SAP. So instead of Web IDE you can use VS....

The Service Binding Access library is a utility for easily reading application configurations for bound services in the Cloud Foundry and Kubernetes environment of SAP Business Technology Platform. It combines best practices with extended compatibility and low maintenance for library developers. A service binding is a set of properties that describe how an application shall establish communication with an....

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

SAP introduced the SAP Job Scheduling Service on the SAP Business Technology Platform to provide a service to define and manage jobs that run once or on a reoccurring schedule. The service can call REST API endpoints once or in time intervals, by sending specified HTTP calls.   The functionality of the SAP Job Scheduling....

Kirkpatrick`s Model – An Evaluation Overview for SAP SuccessFactors Learning Do you know the 4th levels of Kirkpatrick`s Evaluation Model? In this post I’ll present what is and how to apply the main concepts in the SAP SuccessFactors Learning. Donald L. Kirkpatrick (March 15, 1924 – May 9, 2014) was Professor Emeritus at the University of....

It is December again, so everyone is busy like in no other season of the year. Whether it is working on a long backlog list in Jira or finally crossing something off from your to-do list that you keep putting off. And as another year is ending, it is also time to look back on....

SAP Business ByDesign (ByD) uses unified data model components and UI components for address information in master data objects and business documents. This blog post describes how to read and write address information using OData services. You find all examples mentioned in this blog post in the GitHub repository SAP Business ByDesign – API Samples including the ByD....

In this blog post, we will learn How to Connect to Cloud Services From CAP Application Locally Though our SAP CAP Official Document is clearly explained hybrid-testing, I would like to illustrate with an use-case  “Connect to Northwind Cloud Service Locally in CAP Node JS Application using Function Import” In General  Service can be from any external remote....

To best follow this post and try things out yourself, you should: Have some basic knowledge of the Python programming language Have a data lake Instance provisioned and configured. For instructions on how to provision an instance one can refer to the following – Configure the SAP HANA data lake File Container. Managing Data Lake Files |....

This blog is co-created with my colleague Charlotte BURNIER, Planning Expert. This blog illustrates the step-by-step details of automating the row addition with calculations for tables in SAC for HXM Data collection and the process of adding new dimension member combinations to users. 1. Requirement: As a HXM customer, you need to Plan for the coming....

In an SAP UI5 application, search helps are widely used and make up for a better user experience in selecting the data. There are multiple ways of adding search help to a field in the SAP UI5 application. The most commonly used way is by creating a search help dialog and binding it through the....

I posted this blog back in 2005 in SDN (earlier to SCN) & it is missing now ! Hence I am reposting the same content as this concept is very useful & used widely in ABAP development world.   Introduction – Test Data Container A Test Data Container (hence its is referred as TDC) is....

Just imagine you have implemented a new ATC check in your ABAP cloud system (SAP BTP ABAP Environment or SAP S/4HANA Public Cloud) and bundled it into your custom ATC check variant. Since this new ATC check variant fully covers your special testing requirements, you would like to reuse this check variant also in your....

If you’ve worked with SPA, iRPA or Outlook SDK in the past, sending an e-mail with SPA or iRPA should be easy! Simply add Outlook SDK to your project, create a new automation, open an Outlook instance and you can send your e-mail directly from your automation. All of this is easy and straightforward… until....

We all know that many business receiving multiple invoices over email,it is very tedious and time-consuming task to process numerous Invoices sometimes leading to human errors as well. so in this blog We are going to see how easily we can Extract the data from invoice samples and store it in Excel sheet using SAP....

2023/02/25, a very good high level introduction about how to give prompt to call OpenAI AI models especially Codex. Prompt Engineering (https://microsoft.github.io/prompt-engineering/) 2023/01/14, two examples added in the comments section. One for generation of XPath selection and another one for Groovy script. 2022/12/28, I encourage everyone who uses this plugin sharing your use case in the....

Here’s the deal: There’s an urgent business issue that you want to bring to the attention of the end users, but none of the available predelivered Situation Handling use cases fulfill your requirements. While we continue increasing the number of standard situation templates with each SAP S/4HANA Cloud release, did you know that you can also create....

SAP Process Automation: Multiple pages Invoice Data Extraction (Document Template (Training a New Model)) and populate extracted data in Excel Sheet   Introduction: – In this Blog Post, we will see how SAP Intelligent RPA can help to simplify Invoice data Extraction in some simple steps and get those Extracted Data in an Excel Sheet. I....

In this post blog, I will show you how to change screen field properties and how to hide screen fields/tabs on purchase requisitions screens.(ME51N, ME52N, ME53N) This blog post specifically will cover showing, hiding fields which can not be customized by using SPRO customizing settings. In additional, it works on S/4HANA Cloud too. In our....

在SAP S/4HANA Cloud中，批次派生始终处于激活状态。通过批次派生，您可以将批次主数据和分类数据从组件批次传输到生产批次。 概览 建立“生产订单下达触发”和“手动触发”批次派生的演示案例 前提 创建激活“批次管理”的产成品和原材料物料。成品物料需要有BOM，工艺路线及生产版本，且BOM中要包含对应的原材料组件。 图1 – 成品物料的物料清单 为原材料组件创建至少一个批次 为原材料批次做收货以确保其有库存 在 SSCUI 103728 中定义派生事件 图2 – SSCUI:103728 步骤 在 管理偏差策略 – 发送方 (DVS2) 应用中设置发送方派生策略。可在SSCUI: 500445 中定义策略类型和组合 图 3 – 配置发送方的派生策略 – 选择键值组合 图 4 – 确定发送方物料 图 5 – 配置要发送的属性 发送的内容可以是标准数据库表中的字段，通常参考标准LOBM* 特征。也可以是发送方物料批次类中的特征。您还需要决定它是否为发送方派生策略中的推式派生。本案例中仅针对拉式派生进行演示，读者可参考官方帮助文档了解拉式和推式派生的定义: https://help.sap.com/docs/SAP_S4HANA_CLOUD/32da8359c8ee4e8b8e8c5e15cacba5aa/adfdb753128eb44ce10000000a174cb4.html?locale=zh-CN&version=2208.500 在 管理偏差策略 – 接收方 (DVR2) 应用中设置接收方派生策略。应在SSCUI: 500446中定义策略类型和组合。 图 6 –....

Lifecycle management in SAP Analytics Cloud is a bit different than in traditional on-premise systems, because SAP is responsible for software, hardware, and infrastructure updates. Read this guide to start planning your deployment. Object Transport Approach Option 1: (legacy) manual ‘Deployment-Export/Import Unlike Content Network: Can be used for transporting between a mixture of SAP and non-SAP data....

You might want more fields from master data available in your sales documents, for example, to display in a sales order app or to print in the sales order confirmation. You can do this with key user extensibility. You can find detailed information about how to use key user extensibility in SAP S/4HANA Cloud Sales....

目次 はじめに 概要 シナリオ説明 ハンズオン プロジェクト用意 プロジェクト生成 SFSF接続設定 データモデル定義 サービスモデル定義 ビジネスロジック拡張 読み込み系処理 書き込み系処理 ローカル実行 CFへのデプロイ 1. はじめに 1.1. 概要 本ブログはCloud Application Programming Model（CAP）を用いてSFSFとHANA Cloudのデータのやり取りをするアプリケーションの開発方法を紹介します。主な紹介の範囲はCAP上のSAP SuccessFactors（SFSF）接続用の設定からビジネスロジックの拡張方法までです。 1.2. シナリオ説明 SAP Business Application Studio（BAS）上でSFSFのPerPersonalのODataサービスを利用したCRUD処理を提供するアプリケーションを開発します。開発したアプリケーションはCloud Foundry環境へとデプロイし、HANA Cloudに接続されます。 2. ハンズオン 2.1. プロジェクト用意 2.1.1. プロジェクト生成 BASのTerminal上でcds init <project-name>を実行し、アプリケーションの雛形を作成します。実際に実行するコマンドは以下のようにaddオプションを使用して--add mta,hanaを付け加えた上でアプリケーション名を入力してください。addオプションを用いることで生成される雛形にいくつかの機能を追加可能です。ここではCloud Foundry環境へのデプロイ時に使用するMulti Target ApplicationのディスクリプタファイルやHANA Cloud用デプロイメントアーティファクトを生成するための設定を機能として加えています。他にはサンプルプログラムを埋め込むためのsamplesなどがあります。これらの機能はすべて手動で記述することも可能ですが、プロジェクト生成時のオプションとして事前に付け加えることで開発作業のうち煩雑ないくつかの要素をスキップすることができます。 $ cds init --add mta,hana cap-sfsf-handson Creating new....

So you are a business process expert and you have spent time building some great skills – but you know not everyone on the team has had the time or the opportunity to get to the same level. You are looking for a way to reduce data entry and filtering mistakes across all apps, by....

本篇博文将向您介绍如何设置多步操作的 HTTP API 步骤来实现SAP分析云与外部应用程序（不仅包括 SAP 的产品，还包括非 SAP 的应用程序）的集成，对于广大SAP分析云的使用者来说，本文将为您在不同APP的数据集成带来详细的指导。 API 步骤的新功能无需修改原始应用程序，集成到 SAP 分析云的多步操作中。API 步骤创建客户出口。您可以将自己的附加功能挂在这些挂钩上。 在我们开始在多步操作中构建 API 步骤之前，您需要创建一个专门用于 API 集成的连接。创建连接： 点击连接>添加连接。 添加连接 在连接到公共 API下，选择HTTP API 连接。 选择 HTTP API 连接   然后您需要设置连接的必填信息。多步操作中的API 步骤是为了集成后端服务，因此HTTP API连接支持基本认证和OAuth2.0的客户端凭证。因此，客户应提供至少支持上述身份验证的公共 API。 简单来说，一个响应为JSON MINE类型的GET方法URL  ，需要基本认证/OAuth2.0的客户端凭证，必须返回HTTP code 200才可以用在这里保存连接。对于本地连接，由于 SCC 限制，需要明确指定端口。 配置 HTTP API 连接 该连接也支持本地环境。如果 HTTP API 留在 SAP 分析云无法访问的网络中，则有必须要在客户的网络中设置 SAP Cloud Connector，因为它扮演着在 SAP 分析云和用户的本地服务之间创建桥梁的角色。如何设置和配置SAP Cloud Connector，请参考博客SAP Cloud Connector的安装和配置。....

In December 2022 SAP held a machine learning competition called “I quit!” attended by 50 participants to showcase the machine learning capabilities of SAP HANA Cloud. The idea is to predict from a database of employees who is the most likely to be quitting his or her job in the short term, based on historical information of....

Purpose of the AFL is to do complex calculations and computations at Database Level rather than at application level to save network traffic and bandwidth along with making the executions much faster, so the Application Function Library (AFL) defines functions that can be called from within SAP HANA SQL Script procedures to perform analytic algorithms.SAP HANA’s SQL Script is an extension....

This blog is a step-by-step guide to get started with Forms service by Adobe API. In the end of the blog, we will test the Form service API by calling them from ABAP environment in BTP. This is also a blog part 1 for my blog series “Create No-Code PDF generation app in SAP Build....

In the previous blog, we went through the steps to get started with Forms service by Adobe REST API. We tested by calling the API from ABAP environment and generated a sample invoice document. In this blog, we will wrap the logic of calling the Forms service API to render PDF into our own HTTP....

In the previous blogs, we got started with Forms service by Adobe REST API and wrapped the contents as your own custom API. In this last blog, we will consume the API in SAP Build Apps as classic AppGyver application. Blog series Part1 –  Get ready for Form Service by Adobe API in BTP Part2 – Wrapping....

This is the 2nd blog related to the new feature referred to as Visual Cloud Functions. In the first blog, I discussed how to create entities. In this blog we’ll discuss the other half, building functions that can called from your app. Note there is really nice documentation for the feature.   Use Case I was trying....

Hello, this is my first SAP Build App blog since last month’s SAP Tech Ed. While at Tech Ed, I met  Daniel Wroblewski at the show floor and our discussion about SAP Build Apps, Process automation and Work Zone started. The concept of Build Bros is because both of us are interested in the topic and we....

Este es mi primer blog de SAP Build App desde que acudi el mes pasado a SAP Tech Ed. Mientras estaba en Tech Ed, conoci a Daniel Wroblewski en el piso de la conferencia y empezamos una charla acerca de SAP Build Apps, Process automation y Work Zone. El concepto de Build Bros (Hermanos constructores) fue debido....

Hi everyone. As we know, with the development of technology, CDS views have started to be used frequently. One of the biggest reasons for their frequent use is that they can get data quickly with the push-down method and can work in harmony with many different technologies of SAP. In this blog, I will create....

Content Packages are collection of content items like cards, workspace templates, workflows and workspaces that are bundled in a ZIP file that can be easily uploaded and installed in sub account. For more details on the Content packages, refer the sap help link – Content Packages Today I will be illustrating the creation of Local Content....