MDM Java API:Extracting Values from Qualified Lookup table

[Former Member]

I have a requirement where my mulivalued data is stored in <i>Qualified Lookup Flat table</i> and I need to extract the data using JAVA API. Can anyone throw some light on how I can do the same?

[Former Member · Accepted solution]

Hi,

Please take a look at my weblog to see how to get started.

/people/udi.katz/blog/2005/08/21/retrieving-data-from-mdm-server-using-the-mdm-java-api

Regards,

Udi

[Former Member · Accepted solution]

Hi,

I have exactly the same requirement and unfortunately the weblogs does not answer to the question : how do I extract data stored in a qualified table with the APIs.

thanks for your help

Nicolas

[Former Member · Accepted solution]

Hi Nicolas,

The CatalogData class has a few variations of a method called getQualifiedLinks. It requires at least the table id of the table that contains the qualified lookup field, the record id of the record for which you want to get the qualified data and the field id of the qualified lookup field. It returns an array of qualified records that you can iterate through and get the qualifiers for each record. This is all contained in the javadoc that comes with the Java API installation on http://service.sap.com

Hope this helps,

Richard

[Former Member · Accepted solution]

Hi Richard,

Thanks a lot for your answer, it works fine.

One other thing we have to do is :

Starting with a value of the qualified table, we want to get the corresponding products.

i.e. : EAN = 1234567890988 => search => products A,B and C

[Former Member · Accepted solution]

Hi Nicolas,

1. Set the search table to the main table.

Search.SetSearchTable(String)

2. Create a FreeFormTableParameter that points to the qualified lookup table.

Search.GetParameters().NewFreeFormTableParameter(String)

3. Create a FreeFormParameterField that points to the field in the qualified table you want to search for.

FreeFormTableParameter.GetFields().New(FreeFormTableParameter)

4. Specify the string to search for and what kind of search.

FreeFormParameterField.GetFreeForm().NewString(String, SearchType);

5. Add the parameter field to the table parameter

FreeFormTableParameter.Add(FreeFormParameterField)

6. Execute the search.

Hope this helps...

Richard