In this blog, I wish to give high-level technical details on the new features available with SUM2.0 SP17. Homogeneous DMO DMOVE2S4 For those looking for quick details, below is a simple explanation in my own words in this regard. DMOVE2S4:(Available since SUM2.0SP17) DMOVE2S4 is a way to move/convert SAP on anyDB to S/4HANA system or....
Although, having passwords to secure PSEs is a good idea, it is good to know how we can remove the passwords instead from accessing the PSEs. Note: If you are using passwords to secure your PSEs, please do not forget those passwords. When you open STRUST and try to access a PSE which is password....
Owing to various business scenarios, we might come across requirements where background jobs must be scheduled. Now, the most common way to schedule batch job is through the TCode SM36. Especially, in case of Interfaces through which SAP receives huge volumes of data from Third Party and must process them in one batch run, nightly in most....
While deleting Inbound Queues without resolving the errors are a risk, there might be cases where queues need to be cleared on regular intervals. Best practice is to check the Stuck Queues and then act accordingly. We can delete Queues and specific LUWs from SMQ2 TCode manually. However, when the count goes up to 1000s....
In his very useful blog in 2016, SAP Expert Cristiano Hansen writes about how to create a CSR and import a public certificate response. Unfortunately, as hackers become more intrusive, SAP has been forced to respond. As business demands move towards tighter security as well as enterprise-wide Robotics Process Automation (RPA), having trusted certificates becomes a....
Setting up connectivity between SAP S/4HANA Application and SAP PO application is a complex task with multiple steps to consider. As a BASIS or PO consultant it is important to understand how we can configure a S/4HANA server to interact with SAP PO/PI. This blog will provide information on how you can configure a S/4HANA....
When end users use saplogon in the sapgui screen to log into the system for the first time, the system notifies them that the validity of a certificate from the list with the PSE type >SSL client (standard) expires in 29 days. End users are angry and alarmed when they initially log in to the....
I was occasionally asked to download the EWA report generated in the Solution Manager for some managed systems. The browser displays “Site Not secured…” whenever I enter the transaction code “SM_WORKCENTER.” This article described the step-by-step procedure to resolve the issue “Site not secured “. Investigation: As indicated above, type the Tcode SM_WORKCENTER or if....
I recently investigated an issue in our PO system and learnt few useful things. I thought it will be useful for others to share it here: Issue In our PO system, every morning, we will open NetWeaver Administrator and go to “Message Monitor”. There we could see messages in Error and Successful status. When clicking....
SAP Business Technology Platform (BTP) is a comprehensive cloud-based platform that offers a wide range of tools and services for enterprise application creation, deployment and management. One of these effective tools is Cloud Application Programming (CAP) Model. CAP is a set of frameworks, tools and libraries deployed on top of Business Application Studio tenant to....
The purpose of this article is to describe the procedure to enlarge the MAXDB database size running on any SAP application. There was an alert that the database size used was getting full. The procedure for enlarging MAXDB datafiles is described below. Login using SAPGUI in any productive client. To identify and confirm the....
Just 5 Steps for SAP Analytics Cloud <-> S/4HANA Integration 1. Enable /sap/bw/ina/service/v2 in your S/4HANA backend 2. Set Parameter : icf/cors_enabled=1 3. Whitelist the SAP Analytics Cloud tenant url via /nUCONCOCKPIT 4. Configure to allow pop-up for your SAP Analytics Cloud tenant url 5. Create connection to your S/4HANA Backend system in your SAC....
In the continuation of my previous article, White Paper SAP Sizing Solution Based on Users and Workloads – Part 1 | SAP Blogs White Paper SAP Sizing Solution Based on Users and Workloads – Part 2 | SAP Blogs This article describes SAPS calculation for the number of named users and based on SAP workloads. SAP....
In the continuation of my previous article, White Paper SAP Sizing Solution Based on Users and Workloads – Part 1 | SAP Blogs I wanted to describe the concept of SAPS Sizing Methodology, Classification of SAP users and Normalized SD user. This will enable for any beginner to understand and wishing to prepare the Sizing Report....
In this blog, we will provide steps to configure Highly available SAP Content Server 7.53 with MaxDB database version 7.9 on SUSE Linux in Microsoft Azure Cloud using Azure NetApp Files (ANF) as storage platform for database. It uses SUSE High Availability Extension tool set (Pacemaker) for the cluster solution. Though we are using SUSE....
The purpose of this blog is to help customers to understand the concept of sizing based on SAP Workloads. The sizing procedure helps customers to determine the correct resources required by an application within the customer’s business context. I wanted to share to make it easier for any beginner wishing to prepare the Sizing Report.....
After activating the sslenforce parameter in the hanadatabase, our attempts to connect to the hana database via hana studio were unsuccessful due to an “only secured connections are allowed” error. Here is one of the methods we employed to establish a secure connection with the hana database. This change was implemented based on the....
There is huge knowledge available about SAP HANA High Availability and Disaster Recovery topic, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). The aim of this article is simplify and make content consumption easier with a centralized page. There is no reason to duplicate the already well prepared content,....
In today’s data-driven world, collecting and analyzing data has become crucial for businesses to make informed decisions. Prometheus is a popular open-source monitoring and alerting toolkit that is widely used to monitor infrastructure and applications. It provides a powerful query language and visualization tools that enable users to collect, store, and analyze metrics. One of....
We show how to set up SAP SNC Encryption (both Encryption-Only and SSO), on the two main kinds of Apple MacBook OS architecture, using X.509 certificates handled either by the PSE-Method (using SAP PSEs “Personal Security Environments”) or by the SLC-Method (using a downloadable helper-app called SAP Secure Login Client 3.0 “SLC 3.0”). We begin by showing how to set up....
SAP has released quite a big list of APIs for SAP Cloud Connector . I recently noticed this wonderful blog written by Philipp Stehle describing the CLIs created by Philipp and was inspired to test out the APIs I am a Basis Consultant who has recently started learning node js . So, I started working on this idea to test out....
SAP HANA is an in-memory database architecture. This architecture is the heart of the concept. Huge knowledge available about SAP HANA memory topic, but the knowledge is fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make content consumption easier I have created a centralized page, a single source....
In this blog, I’ll delve into how you can troubleshoot errors in SAP IAS related to SSO and S/4 HANA private cloud. As you may know, SAP IAS is a highly competitive product when it comes to integrating SAP SaaS and PaaS solutions with S/4 HANA. Its main focus is on integration, security, compliance, simplicity,....
The purpose of this document is to cover the detailed procedure around setting up and executing the migration of large sized database with considerably higher number of application servers using SAP Distribution Monitor. The Source system run on an Oracle 10.2.0.4 but the Target RHEL based SAP systems will run on Oracle 11.2. The Oracle....
A technical database user was locked many times. Therefore, an application, such as a third-party BI reporting tool, cannot connect to the SAP Hana Database. Checked the traces and HANA studio to investigate the root cause. In the Hana studio as shown below Investigation and Finding: Executed SQL statement. ALTER USER ZUSER ACTIVATE....
In my last post, I concluded that the topic of (performance) Anomaly Detection is now solved and I will switch over to (performance) Anomaly Prediction. For the prediction, I distinguish three time windows: The past time, which will be in the input for the model, to decide whether performance problems are imminent. The immediate future, which will be....
There is huge knowledge available about SAP HANA reclaim / shrink / defragmentation topic, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make content consumption easier I have created a centralized page, a single source of the available information regarding SAP HANA persistence.....
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....
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....
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....
The Purpose of Creating a Multi-clients S/4HANA System During large scale S/4HANA implementation projects for On-premise or Private Cloud versions, it is by far the common practice to establish multiple ‘working’ clients in each SAP systems of the 3 tiers (Dev, QA, Prod) or 4 tiers (Dev, QA, Preprod, Prod) landscape. This is to cover....
System copy configuration of SAP Business Warehouse (SAP BW and BW/4HANA) system landscape is highly complex due to the many connections between the involved application systems. Typically such a system landscape contains SAP BW (incl. BW/4HANA) systems, BI Java systems and SAP BW source systems such as SAP ERP, SAP CRM and SAP SCM etc.. ....
ADS(Adobe document service)renders the PDF documents using the form templates designed with Adobe LiveCycle Designer and the business data provided by the applications. More info please refer help.sap.com for product documentation In this scenario we have SAP Netweaver 7.5 XYZ ABAP system connected to ABC AS JAVA system.In ABC AS JAVA system ADS is....
Installation of JAVA system on SUSE Linux 12.0 with ASE DB Step 1-OS preparation(Read the master guide for toolset option and service market place and prepare the OS)Make sure that you are using Suse for SAP,OS which is specifically built for SAP Create the users sidadm,sybsid,daaadm,sapadm(standard users are created)Rest login users can also be created....
Recently I came across a very weird situation where after installation of SAP Web Dispatcher and setting up of SSL I found that I wasn’t able to login to Admin page, the credentials of webadm user weren’t working. There were lots of messages in /usr/sap/SID/W00/work/dev_webdisp as below: [Thr 139921060026112] Sun Oct 23 09:55:29:304 2022....
I have been working quite a lot on cloud applications integration with SAP S/4 HANA systems off late and thought it would be useful to put a few basics together for any new starters. What is SAP BTP? In simple terms, SAP BTP hosts numerous cloud applications and provides integration capabilities across SAP & third-party....
HANA SPS upgrade from HANA 2.0 Rev 37 to HANA 2.0 Rev 59 on the DR server when primary and secondary server setup as replication are present There are many environments and larger landscapes where we have cluster environment.But in this environment we have Primary DB replicated with the secondary DB where the primary system....
In my last part I described how I started collecting data from FRUN. Now the next question is: Which metrics will I use for evaluating the performance of a SAP system? I don’t have very much time to check the FRUN metrics out individually, and the productive FRUN system is already under heavy load, so I....
Purpose of the blog To get rid of the failed entries and shrink the overall memory footprint size of ARFCS* and TRFCQ* tables if there are huge amount of failed entries in SM58. If the Log file / Reorganize method of cleaning the SM58 is still not helping to remove unwanted / failed entries then....
Configuring HA for a resource (Resource can be IP, DB, Webserver, etc.,) In reference to Open SAP course (Say Goodbye to Downtime with SUSE Linux Enterprise Server ), following lab environment was setup and could be useful for someone who wish to create everything from scratch. Good overview of managing ANY – 1 resource (Be it,....
Configure SAP-SIC (SAP Integration Component) for Vertex As a SAP BASIS Consultant, sometimes we need to Manage and Maintain a Software called Vertex. There is multiple aspect of this software and one of that is Administration of Vertex Application. So I thought to share my knowledge while working as an SAP BASIS Administrator. We have....
Now that I have made the decision to predict bad SAP performance, I need to specify better what I mean by “bad SAP performance”. End users frequently complain about specific transactions or even whole systems being unresponsive. Often it gets difficult to pinpoint the root cause. In my project here, I want to focus on....
This blog demonstrates a simple use of SAP Client for Python with SAP HANA HDI SQL APIs (stored procedures) in an on-premise SAP HANA Database. TL;DR: A simple example of a Python wrapper on top of the SAP HANA Client for Python (https://pypi.org/project/hdbcli/) is provided in the Git repository https://github.com/nklinked/hana-task-runner with one predefined example for containers deletion.....
After I was clearer on my goal – predicting a general performance issue (i.e. an incident which is so severe that it will get noticed by almost all users) – I can now begin to get more technical. The most fundamental decision is about the data source. Where do I get reliable data about my SAP systems?....
As a Functional Consultant, one may wonder what a Role is and how different it is from the Authorization Object and Profile. While it is mostly the job of the Security team to assign the required Role for a user, it is also the Functional Consultant’s responsibility to provide inputs about the required Transactions, restrictions....
Vertex Tax Solution – Installation: – As a SAP BASIS Consultant, sometimes we need to Manage and Maintain a Software called Vertex. There is multiple aspect of this software and one of that is Administration of Vertex Application. So I thought to share my knowledge while working as an SAP BASIS Administrator. In this blog,....
Welcome to my third and final blog of SAP S/4 Hana Conversion series. In this blog we will take a deep dive into Realize phase of SAP S/4 Hana Conversion. This blog is the continuation of my previous blogs SAP S/4 Hana Conversion – I and SAP S/4 Hana Conversion – II – Prepare ;Please read previous blog....
To start with there is always a lot of confusion on S/4HANA Conversion projects. Too many tasks, too many teams, and too many responsibilities. Also moving away from our beloved Business Suite sparks fear in us. Lets explain why we should move away from ECC 6.0 : SAP Maintenance Strategy: SAP provides mainstream maintenance for....
After more than 2 years pause, I finally decided to start another blog, or let’s better say a whole series. I was always wondered why Machine Learning isn’t much (or at all?) used in the SAP basis realm. Who had since always lots of structured data available? SAP basis people Who handled big data when Big Data wasn’t....
This blog demonstrates an approach of collecting information about applications, service instances and other entities from SAP HANA Extended Application Services, Advanced Model (XSA) using XS Controller APIs. TL;DR: The blog provided an overview of a command-line tool that utilizes XS Controller APIs to simplify some of maintenance operations. The tool is based on a....
Wireshark is a popular and free open-source toolset for analysing network traffic: https://wireshark.org Wireshark can also be used to analyse SAP-specific network traffic – such as for example SAPGUI traffic and RFC traffic – using a most excellent Wireshark plugin for SAP Dissectors, the code for which is provided by SecureAuth on GitHub: https://github.com/SecureAuthCorp/SAP-Dissection-plug-in-for-Wireshark We....
In this blog I will discuss one issue which I face after S/4 HANA conversion in SWIA (WI Administration Report). In SWIA when assigning workitem to another user agent. System was giving following error. “Exception condition “PACKAGE_DOES_NOT_EXIST” triggered”. Although the error was clear as it shows that package does not exist. But the error was coming....
As a Basis Administrator, many of the times we get requests from the developers to deploy EAR (Enterprise Archive) files in the SAP system. These files can be deployed via many available tools provided by SAP and one of them is deploy via the telnet administrator tool. Just for the reference to consultant,....
Introduction: If you are looking to Upskill yourself with SAP Learning Trainings and wanna get free SAP Badges – Record of Achievement , this blog can help you. Thank me later ! No learning hub access needed and you need not to pay anything. I recently acquired 2 SAP Badges after completion of learning. Badges:....
In this blog I wish to bring out the difference involved with implementing RISE with SAP S/4HANA,private edition against RISE with SAP S/4HANA cloud(essential edition) This blog is intended for those who have basic understanding of RISE and wish to understand a detailed difference between the public and private edition while using SAP Activate methodology.....
In this blog I wish to share my personnel experience in preparing for the beta exam ‘SAP on AWS – Specialty (PAS-C01)” . NOTE: This does not cover any new additions or modifications that AWS might bring in with the Standard version starting from 7th April 2022 As this is a brand new exam till today ,....
In this short blog, I wish to share my personnel learning experience for RISE with one of the best learning courses provided by SAP for its partners to jump start with RISE with SAP for a Partner Cloud Solution architect (PCA) . NOTE:Learning Hub access is mandatory for the same and you must be a....
Introduction The Business Application Log (BAL) is a tool widely used by many applications. It offers nice functionality for enhancements and adaptation. For the PMMO application we made extensive use of these capabilities. Transaction SLG1 This is the standard transaction for displaying application logs. Initial Screen of Transaction SLG1 For the PMMO application, the following....
Hello Experts, We have a standard report in SAP to test the communication with any URL. The same is explained below Test Method: 1. Run the report RSHTML01 in SE38 tcode from ISQ. 2. Enter the below link, Proxy and port as shown below: https://utility.xxxx.com We are getting the below Error. 3. We traced the log with....
Hello, *** Default Header *** With the intention to show why SAPUI5 developers (as most of them came from the ABAP world) need to upskill with “safe programming” knowledge and skills, i’ve decided to create the #SafeSAPUI5. What is #SafeSAPUI5? A series of episodes with examples (of course with responsible disclosure, not showing names, servers, etc.) of security breaches....
In this blog post you will get a clear, step-by-step process of how to install and run the ABAP Sizing Report (described in SAP Note 1872170), with screenshots accompanying each step. When dealing with sizing requests from the presales field, I typically ran into the problem of not having clear instructions to follow for running....
16 Likes 1,940 View 3 Comments The SAP Web Dispatcher is a reverse proxy designed to work best with other SAP software solutions. While there exist many reverse proxy solutions from various software vendors out there, the SAP Web Dispatcher is maintained and supported by SAP, is available for multiple operating systems, follows the same configuration principles....
Intro This blog post continues a series of publications about the Installation of different SAP Systems in Hyperscalers In previous parts: SAP HANA EXPRESS EDITION in Yandex Cloud. Binary Installation. Step-by-step guide https://blogs.sap.com/2019/11/29/sap-hana-express-edition-in-yandex-cloud.-binary-installation.-step-by-step-guide/ SAP NetWeaver AS ABAP Developer Edition 7.52 SP04 in Yandex Cloud. Binary Installation. Step-by-step guide https://blogs.sap.com/2019/12/15/sap-netweaver-as-abap-developer-edition-7.52-sp04-in-yandex-cloud.-binary-installation.-step-by-step-guide/ Installation of SAP HANA Database with Extended Application Service....
What is Utopia? Utopia is a peer to peer (p2p) closed decentralised ecosystem with a p2p network that is designed to help protect the privacy of personal data and freedom of communication without censorship. This species of an ecosystem is different from others—being a private one, which is free from any type of censorship. Through....
Introduction: This blog describes the SAP MaxDB Content Server Migration Method which reduces downtime for large database during migration using online backup and restore method. This blog can be used as reference for performing SAP Content Server MaxDB Migration of large databases between different release of Windows Server. Purpose: Blog provides step by step procedure....
Dear All Readers, This blog is about what is HANA DB Backup Catalog and how we can check the size of Backup Catalog and how we can automate the old backup catalog cleanup using backup retention policy in HANA cockpit. We have below phases as part of this blog to cover Backup catalog cleanup using....