Question Re: MIC groups in CG02 transaction in Product Lifecycle Management Q&A

MIC groups in CG02 transaction

Former Member — Wed, 06 Jan 2010 10:53:11 GMT

Hi,

In CG02 transaction while assigning substance characteristics, We have MIC(Master Inspection Characteristic) group and corresponding MICs.

In Which table these groups and corresponding MICs are stored? Or is there any FM to fetch MICs corresponding to an MIC groups?

Thanks

Vishnu

Re: MIC groups in CG02 transaction

Former Member — Mon, 11 Jan 2010 08:27:15 GMT

Hello,

Under which property tree you are assigning MIC characteristics?

Regards,

Pavan

Re: MIC groups in CG02 transaction

Former Member — Mon, 11 Jan 2010 10:43:55 GMT

HI Pavan,

Functional requirement says, it can be under any property tree.

But right now i'm using ZGENERAL and ZLIPID.

Re: MIC groups in CG02 transaction

Former Member — Mon, 11 Jan 2010 11:13:36 GMT

Hi Vishnu,

Please check the following:

Table Name QAMV

Field Name VERWMERKM

Data Element QMERKNR

Regards,

Pavan

Re: MIC groups in CG02 transaction

Former Member — Mon, 11 Jan 2010 11:35:14 GMT

Thanks Pavan. Let me put my question in a crude wayby taking an example.

In "GENERAL" Property tree, in Chemical (node), Quantitative(subnode),

I have an MIC group called "NUTRIENT AMOUT".

MIC as "10000052" and MIC description as "SUGAR CONTENT".

Now i wanna do reverse engineering. I want to know

1) in which table and which field "NUTRIENT AMOUNT" Is stored.

2) An MIC group consists of a set of MICs. where are these MICs stored(with respect to "NUTRIENT AMOUNT" MIC group) ?

3) Is there any clear link to establish between MIC and corresponding MIC group(In database tables)?

Re: MIC groups in CG02 transaction

Former Member — Mon, 11 Jan 2010 12:19:47 GMT

Hello vishnu,

Based on your explanation - Here's what I could find out

Name of the Property Tree is "General" or Lipid- it is custom developed property with classes and characteristics assigned to custom value assignments.

Node without class is Chemical - for identification of entries

Quatiative is a Value assignment - Class with Characteritics

Nutrient amount and Nutrient Description - is characterstics for the class.

1) in which table and which field "NUTRIENT AMOUNT" Is stored.

Since you are maintaining data in Specification database - it should be available in standard specification dabase tables - check EST* tables.

2) An MIC group consists of a set of MICs. where are these MICs stored(with respect to "NUTRIENT AMOUNT" MIC group) ?

You have something called Inspection chracterstics in QM module under "Basic Data" section of QM (QS21) there you maintain inspection and insptection characteristics

3) Is there any clear link to establish between MIC and corresponding MIC group(In database tables)?

You maintain MIC group during MIC step above. You check with standard QM database stables to check the entries.

I understand you are maintaining data in General / Lipid property tree to create Inspection plans, so please check in Inspection Plan standard tables in QM.

Thanks and Regards

Jayakumar

Re: MIC groups in CG02 transaction

Former Member — Mon, 11 Jan 2010 13:14:31 GMT

Hi Jayakumar,

thanks for writing.

But i've hit a dead end. No break through from QS21 transaction. neither from any tables.

Re: MIC groups in CG02 transaction

Former Member — Mon, 11 Jan 2010 16:14:28 GMT

Hello vishnu,

Navigate to Quatiative - node and press F1 key or navigate to characteristics and check the technical details. Note the field name and do where used search for the field name.

Take some ABAP support for doing "where used" search.

Thanks

Jayakumar