C_MLPrcWthUnivCompBreakdown

DDL: C_MLPRCWTHUNIVCOMPBREAKDOWN Type: view_entity CONSUMPTION Package: ODATA_ML_MNTRMATLPRICES
70 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

Prices with Component Breakdown

C_MLPrcWthUnivCompBreakdown is a Consumption CDS View that provides data about "Prices with Component Breakdown" in SAP S/4HANA. It reads from 1 data source (I_MLPrcWthUnivCompBreakdown) and exposes 70 fields with key fields CostEstimate, Ledger, CurrencyRole, MaterialPriceType, MaterialPriceSubtype. It is exposed through 2 OData services (ASQL_F7245, UI_FML_MNTRMATLPRICES). It is used in 1 Fiori application: Monitor Material Prices. Part of development package ODATA_ML_MNTRMATLPRICES.

Data Sources (1)

SourceAliasJoin Type
I_MLPrcWthUnivCompBreakdown I_MLPrcWthUnivCompBreakdown from

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Consumption.ranked true view
EndUserText.label Prices with Component Breakdown view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
UI.headerInfo.typeName Price with Component Breakdown view
UI.headerInfo.typeNamePlural Price with Component Breakdown view
UI.headerInfo.title.type #WITH_INTENT_BASED_NAVIGATION view
UI.headerInfo.title.value Material view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value MaterialName view
UI.headerInfo.imageUrl ProductImageURL view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7245 ASQL_F7245 C2 NOT_RELEASED
UI_FML_MNTRMATLPRICES UI_FML_MNTRMATLPRICES V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F7245 Monitor Material Prices Transactional With this app, you can analyze material prices across all your valuations. You can choose from two views. One view allows to you to analyze price variations through a detailed price comparison in two selected valuations. The other view displays material prices over time in all your valuations.

Monitor Material Prices

Business Role: Cost Accountant - Inventory

With this app, you can analyze material prices across all your valuations. You can choose from two views. One view allows to you to analyze price variations through a detailed price comparison in two selected valuations. The other view displays material prices over time in all your valuations. You can only use Monitor 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 Manage Material Valuations (F2680) instead.

