Query Flat Lookup Table in MDM using ABAP API

[former_member593687]

Hi All,

I need to extract a value from a Flat Lookup Table in MDM using ABAP API. For example, i would like to query the Lookup Table Countries and get the MDM_ID for the country PH. I used the mo_core_service->query but it is stating that the Countries table does not exist. I checked MDM and the name of the lookup table is Countries. What am i doing wrong?

Thanks.

Regards,

April

[Former Member]

Hi,

In mo_core_service->query, Put--> iv_object_type_code = 'XXX'

Where XXX is not the name of the lookup table that is Countries. Please Pass XXX here as Code of the Table. It may be Countries too or something else Check in Table Properties of MDM Console. Just try it with Code and revert with result.

Regards,

Mandeep Saini

[Former Member]

Hi,

For the parameter iv_object_type_code , pass the table code and not the table name. There will be a table code for each table in MDM. please check with the MDM team for the same.

Thanks,

Hima

[former_member182007]

Hi,

Check your MDM-ABAP server connection setting. if you can elobrate more like what steps you have followed on that it would make scenario more clear ?

moreover you can follow below link

it may help.

Deep