SAP MDG · COMMUNITY
How can I replace Enterprise Search in MDG Material with database search or SAP HANA search?
MDG Material can be adapted to use database search or SAP HANA search instead of Enterprise Search, but the implementation depends on release and provider. The database-search example uses `MDG_BS_MAT_PP_SEARCH_DB` for `BADI_SDQ_PP_SEARCH`, while MDG 7/8 adds provider-mode and provider-support enhancements; duplicate check and DIF still need Enterprise Search or HANA-based search.
MDG Material can be adapted to use database search or SAP HANA search instead of Enterprise Search, but the implementation depends on release and provider. The database-search example uses `MDG_BS_MAT_PP_SEARCH_DB` for `BADI_SDQ_PP_SEARCH`, while MDG 7/8 adds provider-mode and provider-support enhancements; duplicate check and DIF still need Enterprise Search or HANA-based search.
MDG Material can be switched away from Enterprise Search, but the exact setup depends on whether you want database search or SAP HANA search and on your MDG release. The standard SAP example for DB search is `MDG_BS_MAT_PP_SEARCH_DB`, which implements `BADI_SDQ_PP_SEARCH` and supports `MATNR`, `MATKL`, and `TXTMI`.
Process flow
- Review DB-search limitations before changing the provider.
- Deactivate `MDG_BS_MAT_PP_SEARCH`.
- For DB search, copy `MDG_BS_MAT_PP_SEARCH_DB`.
- Create or adapt the `BADI_SDQ_PP_SEARCH` implementation and activate it.
- Enhance `CL_MDG_BS_MAT_SERVICES->CLASS_CONSTRUCTOR`.
- For DB search in MDG 7/8, set `sv_search_mode = if_mdg_sdq_const=>search_mode_db`.
- For MDG 6.1, implement an Overwrite Exit for `CL_MDG_BS_MAT_BO_SEARCH->GET_SEARCHABLE_ATTRIBUTES`.
- For MDG 7/8, implement a Post Exit for `CL_MDG_BS_MAT_BO_SEARCH->GET_SEARCHABLE_ATTRIBUTES` and execute DB logic only when search mode is DB.
MDGIMGMaster Data Governance, Central Governance → Data Quality and Search → Business Add-Ins → BAdI: Search for Data in Reuse Active Area
Deactivate `MDG_BS_MAT_PP_SEARCH` for the simplified decoupling approach.
MDGIMGMaster Data Governance, Central Governance → Master Data Governance for Material → Business Add-Ins → BAdI: Define Alternate DRF Filter Provider
Deactivate `MDG_BS_MAT_DRF_SEARCH` for the simplified decoupling approach.
Customizing activity
Clear the shared memory buffer after DB-search implementation changes in MDG 6.1.
Referenced tables
| Object | Purpose |
|---|---|
VC_USMD006 | Field Properties customizing used to derive result-list attributes in the DB-search example. |
The remaining configuration, implementation details, and testing guidance continue from this answer more…
Related questions and keywords
Alternative questions
- How can I replace Enterprise Search in MDG-M?
- Can MDG Material use database search instead of Enterprise Search?
- Can SAP HANA search replace Enterprise Search for Material?
Possible questions
- What is `MDG_BS_MAT_PP_SEARCH_DB`?
- Which BAdI is used for database search in MDG Material?
- Which search criteria are supported by the example DB search?
- Does duplicate check work with database search?
- How do I make DB search the default in MDG 7/8?