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 56 fields.

Which tables does C_MatlLdgrPrChartByValuation read from?

C_MatlLdgrPrChartByValuation reads data from: R_MatlLedgerPriceByPriceType.

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

56 Fields 1 Data Sources

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 (R_MatlLedgerPriceByPriceType) and exposes 56 fields with key fields CostEstimate, MaterialPriceType, MaterialPriceSubtype, MaterialPriceValidityStartDate, MaterialPriceValidityEndDate.

Data Sources (1)

Source	Alias	Join Type
R_MatlLedgerPriceByPriceType	R_MatlLedgerPriceByPriceType	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

Fields (56)

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
KEY	MatlPrcValdtyStrtFsclYearPerd		MatlPrcValdtyStrtFsclYearPerd
KEY	MatlPrcValdtyEndFsclYearPeriod		MatlPrcValdtyEndFsclYearPeriod
	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
	MatlPrcValidityStartFiscalYear
	MatlPrcValdtyStartFiscalPeriod		MatlPrcValdtyStartFiscalPeriod
	MatlPrcValidityEndFiscalYear
	MatlPrcValdtyEndFiscalPeriod		MatlPrcValdtyEndFiscalPeriod
	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
	_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,
  MatlPrcValdtyStrtFsclYearPerd,
  MatlPrcValdtyEndFsclYearPeriod,
  Material,
  MatlLdgrPrValnCrcyRoleSemKey,
  ValidOnDate,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  cast(MatlPrcValidityStartFiscalYear as farr_from_fiscal_year preserving type ) AS MatlPrcValidityStartFiscalYear,
  MatlPrcValdtyStartFiscalPeriod,
  cast(MatlPrcValidityEndFiscalYear as farr_to_fiscal_year preserving type ) AS MatlPrcValidityEndFiscalYear,
  MatlPrcValdtyEndFiscalPeriod,
  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
FROM R_MatlLedgerPriceByPriceType
;

Depth:

C_MatlLdgrPrChartByValuation view_entity

R_MatlLedgerPriceByPriceType view_entity