MDM Lookup from SAP PI

[sriram_devarapalli]

Hi All,

How do we do a Lookup to MDM system to get a value from MDM Lookup Table from SAP PI 7.1 EHP1.

We have MDM PI Adapter 7.1

Proposal for this approach

1)    We are proposing a WS to be generated on MDM and call the WS using Soap Lookup.

2)    How can we use MDM Java API's to achieve this requirement? any idea.

Can we use JAVA API's in UDF of our PI Mappings to get the Lookup value from MDM.

Any other design or pointers are highly appreciated.

Thanks in Advance,

Sriram.

[Former Member · Accepted solution]

Hi Sriram,

You can import the MDM Java api (Jar) into your SWCV (under imported archive) and then use the available functions from these api's in your UDF program. We have done something similar here but for accessing seeburger workbench in message mapping.

Regards,

Anurag

[sriram_devarapalli · Accepted solution]

Hi Anurag,

Thanks for the reply.

In the UDF can we use the MDM Communication channel as we use SOAP Channel in the below link.

http://scn.sap.com/community/pi-and-soa-middleware/blog/2013/08/07/how-to--soap-lookup

Please suggest, did any one use the MDM channel as lookup.

Thanks in Advance.

Sriram.

[Former Member · Accepted solution]

Hi Sriram,

If you are using MDM Java API, you do not need to use MDM adapter as done for SOAP Lookup. In this case, you directly link to the MDM server using java API classes within the udf and extract the required information. The classes within the java api will act as MDM adapter and provide connectivity to the MDM application. This link here provides some example codes for using MDM API to access data 'http://scn.sap.com/docs/DOC-29061'. Hope this helps!!!

Regards,

Anurag

[anupam_ghosh2]

Hi Sri Ram,

                   Do yu have a WSDL ? If you do not have a WSDL from the web service then you need the API. This can be made using java mapping or adapter module.

Regards

Anupam

[former_member184720]

Can you check below blog

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/12/18/why-use-sap-netweaver-pi-for-sap-...

[former_member190624]

Hi Sriram,

In my system ,  MDM Lookup (vendor / Material - via SOAP Lookup API in message mapping ) was done through Portal system .

Thanks

Hari.