C_MaterialLedgerPriceOverview

DDL: C_MATERIALLEDGERPRICEOVERVIEW Type: view_entity CONSUMPTION Package: ODATA_ML_CHANGEMATERIALPRICES
63 Fields 1 Data Sources 3 OData Services 1 Fiori Apps

Material Price Changes

C_MaterialLedgerPriceOverview is a Consumption CDS View that provides data about "Material Price Changes" in SAP S/4HANA. It reads from 1 data source (I_MaterialLedgerPriceOverview) and exposes 63 fields with key fields CostEstimate, Ledger, CurrencyRole, MaterialPriceType, MaterialPriceSubtype. It is exposed through 3 OData services (ASQL_F6489, FML_CHANGE_MATERIAL_PRICES, UI_FML_CHG_MATERIAL_PRICES). It is used in 1 Fiori application: Change Material Prices. Part of development package ODATA_ML_CHANGEMATERIALPRICES.

Data Sources (1)

SourceAliasJoin Type
I_MaterialLedgerPriceOverview I_MaterialLedgerPriceOverview projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
EndUserText.label Material Price Changes view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F6489 ASQL_F6489 C2 NOT_RELEASED
FML_CHANGE_MATERIAL_PRICES FML_CHANGE_MATERIAL_PRICES V4 C1 NOT_RELEASED
UI_FML_CHG_MATERIAL_PRICES UI_FML_CHG_MATERIAL_PRICES V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6489 Change Material Prices Transactional With this app, you create, analyze, simulate, and post material price changes. It allows you to change inventory prices, including sales order stock and project stock. You can change current material valuation prices retroactively or at the current date. To do so, enter the posting date and company code in the selection screen. You can change the price for a single reference valuation, then convert those changes to some or all valuations of the same material, or change prices for valuations individually. As you make changes, you can see the impact of the changes on price and valuation as percentages. You can also simulate material price changes to check for errors, warnings, and inconsistencies before posting.

Change Material Prices

Business Role: Cost Accountant - Inventory

