C_MaterialPriceVariance

Material Price Variance | view: CMMMATLPRCVAR | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, CDHDR, EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, MATDOC_EXTRACT, FMLT_PRICE, CKMLCR, CKMLCR, EKBE, EKBEH, EKKO, EKPO, MARA, T001, TKA02, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, MBEWH, T001, T001K, CKMLHD, T001K, T001W, MARA, T163B, T024, EINA, T024E, T161, T162, EINE, LFA1, PRPS, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, T001W, FINSC_CURTYPE, CKMLHD, CKMLPR, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, CKMLHD, T001K, CKMLHD, MARV, MARV, FINSC_CURTYPET, FINSC_VALSUBTYPT, FINSC_VALUTYPT, CDPOS, FINSC_ACTVE_APPL, /SAPSLL/TUNOS, FMLC_TOGGLE, FMLT_CURTP_ML
Column Name Description
PurchasingDocument FK Purchasing Document
PurchasingDocumentItem Item Number of Purchasing Document
ChangeDocument FK Change Number of Document
MaterialDocumentYear Fiscal Year
MaterialDocumentItem Material Document Item
PurchasingInfoRecordCategory Purchasing info record category Show values
PurchasingGroup FK Purchasing Group
Column Name Description
💲 Display Currency (DisplayCurrency):
PricePerUnitAmount Material Net Unit Price
NetPriceAmount Material Price
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
InvoiceAmtInDisplayCurrency Invoice Amount
TargetAmount Target Amount
ReleaseOrderItemNetAmount Release Net Amount
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
Column Name Description
CreationDate Date on which the record was created
Column Name Description
PurchasingInfoRecordCategory Purchasing info record category Show values
PurchasingDocumentType Object Type Show values
Column Name Description Domain name
FormattedDocumentKey Purchasing Document Item
PurchaseOrder Purchase Order Number EBELN
Invoice Invoice Number TEXT50
PurchasingInfoRecord Purchasing Info Record INFNR
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingSourceType null
PurchasingDocumentTypeName Document Type Name CHAR40
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
SupplierName Supplier Name TEXT80
CompanyCodeName Name of Company Code or Company TEXT25
PlantName Plant Name TEXT30
NetPriceQuantity Price Unit
PurchasingOrganizationName Purchasing Organization Name TEXT20
NumberOfPurchaseOrders Number of Purchase Orders
NumberOfContractChanges null
NumberOfPriceChanges 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
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_MATERIALPRICEVARIANCE.MANDT == T001.MANDT
  • C_MATERIALPRICEVARIANCE.COMPANYCODE == T001.BUKRS
Material Number
  • Material Number
  • Client
  • C_MATERIALPRICEVARIANCE.MATERIAL == MARA.MATNR
  • C_MATERIALPRICEVARIANCE.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_MATERIALPRICEVARIANCE.MANDT == T023.MANDT
  • C_MATERIALPRICEVARIANCE.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • C_MATERIALPRICEVARIANCE.ORDERPRICEUNIT == T006.MSEHI
  • C_MATERIALPRICEVARIANCE.MANDT == T006.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_MATERIALPRICEVARIANCE.ORDERQUANTITYUNIT == T006.MSEHI
  • C_MATERIALPRICEVARIANCE.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • C_MATERIALPRICEVARIANCE.PLANT == T001W.WERKS
  • C_MATERIALPRICEVARIANCE.MANDT == T001W.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_MATERIALPRICEVARIANCE.PURCHASINGGROUP == T024.EKGRP
  • C_MATERIALPRICEVARIANCE.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_MATERIALPRICEVARIANCE.PURCHASINGORGANIZATION == T024E.EKORG
  • C_MATERIALPRICEVARIANCE.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_MATERIALPRICEVARIANCE.SUPPLIER == LFA1.LIFNR
  • C_MATERIALPRICEVARIANCE.MANDT == LFA1.MANDT