Configuring MDG Business Partner HANA based Search

[PearlBigKing]

generate.jpgerror.jpg

Hi Guys,

I'm Trying to activate the MDG HANA Business partner search(CL_MDG_HDB_SEARCH) on MDG 9.0 system which is on HANA database.

When Trying to generate the Search views , Getting error message

"Unexpected error while activating search view MDG_BS_SUP_SUPPLIER_Reuse"

MDG is on HANA Database only. Hope there's no database connection needed and in Landscape profile no entries i have given.

When i create DB connection and adding that to the Landscape profile settings, the error message in generating search view is different. .

"Some required tables not available in SAP HANA; configure replication"

[PearlBigKing · Accepted solution]

Thanks Loga / Senthil and Naga.

this has been resolved.

All due to authorization errors in HANA studio.

REPO.MODIFY_CHANGE

REPO.MODIFY_OWN_CONTRIBUTION

• REPO.READ
• REPO.EDIT_NATIVE_OBJECTS
• REPO.ACTIVATE_NATIVE_OBJECTS
• REPO.MAINTAIN_NATIVE_OBJECTS

These previleges needs to be given to the HANA user id.

[former_member693638]

This error is described in Note 2835581, and also the solution: “Delete the entry from MDGIMG-> General Setting=>Technical setting for master data=> Define MDG landscape profile and retest the system behavior

[Loga_Nathan_Duraisamy201]

Hi Muthu,

I never faced the issue but you need to check with Basis about the proper replication to HDB using SLT .

Before to that you need to identify what function is missing, Debug the class

CL_MDG_HDB_VIEW_GENERATOR method REPLICATE_TABLES_TO_HDB. Based on your understanding check if you can implement this note 2503673.

Thanks and Regards,

Logan.D

[Former Member]

Hello Muthu,

The fields are not directly displayed in the Search attributes. You will have to enhance the Search UIBB and add the fields which you have added in the Search view, manually. Please find the screenshot on how to identify the correct UIBB that you are using.

Regards

Senthil.

[PearlBigKing]

Senthil,

There are no custom attributes to be added. So no config require i believe.

Just the standard Business search templates what SAP gave is that i'm trying to generate. After generating the view the fields should appear in the search criteria. that should be the functionality of the search view which is not working for me..

[Former Member]

Yes, but the fields will not come even if you have standard attributes as the field catalog is not dynamic. So, please try this approach.

[PearlBigKing]

Hi Senthil,

I followed the same guide. It's still not successfull.

@ Venkat

Yes. As it is on HANA DB there's no DBCO required. This problem is solved. The problem is because of the authorizations in HANA studio. Those have been identified and given and am able to generate the search views.

But , Even after configuring and generating the search views , the attributes and entities what ever i select is not appearing the search criterias. Only Name1 AND Name2 is appearing.

Any Pointers on this please.

Thanks

[Former Member]

Hi,

Please go through the below documentation and check if all the settings are in place.

https://help.sap.com/viewer/fe69af2ae6534e0aa7559a69dd84b7ea/MDG91_SP01/en-US/7293f8516599a060e10000...

Regards

Senthil

[former_member547756]

HI ,

Is your system on S/4 HANA ? If yes, then this should work automatically no special connections are required .

[PearlBigKing]

Yes. That is correct Naga.

DBCO is not required. The error is beacuse of Authorizations inside SAP HANA Studio on Views.