SAP MDG · UTILITIES
How do I enable SAP HANA-based search for an SAP MDG reuse model?
Enable HANA-based search by generating and configuring the HANA search view, implementing IF_USMD_PP_HANA_SEARCH in the reuse access class, and maintaining reuse metadata in SM34 so both active and inactive master data can be retrieved.
Enable HANA-based search by generating and configuring the HANA search view, implementing IF_USMD_PP_HANA_SEARCH in the reuse access class, and maintaining reuse metadata in SM34 so both active and inactive master data can be retrieved.
To enable SAP HANA-based search for a reuse model in SAP MDG, first generate the HANA search view and configure it for HANA database searching. Then ensure the reuse access class implements IF_USMD_PP_HANA_SEARCH, using CL_MDG_BS_BP_ACCESS_MASTER as the reference example, and maintain the reuse-area mapping and join metadata in SM34 through VC_HDB_PP_FMAP.
Process flow
- Generate a HANA search view.
- Configure the HANA search view for HANA database search.
- Ensure the reuse access class implements IF_USMD_PP_HANA_SEARCH.
- Implement ADAPT_SEL_FIELDS, GET_REUSE_VIEW_CONTENT, MERGE_REUSE_AUTHORIZATION, GET_MAPPING_INFO, ADAPT_WHERE_CLAUSE, and ADAPT_RESULT_SET.
- Run SM34 and open VC_HDB_PP_FMAP.
- Maintain Join Attributes and Join Fields.
- Verify metadata in MDGHDB_PP_FMAP, MDGHDB_PP_FJOIN, and MDGHDB_PP_TJOIN.
- Use the maintained metadata during search-view generation and runtime search.
SM34VC_HDB_PP_FMAP
Maintain reuse-area field mapping and join metadata for HANA-based search.
Referenced tables
| Object | Purpose |
|---|---|
MDGHDB_PP_FMAP | Stores field mapping information between MDG data-model fields and reuse-area fields, including deviating field names. |
MDGHDB_PP_FJOIN | Stores field-level join and mapping information used for HANA search view generation. |
MDGHDB_PP_TJOIN | Stores table-level join information including left/right tables, cardinality, and join type. |
The remaining configuration, implementation details, and testing guidance continue from this answer more…
Related questions and keywords
Alternative questions
- How do I enable HANA search for a reuse model in SAP MDG?
- How can HANA search retrieve active and inactive data?
- What is required to implement HANA-based search for reuse data?
Possible questions
- What is the first step for HANA-based search?
- Which interface must the reuse access class implement?
- What transaction is used to maintain the HANA search metadata?
- Which tables store reuse search mapping and join metadata?
- What are the required methods in IF_USMD_PP_HANA_SEARCH?