P_PriceAndQuantityVariance1

Price And Quantity Variance 1 | view: PMMPRCQNTYVAR1 | Extraction: Not supported | Component: Reporting
Tables used: /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKBE, EKBEH, T163B
Column Name Description
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Currency Key (Currency):
NetAmount Net Order Value in PO Currency
Column Name Description
DeliveredQuantity null
Column Name Description
PurOrdItmFirstGRPostingDate First Goods Receipt Date
PurOrdItmFinalGRPostingDate Final Goods Receipt Date
PurchaseOrderDate Purchase Order Date
Column Name Description
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
Column Name Description Domain name
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
NetPriceAmount null
NetPriceQuantity Price Unit DEC5
AbsolutePriceVariance null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == T001.MANDT
  • P_PRICEANDQUANTITYVARIANCE1.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == TCURC.MANDT
  • P_PRICEANDQUANTITYVARIANCE1.CURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • P_PRICEANDQUANTITYVARIANCE1.MATERIAL == MARA.MATNR
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PRICEANDQUANTITYVARIANCE1.MATERIALGROUP == T023.MATKL
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == T001W.MANDT
  • P_PRICEANDQUANTITYVARIANCE1.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PRICEANDQUANTITYVARIANCE1.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == T006.MANDT
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • P_PRICEANDQUANTITYVARIANCE1.PURCHASEORDERTYPE == T161.BSART
  • P_PRICEANDQUANTITYVARIANCE1.[column in domain "BSTYP"] == T161.BSTYP
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == T024.MANDT
  • P_PRICEANDQUANTITYVARIANCE1.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_PRICEANDQUANTITYVARIANCE1.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • P_PRICEANDQUANTITYVARIANCE1.MANDT == LFA1.MANDT
  • P_PRICEANDQUANTITYVARIANCE1.SUPPLIER == LFA1.LIFNR