SAP Reports / Programs
ESH_SET_HDB_SCHEMA_MAPPING SAP ABAP Report - Customize Schema Mapping for ESH-on-Application-Tables Scenario
ESH_SET_HDB_SCHEMA_MAPPING 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 ESH_SET_HDB_SCHEMA_MAPPING 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 ESH_SET_HDB_SCHEMA_MAPPING. "Basic submit
SUBMIT ESH_SET_HDB_SCHEMA_MAPPING AND RETURN. "Return to original report after report execution complete
SUBMIT ESH_SET_HDB_SCHEMA_MAPPING 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_TABNAM = Deviating Node Table
Selection Text: P_SCHEMA = Customized Schema Name
Selection Text: P_OTYP = Object Type
Selection Text: P_NODE = Node Name
Selection Text: P_LOGSYS = Logical System
Selection Text: P_HSWC = Software Component
Title: Customize Schema Mapping for ESH-on-Application-Tables Scenario
Text Symbol: 026 = No schema found
Text Symbol: 027 = Schema determination failed:
Text Symbol: 028 = SQL exception on schema determination
Text Symbol: 029 = Failed to initialize remote communication
Text Symbol: 030 = Bad request exception
Text Symbol: 031 = Root
Text Symbol: 032 = All
Text Symbol: 033 = Application-Table Based
Text Symbol: 034 = Technical
Text Symbol: 035 = Authorization
Text Symbol: 036 = System attached to classical TREX or BWA installation.
Text Symbol: 037 = ESH on Application Tables Scenario not available.
Text Symbol: 038 = All nodes will be generated as classical TREX indices.
Text Symbol: 039 = Schema mapping not required.
Text Symbol: 040 = Schema mapping is required for cases where standard schema cannot be used.
Text Symbol: 041 = Set schema for swc (generic), or swc+object, or swc+object+node.
Text Symbol: 042 = If schema mapping is not set for at least one node standards will be used.
Text Symbol: 043 = Table name: Specify only in case of deviating table names for spcecific nodes.
Text Symbol: 044 = Type
Text Symbol: 001 = Info
Text Symbol: 002 = Maintain Entries
Text Symbol: 003 = Software Component
Text Symbol: 004 = Object Type
Text Symbol: 005 = Logsys
Text Symbol: 006 = Node Name
Text Symbol: 007 = Customized Schema Name
Text Symbol: 008 = Deviating Node Table
Text Symbol: 009 = Close Window
Text Symbol: 010 = Delete
Text Symbol: 011 = Delete selected rows
Text Symbol: 012 = Refresh
Text Symbol: 013 = Refresh list
Text Symbol: 014 = No entries selected in the table
Text Symbol: 015 = Logical systems not yet set up
Text Symbol: 016 = Logical system not specified
Text Symbol: 017 = Software component has to be specified at least
Text Symbol: 018 = Select logical system first
Text Symbol: 019 = No software component selected
Text Symbol: 020 = Logical system not found:
Text Symbol: 021 = Software component not found:
Text Symbol: 022 = SWC does not contain table-based objects
Text Symbol: 023 = Select a specific object type
Text Symbol: 024 = Select software component and object type first
Text Symbol: 025 = No nodes found. Check selected object type.
INCLUDES used within this REPORT ESH_SET_HDB_SCHEMA_MAPPING
No INCLUDES are used within this REPORT code!
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:
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'LOGSYS' dynpprog = sy-repid dynpnr = sy-dynnr dynprofield = 'P_LOGSYS' value_org = 'S' TABLES field_tab = lt_fieldtab value_tab = lt_adm_rfc_conn EXCEPTIONS parameter_error = 1 no_values_found = 2 OTHERS = 3.
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'SYSREL' dynpprog = sy-repid dynpnr = sy-dynnr dynprofield = 'P_SWC' value_org = 'S' TABLES field_tab = lt_fieldtab value_tab = lt_software_components EXCEPTIONS parameter_error = 1 no_values_found = 2 OTHERS = 3.
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'OBJECT_TYPE_NAME' dynpprog = sy-repid dynpnr = sy-dynnr dynprofield = 'P_OTYP' value_org = 'S' TABLES field_tab = lt_fieldtab value_tab = lt_otypt_f4 EXCEPTIONS parameter_error = 1 no_values_found = 2 OTHERS = 3.
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'NODE_NAME' dynpprog = sy-repid dynpnr = sy-dynnr dynprofield = 'P_NODE' value_org = 'S' TABLES field_tab = lt_fieldtab value_tab = lt_otypnt_f4 EXCEPTIONS parameter_error = 1 no_values_found = 2 OTHERS = 3.
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'HDB_DBSCHEMA' dynpprog = sy-repid dynpnr = sy-dynnr dynprofield = 'P_SCHEMA' value_org = 'S' TABLES field_tab = lt_fieldtab value_tab = lt_schemas_f4 EXCEPTIONS parameter_error = 1 no_values_found = 2 OTHERS = 3.
DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING dyname = sy-cprog dynumb = sy-dynnr TABLES dynpfields = lt_dyfields EXCEPTIONS invalid_abapworkarea = 1 invalid_dynprofield = 2 invalid_dynproname = 3 invalid_dynpronummer = 4 invalid_request = 5 no_fielddescription = 6 invalid_parameter = 7 undefind_error = 8 double_conversion = 9 stepl_not_found = 10 OTHERS = 11.
DYNP_UPDATE_FIELDS CALL FUNCTION 'DYNP_UPDATE_FIELDS' EXPORTING dyname = sy-cprog dynumb = sy-dynnr TABLES dynpfields = lt_dynpfields EXCEPTIONS invalid_abapworkarea = 1 invalid_dynprofield = 2 invalid_dynproname = 3 invalid_dynpronummer = 4 invalid_request = 5 no_fielddescription = 6 undefind_error = 7 OTHERS = 8.
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 ESH_SET_HDB_SCHEMA_MAPPING or its description.
ESH_SET_HDB_SCHEMA_MAPPING - Customize Schema Mapping for ESH-on-Application-Tables Scenario ESH_SET_HDB_SCHEMA_MAPPING - Customize Schema Mapping for ESH-on-Application-Tables Scenario ESH_SET_BINATTR_AS_CLASSIC_TXT - Binary Text Attributes: Set As Classic Text ESH_SET_BINATTR_AS_CLASSIC_TXT - Binary Text Attributes: Set As Classic Text ESH_REQUEST_LOG_MONITOR - Search Request Monitor ESH_REQUEST_LOG_MONITOR - Search Request Monitor