DTL_CREATE_CLUSTER is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report allows the creation of a cluster table (DMC_INDXCL) in the sender system of a data transfer...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.
If you would like to execute this report or see the full code listing simply enter DTL_CREATE_CLUSTER into the relevant SAP transactions such as SE38 or SE80
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.
Selection Text: GP_CRE = Create with tablespace select.
Selection Text: GP_DEL = Delete the cluster
Selection Text: GP_SIZ = Create automatically
Selection Text: GP_TEST = Test run - no change to DB
Selection Text: P_ACT_ID = Actvity ID
Selection Text: P_PACK = Package ID
Selection Text: P_PHASE = Phase
Title: data migration: create cluster for temporary data storage in the sende
Text Symbol: 001 = Standard parameters
Text Symbol: 002 = Cluster for temporary data storage
Text Symbol: 003 = Select table space
Text Symbol: 004 = 'Really delete'
Text Symbol: 005 = Create cluster in tablespace:
Text Symbol: 010 = Action to be executed
Text Symbol: 100 = Delete?
Text Symbol: 101 = Cluster CNVMBTCLU contains data !
Text Symbol: CO1 = cluster have not been changed.
Text Symbol: COK = customer-defined table parameters are ok,
INCLUDE CNV_MBT_SM_MACROS.
No SAP DATABASE tables are accessed within this REPORT code!
DD_EXISTS_DATA * CALL FUNCTION 'DD_EXISTS_DATA' * EXPORTING * tabclass = 'TRANSP' * tabname = lp_tabname * IMPORTING * subrc = ld_subrc.
POPUP_TO_CONFIRM_STEP * CALL FUNCTION 'POPUP_TO_CONFIRM_STEP' * EXPORTING * defaultoption = 'N' * textline1 = text-101 * titel = text-004 * IMPORTING * answer = gd_answer_del_data * EXCEPTIONS * OTHERS = 1.
GET_TSP_INFO_ORA * CALL FUNCTION 'GET_TSP_INFO_ORA' * TABLES * tsp_tab_out = lt_tsp_ora * EXCEPTIONS * OTHERS = 1.
DB_INF_DB_SPACE_ALL_DETAIL * CALL FUNCTION 'DB_INF_DB_SPACE_ALL_DETAIL' * TABLES * dbspaces_tab = lt_infdbspace * EXCEPTIONS * OTHERS = 1.
DB6_TABLESPACE_INFO * CALL FUNCTION 'DB6_TABLESPACE_INFO' * TABLES * tbstab = lt_db6tspace * EXCEPTIONS * OTHERS = 1.
REUSE_ALV_LIST_DISPLAY * CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' * EXPORTING * i_callback_program = syst-cprog * i_callback_user_command = 'INT_LIST_CALLBACK' * is_layout = ld_layout * it_fieldcat = lt_fieldcat * TABLES * t_outtab = lt_table_spc.
REUSE_ALV_LIST_DISPLAY * CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' * EXPORTING * i_callback_program = syst-cprog * i_callback_user_command = 'INT_LIST_CALLBACK' * is_layout = ld_layout * it_fieldcat = lt_fieldcat * TABLES * t_outtab = lt_infdbspace.
REUSE_ALV_LIST_DISPLAY * CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' * EXPORTING * i_callback_program = syst-cprog * i_callback_user_command = 'INT_LIST_CALLBACK' * is_layout = ld_layout * it_fieldcat = lt_fieldcat * TABLES * t_outtab = lt_db6tspace.
POPUP_TO_CONFIRM_STEP * CALL FUNCTION 'POPUP_TO_CONFIRM_STEP' * EXPORTING * textline1 = text-005 * textline2 = gd_tablespace * titel = text-003 * IMPORTING * answer = ld_answer.
DB_STORAGE_PUT * CALL FUNCTION 'DB_STORAGE_PUT' * EXPORTING * tabname = lp_tabname * useflag = t_yes * TABLES * storpar = gt_storpar * EXCEPTIONS * db_error = 1 * other_error = 2 * OTHERS = 3.
DDIF_TABL_PUT * CALL FUNCTION 'DDIF_TABL_PUT' * EXPORTING * name = lp_tabname * dd02v_wa = ld_dd02v * dd09l_wa = ld_dd09l * TABLES * dd03p_tab = lt_dd03p "#EC * * dd05m_tab = lt_dd05m "#EC * * dd08v_tab = lt_dd08v "#EC * * EXCEPTIONS * tabl_not_found = 1 * name_inconsistent = 2 * tabl_inconsistent = 3 * put_failure = 4 * put_refused = 5 * OTHERS = 6.
TRINT_TADIR_INSERT * CALL FUNCTION 'TRINT_TADIR_INSERT' * EXPORTING * devclass = 'CNVM' * genflag = 'T' * object = 'TABL' * obj_name = ld_tabname * pgmid = 'R3TR' * srcsystem = 'SAP' * EXCEPTIONS * object_exists_global = 1 * object_exists_local = 2 * OTHERS = 3.
DDIF_TABL_ACTIVATE * CALL FUNCTION 'DDIF_TABL_ACTIVATE' * EXPORTING * name = lp_tabname "#EC DOM_EQUAL * IMPORTING * rc = ld_rc * EXCEPTIONS * not_found = 1 * put_failure = 2 * OTHERS = 3.
DD_TABL_DEL * CALL FUNCTION 'DD_TABL_DEL' * EXPORTING * tabname = lp_tabname * del_state = 'M' * EXCEPTIONS * OTHERS = 1.
TRINT_TADIR_DELETE * CALL FUNCTION 'TRINT_TADIR_DELETE' * EXPORTING * object = 'TABL' * obj_name = ld_tabname * pgmid = 'R3TR' * EXCEPTIONS * tadir_entry_not_existing = 1 * object_exists = 2 * OTHERS = 3.
DB_STORAGE_GET * CALL FUNCTION 'DB_STORAGE_GET' * EXPORTING * dbsys = sy-dbsys * prid = 0 * tabname = 'DMC_INDXCL' * source_hierarchy = ld_storagesrc * TABLES * storpar = gt_storpar * EXCEPTIONS * OTHERS = 0.
DB_STORAGE_GET * CALL FUNCTION 'DB_STORAGE_GET' * EXPORTING * dbsys = sy-dbsys * prid = 0 * tabname = 'DMC_INDXCL' * source_hierarchy = ld_storagesrc * TABLES * storpar = gt_storpar * EXCEPTIONS * OTHERS = 0.
CNV_MBT_RFC_PCL * CALL FUNCTION 'CNV_MBT_RFC_PCL' * EXPORTING * packid = p_pack * IMPORTING * destination_id = l_rfcdest_pcl * EXCEPTIONS * no_destinations_for_packid = 1 * no_pcl_destination_for_packid = 2 * OTHERS = 3.
* CALL FUNCTION 'CNV_MBT_RFC_GET' * EXPORTING * packid = p_pack * exec_target = 'C' * IMPORTING * destination_id = l_rfcdest_dtl * EXCEPTIONS * OTHERS = 0.
CNV_MBT_ADM_PACKAGE_INFO * CALL FUNCTION 'CNV_MBT_ADM_PACKAGE_INFO' * DESTINATION l_rfcdest_pcl * EXPORTING * packid = p_pack * IMPORTING * mtid = l_mtid * EXCEPTIONS * packid_does_not_exist = 1 * OTHERS = 2.
DTL_GET_RELID * CALL FUNCTION 'DTL_GET_RELID' * DESTINATION l_rfcdest_dtl * EXPORTING * i_mt_id = l_mtid * IMPORTING * e_relid = l_relid.
DB_STORAGE_GET * CALL FUNCTION 'DB_STORAGE_GET' * EXPORTING * dbsys = sy-dbsys * prid = 0 * tabname = 'DMC_INDXCL' * source_hierarchy = ls_storagesrc * TABLES * storpar = gt_storpar * EXCEPTIONS * OTHERS = 0.
DB_STORAGE_GET * CALL FUNCTION 'DB_STORAGE_GET' * EXPORTING * dbsys = sy-dbsys * prid = 0 * tabname = 'DMC_INDXCL' * source_hierarchy = ls_storagesrc * TABLES * storpar = lt_storpar_tech * EXCEPTIONS * OTHERS = 0.
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 DTL_CREATE_CLUSTER or its description.
DTL_CREATE_CLUSTER - data migration: create cluster for temporary data storage in the sende DTL_CREATE_CLUSTER - data migration: create cluster for temporary data storage in the sende DTL_COMPARE_REMOTE_DDIC - MWB: compare DDIC data for tables in MWB and remote systems DTL_COMPARE_REMOTE_DDIC - MWB: compare DDIC data for tables in MWB and remote systems DTL_ANALYZE_DB - database analysis for selection parameter and block size determination DTL_ANALYZE_DB - database analysis for selection parameter and block size determination