To create an assignment in Tuple table in MDM

[former_member245533]

Dear Experts,

We have a requirement to run an assignment in tuple table.

We have tuple table as sales data in which we have called Partner function which is also a tuple table. In this patner function, we have again called a Lookup -main table as Partner Number.

Now we need to create an assignment in this partner function table that when a value choose in Partner number (Look-up main table), an assignment will run and the same number will automatic populate in a text field (which is also below to Partner number field.

Can we achieve this requirement? Please help me to short out this scenario.

Awaiting your response for this.

With regards

Shailendra

[Former Member]

Shailendra,

1. Unfortunately, we cannot run Assignement on Tuple, in any of the SP of SAP MDM. We are expecting this functionality in coming SAP MDM version.
2. You can achive your requirement, by remodeling your sales data tuple into qualified lookup table.

Let me know, if you have any other doubt.

Thx/-Tarun

[Former Member]

Hi Shailendra,

I can confirm that it is not possible to perform assignments on tuple fields with SP08 or below. On page 203 of MDM 7.1 SP08 user guide, it is mentioned that assignment on tuple fields is not possible.

We have recently upgraded to SP08 and this is indeed the case. The only workaround is to set a field value in a tuple using JAVA API.

Regards,

Aonghus

[Former Member]

Hi Shailendra,

If you are working on SP07 or lower service packs of MDM 7.1, then you will not be able to acheive your requirement. Because it is not possible to use Tuple fields in Assignment expression and neither a tuple field can be used as Assignment Field because tuple fields do not appear in the displayed list of fields while choosing a field. This functionality might be available from SP08 service packs onwards.

Thank you.

Regards,

Ankush Bhardwaj

[former_member209780]

Ankush Bhardwaj wrote:
Hi Shailendra,
If you are working on SP07 or lower service packs of MDM 7.1, then you will not be able to acheive your requirement. Because it is not possible to use Tuple fields in Assignment expression and neither a tuple field can be used as Assignment Field because tuple fields do not appear in the displayed list of fields while choosing a field. This functionality might be available from SP08 service packs onwards.
Thank you.
Regards,
Ankush Bhardwaj

Hi Ankush,

You can use tuple fields in assignment expression, but you cannot set tuple fields as assignment fields. Please check it once.

Regards

Goutham Kanithi

[former_member198313]

May be it will be helpful if SAP has enabled this in SP08.

Pls confirm from SAP if this fucntionality is included in SP08.

+ An

[former_member209780]

Hi Shailendra

According to my knowledge, you can use tuple fields in assignment expression, but you cannot set tuple fields as assignment fields. But there is a work around for this, you can use MDM programming interface like Java or ABAP.

The below links will help you regarding this

http://scn.sap.com/thread/1803548

http://boardreader.com/thread/When_MDM_will_support_Tuple_assignments_6rdpbX132kk.html

If you want to know the working of MDM Java APi, you can follow the below link

http://scn.sap.com/docs/DOC-29061

Regards

Goutham Kanithi