- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
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, EKBE, EKBEH, MARA, T001, TKA02, FINSC_LEDGER, FINSC_LEDGER_T, T023, T023T, MAKT, MBEWH, T001K, CKMLHD, T001W, T163B, T024, EINA, T024E, T161, T162, EINE, LFA1, PRPS, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, FINSC_CURTYPE, CKMLPR, FINSC_CURTYPET, MARV, 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
| |
Material Number
| |
Material Group
| |
Order Price Unit (Purchasing)
| |
Purchase Order Unit of Measure
| |
Plant
| |
Purchasing Group
| |
Purchasing Organization
| |
Supplier
|