Assigning values of a Lookup Table in to a Main Table.

[Former Member]

Hi Experts

My requirement: I need to update value of Lookup Table into a field of Main table. Once user selects data in Main Table, based on selection (from Lookup), i want a value  to get updated in another field of Main Table.

Example: Category_Table (Lookup Table) - Has filed's - cat-Name and Cat-Type. In Main Table, On selection of Category, I want to populate value of cat-Type  into Main Table.

Regards

[Former Member]

Hi Roy,

Your example is a bit unclear, What are the display fields of the look up table 'Category_Table'?

If both the fields Cat name and Cat type are in Category_Table, and Category field is in the main table,

then on selecting Category Field value in the main table, you want to populate Cat- Type field value in to which field of the main table?

Thanks & Regards,

Namrta Mahajan

[Former Member]

Hi Namrata

I have another filed in Main Table called "Check_Catg", i want to update that filed with one of the fields from Cat-Lookup Table. In Cat-Lookup I have 2 fileds, I select one filed from Drop Down list and value of the other should get populated in  Main Table Field - "Check_Catg",

Regards

[Former Member]

Hi Prasenjit,

I am not very clear here of the requirement.

Let me take an example here to explain my understanding.

If you Primary Main table Material,and you have another main table Category_Table.

You have a field "Check_Catg" of Type Lookup Main looking into Category_Table from Material main table.

Now in this scenario,when for a Material 100020001000 (say) you click on the "Check_Catg" field you will get list of all the entries in Category_Table and valuse shown will be of Display Field.

Or do you want to assign value of lookup field to Main table field?

Thanks,

Ravi

[Former Member]

Hi

The second option is what I want -

Want to assign value of lookup field to Main table field?

Example - I choose Country in Lookup, Country has another field called capital, I want to assgn Capital in Main Table Field.

Regards

[Former Member]

Hi Prasenjit,

I think this is not currently supported with SAP MDM 7.1 SP 08.

SDNers please comment.

As a workaround you can use apis or use import based workaround to populate this value.

Thanks,

Ravi

[Former Member]

Hi Pransenjit,

Solution to your requirement can be achieved through Assignments.

You need to write one assignment as follows:

IF(Country.[Record]=Country.Country Code,"",Country.Capital)

And you need to choose required field (i suppose it is Check_Catg in your case) as assignment field.

This assignment will check if Value of country field in record matches with any value in Countries lookup table, and then assign the corresponding Capital of matched country to the assignment field.

Just one drawback here is that you need to manually execute this Assignment.

You can run assignment once a day to assign corresponding values to newly created records.

I hope it helps. Please revert for any issues. Thank you.

[Former Member]

Hello,

If your Lookup table is of hierarchy, then this can be achieved through assignments,

else only option is to use API, JAVA or ABAP.

Regards,

Abhishek

[Former Member]

Hi Abhishek

Thanks for your response.

My Lookup Table is of Hierarchy type. Please advice with some example.

Regards

[Former Member]

Hello,

you can design the assignment for same as explained above,

Regards,

Abhishek

[Former Member]

Hi Anhishek

My requirement is that, i select a record from Hierarchy table (which is there in the main table  as lookup) and the record selected will get pupulated in aother filed of Main Table.

Is this possible with given assignment example.

Please advice.

Regards

[Former Member]

Hello,

We try one option,

first we need to check whether the field is populated or not, using isnull operator,

with if else condition, if true, then leave it blank, else specify the value using equal operator.

Regards,

Abhishek

[Former Member]

Hi Prasenjit,

My suggestion would be instead of LooKup Hierarchy make the category as Lookup Taxanomy with only one field Category Name and maintain Category type as Attribute to link to each node with respective values.

So now whenever user will select the category name in Main table u will get Category type as attribute where only one values will be displayed which user will be bound to select.

Regards,

Neethu Joy

[Former Member]

Hi Prasenjit,

I had tried rexecuting this assignment before posting it here.

It worked fine for me. Kindly try executing this on your system and let me know if it works or not.

Thank you.