P_PurchaseOrderPriceVariance

Purchase Order Price Variance | view: PMMPOPRICEVAR | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, EKKO, EKPO
Column Name Description
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
NetPriceAmount Material Price
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
QuantityInBaseUnit null
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
DocNumber Document Type Show values
Column Name Description Domain name
NetPriceQuantity Price Unit DEC5
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
YearQuarter Year Quarter NUM5
YearMonth Year Month NUM6
YearWeek Year Week NUM6
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.COMPANYCODE == T001.BUKRS
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.DOCUMENTCURRENCY == TCURC.WAERS
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == MARA.MANDT
  • P_PURCHASEORDERPRICEVARIANCE.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.MATERIALGROUP == T023.MATKL
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.ORDERPRICEUNIT == T006.MSEHI
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == T001W.MANDT
  • P_PURCHASEORDERPRICEVARIANCE.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == T006.MANDT
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.PURCHASEORDERTYPE == T161.BSART
  • P_PURCHASEORDERPRICEVARIANCE.[column in domain "BSTYP"] == T161.BSTYP
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.PURCHASINGINFORECORD == EINA.INFNR
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURCHASEORDERPRICEVARIANCE.SUPPLIER == LFA1.LIFNR
  • P_PURCHASEORDERPRICEVARIANCE.MANDT == LFA1.MANDT