MIC groups in CG02 transaction

[Former Member]

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

[Former Member]

Hello,

Under which property tree you are assigning MIC characteristics?

Regards,

Pavan

[Former Member]

HI Pavan,

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

But right now i'm using ZGENERAL and ZLIPID.

[Former Member]

Hi Vishnu,

Please check the following:

Table Name QAMV

Field Name VERWMERKM

Data Element QMERKNR

Regards,

Pavan

[Former Member]

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)?

[Former Member]

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

[Former Member]

Hi Jayakumar,

thanks for writing.

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

[Former Member]

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