MDM7.1 lookup( main ) Functionality

[Former Member]

Hi,

In MDM7.1 lookup( main )is available, if I want to make use of this lookup table in both bidirectional or multidirectional to retailer main table and and supplier main table ,how we will achieve this?

Thanks in Advance.

Regards,

coti.

[Former Member]

Hi COTI

to maintain bidirectional data flow between Vendor and Retailer please follow the following steps-

1. FIrst of all import the schema of Vendor repository in Retailer one.We need to take care of conflicting lookup tables, Ports and maps.

2. Define a field in Vendor main table of type Lookup main and link to Retailer main table.

3. Define a field in Retailer main table of type Lookup main and link to Vendor main table.

4. Import a file which contains the relationship between Vendor and Retailer to Vendor main table.

5. Import a file which contains the relationship between Retailer and Vendor to Retailer main table.

hope this helps-Ravi

[Former Member]

Hi Coti,

As per your requirement, if you are looking for Two Masters in a single repository as you said retailer main table and and supplier main table. Please refer below guide where Vendor repository is imported into Material repository and using multiple main tbales 1 main tbale for Material and other for Vendor. If fits in your requirement you can follow the same procedure as discussed in guide.

[Migrating from two Repositories to one Repository with two Main Tables|http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80765a21-78f3-2b10-74a2-dc2ab57a1bd2?quicklink=index&overridelayout=true]

You have also look into the other aspects for making such a decision like performance aspect, Commom lookup tables.

For this please refer this useful [thread |;

Regards,

Mandeep Saini

[Former Member]

Hi ,

Plesae go through following links to get more understanding on multi main table

http://wiki.sdn.sap.com/wiki/display/SAPMDM/MultipleMainTablesandImport+Manager

page 64-67

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70b0caa1-92e5-2c10-c687-a8d05e778...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a06efa38-ec08-2d10-f38b-9bb63df3a...

/people/klaus.david/blog/2009/10/01/sap-teched-09--live-expert-session-multiple-domains-in-one-mdm-repository-vs-one-mdm-repository-per-domain

Thanks,

Sudhanshu

Edited by: Sudhanshu Agarwal on Aug 4, 2010 7:27 PM