SAP HANA Tutorials, Tcodes, Tables

SAP HANA (High-Performance Analytic Appliance) is another initiative from SAP for high performance real-time database data processing. In SAP HANA data resides in RAM than the traditional physical disk storage. So the time taken to process data and all are extremely low. This technology is known as in-memory computing ( data reside in memory for computing ).

[Update : due to the request from SAP SE, I need to remove the PDF training contents from this page. You can download that from their official website. Sorry for the inconvenience.  ]

SAP HANA Tcodes

Here is a list of possible transaction codes dealing with HANA in SAP.

• SQLDBC Trace for HANA – HDB_SQLDBC
• EPM: Data Generator for HANA/OIA – SEPM_DG_OIA
• Activation of HANA set hierarchies – SETHANA_ACTIVATOR
• Change HANA Access Mode – KEHM
• HANA Accelerator for Material Ledger – FCMLACC

SAP HANA Tables

Here is a list of possible system tables storing HANA related data in SAP.

• HANA CO-PA Integration: CE1 Error with HANA Replication – TKEHDB_CE1_ERR
• HANA CO-PA Integration: CE4 Error with HANA Replication – TKEHDB_CE4_ERR
• HANA CO-PA Integration: CE2 Error with HANA Replication – TKEHDB_CE2_ERR
• SAP HANA Scripts – GRFNSCRHAN
• Integration of HANA and CO-PA – TKEHDBLCR
• HANA Protocol – TKEHA_LOG
• HANA Analysis Processes – RSDHAMAP
• HANA Model Descriptions – TKEHA_MODELT
• HANA Information Models – TKEHA_MODEL
• HANA Analytic View – TKEHA_ANA_VIEW
• Status of set hierarchies in HANA – SETHANA_STATUS
• SAP HANA Script Texts – GRFNSCRHANT
• Status of set hierarchies in HANA – SETHANA_HIER
• HANA Analytic View Characteristics – TKEHA_CHAR
• SAP HANA Scripts Category Assignment – GRFNSCRHANCAT
• Settings for SAP HANA Views for BW InfoProvider – RS2HANA_VIEW_SET
• BW-IP: Activation of Deep HANA Integration – RSPLS_HDB_ACT
• COPA HANA: Use of Read Access – TKEHDB_RANGES
• Hierarchy classes with HANA acceleleration – SETHANACLASSES
• Executions of HANA Analysis Processes – RSDHARUN

Table Fields with HANA data

Here is a list of possible table fields which are may be used for storing HANA related data in SAP.

• DELIVERY_UNIT_VENDOR – HANA Integration: Name of a HANA Delivery Unit Vendor
• DELIVERY_UNIT_NAME – HANA Integration: Name of a HANA Delivery Unit
• CONTENT_VENDOR – HANA Integration: Name of a HANA Delivery Unit Vendor
• EXAMPLE_ID – SAP HANA Live Report Example ID
• EXAMPLE_DESCR – SAP HANA Live Report Description
• HANA_SERVER_PACKAGE – Package Path on SAP HANA Server
• USER_HDB – username in HANA-DB
• NUMBER_OF_XS_SCHEDULES – Number of Schedules on SAP HANA XS
• FILE_KEY – File key (EPM File Loader HANA)
• FILE_NAME – File Name (EPM File Loader HANA)
• MIME_TYPE – Mime Type (EPM File Loader HANA)
• CONTENT_URL – Content URL (EPM File Loader HANA)
• URL – URL (EPM File Loader HANA)
• DBSCHEMA – BRFplus: Schema Name for the HANA Database
• DBPROCEDURE – BRFplus: Name of HANA Column Object
• PARAMETER_DB – BRFplus: Name of HANA Column Object
• HANA_OBJECT_NAME – BRFplus: HANA Database ID
• SOURCE_PACKAGE – BRFplus: Package Name for the HANA Database
• SOURCE_SCHEMA – BRFplus: Schema Name for the HANA Database
• SOURCE_NAME – BRFplus: Name of HANA Column Object

Function Modules for HANA in SAP

Here is a list of possible function modules which may be used with HANA related processes in SAP.

