Setup and Enhance SAP HANA-Based Search for Material
As of MDG 7.0 it is also possible to use SAP HANA as search provider. If you have extended the data model MM and want to search with these new fields you have to extend the search. This guide provides background information about the SAP HANA search and describes how to configure it if you have extended the data model. Download the DocumentPUBLIC
How-To
Setup and Enhance the SAP HANA-Based Search for
Material
Applicable releases:
All
Version: 3.0
Date: 2026-03-27
How-To
Setup and Enhance the SAP HANA-Based Search for
Material
Applicable releases:
All
Version: 3.0
Date: 2026-03-27
Document History
Document Version Description
1.0 First official release of this guide (August 2016)
2.0 Small corrections, layout update (February 2023)
3.0 Layout update
© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on https://www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 2 / 29
Document Version Description
1.0 First official release of this guide (August 2016)
2.0 Small corrections, layout update (February 2023)
3.0 Layout update
© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on https://www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 2 / 29
Table of Contents
1. Business Scenario . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
2. General Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
3. Comparison: Enterprise search and SAP HANA Search . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
4. Upgrade SAP HANA Search. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
5. Restrictions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
6. Step by Step Explanation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
6.1. Save and Generate Delivered Search Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
6.1.1. Provide the General Data Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
6.1.2. Save Search View. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
6.1.3. Generate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
6.1.4. SAP HANA Studio. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
6.2. Create, Save and Generate new Search Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
6.2.1. Model Extension with Attributes (Case A and B) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
6.2.2. Model Extension with Reuse Entity (Case C) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
6.2.3. Model Extension with Flex Entity (Case D) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
6.3. Customizing for search attributes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
6.4. Enhance UIBB MDG_BS_MAT_SEARCH_RESULT_LIST. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
7. Additional Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.1. Further Reading . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.1.1. Information on SAP MDG on SAP S/4HANA . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.1.2. SAP Roadmap Explorer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.1.3. Related Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.2. SAP Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on https://www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 3 / 29
1. Business Scenario . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
2. General Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
3. Comparison: Enterprise search and SAP HANA Search . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
4. Upgrade SAP HANA Search. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
5. Restrictions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
6. Step by Step Explanation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
6.1. Save and Generate Delivered Search Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
6.1.1. Provide the General Data Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
6.1.2. Save Search View. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
6.1.3. Generate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
6.1.4. SAP HANA Studio. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
6.2. Create, Save and Generate new Search Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
6.2.1. Model Extension with Attributes (Case A and B) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
6.2.2. Model Extension with Reuse Entity (Case C) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
6.2.3. Model Extension with Flex Entity (Case D) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
6.3. Customizing for search attributes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
6.4. Enhance UIBB MDG_BS_MAT_SEARCH_RESULT_LIST. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
7. Additional Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.1. Further Reading . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.1.1. Information on SAP MDG on SAP S/4HANA . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.1.2. SAP Roadmap Explorer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.1.3. Related Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
7.2. SAP Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on https://www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 3 / 29
1. Business Scenario
SAP Master Data Governance provides business processes to find, create, change, and mark master data for
deletion. It supports the governance of master data in a central hub and the distribution to connected opera
tional and business intelligence systems.
The processes are workflow-driven and can include several approval and revision phases, and the collabora
tion of all users participating in the master data maintenance.
A users can search for materials that are stored in the active or in the staging area. The search criteria combine
material attributes and classification. The search uses SAP HANA-Based Search, Enterprise Search or alterna
tive search providers.
As of MDG 7.0 it is also possible to use SAP HANA-Based Search as search provider. If you have extended the
data model MM and want to search with these new fields you have to extend the search.
This guide provides background information about the SAP HANA-Based Search and describes how to config
ure it if you have extended the data model.
2. General Information
• SAP Online Help: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/
6d52de87aa0d4fb6a90924720a5b0549/e0de68cd46914e3797762c43cba621bd.html
• Guide available on the MDG Community (https://www.sap.com/documents/2015/07/60c49158-5b7c-
0010-82c7-eda71af511fa.html)
3. Comparison: Enterprise search and SAP HANA Search
© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on https://www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 4 / 29
SAP Master Data Governance provides business processes to find, create, change, and mark master data for
deletion. It supports the governance of master data in a central hub and the distribution to connected opera
tional and business intelligence systems.
The processes are workflow-driven and can include several approval and revision phases, and the collabora
tion of all users participating in the master data maintenance.
A users can search for materials that are stored in the active or in the staging area. The search criteria combine
material attributes and classification. The search uses SAP HANA-Based Search, Enterprise Search or alterna
tive search providers.
As of MDG 7.0 it is also possible to use SAP HANA-Based Search as search provider. If you have extended the
data model MM and want to search with these new fields you have to extend the search.
This guide provides background information about the SAP HANA-Based Search and describes how to config
ure it if you have extended the data model.
2. General Information
• SAP Online Help: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/
6d52de87aa0d4fb6a90924720a5b0549/e0de68cd46914e3797762c43cba621bd.html
• Guide available on the MDG Community (https://www.sap.com/documents/2015/07/60c49158-5b7c-
0010-82c7-eda71af511fa.html)
3. Comparison: Enterprise search and SAP HANA Search
© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on https://www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 4 / 29
4. Upgrade SAP HANA Search
We recommend installing the highest available version of the SAP HANA database.
If you use SAP HANA-Based Search for Material Master then you must run the report program
MDG_HDB_MAT_MIGRATE_LONGTEXT to build the longtext for search after upgrade.
With MDG on S/4HANA, if you use SAP HANA-Based Search for Material Master then you must run the
report program MDG_HDB_MAT_MIGRATE_LONGTEXT to build the longtext for search before you use the
SAP HANA-Based Search.
5. Restrictions
There is a restriction in class CL_MDG_BS_MAT_HDB_SEARCH which does not allow to use an entity which has
no persistent table.
The following is a list of entities that are read-only or cannot be selected for search.
• MLANSALES (Tax Classification for Sales) and MLANPURCH (Tax Classification for Purchasing), as they
do not have any persistent table, but rather use structures STEUMM and STEU
• MATCHGMNG (Material Change Management)
• DRADTXT (Document Link Test)
6. Step by Step Explanation
The following explanation shows you how to set up the SAP HANA-Based Search. Follow the SAP online help
to set up SAP HANA-Based search.
SAP Online Help: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/
6d52de87aa0d4fb6a90924720a5b0549/e0de68cd46914e3797762c43cba621bd.html
Configuring SAP HANA-Based Search for MDG: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/
© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on https://www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 5 / 29
We recommend installing the highest available version of the SAP HANA database.
If you use SAP HANA-Based Search for Material Master then you must run the report program
MDG_HDB_MAT_MIGRATE_LONGTEXT to build the longtext for search after upgrade.
With MDG on S/4HANA, if you use SAP HANA-Based Search for Material Master then you must run the
report program MDG_HDB_MAT_MIGRATE_LONGTEXT to build the longtext for search before you use the
SAP HANA-Based Search.
5. Restrictions
There is a restriction in class CL_MDG_BS_MAT_HDB_SEARCH which does not allow to use an entity which has
no persistent table.
The following is a list of entities that are read-only or cannot be selected for search.
• MLANSALES (Tax Classification for Sales) and MLANPURCH (Tax Classification for Purchasing), as they
do not have any persistent table, but rather use structures STEUMM and STEU
• MATCHGMNG (Material Change Management)
• DRADTXT (Document Link Test)
6. Step by Step Explanation
The following explanation shows you how to set up the SAP HANA-Based Search. Follow the SAP online help
to set up SAP HANA-Based search.
SAP Online Help: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/
6d52de87aa0d4fb6a90924720a5b0549/e0de68cd46914e3797762c43cba621bd.html
Configuring SAP HANA-Based Search for MDG: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/
© 2026 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on https://www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 5 / 29