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 […]
How-To update CSV number formats in Notepad++
Sometimes it is necessary to convert data from number format, which includes separation to format without them. It means, from the format: x,xxx,xxx.## to the format: xxxxxxx,## (from: 1,250,387.25 to: 1250387,25). This can be done for example in the notepad++ application with the following approach: (!) Regular expression has to be ON 1. Replace “,” […]
How-To plan RSBATCH_WRITE_PROT_TO_APPLLOG
If the following message is shown when running transaction RSA1: Report RSBATCH_WRITE_PROT_TO_APPLLOG not planned. See long text. Message no. RSM2081 Procedure Plan program RSBATCH_WRITE_PROT_TO_APPLLOG as a periodic job using report RSSM_PLAN_PROTWRITE_TO_APPLLOG. For further details, see SAP Notes 2205739 and 769414. Please do: Transaction: SE38 Run program: RSSM_PLAN_PROTWRITE_TO_APPLLOG Click OK in case an warning occurs Click […]
How-To use data from a dynamic SQL in a procedure
If you are using in your procedure a data load from the HANA model you may need to parametrize for example the Placeholders. I’m not aware about any possibility how to do that directly in the procedure but I may also be wrong, so if you know about the way, please leave the comment. Otherwise […]
How-To Create a temporary local table in a procedure
The temporary tables can be created at runtime and can be used for the same operations as the normal tables. But, based on the table types, the scope is limited. Temporary Tables lets you store and process intermediate results. Temporary tables only last as long as the session is alive. Data in temporary tables is […]
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) […]