SAP MDG · UTILITIES
How do I show descriptions instead of technical keys in SAP MDG Drilldown Search by joining text tables in the HANA view?
Enhance the generated HANA view with text-table joins, expose the description fields in the view output, and then configure those fields in MDGIMG Drill-Down Search so Country/Region descriptions display instead of technical keys.
Enhance the generated HANA view with text-table joins, expose the description fields in the view output, and then configure those fields in MDGIMG Drill-Down Search so Country/Region descriptions display instead of technical keys.
To display descriptions instead of technical keys in MDG Drilldown Search, manually enhance the generated HANA view with text-table joins. In the BP example from the guide, the main table is ADRO, the Country text table is TOO5T, and the Region text table is TOO5U. After joining the tables, add LANDX and BEZEI to the view Output, activate the view, and then maintain the Drill-Down Search configuration in MDGIMG so the description fields are available in Detail Data and shown in the result.
Process flow
- Identify the HANA view used by MDG Drilldown Search.
- Identify the technical-key fields that should display descriptions.
- Open the generated HANA view in SAP HANA Studio.
- Use Add Objects to add the Country text table `TOO5T`.
- Create the Country client join: `ADRO-OLIENT` -> `TOO5T-MANDT`.
- Create the Country key join: `ADRO-OOUNTRY` -> `TOO5T-LANDl`.
- Add the Region text table `TOO5U`.
- Create the Region client join: `ADRO-OLIENT` -> `TOO5U-MANDT`.
MDGIMGGeneral Settings -> Data Quality and Search -> Search and Duplicate Check -> Define Drill-Down Search Configuration
Select the enhanced HANA view, open Detail Data, add Country Description and Region Description, and mark them for Result display.
Referenced tables
| Object | Purpose |
|---|---|
ADRO | Main table in the BP HANA-view example. |
TOO5T | Country Names text table. |
TOO5U | Region Key Text table. |
LANDX | Country description field added to the view Output. |
BEZEI | Region description field added to the view Output. |
MDGIMG | Transaction used to configure Drill-Down Search. |
The remaining configuration, implementation details, and testing guidance continue from this answer more…
Related questions and keywords
Alternative questions
- How do I show country names instead of country keys in MDG search?
- How do I replace technical codes with descriptions in Drilldown Search?
- Why does MDG Drilldown Search show technical keys?','How can I show Region descriptions in HANA-based search?','How do I add text descriptions to a generated HANA view?
Possible questions
- What is the SAP MDG procedure to replace technical keys with descriptions in Drilldown Search?
- Which HANA view changes are required to display descriptions in MDG search?
- How do I configure Detail Data and Result display for description fields in MDGIMG?
- Which text tables and fields are used for Country and Region descriptions in the BP example?
- What is the end-to-end setup for text joins in a generated HANA view?