C_SuplrEvalByQuantityCube

Supplier Evaluation by Quantity Cube | view: CMMQUANTVARCUBE | TRAN | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, SEVADJSC, EKBE, EKBEH, T163B, SEWS_VAR_SCORE, LFA1, SEWS_SWITCH_C
Column Name Description
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Display Currency (DisplayCurrency):
QuantityVarianceInDspCrcy Quantity Variance in Display Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderedQuantity Ordered Quantity
GoodsReceiptQty null
QuantityVarianceInOrdUnit Quantity Variance in Order Unit
Column Name Description
PurOrdItmFirstGRPostingDate First Goods Receipt Date
PurOrdItmFinalGRPostingDate Final Goods Receipt Date
Column Name Description
SuplrEvalCritraDelivCompleted Delivery Completed Show values
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
QuantityVarianceScore Variance Score
QuantityVarianceInPctValue null
NumberOfPurchaseOrders Number of Purchase Orders
NumberOfPurchaseOrderItems Number of Purchase Order Items
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_SUPLREVALBYQUANTITYCUBE.COMPANYCODE == T001.BUKRS
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_SUPLREVALBYQUANTITYCUBE.COUNTRY == T005.LAND1
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == T005.MANDT
Material Number
  • Material Number
  • Client
  • C_SUPLREVALBYQUANTITYCUBE.MATERIAL == MARA.MATNR
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_SUPLREVALBYQUANTITYCUBE.MATERIALGROUP == T023.MATKL
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • C_SUPLREVALBYQUANTITYCUBE.PLANT == T001W.WERKS
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == T006.MANDT
  • C_SUPLREVALBYQUANTITYCUBE.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • C_SUPLREVALBYQUANTITYCUBE.PURCHASINGGROUP == T024.EKGRP
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_SUPLREVALBYQUANTITYCUBE.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == T024E.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region Key
  • Client
  • C_SUPLREVALBYQUANTITYCUBE.REGION == T005S.BLAND
  • C_SUPLREVALBYQUANTITYCUBE.COUNTRY == T005S.LAND1
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == T005S.MANDT
Supplier
  • Supplier
  • Client
  • C_SUPLREVALBYQUANTITYCUBE.SUPPLIER == LFA1.LIFNR
  • C_SUPLREVALBYQUANTITYCUBE.MANDT == LFA1.MANDT