Fields (70)

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
KEY CompanyCode CompanyCode Receiver Company Code
KEY ComponentBreakdown ComponentBreakdown
MaterialPriceValidityEndDate MaterialPriceValidityEndDate
MatlPrcValdtyStrtFsclYearPerd MatlPrcValdtyStrtFsclYearPerd
MatlPrcValidityStartFiscalYear MatlPrcValidityStartFiscalYear
MatlPrcValdtyStartFiscalPeriod MatlPrcValdtyStartFiscalPeriod
MatlPrcValdtyEndFsclYearPeriod MatlPrcValdtyEndFsclYearPeriod
MatlPrcValidityEndFiscalYear MatlPrcValidityEndFiscalYear
MatlPrcValdtyEndFiscalPeriod MatlPrcValdtyEndFiscalPeriod
MaterialPrice MaterialPrice Inventory Price
MaterialPriceInCoCodeCurrency MaterialPriceInCoCodeCurrency
MaterialPriceInGlobalCurrency MaterialPriceInGlobalCurrency
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FixedPortionOfMaterialPrice FixedPortionOfMaterialPrice
Currency Currency Valuation Crcy
ProductImageURL
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
ValuationQuantityUnit ValuationQuantityUnit
MaterialPriceControl MaterialPriceControl Price Control
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy
SlsOrdProjValnStrgyName SlsOrdProjValnStrgyName
MaterialPriceCostEstimateStage MaterialPriceCostEstimateStage
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
InvtryValnSpecialStockType InvtryValnSpecialStockType
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID WBSElementInternalID WBS Internal ID
ValidOnDate ValidOnDate
Supplier Supplier Supplier
Plant _Plant Plant Valuation Area
MaterialPriceTypeName
MaterialPriceControlName
MaterialName
CompanyCodeName _CompanyCode CompanyCodeName Company Name
PlantName _Plant PlantName Plant Name
InventorySpecialStockTypeName
MatlPriceCostEstimateStageName
StkMatlPriceValuationTypeName
WBSDescription _WBSElementBasicData WBSDescription WBS Element Name
LedgerName
StkMaterialPriceValuationType StkMaterialPriceValuationType
MaterialPriceExtRefCategory MaterialPriceExtRefCategory
MaterialPriceExtReference MaterialPriceExtReference
MaterialPriceCreatedByUser MaterialPriceCreatedByUser
MaterialPriceChangedByUser MaterialPriceChangedByUser User Name
MaterialPriceCreationDateTime MaterialPriceCreationDateTime
MatlPriceLastChangeDateTime MatlPriceLastChangeDateTime
LegalCurrencyRoleName LegalCurrencyRoleName
LegalCurrencyRole LegalCurrencyRole
AccountingValuationViewName AccountingValuationViewName
_Plant _Plant
_Material _Material
_PriceType _PriceType
_Product _Product
_WBSElementBasicData _WBSElementBasicData
_MaterialPriceControl _MaterialPriceControl
_CompanyCode _CompanyCode
_Ledger _Ledger
_InvtryValnSpecialStockType _InvtryValnSpecialStockType
_MatlPriceCostEstimateStage _MatlPriceCostEstimateStage
_StkMatlPriceValuationType _StkMatlPriceValuationType
_CurrencyRoleMapping _CurrencyRoleMapping

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_MLPrcWthUnivCompBreakdown.
-- 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_MLPrcWthUnivCompBreakdown AS
SELECT
  CostEstimate,
  Ledger,
  CurrencyRole,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  CompanyCode,
  ComponentBreakdown,
  MaterialPriceValidityEndDate,
  MatlPrcValdtyStrtFsclYearPerd,
  MatlPrcValidityStartFiscalYear,
  MatlPrcValdtyStartFiscalPeriod,
  MatlPrcValdtyEndFsclYearPeriod,
  MatlPrcValidityEndFiscalYear,
  MatlPrcValdtyEndFiscalPeriod,
  MaterialPrice,
  MaterialPriceInCoCodeCurrency,
  MaterialPriceInGlobalCurrency,
  AmountInFreeDefinedCurrency1,
  FixedPortionOfMaterialPrice,
  Currency,
  cast('' as productimageurl) AS ProductImageURL,
  MaterialPriceUnitQty,
  ValuationQuantityUnit,
  MaterialPriceControl,
  CurPlanProjSlsOrdValnStrategy,
  SlsOrdProjValnStrgyName,
  MaterialPriceCostEstimateStage,
  Material,
  ValuationArea,
  InventoryValuationType,
  InvtryValnSpecialStockType,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  ValidOnDate,
  Supplier,
  _Plant.Plant AS Plant,
  _PriceType._Text[1: Language = $session.system_language].MaterialPriceTypeName AS MaterialPriceTypeName,
  _MaterialPriceControl._Text[1: Language = $session.system_language].MaterialPriceControlName AS MaterialPriceControlName,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Plant.PlantName AS PlantName,
  _InvtryValnSpecialStockType._Text[1: Language = $session.system_language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  _MatlPriceCostEstimateStage._Text[1: Language = $session.system_language].MatlPriceCostEstimateStageName AS MatlPriceCostEstimateStageName,
  _StkMatlPriceValuationType._Text[1: Language = $session.system_language].StkMatlPriceValuationTypeName AS StkMatlPriceValuationTypeName,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  _Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
  StkMaterialPriceValuationType,
  MaterialPriceExtRefCategory,
  MaterialPriceExtReference,
  MaterialPriceCreatedByUser,
  MaterialPriceChangedByUser,
  MaterialPriceCreationDateTime,
  MatlPriceLastChangeDateTime,
  LegalCurrencyRoleName,
  LegalCurrencyRole,
  AccountingValuationViewName
FROM I_MLPrcWthUnivCompBreakdown
;

Learn More