P_InvoicePriceVariance

Invoice Price Variance | view: PMMINVPRCVARC | Extraction: Not supported | Component: Reporting
Column Name Description
MaterialDocumentYear Material Document Year
Invoice Invoice Number
MaterialDocumentItem Item in Material Document
Column Name Description
NetPriceAmount null
InvoiceAmtInDisplayCurrency null
Column Name Description
QtyInPurchaseOrderPriceUnit null
Column Name Description
InvoiceDate Invoice Date in Document
Column Name Description
DocNumber Document Type Show values
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
YearWeek Year Week NUM6
YearMonth Year Month NUM6
YearQuarter Year Quarter NUM5
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
NetPriceQuantity Price Unit DEC5
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_INVOICEPRICEVARIANCE.COMPANYCODE == T001.BUKRS
  • P_INVOICEPRICEVARIANCE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_INVOICEPRICEVARIANCE.CURRENCY == TCURC.WAERS
  • P_INVOICEPRICEVARIANCE.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • P_INVOICEPRICEVARIANCE.MATERIAL == MARA.MATNR
  • P_INVOICEPRICEVARIANCE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_INVOICEPRICEVARIANCE.MATERIALGROUP == T023.MATKL
  • P_INVOICEPRICEVARIANCE.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_INVOICEPRICEVARIANCE.ORDERPRICEUNIT == T006.MSEHI
  • P_INVOICEPRICEVARIANCE.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • P_INVOICEPRICEVARIANCE.PLANT == T001W.WERKS
  • P_INVOICEPRICEVARIANCE.MANDT == T001W.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_INVOICEPRICEVARIANCE.PURCHASINGGROUP == T024.EKGRP
  • P_INVOICEPRICEVARIANCE.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_INVOICEPRICEVARIANCE.PURCHASINGORGANIZATION == T024E.EKORG
  • P_INVOICEPRICEVARIANCE.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_INVOICEPRICEVARIANCE.SUPPLIER == LFA1.LIFNR
  • P_INVOICEPRICEVARIANCE.MANDT == LFA1.MANDT