cancel
Showing results for 
Search instead for 
Did you mean: 

what is Relationship table and how to work on that

Former Member
0 Kudos

Hi MDM Gurus,

Can anybody please let me know regarding Relationships table and how to work with that. I am aware of all the other MDM concepts.

Regards

Yugandher

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi YugandherSantosh,

Relationship table is used to relate the records that are present in MDM.

You can basically create two types of relationships - parent/child and siblings in the console.

When the products can be related to either of this relation you select them in the data manage and click on the relationship table in the record details pane.It opens a window wherein the selected reocrd becomes the anchor record.You can relate any no. of records for this relationship to that particular selected record.

Alternately, you can export and import the records in a relationship through Data Manager.

Go to Realtionship tab->Export Records / Import Records

Refer https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0026053-e9ee-2b10-e4bd-bc5783a4...

Hope it helps.

Thanks,

Minaz

Former Member
0 Kudos
Former Member
0 Kudos

Hi,

Relationship tells how the records from main table and subtable are related to each other. We need to first create the entry in relationship table from MDM Console. MDM support two types of relationships:

1. Parent/Child Relationship - Applicable for all possibilities of main and lookup table

2. Sibling Relationship - Applicable only for Main table records

For More information refer the below links

1. What are Relationships and how to create them

http://help.sap.com/saphelp_mdm550/helpdata/en/8e/9f9c427055c66ae10000000a155106/frameset.htm

Repository Maintainance -> Repository Structure Operations -> Relationship table

2. How to work with Relationship table

http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0615f82b40a2ee10000000a11466f/frameset.htm

Record Mode -> Editing Relationships

Regards,

Jitesh Talreja