Material, Customer & Certificate profile link in table

[former_member491596]

Hi All

I develop one smart form for quality certificate.

But I am not able to find out the link between Material, Customer & Certificate profile.

One material can have more than one Certificate profiles with more than one Customer.

Now How I will find particular material with particular profile with a particular customer.

In which table these all data are storing.

On the basis of above condition MIC will print on Quality certificate.

Regards

ARK

[Former Member · Accepted solution]

Hi

you have to link 2 tables

Material and Customer stored in one table and Profile stored in another table.

the link is cond. record number

Table

KOTI002 & KONDI

check & let me know if it is not solved

thanks

[former_member491596 · Accepted solution]

Thanks Shami

ARK

[shubhphoenix · Accepted solution]

Hi, can you please also tell the table for the other combinations like Customer/Plant.

[Former Member]

Hi

Combination of these two tables would be help full to u

QCVK and KOTI002

In QCVK u will get the assigned form number also

Thanks

Shiva Patil

[Former Member]

Check FM

QC01_CERT_PROFILE_CHAR_TEXT

QC01_QCVM_SEL_FUNCTIONS_ASSIGN

QC04_VALUE_OUTPUT_CONTROL

QC06_QCVMT_MEM_GET_ONE_CHARACT