With this feature, you create, analyze, simulate, and post material price changes. It allows you to change inventory prices, including sales order stock and project stock. You can change the price for a single reference valuation, then convert those changes to some or all valuations of the same material, or change prices for valuations individually. As you make changes, you can see the impact of the changes on price and valuation as percentages. You can also simulate material price changes to check for errors, warnings, and inconsistencies before posting.You can only use Change Material Prices if you have activated the business function Universal Parallel Accounting (FINS_PARALLEL_ACCOUNTING_BF, short: UPA). If you have not activated the UPA business function, you can use Change Material Prices (MR21) instead.

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
KEY Ledger Ledger Ledger
KEY CurrencyRole CurrencyRole Curr./Val. Type
KEY MaterialPriceType MaterialPriceType Price Type
KEY MaterialPriceSubtype MaterialPriceSubtype
KEY MaterialPriceValidityStartDate MaterialPriceValidityStartDate
MaterialPriceValidityEndDate MaterialPriceValidityEndDate
virtualValidOnDatefml_date_valid_on
MatlPrcValdtyStrtFsclYearPerd MatlPrcValdtyStrtFsclYearPerd
MatlPrcValidityStartFiscalYear MatlPrcValidityStartFiscalYear
MatlPrcValdtyStartFiscalPeriod MatlPrcValdtyStartFiscalPeriod
MatlPrcValdtyEndFsclYearPeriod MatlPrcValdtyEndFsclYearPeriod
MatlPrcValidityEndFiscalYear MatlPrcValidityEndFiscalYear
MatlPrcValdtyEndFiscalPeriod MatlPrcValdtyEndFiscalPeriod
MaterialPrice MaterialPrice Inventory Price
FixedPortionOfMaterialPrice FixedPortionOfMaterialPrice
Currency Currency Valuation Crcy
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
ValuationQuantityUnit ValuationQuantityUnit
MaterialPriceControl MaterialPriceControl Price Control
MaterialPriceControlName
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy
SlsOrdProjValnStrgyName
MaterialPriceCostEstimateStage MaterialPriceCostEstimateStage
MatlPriceCostEstimateStageName
Material Material Vehicle Model
MaterialName
ValuationArea ValuationArea Valuation Area
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
InventoryValuationType InventoryValuationType Valuation Type
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
InvtryValnSpecialStockType InvtryValnSpecialStockType
InventorySpecialStockTypeName
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementExternalID _WBSElementBasicData WBSElementExternalID WBS Element External ID
Supplier Supplier Supplier
StkMaterialPriceValuationType StkMaterialPriceValuationType
StkMatlPriceValuationTypeName
MaterialPriceExtRefCategory MaterialPriceExtRefCategory
MaterialPriceExtReference MaterialPriceExtReference
LedgerName
SalesDocumentItemText _SalesDocumentItem SalesDocumentItemText Item Descr.
CurrencyRoleName
LedgerValuationCurrencyRole _LedgerValuationCrcyRole LedgerValuationCurrencyRole
LegalCurrencyRole _LedgerValuationCrcyRole LegalCurrencyRole
LegalCurrencyRoleName _LedgerValuationCrcyRole LegalCurrencyRoleName
AcctgValnVwSubviewCombinedName
MaterialPriceTypeName
LedgerValnCrcyRoleIsUsedInLogs _LedgerValuationCrcyRole LedgerValnCrcyRoleIsUsedInLogs Is Log. Curr. Type
MaterialPriceCreatedByUser MaterialPriceCreatedByUser
MaterialPriceCreatedByUserName _CreatedBy FullName Name
MaterialPriceChangedByUser MaterialPriceChangedByUser User Name
MaterialPriceChangedByUserName _ChangedBy FullName Name
WBSDescription _WBSElementBasicData WBSDescription WBS Element Name
MaterialPriceCreationDateTime MaterialPriceCreationDateTime
MatlPriceLastChangeDateTime MatlPriceLastChangeDateTime
_Material _Material
_CreatedBy _CreatedBy
_ChangedBy _ChangedBy
_SalesDocumentItem _SalesDocumentItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MaterialLedgerPriceOverview.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_MaterialLedgerPriceOverview AS
SELECT
  CostEstimate,
  Ledger,
  CurrencyRole,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  MaterialPriceValidityEndDate,
  virtual ValidOnDate : fml_date_valid_on AS virtualValidOnDatefml_date_valid_on,
  MatlPrcValdtyStrtFsclYearPerd,
  MatlPrcValidityStartFiscalYear,
  MatlPrcValdtyStartFiscalPeriod,
  MatlPrcValdtyEndFsclYearPeriod,
  MatlPrcValidityEndFiscalYear,
  MatlPrcValdtyEndFiscalPeriod,
  MaterialPrice,
  FixedPortionOfMaterialPrice,
  Currency,
  MaterialPriceUnitQty,
  ValuationQuantityUnit,
  MaterialPriceControl,
  _MaterialPriceControl._Text[1: Language = $session.system_language].MaterialPriceControlName AS MaterialPriceControlName,
  CurPlanProjSlsOrdValnStrategy,
  _SlsOrdProjValuationStrategy._Text[1: Language = $session.system_language].SlsOrdProjValnStrgyName AS SlsOrdProjValnStrgyName,
  MaterialPriceCostEstimateStage,
  _MatlPriceCostEstimateStage._Text[1: Language = $session.system_language].MatlPriceCostEstimateStageName AS MatlPriceCostEstimateStageName,
  Material,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  ValuationArea,
  Plant,
  _Plant.PlantName AS PlantName,
  InventoryValuationType,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  InvtryValnSpecialStockType,
  _InvtryValnSpecialStockType._Text[1: Language = $session.system_language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  SalesOrder,
  SalesOrderItem,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  Supplier,
  StkMaterialPriceValuationType,
  _StkMatlPriceValuationType._Text[1: Language = $session.system_language].StkMatlPriceValuationTypeName AS StkMatlPriceValuationTypeName,
  MaterialPriceExtRefCategory,
  MaterialPriceExtReference,
  _Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText,
  _CurrencyRole._Text[1: Language = $session.system_language].CurrencyRoleName AS CurrencyRoleName,
  _LedgerValuationCrcyRole.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  _LedgerValuationCrcyRole.LegalCurrencyRole AS LegalCurrencyRole,
  _LedgerValuationCrcyRole.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  cast(_LedgerValuationCrcyRole.AcctgValnVwSubviewCombinedName as fml_umip_valuviewname preserving type ) AS AcctgValnVwSubviewCombinedName,
  _PriceType._Text[1: Language = $session.system_language].MaterialPriceTypeName AS MaterialPriceTypeName,
  _LedgerValuationCrcyRole.LedgerValnCrcyRoleIsUsedInLogs AS LedgerValnCrcyRoleIsUsedInLogs,
  MaterialPriceCreatedByUser,
  _CreatedBy.FullName AS MaterialPriceCreatedByUserName,
  MaterialPriceChangedByUser,
  _ChangedBy.FullName AS MaterialPriceChangedByUserName,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  MaterialPriceCreationDateTime,
  MatlPriceLastChangeDateTime
FROM I_MaterialLedgerPriceOverview
;

Learn More