P_PriceVariance4

Price Variance 4 | view: PMMPRICEVAR4 | Extraction: Not supported | Component: Reporting
Tables used: EKKOEKPOEKBEEKBEHT163B
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
NetAmount Net Order Value in PO Currency
PurchaseOrderAmount Invoice Value Entered (in Local Currency)
InvoiceAmountInDocCurrency null
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Quantity Quantity
QtyInPurchaseOrderPricUnit null
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
NetPriceQuantity Price Unit DEC5
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_PRICEVARIANCE4.COMPANYCODE == T001.BUKRS
  • P_PRICEVARIANCE4.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_PRICEVARIANCE4.MANDT == TCURC.MANDT
  • P_PRICEVARIANCE4.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • P_PRICEVARIANCE4.MATERIAL == MARA.MATNR
  • P_PRICEVARIANCE4.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PRICEVARIANCE4.MATERIALGROUP == T023.MATKL
  • P_PRICEVARIANCE4.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • P_PRICEVARIANCE4.PLANT == T001W.WERKS
  • P_PRICEVARIANCE4.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PRICEVARIANCE4.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_PRICEVARIANCE4.MANDT == T006.MANDT
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • P_PRICEVARIANCE4.PURCHASEORDERTYPE == T161.BSART
  • P_PRICEVARIANCE4.[column in domain "BSTYP"] == T161.BSTYP
  • P_PRICEVARIANCE4.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PRICEVARIANCE4.PURCHASINGGROUP == T024.EKGRP
  • P_PRICEVARIANCE4.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PRICEVARIANCE4.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PRICEVARIANCE4.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PRICEVARIANCE4.SUPPLIER == LFA1.LIFNR
  • P_PRICEVARIANCE4.MANDT == LFA1.MANDT