SAP SUM Introduction Upgrading an SAP system is a complex undertaking that requires careful planning and execution. SAP’s Software Update Manager (SUM) tool simplifies this process, providing a structured approach to system upgrades, EHP updates, S/4HANA conversions, and more. In this blog post, we’ll delve into the key phases and…
Read MoreSAP HANA SQL Commands for Auditing/SOX
By using SAP HANA SQL Commands, we can perform following job Finding index and primary keys of tables SELECT IFNULL(CONSTRAINT,’NUNIQUE’), INDEX_NAME,COLUMN_NAME FROM INDEX_COLUMNS WHERE SCHEMA_NAME = ‘%s’ AND TABLE_NAME = ‘%s’ ORDER BY INDEX_OID,POSITION Show details of users that have been logged-in select * from “SYS”.”USERS” where “LAST_SUCCESSFUL_CONNECT” is not…
Read MoreUnderstanding HANA Licensing Model for Multiple Tenants
The HANA Licensing Landscape for Multi-Tenant Environments A common query among HANA administrators is how system-wide and tenant-specific licenses interact in multi-tenant setups. Let’s delve into the intricacies of HANA licensing to clarify these aspects. Read also – Reclaim HANA Log to avoid log full situation. Scenario: A 750 GB…
Read MoreGenerate a System Information XML File for SAP JAVA stack
How to Generate a System Information XML File (Stack XML) from SAP JAVA stack SUM: Generating a System Information XML File (stack XML)from JAVA Stack for use with SAP Maintenance Planner See also – JAVA system Performance Issue Proceed as follows: 1. Download and unpack a new SUM 1.0/2.0 instance…
Read MoreConfigure SAML Integration in Okta with Cloud Identity
1. Prerequisites: – You need an active license for Identity Authentication. – Ensure that you have the necessary authorizations (e.g., “Manage Applications” and “Manage Corporate Identity Providers”) assigned to your Identity Authentication account. – Access the Okta Admin portal. 2. Create a SAML 2.0 Application in Okta: – Log in…
Read MoreSAP Cloud ALM vs Solution Manager: 5 Critical Functions for SAP IT Team
SAP Cloud ALM vs Solution Manager: 5 Critical Functions SAP IT Teams Will Miss | SAP Transition Guide SAP Cloud ALM vs Solution Manager: 5 Critical Functions SAP IT Teams Will Miss As SAP teams prepare for their S/4 HANA transition, they’re facing another challenge: migrating from Solution Manager to…
Read MoreOracle BRTOOLS SSFS Configuration
If you are still managing an SAP system with an Oracle database. If so, understanding how to configure BRTOOLS SSFS (Secure Storage in File System) is crucial. SSFS provides a secure way to store sensitive data such as database passwords. Let’s dive into the key steps: Avoid using OPS$ mechanism, locking/deleting OPS$…
Read MoreOracle Database 19c | Enable Automatic Indexing
What is Automatic Indexing? Automatic Indexing is a feature introduced in Oracle 19c that automates index management. It analyzes workloads, recommends creating or dropping indexes, and can even implement those recommendations. This can improve query performance without requiring a DBA to manually manage indexes. Pros of Enabling Automatic Indexing: Improved…
Read MoreSAP | Cleaning Up the Transport Directory: Best Practices
Introduction of SAP Transport Over time, the global transport directory in SAP systems can accumulate a large number of files. These files reside in subdirectories such as ‘cofiles’, ‘data’, and ‘log’. While these files contain important information, they can also consume valuable disk space and become obsolete. In this article,…
Read More