P_PriceVariance3

Price Variance 3 | view: PMMPRICEVAR3 | 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):
PurchaseOrderNetPriceAmount Purchase Order Net Price Amount
InvoicePrice Invoice Price per Order Unit
PriceVarianceAmount Price Variance Amount
Column Name Description
DeliveredQuantity null
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderedQuantity Purchase Order Quantity
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
PriceVarianceInPct null
SupplierEvaluationScore Variance Score
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_PRICEVARIANCE3.MANDT == T001.MANDT
  • P_PRICEVARIANCE3.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_PRICEVARIANCE3.MANDT == TCURC.MANDT
  • P_PRICEVARIANCE3.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_PRICEVARIANCE3.MANDT == MARA.MANDT
  • P_PRICEVARIANCE3.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PRICEVARIANCE3.MANDT == T023.MANDT
  • P_PRICEVARIANCE3.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PRICEVARIANCE3.MANDT == T001W.MANDT
  • P_PRICEVARIANCE3.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PRICEVARIANCE3.MANDT == T006.MANDT
  • P_PRICEVARIANCE3.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group
  • Client
  • Purchasing Group
  • P_PRICEVARIANCE3.MANDT == T024.MANDT
  • P_PRICEVARIANCE3.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • P_PRICEVARIANCE3.MANDT == T024E.MANDT
  • P_PRICEVARIANCE3.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_PRICEVARIANCE3.MANDT == LFA1.MANDT
  • P_PRICEVARIANCE3.SUPPLIER == LFA1.LIFNR