C_SuplrEvalByQltyNotifQry

By Quality Notification | view: CMMASEBYQNQRY | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
Column Name Description
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
QualityNotificationCount null
PurchaseOrderItemUniqueID null
UniqueIntSourcingRequest null
SuplrEvalCalculatedScoreValue Calculated Score
NumberOfPurchaseOrders Number of Purchase Orders
NmbrOfPurchaseOrderItemsWithGR Number of Purchase Order Items
NmbrOfPOItemWithQltyNotifScr null
QualityNotifVarianceScoreValue null
QltyNotifScrRltvToPOWthGRValue Relative score of a Supplier
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_SUPLREVALBYQLTYNOTIFQRY.MANDT == T001.MANDT
  • C_SUPLREVALBYQLTYNOTIFQRY.COMPANYCODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • C_SUPLREVALBYQLTYNOTIFQRY.MANDT == MARA.MANDT
  • C_SUPLREVALBYQLTYNOTIFQRY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPLREVALBYQLTYNOTIFQRY.MANDT == T023.MANDT
  • C_SUPLREVALBYQLTYNOTIFQRY.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_SUPLREVALBYQLTYNOTIFQRY.MANDT == T001W.MANDT
  • C_SUPLREVALBYQLTYNOTIFQRY.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • C_SUPLREVALBYQLTYNOTIFQRY.MANDT == T024.MANDT
  • C_SUPLREVALBYQLTYNOTIFQRY.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_SUPLREVALBYQLTYNOTIFQRY.MANDT == T024E.MANDT
  • C_SUPLREVALBYQLTYNOTIFQRY.PURCHASINGORGANIZATION == T024E.EKORG
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Supplier Country/Region
  • C_SUPLREVALBYQLTYNOTIFQRY.MANDT == T005S.MANDT
  • C_SUPLREVALBYQLTYNOTIFQRY.REGION == T005S.BLAND
  • C_SUPLREVALBYQLTYNOTIFQRY.SUPPLIERCOUNTRY == T005S.LAND1
Supplier
  • Client
  • Supplier
  • C_SUPLREVALBYQLTYNOTIFQRY.MANDT == LFA1.MANDT
  • C_SUPLREVALBYQLTYNOTIFQRY.SUPPLIER == LFA1.LIFNR
Supplier Country/Region
  • Client
  • Supplier Country/Region
  • C_SUPLREVALBYQLTYNOTIFQRY.MANDT == T005.MANDT
  • C_SUPLREVALBYQLTYNOTIFQRY.SUPPLIERCOUNTRY == T005.LAND1