Skip to Content
0

how to get non sap system database search while in customer search

Jan 01, 2017 at 01:52 PM

54

avatar image

Hi,

I have a requirement in MDG customer , when i am searching for customer in UI, search database needs to include NON SAP system data also to search for customer(i mean in MDG system how to get non SAP system data for customer, if i enter any data in search customer UI, search should be non SAP system database also )

Regards,

Sri

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Loga Nathan Duraisamy Jan 02, 2017 at 08:48 AM
0

Hi Sri,

Connection can be done using DBCO tcode and you can enhance handler methods of BP to attach DB search results with MDG search results.

If user wants to change customer , you have to enhance lot more but it is not feasible one.

For an example-http://www.saptechnical.com/Tutorials/Basis/Oracle/RetrieveData.htm

SAP provides fuzzy,free text searches and HANA provides more . Not sure you can able to tune to get all from your external DB. It is better to create an interface to pull all the records to MDG. If you want ,create custom account group to group them all for unique identification. Instead of making two DB to search and aggregate the results better to make one(MDG) to work to avoid delays. This is even better approach if your non DB is a production Database so you can avoid overloading it.

Coming to Trex- go through https://archive.sap.com/discussions/thread/42786. I am not very sure about this.

Thanks

Share
10 |10000 characters needed characters left characters exceeded