SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | SAP HANA database(BC-DB-HDB) SAP BC
SHDB_INDEX_CREATE SAP ABAP Report - Create secondary indexes for HANA
SHDB_INDEX_CREATE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter SHDB_INDEX_CREATE into the relevant SAP transactions such as SE38 or SE80
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT SHDB_INDEX_CREATE. "Basic submit
SUBMIT SHDB_INDEX_CREATE AND RETURN. "Return to original report after report execution complete
SUBMIT SHDB_INDEX_CREATE VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: P_TRKORR = D .
Selection Text: P_TEST = Test
Selection Text: INDFLD = List of Indexes to be created
Title: Create secondary indexes for HANA
Text Symbol: 039 = Log Name:
Text Symbol: 038 = Tranport request:
Text Symbol: 037 = create and activate indexes
Text Symbol: 036 = Task:
Text Symbol: 029 = Wrong transport request. Index not activated
Text Symbol: 028 = Index
Text Symbol: 027 = Index cannot be changed
Text Symbol: 026 = while creating Index on DB
Text Symbol: 025 = Error for Index
Text Symbol: 024 = Activation with errors
Text Symbol: 023 = Activation with warning
Text Symbol: 022 = activated for HANA
Text Symbol: 021 = No authorization to modify Index
Text Symbol: 020 = will be created
Text Symbol: 019 = HANA Index
Text Symbol: 018 = with field
Text Symbol: 017 = on table
Text Symbol: 016 = No authorization to create Index
Text Symbol: 015 = Hash collision for:
Text Symbol: 014 = Indexid already used:
Text Symbol: 013 = create additional HANA single column Index for
Text Symbol: 012 = Index marked as no DB index. No Index created
Text Symbol: 011 = Index on field already exists
Text Symbol: 010 = Field in no index available
Text Symbol: 009 = Quantity or time field. No index created for
Text Symbol: 008 = Table not in column store:
Text Symbol: 007 = Table not available:
Text Symbol: 006 = wrong format: SAP/CUS"tabname"~"fieldname":
Text Symbol: 005 = Ddl Source
Text Symbol: 004 = Structured Object
Text Symbol: 003 = Unknown Objecttype
Text Symbol: 002 = View
Text Symbol: 001 = Table
INCLUDES used within this REPORT SHDB_INDEX_CREATE
INCLUDE: RADBTOUM, RADBTLOM.
INCLUDE: RADBTOUM, RADBTLOM.
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
MD5_CALCULATE_HASH_FOR_CHAR CALL FUNCTION 'MD5_CALCULATE_HASH_FOR_CHAR' EXPORTING DATA = index_wa-FIELDNAME * LENGTH = 0 * VERSION = 1 IMPORTING HASH = l_hash * TABLES * DATA_TAB = * EXCEPTIONS * NO_DATA = 1 * INTERNAL_ERROR = 2 * OTHERS = 3 .
DD_AUTH_CHECK CALL FUNCTION 'DD_AUTH_CHECK' EXPORTING ACTION = 'INSERT' OBJNAME = index_wa-sqltab ID = index_wa-indexname OBJTYPE = 'INDX' IMPORTING RC = rc.
DD_AUTH_CHECK CALL FUNCTION 'DD_AUTH_CHECK' EXPORTING ACTION = 'MODIFY' OBJNAME = index_wa-sqltab ID = index_wa-indexname OBJTYPE = 'INDX' IMPORTING RC = rc.
DD_CREATE_INDEX CALL FUNCTION 'DD_CREATE_INDEX' EXPORTING * DBSYS = SY-DBSYS INDEXNAME = index_wa-indexname * NO_EXEC = ' ' * PRID = 0 * PROGNAME = ' ' TABNAME = index_wa-sqltab * IMPORTING * GENPROG = EXCEPTIONS * BASETAB_ERROR = 1 * DB_ERROR = 2 DD_ERROR = 3 INDEX_EXISTS = 4 * OTHERS = 5 .
DD_TBIX_PUT call function 'DD_TBIX_PUT' EXPORTING PRID = prid PUT_STATE = 'N' REPLACE = ' ' TABL_NAME = sqltab_old tables dd12v_tab = dd12v_one dd17v_tab = dd17v_one EXCEPTIONS ILLEGAL_VALUE = 1 OBJECT_INCONSISTENT = 2 OTHERS = 3.
DD_TBIX_PUT call function 'DD_TBIX_PUT' EXPORTING PRID = prid PUT_STATE = 'N' REPLACE = ' ' TABL_NAME =
-sqltab tables dd12v_tab = dd12v_one dd17v_tab = dd17v_one EXCEPTIONS ILLEGAL_VALUE = 1 OBJECT_INCONSISTENT = 2 OTHERS = 3.
DD_MASS_ACT_C3 call function 'DD_MASS_ACT_C3' EXPORTING * DDMODE = 'O' * EXTTAB = ' ' * INACTIVE = ' ' * FRCACT = ' ' * AUTH_CHK = 'X' * PERSIST_SEL = * PERSIST = * NOTFILL = * EXCOMMIT = 'X' * VERSION = 'ACT' * DELALL = ' ' * DELNOREF = ' ' * MEDIUM = 'T' * ENQUEUE = 'S' * ACT_S = ' ' * DEVICE = 'T' * LOGNAME = WRITE_LOG = ' ' "No own logname, use PRID * LOG_HEAD_TAIL = 'X' T_ON = ' ' * TST = ' ' * PARALLEL = 'X' * MAXTASKS = 12 * MINOBJS = 3000 * MAXOBJS = 150000 * RESPERC = 30 PRID = prid IMPORTING ACT_RC = act_rc tables gentab = gentab deltab = deltab * CNVTAB = * TRKORR = EXCEPTIONS ACCESS_FAILURE = 1 NO_OBJECTS = 2 LOCKED = 3 INTERNAL_ERROR = 4 OTHERS = 5.
DD_OBJECT_EXISTS call function 'DD_OBJECT_EXISTS' EXPORTING CLASS = objtype NAME = objname STATE = 'M' "N or A IMPORTING EXISTS = exists EXCEPTIONS ILLEGAL_INPUT = 1 OTHERS = 2.
TR_OBJECT_CHECK call function 'TR_OBJECT_CHECK' EXPORTING WI_KO200 = objinfo IV_NO_STANDARD_EDITOR = ABAP_true IV_NO_SHOW_OPTION = ABAP_true "Popup with display will not be shown IMPORTING WE_ORDER = order WE_TASK = task WE_OBJECT_APPENDABLE = appendable ES_TADIR = tadir_wa EXCEPTIONS CANCEL_EDIT_OTHER_ERROR = 1 SHOW_ONLY_OTHER_ERROR = 2 OTHERS = 3.
TR_GTADIR_DELIVERY_STATE call function 'TR_GTADIR_DELIVERY_STATE' exporting iv_pgmid = 'R3TR' iv_object = tadir_wa-object iv_obj_name = tadir_wa-obj_name importing ev_status = state exceptions communication_failure = 1 system_failure = 2 object_not_found = 3 others = 4.
TR_OBJECT_INSERT call function 'TR_OBJECT_INSERT' EXPORTING WI_ORDER = trkorr WI_KO200 = objinfo IV_NO_STANDARD_EDITOR = ABAP_true IV_NO_SHOW_OPTION = ABAP_true EXCEPTIONS CANCEL_EDIT_OTHER_ERROR = 1 SHOW_ONLY_OTHER_ERROR = 2 OTHERS = 3.
BAL_LOG_CREATE call function 'BAL_LOG_CREATE' exporting i_s_log = l_s_log importing e_log_handle = g_log_handle.
BAL_DSP_LOG_DISPLAY call function 'BAL_DSP_LOG_DISPLAY' * EXPORTING * i_t_log_handle = l_t_log_handle exceptions profile_inconsistent = 1 internal_error = 2 no_data_available = 3 no_authority = 4 others = 5.
BAL_DB_SAVE_PREPARE call function 'BAL_DB_SAVE_PREPARE' exporting i_t_replace_in_these_logs = l_t_log_handle.
BAL_DB_SAVE call function 'BAL_DB_SAVE' exporting i_t_log_handle = l_t_log_handle i_in_update_task = ' ' exceptions log_not_found = 0 save_not_allowed = 0 numbering_error = 0.
BAL_LOG_MSG_ADD call function 'BAL_LOG_MSG_ADD' exporting i_log_handle = g_log_handle i_s_msg = l_s_msg exceptions log_not_found = 0 others = 1.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name SHDB_INDEX_CREATE or its description.
SHDB_INDEX_CREATE - Create secondary indexes for HANA SHDB_INDEX_CREATE - Create secondary indexes for HANA SHDB_INDEX_CHECK - Check Indexes created for HANA SHDB_INDEX_CHECK - Check Indexes created for HANA SHDB_INDEX_ANALYZE - Analyze Indexing for HANA SHDB_INDEX_ANALYZE - Analyze Indexing for HANA