Table for Quality certificates

[Former Member]

Hi QM Guys,

Can anybody tell me what is the table name in which quality certificate is stored?

I am searching particularly for certificate number.

S Dey

[Former Member · Accepted solution]

Quality Certificates QCPR QM quality certificates in procurement 
Quality Certificates I000 Conditions for certificate profile 
Quality Certificates KONDI Conditions: Data part for certificates 
Quality Certificates QCVK Certificate profile header 
Quality Certificates QCVM Certificate profile characteristic level 
Quality Certificates QCVMT Certificate profile characteristic level: texts
Quality Certificates QCVV Certificate Profile: List of Preliminary Products 
Quality Certificates TQ61 Result value origin for certificates 
Quality Certificates TQ61T Origin of result values for certificates: texts 
Quality Certificates TQ62 Output strategy for skip characteristics 
Quality Certificates TQ62T Output strategy for skip characteristics: texts 
Quality Certificates TQ63 Origin of insp. specs for certificates (function modules) 
Quality Certificates TQ63T Origin of inspection specifications for certificates: texts 
Quality Certificates TQ64 Origin of characteristic short text for certificates 
Quality Certificates TQ64T Origin of characteristic short text for certificates: texts 
Quality Certificates TQ65 Certificates: Combinations allowed for origins, specs/values 
Quality Certificates TQ67 Certificate-Relevant Output Types 

[Former Member · Accepted solution]

Hi Baiju and Saurabh,

Thanks for your reply.

QCPR table shows certificate number for certificates in procurement.

I want the table where certificates for batch /inspection lot or delivery are saved.

I want to search any batch or inspection lot or delivery for which already COA is created.

How can i search such batch / inspection lot or delivery.

[john_lutz · Accepted solution]

I don't know of any way to get this for a CoA for a batch or insp lot, but you might be able to use table NAST to see the message status on a CoA for delivery....

Good luck

[sahil_bhardwaj · Accepted solution]

Hello Sarves,

Check in table KONDI with the relevant condition record.

Thanks

[baiju_kumar2]

You can use table QCPR for certificate number..