SAP HANA (High-Performance Analytic Appliance) is an in-memory database and data management platform developed by SAP, designed to process large volumes of real-time data quickly. It combines transactional and analytical processing on a single system, enabling faster decision-making and advanced analytics.

Default hierarchy

In the chart below, you will find the organizational structure of SAP HANA objects. Objects are in represented in green and folders are in yellow. diagram

Object types

Dawiso ingests the following objects from SAP HANA:

Function

Maps to SAP HANA Function object type.

Source AttributeTarget Attribute in Dawiso
CREATE_TIMECreate Time
DEFINITIONDefinition
DEFAULT_SCHEMA_NAMEDefault Schema Name
HAS_STRUCTURED_FILTER_CHECKHas Structured Filter Check
INPUT_PARAMETER_COUNTInput Parameter Count
IS_DETERMINISTICDeterministic
IS_ENCRYPTEDEncrypted
IS_HEADER_ONLYHeader Only
IS_VALIDValid
OWNER_NAMEOwner Name
FUNCTION_OIDOID
RETURN_VALUE_COUNTReturn Value Count
SQL_SECURITYSql Security
FUNCTION_TYPEType
FUNCTION_USAGE_TYPEUsage Type

Function Parameter

Maps to SAP HANA Function Parameter object type.

Source AttributeTarget Attribute in Dawiso
DATA_TYPE_NAMEData Type
DATA_TYPE_IDData Type Id
DEFAULT_VALUEDefault Value
HAS_DEFAULT_VALUEHas Default Value
IS_INPLACE_TYPEIs Inplace Type
IS_NULLABLENullable
LENGTHLength
POSITIONPosition
SCALEScale
TABLE_TYPE_SCHEMATable Type Schema
TABLE_TYPE_NAMETable Type Name
PARAMETER_TYPEType

Procedure

Maps to SAP HANA Procedure object type.

Source AttributeTarget Attribute in Dawiso
AUTO_COMMIT_DDLAuto Commit DDL
CREATE_TIMECreate Time
DEFINITIONDefinition
DEFAULT_SCHEMA_NAMEDefault Schema Name
HAS_TRANSACTION_CONTROL_STATEMENTSHas Transactional Control Statements
INPUT_PARAMETER_COUNTInput Parameter Count
IS_DETERMINISTICDeterministic
IS_ENCRYPTEDEncrypted
IS_HEADER_ONLYHeader Only
READ_ONLYRead Only
IS_VALIDValid
INOUT_PARAMETER_COUNTInput and Output Parameter Count
OWNER_NAMEOwner Name
PROCEDURE_OIDOID
OUTPUT_PARAMETER_COUNTOutput Parameter Count
RESULT_SET_COUNTResult Set Count
SQL_SECURITYSql Security
PROCEDURE_TYPEType

Procedure Parameter

Maps to SAP HANA Procedure Parameter object type.

Source AttributeTarget Attribute in Dawiso
DATA_TYPE_NAMEData Type
DATA_TYPE_IDData Type Id
DEFAULT_VALUEDefault Value
HAS_DEFAULT_VALUEHas Default Value
IS_INPLACE_TYPEIs Inplace Type
IS_NULLABLENullable
LENGTHLength
POSITIONPosition
SCALEScale
TABLE_TYPE_SCHEMATable Type Schema
TABLE_TYPE_NAMETable Type Name
PARAMETER_TYPEType

Schema

Maps to SAP HANA Schema object type.

Source AttributeTarget Attribute in Dawiso
CREATE_TIMECreate Time
HAS_PRIVILEGESHas Privileges
SCHEMA_OWNEROwner

Table

Maps to SAP HANA Table object type.

Source AttributeTarget Attribute in Dawiso
DESCRIPTIONScanned Description
AUTO_MERGE_ONAuto Merge
AUTO_OPTIMIZE_COMPRESSION_ONAuto Optimize Compression
CREATE_TIMECreate Time
COMMIT_ACTIONCommit Action
COMPRESSED_EXTKEYCompressed Extkey
FIXED_PART_SIZEFixed Part Size
HAS_PRIMARY_KEYHas Primary Key
HAS_RECORD_COMMIT_TIMESTAMPHas Record Commit Timestamp
HAS_TEXT_FIELDSHas Text Fields
HAS_MASKED_COLUMNSHas Masked Columns
HAS_STRUCTURED_PRIVILEGE_CHECKHas Structured Privilege Check
IS_COLUMN_TABLEColumn Table
IS_INSERT_ONLYInsert Only
IS_LOGGEDLogged
IS_MOVABLEMovable
IS_PARTIAL_PRELOADPartial Preload
IS_PARTITIONEDIs Partitioned
IS_PRELOADPreload
IS_PUBLICPublic
IS_REPLICAReplica
IS_REPLICATION_LOG_ENABLEDReplication Log
IS_REPLICATEDIs Replicated
IS_SYSTEM_TABLESystem Table
IS_TEMPORARYTemporary
IS_USER_DEFINED_TYPEUser Defined Type
LOAD_UNITLoad Unit
MASK_MODEMask Mode
NUMA_NODE_INDEXESNuma Node Indexes
TABLE_OIDOID
PERSISTENT_MEMORYPersistent Memory
ROW_ORDER_TYPERow Order Type
RECORD_COUNTRecord Count
TABLE_SIZETable Size
TABLE_TYPEType
TEMPORARY_TABLE_TYPETemporary Type
TEMPORAL_TYPETemporal Type
UNLOAD_PRIORITYUnload Priority
USES_DIMFN_CACHEUses Dimfn Cache
USES_QUEUE_TABLEUses Queue Table
USES_EXTKEYUses Extkey

