C_PurgMatlPriceChg3

Material Price Change Cube | view: CMMMATLPRC3 | TRAN | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, EKBE, EKBEH, TKA01, T163B, T000, LFA1, PRPS
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
MaterialDocumentYear Material Document Year
Invoice Invoice Number
MaterialDocumentItem Item in Material Document
Column Name Description
💲 Display Currency (DisplayCurrency):
InvoiceAmtInDisplayCurrency Invoice Amount
PurchaseOrderAmount null
NetPriceAmount null
WeightedNetPrice null
Column Name Description
Column Name Description
InvoiceDate Invoice Date in Document
Column Name Description
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
YearWeek Year Week NUM6
YearMonth Year Month NUM6
YearQuarter Year Quarter NUM5
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
NumberOfInvoices null
QuantityInBaseUnit null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PURGMATLPRICECHG3.COMPANYCODE == T001.BUKRS
  • C_PURGMATLPRICECHG3.MANDT == T001.MANDT
Cost Center
  • ?
  • Cost Center
  • ?
  • Client
  • C_PURGMATLPRICECHG3.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PURGMATLPRICECHG3.COSTCENTER == CSKS.KOSTL
  • C_PURGMATLPRICECHG3.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURGMATLPRICECHG3.MANDT == CSKS.MANDT
Material Number
  • Material Number
  • Client
  • C_PURGMATLPRICECHG3.MATERIAL == MARA.MATNR
  • C_PURGMATLPRICECHG3.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_PURGMATLPRICECHG3.MATERIALGROUP == T023.MATKL
  • C_PURGMATLPRICECHG3.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • C_PURGMATLPRICECHG3.PLANT == T001W.WERKS
  • C_PURGMATLPRICECHG3.MANDT == T001W.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURGMATLPRICECHG3.PURCHASINGGROUP == T024.EKGRP
  • C_PURGMATLPRICECHG3.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_PURGMATLPRICECHG3.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURGMATLPRICECHG3.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURGMATLPRICECHG3.SUPPLIER == LFA1.LIFNR
  • C_PURGMATLPRICECHG3.MANDT == LFA1.MANDT
Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_PURGMATLPRICECHG3.SUPPLIERCOUNTRY == T005.LAND1
  • C_PURGMATLPRICECHG3.MANDT == T005.MANDT