• /SDF/GET_HANA_DBSL – Get DBSL and Client Version of a HANA Database
• /SDF/GET_HANA_TABLE – GET HANA Database Tables
• AA_HDB_GET_HANA_SETTINGS – Deliver HANA settings of asset accounting
• CS_BOM_EXPL_MAT_V2_HANA – HANA MBOM explosion function module
• FIN_H_VIEWS_DELETE_SYSBIC_F30 – Delete HANA objects from schema _sys_bic for F.30
• FMCY_GEN_COMB_STRUCTURE_HANA – Generate the combination structure based on HANA DB
• G_SET_FIND_HIERARCHY_VIEW – find hierarcy view and table name for HANA access
• HDB_CREATE_DBACOCKPIT_USER – Create/Modify the DB-User of DBACOCKPIT for HANA
• IUUC_REPL_GET_DD02L_ENTRIES – Read DD02L entries from HANA replication schema
• IUUC_REPL_GET_HANA_STATUS – Remotely get the replication status of a table in HANA
• RSDD_HM_PUBLISH – Publish SAP HANA Model
• RSDG_IPRO_HANA_FIELD_MAP_MAINT – Mapping of IPROV-fields into HANA-Viewfields
• RSDU_CHECK_CALCVIEW_HDB – Check whether HANA-optimized Changelog exists
• RSDU_RECREATE_CHGLG_HDB – Recreate HANA-optimized Changelog
• RSDU_TABLE_INDEX_CHECKER_HDB – Verifies tables and indexes on HANA DB
• RSH_GUI_OH_HANA_DSO_CREATE – Anlegen eines HANA DSO via Open Hub
• SETHANA_HIER_SHLP_EXIT – Search help exit for HANA set hierarchies
• SHDB_GEN_CREATE_TABLE – Generates CREATE TABLE command for HANA DB
• SHDB_GET_TABLE_CLASSIFICATION – HANA table classification
• SNHI_DELIVERY_UNIT_EXPORT – HANA Integration: DU Transport

HANA handling Components in SAP

Here is a list of possible components / sub modules which may be dealing with HANA related processes in SAP. List contains sub module name, then containing component and description.

• BC-HAN-INS – BYI3000442 – For HANA DB use BC-DB-HDB, for HANA Studio use BC-HAN-MOD
• BC-DB-HDB-SCR – BYI3000621 – SAP HANA SQL Script
• BC-DB-HDB-R – BYI3000620 – SAP HANA Integration with R
• BC-DB-HDB-POR – BYI3000619 – DB Porting for SAP HANA
• BC-DB-HDB-CCM – BYI3000616 – CCMS for SAP HANA
• BC-HAN-RUL – BYI3000633 – Rules in HANA
• BC-DB-HDB – BYI3000021 – SAP HANA database
• BC-HAN-MOD – BYI3000119 – SAP HANA Modeler
• BC-HAN – BYI3000117 – SAP HANA Appliance
• BC-DB-HDB-UPG – BYI3000033 – Upgrade of SAP HANA
• BC-DB-HDB-ENG – BYI3000104 – Engine of SAP HANA DB
• BC-DB-HDB-INS – BYI3000023 – Engine of SAP HANA DB
• BC-DB-HDB-DBA – BYI3000022 – Database Administration for SAP HANA
• BC-HAN-TM – BYI3000869 – Task management in SAP HANA
• BC-DB-HDB-BAC – BYI3000615 – SAP HANA Backup & Recovery
• BC-HAN-SRC – BYI3000812 – SAP HANA Search Infrastructure
• BC-DB-HDB-XS – BYI3000691 – SAP HANA Application Services
• BC-DB-HDB-PER – BYI3000031 – Database Persistence for SAP HANA
• BC-LVM-HDB – BYI3000637 – LLVM inside HANA DB
• BW-WHM-DST-HAP – KIW0000016 – HANA Analysis Process

Other Tutorials & User Guides

If you want to learn it as free read about HANA cloud platform free developer account

For creating the applications that have proper html5 rendering read about SAPUI5.

SAP HANA HDBSQL tool

SAP HANA Terms & Full Form

Some Basic Questions & Answers