Table mappings

[lenastodal]

Hi,

I have written script for mappings between tables in the one model. I want to create different mappings between different source tables and one common target table. My script is working well, but it concatenates source tables in one mapping, instead of this I want to create separate mapping for different source tables. Is there any way?

Script:

Dim ds, m1, m2 set ds = ActiveModel.DataSources

set nds = ds.Item(0)

im tt_1, ts_1, ts_2

set tt_1 = ActiveModel.FindChildByCode("Target_1", cls_table)

set ts_1 = ActiveModel.FindChildByCode("Source_1", cls_table)

set ts_2 = ActiveModel.FindChildByCode("Source_2", cls_table)

set m1 = nds.CreateMapping(tt_1)

m1.AddSource(ts_1)

m1.SetNameAndCode "MAP_Source_1", "MAP_Source_1"

set m2 = nds.CreateMapping(tt_1)

m2.AddSource(ts_2)

m2.SetNameAndCode "MAP_Source_2", "MAP_Source_2"

Script does this:

I want this:

[lenastodal]

Hi Oskar,

Thank you for visiting SAP Community to get answers to your questions. I am here to help you to get the most out of it.

First of all, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't done so already), as it provides tips for preparing questions that draw responses from our members.
Please also make sure you're using all appropriate tags, so the right experts can find your question. Overall, the more details you provide, the more likely it is that members will be able to assist you. Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question - but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Best,

Lena (SAP Community Moderator)

[former_member200945]

All you need do is change

from

nds.CreateMapping(tt_1)

to

nds.CreateMapping(tt_1, nothing, false, true)

[GeorgeMcGeachie]

phillip.lam The metamodel documentation doesn't explain what those additional parameters are for. Here's what it says:

CreateMapping(ByVal Object As BaseObject, ByVal Source As BaseObject = Nothing, ByVal SetAsDefault As Boolean = True, ByVal EnforceCreation As Boolean = False) As BaseObject
  Creates a mapping for an object.

Is there anything that describes the method in more detail, please? You've reversed the default values for the last two parameters, and we need to guess what effect that has. In fact, it sounds like the default values are wrong.

With a more complete description of the method, razyapoo wouldn't have needed to start this discussion, and KBA 2792278 probably wouldn't be needed.

[GeorgeMcGeachie]

I've noticed that you can use the CreateMapping method on BaseDataSource to create mappings between columns (presumably only if the parents are already mapped). What happens if there is more than one mapping between the two parents? The method has a SetAsDefault parameter - perhaps it would add the sub-object mapping to the 'default' mapping between the parents?

I looked in the metamodel to see if there's a property on BaseObjectMapping that indicates the default, but I can't find it.

I'm just looking for ways to simplify future mapping scripts 🙂