P_PURCONTRACTPRICEVARIANCE

Purchase Contract Price Variance 1 | view: PMMPCPRCVAR | Extraction: Not supported | Component: Reporting
Tables used: CDHDR, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, T001W, LFA1, CDPOS
Column Name Description
PurchaseContract FK Purchasing Contract Header
PurchaseContractItem Item Number of Purchasing Contract
ChangeDocument FK Change Number of Document
Column Name Description
ContractNetPriceAmount null
💲 Currency Key (ContractCurrency):
TargetAmount Target Value for Outline Agreement in Document Currency
Column Name Description
QuantityInBaseUnit null
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
Column Name Description
CreationDate Creation Date of Purchasing Document
DocumentChangeDate Creation Date of Purchasing Document
Column Name Description
Column Name Description Domain name
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
IsDocumentChanged null
NumberOfChanges null
NumberOfPriceChanges null
TotalNumberOfChanges null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_PURCONTRACTPRICEVARIANCE.MANDT == T001.MANDT
  • P_PURCONTRACTPRICEVARIANCE.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_PURCONTRACTPRICEVARIANCE.MANDT == TCURC.MANDT
  • P_PURCONTRACTPRICEVARIANCE.CONTRACTCURRENCY == TCURC.WAERS
Currency
  • Change documents, referenced currency
  • Client
  • P_PURCONTRACTPRICEVARIANCE.CURRENCY == TCURC.WAERS
  • P_PURCONTRACTPRICEVARIANCE.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • P_PURCONTRACTPRICEVARIANCE.MANDT == MARA.MANDT
  • P_PURCONTRACTPRICEVARIANCE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURCONTRACTPRICEVARIANCE.MANDT == T023.MANDT
  • P_PURCONTRACTPRICEVARIANCE.MATERIALGROUP == T023.MATKL
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_PURCONTRACTPRICEVARIANCE.MANDT == T006.MANDT
  • P_PURCONTRACTPRICEVARIANCE.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_PURCONTRACTPRICEVARIANCE.MANDT == T001W.MANDT
  • P_PURCONTRACTPRICEVARIANCE.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURCONTRACTPRICEVARIANCE.MANDT == T024.MANDT
  • P_PURCONTRACTPRICEVARIANCE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCONTRACTPRICEVARIANCE.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCONTRACTPRICEVARIANCE.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURCONTRACTPRICEVARIANCE.SUPPLIER == LFA1.LIFNR
  • P_PURCONTRACTPRICEVARIANCE.MANDT == LFA1.MANDT