Blog
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 […]
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: […]
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 […]
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 […]
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. […]
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. […]
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 […]
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 […]
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! […]
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 […]
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 […]