C_MaterialLedgerPriceOverview

DDL: C_MATERIALLEDGERPRICEOVERVIEW Type: view_entity CONSUMPTION Package: ODATA_ML_CHANGEMATERIALPRICES

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 2 OData services (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.

1 data source(s) Exposed by 2 service(s) Used in 1 Fiori app(s) 63 fields

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 (2)

ServiceBindingVersionContractRelease
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
KEY Ledger Ledger
KEY CurrencyRole CurrencyRole
KEY MaterialPriceType MaterialPriceType
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
FixedPortionOfMaterialPrice FixedPortionOfMaterialPrice
Currency Currency
MaterialPriceUnitQty MaterialPriceUnitQty
ValuationQuantityUnit ValuationQuantityUnit
MaterialPriceControl MaterialPriceControl
MaterialPriceControlName
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy
SlsOrdProjValnStrgyName
MaterialPriceCostEstimateStage MaterialPriceCostEstimateStage
MatlPriceCostEstimateStageName
Material Material
MaterialName
ValuationArea ValuationArea
Plant Plant
PlantName _Plant PlantName
InventoryValuationType InventoryValuationType
CompanyCode CompanyCode
CompanyCodeName _CompanyCode CompanyCodeName
InvtryValnSpecialStockType InvtryValnSpecialStockType
InventorySpecialStockTypeName
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
WBSElementExternalID _WBSElementBasicData WBSElementExternalID
Supplier Supplier
StkMaterialPriceValuationType StkMaterialPriceValuationType
StkMatlPriceValuationTypeName
MaterialPriceExtRefCategory MaterialPriceExtRefCategory
MaterialPriceExtReference MaterialPriceExtReference
LedgerName
SalesDocumentItemText _SalesDocumentItem SalesDocumentItemText
CurrencyRoleName
LedgerValuationCurrencyRole _LedgerValuationCrcyRole LedgerValuationCurrencyRole
LegalCurrencyRole _LedgerValuationCrcyRole LegalCurrencyRole
LegalCurrencyRoleName _LedgerValuationCrcyRole LegalCurrencyRoleName
AcctgValnVwSubviewCombinedName
MaterialPriceTypeName
LedgerValnCrcyRoleIsUsedInLogs _LedgerValuationCrcyRole LedgerValnCrcyRoleIsUsedInLogs
MaterialPriceCreatedByUser MaterialPriceCreatedByUser
MaterialPriceCreatedByUserName _CreatedBy FullName
MaterialPriceChangedByUser MaterialPriceChangedByUser
MaterialPriceChangedByUserName _ChangedBy FullName
WBSDescription _WBSElementBasicData WBSDescription
MaterialPriceCreationDateTime MaterialPriceCreationDateTime
MatlPriceLastChangeDateTime MatlPriceLastChangeDateTime
_Material _Material
_CreatedBy _CreatedBy
_ChangedBy _ChangedBy
_SalesDocumentItem _SalesDocumentItem 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.allowExtensions: true
@VDM: {
  viewType: #CONSUMPTION,
  usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
}
@ObjectModel.usageType:{ serviceQuality: #C,
                         sizeCategory: #XXL,
                         dataClass: #MIXED }
@AccessControl.privilegedAssociations: ['_CreatedBy','_ChangedBy']
@Search.searchable: true
@EndUserText.label: 'Material Price Changes'
define root view entity C_MaterialLedgerPriceOverview
  provider contract transactional_query
  as projection on I_MaterialLedgerPriceOverview

{

  key     CostEstimate,
          @ObjectModel.text.element: ['LedgerName']
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
  key     Ledger,
  key     CurrencyRole,
          @ObjectModel.text.element: ['MaterialPriceTypeName']
          @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
  key     MaterialPriceType,
  key     MaterialPriceSubtype,
  key     MaterialPriceValidityStartDate,
          @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.99 }
          MaterialPriceValidityEndDate,
          @ObjectModel: { virtualElement: true,
                          filter.transformedBy: 'ABAP:CL_FML_CHMP_FILTER_TRANSFORM'}
  virtual ValidOnDate : fml_date_valid_on,
          @Semantics.fiscal.yearPeriod: true
          MatlPrcValdtyStrtFsclYearPerd,
          @Semantics.calendar.year: true
          MatlPrcValidityStartFiscalYear,
          @Semantics.fiscal.period: true
          MatlPrcValdtyStartFiscalPeriod,
          @Semantics.fiscal.yearPeriod: true
          MatlPrcValdtyEndFsclYearPeriod,
          @Semantics.calendar.year: true
          MatlPrcValidityEndFiscalYear,
          @Semantics.fiscal.period: true
          MatlPrcValdtyEndFiscalPeriod,
          @Semantics.amount.currencyCode: 'Currency'
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.99 }
          MaterialPrice,
          FixedPortionOfMaterialPrice,
          Currency,
          @Semantics.quantity.unitOfMeasure: 'ValuationQuantityUnit'
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.9 }
          MaterialPriceUnitQty,
          ValuationQuantityUnit,
          @ObjectModel.text.element: ['MaterialPriceControlName']
          MaterialPriceControl,
          @Semantics.text: true
          _MaterialPriceControl._Text[1: Language = $session.system_language].MaterialPriceControlName             as MaterialPriceControlName,
          @ObjectModel.text.element: [ 'SlsOrdProjValnStrgyName' ]
          CurPlanProjSlsOrdValnStrategy,
          _SlsOrdProjValuationStrategy._Text[1: Language = $session.system_language].SlsOrdProjValnStrgyName as SlsOrdProjValnStrgyName,
          @ObjectModel.text.element: ['MatlPriceCostEstimateStageName']
          MaterialPriceCostEstimateStage,
          @Semantics.text: true
          _MatlPriceCostEstimateStage._Text[1: Language = $session.system_language].MatlPriceCostEstimateStageName as MatlPriceCostEstimateStageName,
          @ObjectModel.text.element: ['MaterialName']
          @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
          Material,
          @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
          @Semantics.text: true
          _Material._Text[1: Language = $session.system_language].MaterialName                                     as MaterialName,
          ValuationArea,
          @ObjectModel.text.element: [ 'PlantName' ]
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
          Plant,
          @Semantics.text: true
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
          _Plant.PlantName                                                                                         as PlantName,
          InventoryValuationType,
          @ObjectModel.text.element: [ 'CompanyCodeName' ]
          CompanyCode,
          @Semantics.text: true
          _CompanyCode.CompanyCodeName                                                                             as CompanyCodeName,
          @ObjectModel.text.element: [ 'InventorySpecialStockTypeName' ]
          InvtryValnSpecialStockType,
          @Semantics.text: true
          _InvtryValnSpecialStockType._Text[1: Language = $session.system_language].InventorySpecialStockTypeName  as InventorySpecialStockTypeName,
          SalesOrder,
          @ObjectModel.text.element:  [ 'SalesDocumentItemText' ]
          SalesOrderItem,
          @ObjectModel.text.element: [ 'WBSDescription' ]
          _WBSElementBasicData.WBSElementExternalID,
          @ObjectModel.text.element: ['Supplier']
          Supplier,
          @ObjectModel.text.element: [ 'StkMatlPriceValuationTypeName' ]
          StkMaterialPriceValuationType,
          @Semantics.text: true
          _StkMatlPriceValuationType._Text[1: Language = $session.system_language].StkMatlPriceValuationTypeName   as StkMatlPriceValuationTypeName,
          MaterialPriceExtRefCategory,
          MaterialPriceExtReference,
          @Semantics.text: true
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
          _Ledger._Text[1: Language = $session.system_language].LedgerName                                         as LedgerName,
          @Semantics.text: true
          _SalesDocumentItem.SalesDocumentItemText,
          @Semantics.text: true
          _CurrencyRole._Text[1: Language = $session.system_language].CurrencyRoleName                             as CurrencyRoleName,
          _LedgerValuationCrcyRole.LedgerValuationCurrencyRole,
          @ObjectModel.text.element: [ 'LegalCurrencyRoleName' ]
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
          _LedgerValuationCrcyRole.LegalCurrencyRole,
          @Semantics.text: true
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
          _LedgerValuationCrcyRole.LegalCurrencyRoleName,
          @ObjectModel.text.element: ['AcctgValnVwSubviewCombinedName']
          cast(_LedgerValuationCrcyRole.AcctgValnVwSubviewCombinedName as fml_umip_valuviewname preserving type )  as AcctgValnVwSubviewCombinedName,
          @Semantics.text: true
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
          _PriceType._Text[1: Language = $session.system_language].MaterialPriceTypeName                           as MaterialPriceTypeName,
          _LedgerValuationCrcyRole.LedgerValnCrcyRoleIsUsedInLogs,
          @ObjectModel.text.element: [ 'MaterialPriceCreatedByUserName' ]
          @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
          MaterialPriceCreatedByUser,
          @Semantics.text: true
          _CreatedBy.FullName                                                                                      as MaterialPriceCreatedByUserName,
          @ObjectModel.text.element: [ 'MaterialPriceChangedByUserName' ]         
          MaterialPriceChangedByUser,
          @Semantics.text: true
          _ChangedBy.FullName                                                                                      as MaterialPriceChangedByUserName,
          @Semantics.text: true
          _WBSElementBasicData.WBSDescription                                                                      as WBSDescription,
          MaterialPriceCreationDateTime,
          MatlPriceLastChangeDateTime,

          _Material,
          _CreatedBy,
          _ChangedBy,
          _SalesDocumentItem

}

Learn More