Finding Material Group Custom Data in ME database

[Former Member]

I am using ME 6.0.4, MII 12.2., and Oracle 11.2

I would like to use a SQL Query in MII to retrieve Material Group Custom Data from the ME (WIP) database.

In what table(s) can I find this data?

[sergiy_katerinich · Accepted solution]

Hi,

Please try CUSTOM_FIELDS and CUSTOM_FIELD_DEF tables.

Regards,

Sergiy

[sergiy_katerinich · Accepted solution]

BTW such information is provided within Object and Database Guide delivered within documentation package of SAP ME SDK. Once you are developing requests to ME databases, you might find this document quite useful.

[Former Member · Accepted solution]

Thank you Sergiy, but the Custom Data that I created in ME doesn't appear in those tables.

[Former Member · Accepted solution]

Don't you need to install the SDK in order to access that documentation?

[sergiy_katerinich · Accepted solution]

You need to download the installation package and then either install it or extract the file by means of WinRAR for example.

[Former Member · Accepted solution]

Kevin

It is in the custom_fields table.

custom_fields.handle = handle of the material group (it will be of the format ItemGroupBO:...)

custom_fields.attribute = your custom field name

custom_fields.value =  custom field contents

[sergiy_katerinich · Accepted solution]

Kevin,

Just checked in 6.0.4.2. The data does appear in those tables.

Or you are talking about something different, not fields defined in Custom Data Maintenance.

Regards,

Sergiy

[Former Member · Accepted solution]

I apologize, Sergiy.  I did finally find the data.  When I ran my query without a filter on those fields, MII did not show my data, but when I filtered the query, I found it.

Thank you everyone for your help.

Kevin

[Former Member · Accepted solution]

Thanks

Regards,

Santhosh K