how to display field by referring another field

[Former Member]

example: a lookup table vendor license

when we select licence in main table in another field need to diaply expiration date.

vendir license table will have following fields

license, expiration date

[Former Member]

Done using Taxonomy Tables.

Expiration date and licence to kept as attributes and vendor licence as hierarchy( if to be maintained).Also can be done using qualified tables where vendor licence should be the qualifier and expiratiorn date and license non qualifiers.

Try both the options and c if it works.

Manish

[Former Member]

Hi Sunita,

If I got your requirement right,you can also satisfy this by using the MDM Qualified table.

- In you main table have a lookup field say license no in the main table.

- This will point to a qualified lookup table say License table

- In this table you will have two fields License no and Expiration date.

- The License no can be the Non Qualifier and the Expiration date the Qualifier.

- When you import themian table and the qualified table data correctly.

- So for every record you can see the license number in teh main table and when you seee its qualified details in the right hand side in data manager.You acn view the coresponding Quualifier value which in your case will be the Expiration date.

To know more on qualified importing you can refer the below links:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c03240fa-cc3e-2b10-aa9a-a5798e31...

If you have limited number of lcense number then the simpler way could be using the Calcualtion expression on which the value of teh license number will determine the Expiration date.

To know more on calculation importing you can refer the below links:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/102dc4e5-07c9-2910-93b3-f49c8ed5...

Hope it helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi Sunita,

Can you please explain your query in proper manner.

Assumption:

Vendor License is a lookup table cvontaining several values amongst which one is the license and when you select the Vendor License = License then Expirtation field should be displayed.

If the above assumption matches with your requirement then this can be achieved with the help of Taxonomy concept in MDM. You need to create a Taxonomy table and add the nodes in it which will be nothing but the lookup values of the Vendor License table and add the attribute Expiration Date linked with License node. Now whenever you will select License as a value for Taxonomy table you will get Expiration Date appeared else nothing will be displayed.

Regards,

Jitesh Talreja

[Former Member]

Do some work around in Assignments tab in Data Manager.

Thanks

Kiran