Material Level Total Vendor Quality Rating (TVQR) Report

[Former Member]

Hi, In SAP QM there is ME61 standard report is available for vendor evalution

But i want This report at Vendor Evalution at material level

[Former Member · Accepted solution]

Hii,

Check ME6B- Evaluations per Material/Material Group. Here u can find analysis & Q-score based on material and mat group wise inrelation with the vendor. Else u maintain Mat group wise selection.

ME6H - Standard Analysis

Check and Revert back.

Edited by: Lokesh K on Oct 19, 2010 4:18 PM

[Former Member · Accepted solution]

I cheched.

My requirement is that

Input Field

We are getting quality rating in details after Bifurcation into four components as below at Vendor and Plant level (ME61)

1. GR Inspection

2. Rejection / complaint

3. Audit

4. TQR

This type of report is needed for Material + Vendor + Plant combination.

and out put in alv format

Output screen u2013

Material GR Inspection Rejection/Complaint Audit QMS Rating Material Level TVQR

1

2

3

4

for this i want table name and logic

[Former Member · Accepted solution]

Hii ,

Check these tables

T147 - Control table for vendor evaluation

T147A - Definition for main criteria

T147B - Text for main criteria

T147K - Assignment: Percentage X Score

T147L - Intervals for quantity reliability

T147M - Definition of scope of list

T147N - Text for scope of list

T027C - specifies the points scores for compliance

Aslo check

QMFEL - Defect data records for the inspection lot

QPCT - Code texts

Above u'll get info on rejection records. These info u can pass thru Table QALS where u'll get all header information reg Inspection lot.

[Former Member · Accepted solution]

Hi Gurus,

we have use

Object Name

Field Short Text Data Element

/ Field Type Field Length Additional info

T001W-WERKS Plant WERKS_D CHAR- 4 Mandatory

MARA-MATNR Material MATNR CHAR-18 Mandatory

LFA1- LIFNR Account Number of Vendor LIFNR CHAR-10 Non-Mandatory

S068- SPMON Period to analyze - month SPMON NUMC-6 Mandatory

S068-ART Inspection Type QPART CHAR-8

S068- LIFNR Vendor Account Number ELIFN CHAR-10

S068-KLASSE_A Absolute Frequency of Quality Score Class A QKLASSE_A INT4-10

S068-KLASSE_B Absolute Frequency of Quality Score Class B QKLASSE_B INT4-10

S068-KLASSE_C Absolute Frequency of Quality Score Class C QKLASSE_C INT4-10

S068-KLASSE_D Absolute Frequency of Quality Score Class D QKLASSE_D INT4-10

S068-KLASSE_E Absolute Frequency of Quality Score

Class E QKLASSE_D INT4-10

S068-ZHLSELECT Number of Summarized Inspection Lots (Without Cancellation) QZHLSELECT INT4-10

QMEL-QMART Notification Type QMART CHAR-2

QMEL-QMDAB Date for Notification Completion QMDAB DATS-8

S012-SPMON Period to analyze - month SPMON NUMC-6

S012-LIFNR Vendor Account Number ELIFN CHAR-10

S012-WERKS Plant EWERK CHAR-4

S012-MATNR Material Number MATNR CHAR-18

S012-REWRT Invoice Amount MC_REWRT CURR-15

score wtg M all this are getting calculated from elbp, t147i,t147e, t147c

in elbp table vendor is there

from where I will get the materia?

[Former Member · Accepted solution]

Hii,

This type of report is needed for Material + Vendor + Plant combination.
and out put in alv format
Output screen u2013

Material GR Inspection Rejection/Complaint Audit QMS Rating Material Level TVQR
1
2
3
4
for this i want table name and logic

I think u r tracking Qscore w.r.t GR Inspection, u can track material no, mat doc , P.O no & Vendor no in QALS table & the same cam be linked to elbp table. Chk & revert back.

[Former Member]

Thanks