Set Up SAP HANA Search

You want to enable SAP HANA search for financial objects because of high volume data or advanced features provided by the SAP HANA database such as freestyle and fuzzy search. This document explains the configuration steps that must be applied to the MDG system to enable this feature. It describes how to connect the search application with the SAP HANA search UIBB and generate the HANA search view.

Prerequisites

Before starting the implementation, check that SAP HANA is connected to the MDG system. If not, refer to Configuring SAP HANA-Based Search for MDG.

Process

Generate SAP HANA search view in the SAP HANA database
1. Open transaction MDGIMG under Master Data Governance, Central Governance General Settings Data Quality and Search Search and Duplicate Check Create Search View . Find the relevant search views from the table SAP HANA Search Supported MDG-F Objects below. For the MDG-F predelivered view for data model 0G, the name starts with MDGF_0G_*. Choose the Edit button to open each search view.
2. Enter the name of the SAP HANA package you received from your system administrator. Save your entries.
3. Choose Next until the last step and choose Generate. You should get a message saying the view generation is successful.

Enable SAP HANA Search UIBB

This is done by adding an SAP-delivered search UIBB to the communicator configuration as follows:

Start the customizing configurator for the communicator configuration.

Start the Web Dynpro application CUSTOMIZE_COMPONENT.

Enter the component name MDG_BS_GOV_COMMUNICATOR. You can find the configuration ID in the table below.

SAP HANA Search Supported MDG-F Objects

Object Name	Communicator Configuration ID	HANA Search UIBB	HANA Search View
G/L Account	MDGF_0G_OVP_FI_ACCOUNT	MDGF_0G_FI_ACCOUNT_DQUERY_HA MDGF_0G_FI_ACCCCDET_DQUERY_HA	MDGF_0G_ACCOUNT MDGF_0G_ACCCCDET
Financial Reporting Structure	MDGF_0G_OVP_FI_REPORT	MDGF_0G_FI_REPORT_DQUERY_HA MDGF_0G_FI_REP_ITEM_DQUERY_HA	MDGF_0G_FRS MDGF_0G_FRSI
Company	MDGF_0G_OVP_COMPANY	MDGF_0G_COMPANY_DQUERY_HA	MDGF_0G_COMP
Cost Center	MDGF_0G_OVP_CCTR	MDGF_0G_CCTR_DQUERY_HA	MDGF_0G_CCTR
Cost Center Group	MDGF_0G_OVP_CCTRG	MDGF_0G_CCTRG_DQUERY_HA	MDGF_0G_CCTRG
Cost Center Group Hierarchy	MDGF_0G_OVP_CCTRH	MDGF_0G_CCTRH_DQUERY_HA	MDGF_0G_CCTRH
Cost Element	MDGF_0G_OVP_CELEM	MDGF_0G_CELEM_DQUERY_HA	MDGF_0G_CELEM
Cost Element Group	MDGF_0G_OVP_CELEMG	MDGF_0G_CELEMG_DQUERY_HA	MDGF_0G_CELEMG
Cost Element Group Hierarchy	MDGF_0G_OVP_CELEMH	MDGF_0G_CELEMH_DQUERY_HA	MDGF_0G_CELEMH
Profit Center	MDGF_0G_OVP_PCTR	MDGF_0G_PCTR_DQUERY_HA	MDGF_0G_PCTR
Profit Center Group	MDGF_0G_OVP_PCTRG	MDGF_0G_PCTRG_DQUERY_HA	MDGF_0G_PCTRG
Profit Center Group Hierarchy	MDGF_0G_OVP_PCTRH	MDGF_0G_PCTRH_DQUERY_HA	MDGF_0G_PCTRH
Item	MDGF_0G_OVP_CO_ACCOUNT	MDGF_0G_CO_ACCOUNT_DQUERY_HA	MDGF_0G_FSI
Item Hierarchy	MDGF_0G_OVP_CO_REPORT	MDGF_0G_CO_REPORT_DQUERY_HA MDGF_0G_CO_REP_ITEM_DQUERY_HA	MDGF_0G_FSI MDGF_0G_FSIH
Consolidation Characteristic	MDGF_0G_OVP_CONSCHAR	MDGF_0G_CONSCHAR_DQUERY_HA	MDGF_0G_CONSCHAR
Consolidation Unit	MDGF_0G_OVP_CONSUNIT	MDGF_0G_CONSUNIT_DQUERY_HA	MDGF_0G_CONSUNIT
Consolidation Group	MDGF_0G_OVP_CONSGRP	MDGF_0G_CONSGRP_DQUERY_HA	MDGF_0G_CONSGRP
Consolidation Structure	MDGF_0G_OVP_CONSGRPH	MDGF_0G_CONSGRPH_DQUERY_HA	MDGF_0G_CONSGRPH
Breakdown Category	MDGF_0G_OVP_BDC	MDGF_0G_BDC_DQUERY_HA	MDGF_0G_BDC
Breakdown Category Set	MDGF_0G_OVP_BDCSET	MDGF_0G_BDCSET_DQUERY_HA	MDGF_0G_BDCSET
Cause for Submission	MDGF_0G_OVP_SUBMPACK	MDGF_0G_SUBMPACK_DQUERY_HA	MDGF_0G_SUBMPACK
Transaction Type	MDGF_0G_OVP_TRANSTYPE	MDGF_0G_TRANSTYPE_DQUERY_HA	MDGF_0G_TRANSTYPE

Choose New, enter a description, and choose OK. Select a transport request if your customizing needs to be transported to other systems.

Mark the Settings node, and choose New Search UIBBs . Enter all parameters for the object in the table, for example, the following are the cost center parameters:
- Search Mode: HA
- Incl. Search Help: MDGF_0G_CCTR
- Component: FPM_SEARCH_UIBB
- Config ID: MDGF_0G_CCTR_DQUERY_HA

Result

You have completed all the necessary steps to enable HANA search.