P_InvoicePriceVariance2

Invoice Price Variance 2 | view: PMMINVPRCVARC2 | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO, EKBE, EKBEH, T163B
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
MaterialDocumentYear Material Document Year
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
Column Name Description
NetPriceAmount Invoice Amount
InvoiceAmountInDocCurrency null
InvoiceAmtInDisplayCurrency Invoice Amount
Column Name Description
📏 Order Price Unit (Purchasing) (OrderPriceUnit):
QtyInPurchaseOrderPricUnit null
QtyInPurchaseOrderPriceUnit Quantity in purchase order price unit
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
DocNumber Document Type Show values
Column Name Description Domain name
NetPriceQuantity Price Unit DEC5
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_INVOICEPRICEVARIANCE2.MANDT == T006.MANDT
  • P_INVOICEPRICEVARIANCE2.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
  • P_INVOICEPRICEVARIANCE2.MANDT == T001.MANDT
  • P_INVOICEPRICEVARIANCE2.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_INVOICEPRICEVARIANCE2.MANDT == TCURC.MANDT
  • P_INVOICEPRICEVARIANCE2.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_INVOICEPRICEVARIANCE2.MANDT == MARA.MANDT
  • P_INVOICEPRICEVARIANCE2.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_INVOICEPRICEVARIANCE2.MANDT == T023.MANDT
  • P_INVOICEPRICEVARIANCE2.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_INVOICEPRICEVARIANCE2.ORDERPRICEUNIT == T006.MSEHI
  • P_INVOICEPRICEVARIANCE2.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • P_INVOICEPRICEVARIANCE2.MANDT == T001W.MANDT
  • P_INVOICEPRICEVARIANCE2.PLANT == T001W.WERKS
Purchase Order Type
  • Client
  • ?
  • Purchase Order Type
  • P_INVOICEPRICEVARIANCE2.MANDT == T161.MANDT
  • P_INVOICEPRICEVARIANCE2.[column in domain "BSTYP"] == T161.BSTYP
  • P_INVOICEPRICEVARIANCE2.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • P_INVOICEPRICEVARIANCE2.MANDT == T024.MANDT
  • P_INVOICEPRICEVARIANCE2.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_INVOICEPRICEVARIANCE2.MANDT == T024E.MANDT
  • P_INVOICEPRICEVARIANCE2.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_INVOICEPRICEVARIANCE2.MANDT == LFA1.MANDT
  • P_INVOICEPRICEVARIANCE2.SUPPLIER == LFA1.LIFNR