C_SuplrEvalByQualityCube

Supplier Evaluation by Quality | view: CSUPEVALQLTYCUBE | TRAN | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, QALS, QAVE, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, JSTO, JEST, SEVADJSC, ADCP, ADRC, T005, T005T, LFA1
Column Name Description
InspectionLot Inspection Lot Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CountryName Country/Region Name TEXT50
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
InspectionLotQualityScore Variance Score
NumberOfPurchaseOrders Number of Purchase Orders
NumberOfPurchaseOrderItems Number of Purchase Order Items
NumberOfInspectionLots Number of Purchase Order Items
PurchaseOrderItemUniqueID Concatenation of EBELN and EBELP PURCHASINGDOCUMENTITEMUNIQUEID
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_SUPLREVALBYQUALITYCUBE.COMPANYCODE == T001.BUKRS
  • C_SUPLREVALBYQUALITYCUBE.MANDT == T001.MANDT
Material Number
  • Client
  • Material Number
  • C_SUPLREVALBYQUALITYCUBE.MANDT == MARA.MANDT
  • C_SUPLREVALBYQUALITYCUBE.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_SUPLREVALBYQUALITYCUBE.MATERIALGROUP == T023.MATKL
  • C_SUPLREVALBYQUALITYCUBE.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • C_SUPLREVALBYQUALITYCUBE.MANDT == T001W.MANDT
  • C_SUPLREVALBYQUALITYCUBE.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • C_SUPLREVALBYQUALITYCUBE.PURCHASINGGROUP == T024.EKGRP
  • C_SUPLREVALBYQUALITYCUBE.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_SUPLREVALBYQUALITYCUBE.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SUPLREVALBYQUALITYCUBE.MANDT == T024E.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Supplier Country/Region
  • Client
  • C_SUPLREVALBYQUALITYCUBE.REGION == T005S.BLAND
  • C_SUPLREVALBYQUALITYCUBE.SUPPLIERCOUNTRY == T005S.LAND1
  • C_SUPLREVALBYQUALITYCUBE.MANDT == T005S.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • C_SUPLREVALBYQUALITYCUBE.SUPPLIER == LFA1.LIFNR
  • C_SUPLREVALBYQUALITYCUBE.MANDT == LFA1.MANDT
Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_SUPLREVALBYQUALITYCUBE.SUPPLIERCOUNTRY == T005.LAND1
  • C_SUPLREVALBYQUALITYCUBE.MANDT == T005.MANDT