P_InvoicePriceVariance1

Invoice Price Variance 1 | view: PMMINVPRCVARC1 | 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
AccountAssignmentNumber Sequential Number of Account Assignment
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
MaterialDocumentYear Material Document Year
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
Column Name Description
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
InvoiceAmountInDocCurrency null
Column Name Description
Quantity Quantity
QtyInPurchaseOrderPriceUnit Quantity in purchase order price unit
QuantityInBaseUnit Quantity
QtyInPurchaseOrderPricUnit null
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
DebitCreditCode Debit/Credit Indicator Show values
IsReturnsItem Returns Item Show values
Column Name Description Domain name
OrderItemQtyToBaseQtyDnmntr Denominator for Conversion of Order Unit to Base Unit UMBSN
OrderItemQtyToBaseQtyNmrtr Numerator for Conversion of Order Unit to Base Unit UMBSZ
NetPriceQuantity Price Unit DEC5
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_INVOICEPRICEVARIANCE1.MANDT == T006.MANDT
  • P_INVOICEPRICEVARIANCE1.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
  • P_INVOICEPRICEVARIANCE1.MANDT == T001.MANDT
  • P_INVOICEPRICEVARIANCE1.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_INVOICEPRICEVARIANCE1.MANDT == TCURC.MANDT
  • P_INVOICEPRICEVARIANCE1.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_INVOICEPRICEVARIANCE1.MANDT == MARA.MANDT
  • P_INVOICEPRICEVARIANCE1.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_INVOICEPRICEVARIANCE1.MANDT == T023.MANDT
  • P_INVOICEPRICEVARIANCE1.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • P_INVOICEPRICEVARIANCE1.MANDT == T006.MANDT
  • P_INVOICEPRICEVARIANCE1.ORDERPRICEUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_INVOICEPRICEVARIANCE1.MANDT == T001W.MANDT
  • P_INVOICEPRICEVARIANCE1.PLANT == T001W.WERKS
Purchase Order Type
  • Client
  • Purchase Order Type
  • ?
  • P_INVOICEPRICEVARIANCE1.MANDT == T161.MANDT
  • P_INVOICEPRICEVARIANCE1.PURCHASEORDERTYPE == T161.BSART
  • P_INVOICEPRICEVARIANCE1.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_INVOICEPRICEVARIANCE1.PURCHASINGGROUP == T024.EKGRP
  • P_INVOICEPRICEVARIANCE1.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_INVOICEPRICEVARIANCE1.MANDT == T024E.MANDT
  • P_INVOICEPRICEVARIANCE1.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_INVOICEPRICEVARIANCE1.MANDT == LFA1.MANDT
  • P_INVOICEPRICEVARIANCE1.SUPPLIER == LFA1.LIFNR