Develop an SAP RAP based App to upload excel (CSV) file just like you used to develop SE38 classical report. We often get this requirement of developing a utility to create/update mass data for a BO such as Purchase Orders, Materials, Sales Orders etc. In S/4 HANA, the customer prefers to use SAP Fiori applications, rather than using the old classical reports. But can we develop a Fiori application to upload a file without involving using SAP UI5? Yes, we can. Using the following annotations, we can attach any file to our BO in SAP RAP – @Semantics.largeObject The only constraint is that w ..read more

Business rules are one of the important feature in Master Data Governance Process. Deriving the value for particular field of an entity can be done either by BRF Plus or BADI. This Blog Post explains you about creating complex or dynamic derivation rules which can be achieved through BADI. In this post, I am taking the example of deriving Cost Centre value from Cost Centre Entity of Finance Data Model. Its a kind of Mandatory and derivation rule and the naming convention should be followed. RULE: First two characters are defined using the backend table which is the custom table provided by ..read more

We were recently performing regular maintenance, including an OS patching of the SAP BO development server for one of the SoftwareONE customers. During the patching, some issues were encountered leading to a failure. It was decided to restore the operationability of the application by reverting to the previously backed-up state of the VM back to the patching event, and the Basis team was tasked to bring the application up and do the sanity tests. The application was able to start but the login to the CMC was denied. Environment: OS: SLES 15 SP 3 Application: BI 4.2 SP8 P6 Issue ..read more

Objective: - Implementing SAP OData URI to SAP Build and Creating Customers in SAP BUILD which can replicate to SAP System Business Scenario: - How to create Customers using SAP Build Apps and OData Service. Prerequisites: - -> You Have an SAP BTP account or trial account. -> Inside the BTP account, go to Instances and Subscriptions and create an instance of SAP Build Apps -> Now go to Security -> Users Tab and assign Role to the user for SAP BUILD Apps Now, we have to create the SAP Backend connection to SAP BTP : - Before mapping data from S4H or our SAP System to Build ..read more

While automating SAP Fiori applications, one might come across some dynamic UI5 elements such as mentioned in the snapshot below. In most cases, recorder may not be able to uniquely identify the elements, thus terminating the automation where it may not find the suitable elements. In such cases, SAP provides an extremely useful functionality to declare the elements manually using Design Console’s screen and tree feature. Let us look at the steps required to fulfill the requirement. 1. Switch to ‘Both’ view. 2. In the Screen panel, click the target element. 3. Find the element in the ‘Tr ..read more

Introduction In this blog you will learn about the creation of Query CDS Views for Analytical purpose and their consumption in RSRT tool, along with the required steps that needs to be followed to achieve it. Once after the Analytical query creation, I have tried replicating one of my project scenarios to have better understanding on defining key figures/ measures in CDS views. In the end blog explains about the process needs to be followed to expose the given Query CDS view into OData service links. The Query CDS Views are created specifically for Analytical reporting purposes within SAP sys ..read more

Introduction This blog talks about how to collect selections or filter details used in a DTP by using some standard tables in both BW on Hana & BW4HANA systems. Especially In migration projects (SAP BW on Hana to BW4HANA), it’s very hard to collect hardcoded values or ABAP routines or OLAP variable details used in DTPs manually for ‘n’ number of DTPs. So, to overcome from this issue, below steps will help us to collect DTP filter details by using the tables RSBKREQUEST, RSSELDTP, RSBKSELECT. 1. DTP filters in BW on Hana As we know, in a DTP filter we can maintain hardcoded values, ABAP ..read more

Automating Database Dumps in SAP ASE This blog post guides you through automating database and transaction log backups for your SAP system using DBACockpit in SAP Sybase ASE version 15.7.0.021 or higher. We'll focus on using the local file system for intermediate storage. Prerequisites: 1. Administrative access to the SAP ASE server. Understanding of SAP ASE utilities like dump database and dump transaction. Steps: Create a Storage Location: ◉ Designate a dedicated file system to store the dump files. ◉ Consider factors like available disk space and redundancy. Configure Dump ..read more

Prerequisites: ◉ On BTP: Cloud Connector Connection to Gateway system and Destination  ◉ OnPremise: Activating required standard Fiori Application Step 1: Open Template Wizard and select the application type as SAP UI5 Adoptation Project. Step 2: Select the Target Environment as ABAP  as we intend to deploy the application to onPremise Step 3: Enter Project Name and Namespace details as shown below Step 4: Select the Gateway system and the standard Fiori application. select yes for creating extension project as we intend to extend the standard application. Please note that ..read more

Introduction: SAP BW bridge is a functional enhancement of SAP Datasphere and enables ABAP-based data extraction and staging capabilities within SAP Datasphere. It provides customers who are running SAP Business Warehouse or SAP BW/4HANA with access to the public cloud as it offers SAP BW capabilities directly in SAP Datasphere. SAP BW Bridge for SAP Datasphere is a feature that makes certain elements from the on-premise SAP BW system available in the cloud. In order to transfer these elements to SAP Datasphere, SAP also supplies the appropriate conversion tools. SAP BW Bridge is a cost-effe ..read more