P_InfoRecordPriceVariance1

Info Record Price Variance 1 | view: PMMIRPRCVAR1 | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATECDHDREKKOEKPOEINAEINECDPOS
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
NetPrice null
ReleaseOrderItemNetAmount 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
NumberOfChanges null
NumberOfPriceChanges null
TotalNumberOfChanges null
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
MaterialPriceUnitQty Price unit DEC5
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_INFORECORDPRICEVARIANCE1.COMPANYCODE == T001.BUKRS
  • P_INFORECORDPRICEVARIANCE1.MANDT == T001.MANDT
Material Number
  • Client
  • Material Number
  • P_INFORECORDPRICEVARIANCE1.MANDT == MARA.MANDT
  • P_INFORECORDPRICEVARIANCE1.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • P_INFORECORDPRICEVARIANCE1.MATERIALGROUP == T023.MATKL
  • P_INFORECORDPRICEVARIANCE1.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • P_INFORECORDPRICEVARIANCE1.MANDT == T001W.MANDT
  • P_INFORECORDPRICEVARIANCE1.PLANT == T001W.WERKS
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_INFORECORDPRICEVARIANCE1.PURCHASEORDERPRICEUNIT == T006.MSEHI
  • P_INFORECORDPRICEVARIANCE1.MANDT == T006.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_INFORECORDPRICEVARIANCE1.PURCHASINGGROUP == T024.EKGRP
  • P_INFORECORDPRICEVARIANCE1.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_INFORECORDPRICEVARIANCE1.PURCHASINGORGANIZATION == T024E.EKORG
  • P_INFORECORDPRICEVARIANCE1.MANDT == T024E.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • P_INFORECORDPRICEVARIANCE1.SUPPLIER == LFA1.LIFNR
  • P_INFORECORDPRICEVARIANCE1.MANDT == LFA1.MANDT