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 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 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: