C_PriceVarianceCube

Cube view for Sup Eval by Price | view: CMMASEQNCUBE | TRAN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
Column Name Description
💲 Display Currency (DisplayCurrency):
PriceVarianceAmount null
PurchaseOrderNetPriceAmount null
InvoicePrice null
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
DeliveredQuantity null
OrderedQuantity Purchase Order Quantity
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
PriceVarianceInPct null
PriceVarianceScore Variance Score
NumberOfPurchaseOrders Number of Purchase Orders
NumberOfPurchaseOrderItems Number of Purchase Order Items
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PRICEVARIANCECUBE.COMPANYCODE == T001.BUKRS
  • C_PRICEVARIANCECUBE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_PRICEVARIANCECUBE.CURRENCY == TCURC.WAERS
  • C_PRICEVARIANCECUBE.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • C_PRICEVARIANCECUBE.MATERIAL == MARA.MATNR
  • C_PRICEVARIANCECUBE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_PRICEVARIANCECUBE.MATERIALGROUP == T023.MATKL
  • C_PRICEVARIANCECUBE.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • C_PRICEVARIANCECUBE.PLANT == T001W.WERKS
  • C_PRICEVARIANCECUBE.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_PRICEVARIANCECUBE.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • C_PRICEVARIANCECUBE.MANDT == T006.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PRICEVARIANCECUBE.PURCHASINGGROUP == T024.EKGRP
  • C_PRICEVARIANCECUBE.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_PRICEVARIANCECUBE.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PRICEVARIANCECUBE.MANDT == T024E.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Supplier Country/Region
  • Client
  • C_PRICEVARIANCECUBE.REGION == T005S.BLAND
  • C_PRICEVARIANCECUBE.SUPPLIERCOUNTRY == T005S.LAND1
  • C_PRICEVARIANCECUBE.MANDT == T005S.MANDT
Supplier
  • Supplier
  • Client
  • C_PRICEVARIANCECUBE.SUPPLIER == LFA1.LIFNR
  • C_PRICEVARIANCECUBE.MANDT == LFA1.MANDT
Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_PRICEVARIANCECUBE.SUPPLIERCOUNTRY == T005.LAND1
  • C_PRICEVARIANCECUBE.MANDT == T005.MANDT