cancel
Showing results for 
Search instead for 
Did you mean: 

Excel import LDM - Relationship Join

0 Kudos

I'm trying to create relationships between entities in a PD LDM. I'm able to create the relationships themselves, but I also want to specify the relationship join attributes. For the Parent attribute I also succeed in doing this since PD automatically takes the identifier from the parent table. The problem is that for the child attribute I'm not able to specify it, but PD creates a new attribute in the child table which is then used in the join. Any thoughts in how I can make this work? I already tried a lot of things but am not able to get it working.

Accepted Solutions (0)

Answers (1)

Answers (1)

GeorgeMcGeachie
Active Contributor
0 Kudos

Hello Bram

In the PD Client, you can change the child attribute using the Joins tab in the Relationship properties. The attribute that PD added will disappear once it stops being used in a Join.

In the Excel Import, we need to be able to link a Join to the parent relationship. I've tried providing the Relationship name, and telling the Import to map that to the parent object. That doesn't work.

According to the Metamodel Help, the Relationship property on the Join will link to the Relationship but the Excel Import wizard doesn't list it as a property to map to. This must be a bug.

If you've got too many Joins to change them manually after the Import, a custom script would be fairly easy, especially if you don't have any multi-attribute keys. (I write scripts for a living :))

GeorgeMcGeachie
Active Contributor
0 Kudos

I've raised this incident with SAP - let's see what they say

GeorgeMcGeachie
Active Contributor
0 Kudos

SAP have recognised this as a bug - see

https://launchpad.support.sap.com/#/notes/2896731