P_PurContractPriceVariance1

Purchase Contract Price Variance 1 | view: PMMPCPRCVAR1 | 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
NetPriceQuantity Price Unit DEC5
IsDocumentChanged null
NumberOfChanges null
NumberOfPriceChanges null
TotalNumberOfChanges null
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_PURCONTRACTPRICEVARIANCE1.COMPANYCODE == T001.BUKRS
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_PURCONTRACTPRICEVARIANCE1.CONTRACTCURRENCY == TCURC.WAERS
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == TCURC.MANDT
Currency
  • Client
  • Change documents, referenced currency
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == TCURC.MANDT
  • P_PURCONTRACTPRICEVARIANCE1.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == MARA.MANDT
  • P_PURCONTRACTPRICEVARIANCE1.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == T023.MANDT
  • P_PURCONTRACTPRICEVARIANCE1.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_PURCONTRACTPRICEVARIANCE1.ORDERPRICEUNIT == T006.MSEHI
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == T006.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PURCONTRACTPRICEVARIANCE1.ORDERQUANTITYUNIT == T006.MSEHI
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == T001W.MANDT
  • P_PURCONTRACTPRICEVARIANCE1.PLANT == T001W.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCONTRACTPRICEVARIANCE1.PURCHASINGGROUP == T024.EKGRP
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCONTRACTPRICEVARIANCE1.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURCONTRACTPRICEVARIANCE1.SUPPLIER == LFA1.LIFNR
  • P_PURCONTRACTPRICEVARIANCE1.MANDT == LFA1.MANDT