P_InfoRecordPriceVariance

Info Record Price Variance | view: PMMIRPRCVAR | Extraction: Not supported | Component: Reporting
Tables used: CDHDREINAEINECDPOS
Column Name Description
PurchasingInfoRecord Number of purchasing info record
PurchasingInfoRecordCategory Purchasing info record category Show values
PurchasingOrganization FK Purchasing organization
Plant FK Plant
ChangeDocument FK Change Number of Document
Column Name Description
💲 Change documents, referenced currency (Currency):
IRNetPriceAmount Net Price in Purchasing Info Record
NetPriceAmount null
Column Name Description
QuantityInBaseUnit null
Column Name Description
CreationDate Date on which the record was created
DocumentChangeDate Creation date of the change document
Column Name Description
PurchasingInfoRecordCategory Purchasing info record category Show values
Column Name Description Domain name
MaterialPriceUnitQty Price unit DEC5
IsDocumentChanged null
NumberOfChanges null
NumberOfPriceChanges null
Master Data Relations Join Conditions
Currency
  • Change documents, referenced currency
  • Client
  • P_INFORECORDPRICEVARIANCE.CURRENCY == TCURC.WAERS
  • P_INFORECORDPRICEVARIANCE.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • P_INFORECORDPRICEVARIANCE.MANDT == MARA.MANDT
  • P_INFORECORDPRICEVARIANCE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_INFORECORDPRICEVARIANCE.MANDT == T023.MANDT
  • P_INFORECORDPRICEVARIANCE.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_INFORECORDPRICEVARIANCE.MANDT == T001W.MANDT
  • P_INFORECORDPRICEVARIANCE.PLANT == T001W.WERKS
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_INFORECORDPRICEVARIANCE.PURCHASEORDERPRICEUNIT == T006.MSEHI
  • P_INFORECORDPRICEVARIANCE.MANDT == T006.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_INFORECORDPRICEVARIANCE.PURCHASINGGROUP == T024.EKGRP
  • P_INFORECORDPRICEVARIANCE.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_INFORECORDPRICEVARIANCE.MANDT == T024E.MANDT
  • P_INFORECORDPRICEVARIANCE.PURCHASINGORGANIZATION == T024E.EKORG
Vendor's account number
  • Client
  • Vendor's account number
  • P_INFORECORDPRICEVARIANCE.MANDT == LFA1.MANDT
  • P_INFORECORDPRICEVARIANCE.SUPPLIER == LFA1.LIFNR