C_MaterialLedgerPriceOverview

DDL: C_MATERIALLEDGERPRICEOVERVIEW Type: view_entity CONSUMPTION
60 Fields 1 Data Sources

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 60 fields with key fields CostEstimate, Ledger, CurrencyRole, MaterialPriceType, MaterialPriceSubtype.

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

Fields (60)

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
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
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

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,
  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,
  _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