SAP® HANA Analysis Tool (HAT) – Hierarchy
SAP® HANA Analysis Tool Hierarchy is a special form of hierarchy implementation that uses mathematical sets to provide results fast and with fewer queries, comparing to standard hierarchy recursive implementation. There is no recursive calling necessary when searching in the hierarchy table. However, there is a need for recalculation when adding values. It is the […]
SAP® HANA Information Model XML Definition
Every active SAP® HANA Information Model (Attribute views, Analytic views, Calculation views) is saved in the standard table: _SYS_REPO.ACTIVE_OBJECT, in the form of XML code. The columns of the table are the following: The XML presentation of the information model is saved in the column: CDATA, and the main structure of the XML code, depending […]
How-To SAP® HANA Procedures
Find Procedure To find procedure, standard HANA table: “SYS”.”PROCEDURES”, can be used. For example: Searching for Procedure, which contains specific code, the definition column can be used: select * from “SYS”.”PROCEDURES” where definition like ‘%???%’; Templates When creating SAP® HANA Procedures, I’m using SQL code and the following templates: Standard Procedure DROP procedure <procedure_name>; […]
SAP® HANA Authorization
Please consider, everything written below are mainly my personal experiences and opinions and I may be wrong or inaccurate. Please leave a comment if you find a mistake. Thank you! SAP® HANA Authorization (HANA 1.x) SAP® HANA Authorization, applied to the user, is covered by the following areas: Granted Roles System Privileges Object Privileges Analytic […]
How-To get metadata of HANA tables
Relevant useful links Selection example with CDATA search API to get the Metadata of the HANA view Columns for a specific table or model SELECT SCHEMA_NAME, TABLE_NAME, COLUMN_NAME, POSITION FROM SYS.COLUMNS where SCHEMA_NAME = ‘_SYS_BIC’ and TABLE_NAME = ‘???’ order by position; An alternative in case of authorization problems: SELECT SCHEMA_NAME, VIEW_NAME, POSITION, COLUMN_NAME, […]
Useful Resources
HANA Studio Data Distribution Optimizer Administration GuidePartitioning; Table Performance SAP HANA Platform documentationMain documentation Table redistribution and repartitioning in a BW on HANA system 1969700 – SQL Statement Collection for SAP HANA 2081591 – FAQ: SAP HANA Table Distribution 2044468 – FAQ: SAP HANA Partitioning Decimal settings in HCPR on HANA (currency issue for JOD) […]
Useful SAP® NetWeaver Transactions
During years of work in the SAP world, I have noted down “couple” of useful SAP® NetWeaver Transactions from different SAP modules, which I regularly need. Please see the list in the following table:
Useful ABAP
During years of work in the SAP world, I have noted down “couple” of useful Function Modules, Programs, Classes and others from different SAP modules, which I regularly need. Please see the list in the following table:
SAP® Crossroads – Blog Navigation
I have prepared this SAP posts navigation page to make navigation easier. General documentation Useful ABAP Useful SAP® NetWeaver Tables Useful SAP® NetWeaver Transactions Useful Resources Navigation based on module ABAP Business Objects/WebI BW HANA (DB & Studio) CRM ECC Solutions During my work with the SAP software, I have developed some useful […]
Useful SAP® NetWeaver Tables
During years of work in the SAP world, I have noted down “couple” of useful tables from different SAP® NetWeaver modules, which I regularly use. Please see the list in the following tables: