Skip to Content
avatar image
Former Member

To retrieve fieldcodes for a Lookup table's display field

Hi All,

In MDM, I have a main table and one field of that main table is a lookup field.

Now from FieldProperties object I can obtain the lookup table Id using LookupFieldPropertiesobject.getLookupTableId().

Now inside this lookup table say we have 4 fields:

- Name (Display Field)

- Code ( Display Field)

- Email

- Phone number, where Name and Code are display fields as mentioned in MDM console.

Now, which API we can use here to retrieve the display fields codes/ fieldIds?

Regards,

Richa Sinha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 29, 2009 at 03:27 PM

    Hi Richa,

    I would take a look at the RepositorySchema class. Using this class you can get a TableSchema for your table since you already have the TableId by using the getTableSchema method. The TableSchema class has methods like getFieldIds which will give you an array of FieldIds and getDisplayFieldIds that will give you an array of FieldIds for only the display fields. You can also get FieldProperties objects for fields, this class will give you pretty much any information you need about the field.

    -Greg

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2010 at 04:52 PM

    Hello Richa,

    Could you please explain me the scenario? WHy you need to do it programatically? Why can not you use standard MDM functionality?

    It will help me understand your issue.

    Shakil

    SAP USA. PA

    Add comment
    10|10000 characters needed characters exceeded