To retrieve fieldcodes for a Lookup table's display field

[Former Member]

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

[Former Member]

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

[Greg_Austin]

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