Table Column

Maps to SAP HANA Table Column object type.

Source AttributeTarget Attribute in Dawiso
DESCRIPTIONScanned Description
COLUMN_IDColumn Id
COMPRESSION_TYPECompression Type
CLIENTSIDE_ENCRYPTION_MODEClientside Encryption Mode
CLIENTSIDE_ENCRYPTION_COLUMN_KEY_IDClientside Encryption Column Key Id
CLIENTSIDE_ENCRYPTION_STATUSClientside Encryption Status
DDIC_DATA_TYPE_IDDdic Data Type Id
DDIC_DATA_TYPE_NAMEDdic Data Type Name
DATA_TYPE_NAMEData Type
DATA_TYPE_IDData Type Id
DEFAULT_VALUEDefault Value
FUZZY_SEARCH_INDEXFuzzy Search Index
FUZZY_SEARCH_MODEFuzzy Search Mode
GENERATED_ALWAYS_ASGenerated Always As
GENERATION_TYPEGeneration Type
IS_CACHABLECachable
IS_CACHE_KEYCache Key
REF_IS_FOREIGN_KEYForeign Key
IS_HIDDENHidden
IS_MASKEDMasked
IS_PRIMARY_KEYPrimary Key
IS_NULLABLENullable
REF_IS_REFERENCEDIs Referenced
IS_UNIQUE_KEYUnique
INDEX_TYPEIndex Type
LENGTHLength
LOAD_UNITLoad Unit
MASK_EXPRESSIONMask Expression
MEMORY_THRESHOLDMemory Threshold
OFFSETOffset
PRELOADPreload
POSITIONPosition
ROW_ORDER_POSITIONRow Order Position
SCALEScale

View

Maps to SAP HANA View object type.

Source AttributeTarget Attribute in Dawiso
CREATE_TIMECreate Time
DEFINITIONDefinition
HAS_MASKED_COLUMNSHas Masked Columns
HAS_COLUMN_ALIASESHas Column Aliases
HAS_STRUCTURED_PRIVILEGE_CHECKHas Structured Privilege Check
HAS_STRUCTURED_FILTER_CHECKHas Structured Filter Check
HAS_CHECK_OPTIONHas Check Option
HAS_CACHEHas Cache
HAS_ANONYMIZATIONHas Anonymization
HAS_PARAMETERSHas Parameters
IS_COLUMN_VIEWColumn View
IS_DDL_ONLYDdl Only
IS_READ_ONLYRead Only
IS_VALIDValid
MASK_MODEMask Mode
VIEW_OIDOID
VIEW_TYPEType

View Column

Maps to SAP HANA View Column object type.

Source AttributeTarget Attribute in Dawiso
DESCRIPTIONScanned Description
COLUMN_IDColumn Id
COMPRESSION_TYPECompression Type
CLIENTSIDE_ENCRYPTION_MODEClientside Encryption Mode
CLIENTSIDE_ENCRYPTION_COLUMN_KEY_IDClientside Encryption Column Key Id
CLIENTSIDE_ENCRYPTION_STATUSClientside Encryption Status
DDIC_DATA_TYPE_IDDdic Data Type Id
DDIC_DATA_TYPE_NAMEDdic Data Type Name
DATA_TYPE_NAMEData Type
DATA_TYPE_IDData Type Id
DEFAULT_VALUEDefault Value
FUZZY_SEARCH_INDEXFuzzy Search Index
FUZZY_SEARCH_MODEFuzzy Search Mode
GENERATED_ALWAYS_ASGenerated Always As
GENERATION_TYPEGeneration Type
IS_CACHABLECachable
IS_CACHE_KEYCache Key
IS_HIDDENHidden
IS_MASKEDMasked
IS_NULLABLENullable
INDEX_TYPEIndex Type
LENGTHLength
LOAD_UNITLoad Unit
MASK_EXPRESSIONMask Expression
MEMORY_THRESHOLDMemory Threshold
NUMA_NODE_INDEXESNuma Node Indexes
OFFSETOffset
PRELOADPreload
POSITIONPosition
PERSISTENT_MEMORYPersistent Memory
ROW_ORDER_POSITIONRow Order Position
SCALEScale