What is C_MatlLdgrPrChartByValuation in SAP S/4HANA?

C_MatlLdgrPrChartByValuation is a consumption CDS view in SAP S/4HANA. Chart for Multiple Valuations It contains 54 fields.

Which tables does C_MatlLdgrPrChartByValuation read from?

C_MatlLdgrPrChartByValuation reads data from: I_MLPriceByMultipleValnComprn.

What VDM layer is C_MatlLdgrPrChartByValuation?

C_MatlLdgrPrChartByValuation is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MatlLdgrPrChartByValuation

DDL: C_MATLLDGRPRCHARTBYVALUATION Type: view_entity CONSUMPTION Package: ODATA_ML_MNTRMATLPRICES

54 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

Chart for Multiple Valuations

C_MatlLdgrPrChartByValuation is a Consumption CDS View that provides data about "Chart for Multiple Valuations" in SAP S/4HANA. It reads from 1 data source (I_MLPriceByMultipleValnComprn) and exposes 54 fields with key fields CostEstimate, MaterialPriceType, MaterialPriceSubtype, MaterialPriceValidityStartDate, MaterialPriceValidityEndDate. 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)

Source	Alias	Join Type
I_MLPriceByMultipleValnComprn	I_MLPriceByMultipleValnComprn	from

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
Search.searchable	true	view
Consumption.ranked	true	view
Metadata.allowExtensions	true	view
EndUserText.label	Chart for Multiple Valuations	view

OData Services (2)

Service	Binding	Version	Contract	Release
ASQL_F7245	ASQL_F7245		C2	NOT_RELEASED
UI_FML_MNTRMATLPRICES	UI_FML_MNTRMATLPRICES	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
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 (54)

Key	Field	Source Table	Source Field	Description
KEY	CostEstimate		CostEstimate	Cost EstimateNo
KEY	MaterialPriceType		MaterialPriceType	Price Type
KEY	MaterialPriceSubtype		MaterialPriceSubtype
KEY	MaterialPriceValidityStartDate		MaterialPriceValidityStartDate
KEY	MaterialPriceValidityEndDate		MaterialPriceValidityEndDate
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	MaterialPriceControl		MaterialPriceControl	Price Control
KEY	CurPlanProjSlsOrdValnStrategy		CurPlanProjSlsOrdValnStrategy
KEY	MaterialPriceCostEstimateStage		MaterialPriceCostEstimateStage
KEY	InventoryValuationType		InventoryValuationType	Valuation Type
KEY	InvtryValnSpecialStockType		InvtryValnSpecialStockType
KEY	StkMaterialPriceValuationType		StkMaterialPriceValuationType
KEY	MaterialPriceExtReference		MaterialPriceExtReference
KEY	MaterialPriceExtRefCategory		MaterialPriceExtRefCategory
KEY	SalesOrder		SalesOrder	SD Document
KEY	SalesOrderItem		SalesOrderItem	Sales Order Item
	Material		Material	Vehicle Model
	MatlLdgrPrValnCrcyRoleSemKey		MatlLdgrPrValnCrcyRoleSemKey
	ValidOnDate		ValidOnDate
	AmountInFreeDefinedCurrency1		AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	AmountInFreeDefinedCurrency2		AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	AmountInFreeDefinedCurrency3		AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	AmountInFreeDefinedCurrency4		AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	AmountInFreeDefinedCurrency5		AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	AmountInFreeDefinedCurrency6		AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	AmountInFreeDefinedCurrency7		AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	AmountInFreeDefinedCurrency8		AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	AmountInFreeDefinedCurrency9		AmountInFreeDefinedCurrency9
	ValuationArea		ValuationArea	Valuation Area
	WBSElementExternalID	_WBSElementBasicData	WBSElementExternalID	WBS Element External ID
	Supplier		Supplier	Supplier
	Plant	_Plant	Plant	Valuation Area
	MaterialValuationListText		MaterialValuationListText
	MaterialPriceTypeName
	MaterialPriceControlName
	MaterialName
	CompanyCodeName	_CompanyCode	CompanyCodeName	Company Name
	PlantName	_Plant	PlantName	Plant Name
	InventorySpecialStockTypeName
	MatlPriceCostEstimateStageName
	StkMatlPriceValuationTypeName
	WBSDescription	_WBSElementBasicData	WBSDescription	WBS Element Name
	FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
	FreeDefinedCurrency9		FreeDefinedCurrency9
	Ledger		Ledger	Ledger
	CurrencyRole		CurrencyRole	Curr./Val. Type
	_Material		_Material

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_MatlLdgrPrChartByValuation.
-- 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_MatlLdgrPrChartByValuation AS
SELECT
  CostEstimate,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  MaterialPriceValidityEndDate,
  CompanyCode,
  MaterialPriceControl,
  CurPlanProjSlsOrdValnStrategy,
  MaterialPriceCostEstimateStage,
  InventoryValuationType,
  InvtryValnSpecialStockType,
  StkMaterialPriceValuationType,
  MaterialPriceExtReference,
  MaterialPriceExtRefCategory,
  SalesOrder,
  SalesOrderItem,
  Material,
  MatlLdgrPrValnCrcyRoleSemKey,
  ValidOnDate,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  AmountInFreeDefinedCurrency9,
  ValuationArea,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  Supplier,
  _Plant.Plant AS Plant,
  MaterialValuationListText,
  _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,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  FreeDefinedCurrency9,
  Ledger,
  CurrencyRole
FROM I_MLPriceByMultipleValnComprn
;

Depth:

C_MatlLdgrPrChartByValuation view_entity

I_MLPriceByMultipleValnComprn view_entity