is it possible to find which MIC's are assign to material?

[former_member934986]

any table or t code?

[Lakshmipathi]

Please go through this How to ask a Question before posting further queries and avoid using the subject as your content column

[former_member42743]

Use SQVI and link MAPL, PLKO, PLPO and PLMK in a query.

[former_member572818]

Hi Aniket,

please find below the tables of QM module which is using mostly.

QALS Inspection lot record

QAMB Link inspection lot - material document

QAVE Inspection usage decision

QDPS Inspection stages

QMAT Inspection type - material parameters

QINF Inspection info record (vendor - material)

QDQL Quality level QDPS Inspection stages

TQ80 Notification types

QMEL Quality notification

QMFE Quality notification – items

QMUR Quality notification – causes

QMSM Quality notification – tasks

QMMA Quality notification – activities

QMIH Quality message - maintenance data excerpt

QCVMT Certificate profile characteristic leveltexts

QCVM Certificate profile characteristic level

QCVK Certificate profile head

Master Data QMHU QM Link Between Inspection Lot and Handling Unit Item

Master Data QMTB Inspection method master record

Master Data QMTT Inspection Method Texts

Master Data QPAC Inspection catalog codes for selected sets

Master Data QPAM Inspection catalog selected sets

Master Data QPMK Inspection characteristic master

Master Data QPMT Master Inspection Characteristics Texts

Master Data QPMZ Assignment table - insp. methods/master insp. characteristic

Master Data TQ01D Authorization groups for QM master data

Master Data TQ01E Text authorization groups for QM master data

Master Data TQ21 Assignment of screens to screen groups

Master Data TQ25 QM:screen sequence for master and inspection characteristics

Inspection Plan PLKO Inspection plan Header

Inspection Plan MAPL Material Assignement

Inspection Plan PLPO Operation Details

Inspection Plan PLMK Inspection plan characteristics

Inspection Plan PLMW MAPL-Dependent Charac. Specifications (Inspection Plan)

Inspection Plan TQ03 QSS: Control for Screen Texts/TABLE NOT USED (Rel. 4.6)

Inspection Plan TQ29A Dependency tolerance key - nominal measurement

Inspection Plan TQ72 Type of share calculation

Inspection Plan TQ72T Texts for type of share calculation

Inspection Plan TQ75 QM formula parameters

Inspection Plan TQ75F Field names for QM formulas

Inspection Plan TQ75K Short text for Table TQ75F

Inspection Plan TQ75T Description of formula parameters

Thanks,

Dinesh

[former_member934986]

thnx a lot

[Amit_SAP]

Hi,

Kindly mention your question in detail.

1. Pass Material, Plant and task list type = "Q" into table MAPL to get group and group counter.

2. Now pass this task list type, Group and group counter into table PLMK to get MIC's assigned for this material

3. You can also use FM CP_EX_PLAN_READ PLNTY_IMP = Q, PLNNR_IMP = Group number, PLNAL_IMP = Group counter, STTAG_IMP = Explosion date, I_PLANT = Plant code and execute and check the entries in table PLMK_EXP.

Hope this will help you..!!

Regards,

Amit

[former_member572818]

Hi Aniket,

It's possible to check the MIC which is assigned to the material, if that material is related to purchasing material Incoming inspection or Finished product final inspection material, then you can check with the t.code QP03 Inspection plan display, if it is related to In-house production materials you can check the CA03 Routing display, click operation tab and select the each and every line item in which inspection characteristics was assigned.

Use PLKO table inspection plan header.

MAKL table for material assignment.

Thanks,

Dineshkumar S

[former_member934986]

hii dinesh

thank you for your reply

I have to check the MIC'S (master inspection cha.)assign to the material in mass so for that i required a table name

MAKL table is not there.